Difference between revisions of "Itk"

From SPGC Document Wiki
Jump to: navigation, search
(→‎auditlogs)
Line 2: Line 2:
 
{| class="wikitable" \
 
{| class="wikitable" \
 
!colspan="7" | auditlogs
 
!colspan="7" | auditlogs
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|LOG_USER
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_MODULE
 +
|varchar
 +
|20
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_TBL
 +
|varchar
 +
|60
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|LOG_DATE
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_TIME
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_ENUMB
 +
|varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_KEYREC
 +
|varchar
 +
|60
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_FIELD
 +
|varchar
 +
|20
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_OLDVAL
 +
|varchar
 +
|30
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|LOG_NEWVAL
 +
|varchar
 +
|30
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|LOG_CHANGE
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|LOG_IPADDR
 +
|varchar
 +
|20
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_PRNT
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|LOG_SQLEXEC
 +
|longtext
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|}
 +
 +
==dailymhr2015==
 +
{| class="wikitable" \
 +
!colspan="7" | dailymhr2015
 
|-
 
|-
 
! style="text-align:left;" | Column Name
 
! style="text-align:left;" | Column Name

Revision as of 13:29, 9 August 2016

auditlogs

auditlogs
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
LOG_USER varchar 10 No No No
LOG_MODULE varchar 20 No No No
LOG_TBL varchar 60 No Yes No
LOG_DATE date 0 No No No
LOG_TIME varchar 10 No No No
LOG_ENUMB varchar 15 No No No
LOG_KEYREC varchar 60 No No No
LOG_FIELD varchar 20 No No No
LOG_OLDVAL varchar 30 No Yes No
LOG_NEWVAL varchar 30 No Yes No
LOG_CHANGE varchar 1 No Yes No
LOG_IPADDR varchar 20 No No No
LOG_PRNT varchar 1 No Yes No
LOG_SQLEXEC longtext 0 No Yes No

dailymhr2015

dailymhr2015
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
LOG_USER varchar 10 No No No
LOG_MODULE varchar 20 No No No
LOG_TBL varchar 60 No Yes No
LOG_DATE date 0 No No No
LOG_TIME varchar 10 No No No
LOG_ENUMB varchar 15 No No No
LOG_KEYREC varchar 60 No No No
LOG_FIELD varchar 20 No No No
LOG_OLDVAL varchar 30 No Yes No
LOG_NEWVAL varchar 30 No Yes No
LOG_CHANGE varchar 1 No Yes No
LOG_IPADDR varchar 20 No No No
LOG_PRNT varchar 1 No Yes No
LOG_SQLEXEC longtext 0 No Yes No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Itk&oldid=2778"