Difference between revisions of "A"

From SPGC Document Wiki
Jump to: navigation, search
(→‎syslogs)
Line 58: Line 58:
 
|No
 
|No
 
|-
 
|-
−
|DEPT_CODE
+
|LOG_USER
 
|varchar
 
|varchar
 
|25
 
|25
 
|No
 
|No
 +
|Yes
 
|No
 
|No
 +
|-
 +
|LOG_MODULE
 +
|varchar
 +
|25
 +
|No
 +
|Yes
 
|No
 
|No
 
|-
 
|-
−
|SECT_CODE
+
|LOG_DATE
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|LOG_ENUMB
 
|varchar
 
|varchar
 
|25
 
|25
 
|No
 
|No
 +
|Yes
 
|No
 
|No
 +
|-
 +
|LOG_FIELD
 +
|varchar
 +
|25
 +
|No
 +
|Yes
 
|No
 
|No
 
|-
 
|-
−
|SECT_NAME
+
|LOG_OLDVAL
 
|varchar
 
|varchar
−
|150
+
|25
 
|No
 
|No
 +
|Yes
 
|No
 
|No
 +
|-
 +
|LOG_NEWVAL
 +
|varchar
 +
|25
 
|No
 
|No
−
|}
+
|Yes
 +
|No
 +
|-
 +
|LOG_SQLEXEC
 +
|longtext
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_CHANGE
 +
|varchar
 +
|25
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|LOG_IPADDR
 +
|varchar
 +
|25
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|LOG_PRNT
 +
|varchar
 +
|25
 +
|No
 +
|Yes
 +
|No
 +
|-

Revision as of 15:07, 4 August 2016

secthd

secthd
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes No
DEPT_CODE varchar 25 No No No
SECT_CODE varchar 25 No No No
SECT_NAME varchar 150 No No No


syslogs

syslogs
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes No
LOG_USER varchar 25 No Yes No
LOG_MODULE varchar 25 No Yes No
LOG_DATE datetime 0 No Yes No
LOG_ENUMB varchar 25 No Yes No
LOG_FIELD varchar 25 No Yes No
LOG_OLDVAL varchar 25 No Yes No
LOG_NEWVAL varchar 25 No Yes No
LOG_SQLEXEC longtext 0 No No No
LOG_CHANGE varchar 25 No Yes No
LOG_IPADDR varchar 25 No Yes No
LOG_PRNT varchar 25 No Yes No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=A&oldid=2462"