Difference between revisions of "A"

From SPGC Document Wiki
Jump to: navigation, search
(→‎tblclrlog)
Line 155: Line 155:
 
|No
 
|No
 
|-
 
|-
−
|LOG_USER
+
|LOG_ENUMB
 
|varchar
 
|varchar
 
|25
 
|25
Line 162: Line 162:
 
|No
 
|No
 
|-
 
|-
−
|LOG_MODULE
+
|LOG_RCP
 
|varchar
 
|varchar
−
|25
+
|150
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|LOG_DATE
+
|LOG_RCPID
 
|datetime
 
|datetime
−
|0
+
|20
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|LOG_ENUMB
+
|LOG_SENDER
 
|varchar
 
|varchar
−
|25
+
|150
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|LOG_FIELD
+
|LOG_RCPDVIEW
−
|varchar
+
|datetime
−
|25
+
|0
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|LOG_OLDVAL
+
|LOG_RCPCLEARED
 
|varchar
 
|varchar
−
|25
+
|1
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|LOG_NEWVAL
+
|LOG_RCPCLEARED_DATE
−
|varchar
+
|datetime
−
|25
+
|0
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|LOG_SQLEXEC
+
|LOG_RCPREMK
 
|longtext
 
|longtext
 
|0
 
|0
Line 211: Line 211:
 
|No
 
|No
 
|-
 
|-
−
|LOG_CHANGE
+
|LOG_USER
 
|varchar
 
|varchar
−
|25
+
|50
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|LOG_IPADDR
+
|LOG_IDENC
 
|varchar
 
|varchar
−
|25
+
|50
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|LOG_PRNT
+
|LOG_SEND_DATE
−
|varchar
+
|datetime
−
|25
+
|0
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
 +
|LOG_DATE_APP
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_MODULE
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|}

Revision as of 15:13, 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


tblclrlog

tblclrlog
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 20 Yes Yes No
LOG_ENUMB varchar 25 No No No
LOG_RCP varchar 150 No No No
LOG_RCPID datetime 20 No No No
LOG_SENDER varchar 150 No No No
LOG_RCPDVIEW datetime 0 No No No
LOG_RCPCLEARED varchar 1 No No No
LOG_RCPCLEARED_DATE datetime 0 No No No
LOG_RCPREMK longtext 0 No No No
LOG_USER varchar 50 No No No
LOG_IDENC varchar 50 No No No
LOG_SEND_DATE datetime 0 No No No
LOG_DATE_APP date 0 No No No
LOG_MODULE datetime 0 No No No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=A&oldid=2465"