Difference between revisions of "A"

From SPGC Document Wiki
Jump to: navigation, search
(→‎tblclrlog)
Line 244: Line 244:
 
|No
 
|No
 
|No
 
|No
 +
|No
 +
|}
 +
 +
 +
==un2013==
 +
{| class="wikitable" \
 +
!colspan="7" | un2013
 +
|-
 +
! style="text-align:left;" | 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
 
|No
 
|}
 
|}

Revision as of 15:15, 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 varchar 25 No No No


un2013

un2013
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=2467"