Difference between revisions of "A"

From SPGC Document Wiki
Jump to: navigation, search
(→‎syslogs)
Line 133: Line 133:
 
|No
 
|No
 
|Yes
 
|Yes
 +
|No
 +
|}
 +
 +
 +
==tblclrlog==
 +
{| class="wikitable" \
 +
!colspan="7" | tblclrlog
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|recid
 +
|int
 +
|20
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|LOG_USER
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_MODULE
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_DATE
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_ENUMB
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_FIELD
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_OLDVAL
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_NEWVAL
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_SQLEXEC
 +
|longtext
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_CHANGE
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_IPADDR
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_PRNT
 +
|varchar
 +
|25
 +
|No
 +
|No
 
|No
 
|No
 
|-
 
|-

Revision as of 15:09, 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_USER varchar 25 No No No
LOG_MODULE varchar 25 No No No
LOG_DATE datetime 0 No No No
LOG_ENUMB varchar 25 No No No
LOG_FIELD varchar 25 No No No
LOG_OLDVAL varchar 25 No No No
LOG_NEWVAL varchar 25 No No No
LOG_SQLEXEC longtext 0 No No No
LOG_CHANGE varchar 25 No No No
LOG_IPADDR varchar 25 No No No
LOG_PRNT varchar 25 No No No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=A&oldid=2463"