Difference between revisions of "Myleave"

From SPGC Document Wiki
Jump to: navigation, search
(Created page with "==auditlogs== {| class="wikitable" \ !colspan="7" | auditlogs |- ! style="text-align:left;" | Column Name ! Data Type ! Length ! Is PrimaryKey ! Is Not Null ! Auto Increment |...")
 
Line 10: Line 10:
 
! Auto Increment
 
! Auto Increment
 
|-
 
|-
−
|AHSNUMB
+
|recid
−
|Varchar
+
|int
−
|15
+
|30
−
|No
+
|Yes
−
|No
+
|Yes
 
|No
 
|No
 
|-
 
|-
−
|AHSGPAY
+
|LOG_USER
 
|double
 
|double
 
|15,2
 
|15,2
Line 25: Line 25:
 
|-
 
|-
 
|AHSALLO
 
|AHSALLO
−
|double
+
|varchar
−
|15,2
+
|25
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|AHS13MO
+
|LOG_MODULE
−
|double
+
|varchar
−
|15,2
+
|50
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|AHSSLVL
+
|LOG_DATE
−
|double
+
|datetime
−
|15,2
+
|0
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|AHSSVLR
+
|LOG_TBL
−
|double
+
|varchar
−
|15,2
+
|50
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|AHSBONS
+
|LOG_KEYREC
−
|double
+
|varchar
−
|15,2
+
|50
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|AHSTAXD
+
|LOG_FIELD
−
|double
+
|varchar
−
|15,2
+
|25
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|-
 
|-
−
|AHSTAXW
+
|LOG_OLDVAL
−
|double
+
|longtext
−
|15,2
+
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_NEWVAL
 +
|longtext
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_CHANGE
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_SQLEXEC
 +
|longtext
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_IPADDR
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOG_PRNT
 +
|varchar
 +
|25
 
|No
 
|No
 
|No
 
|No
 
|No
 
|No
 
|}
 
|}

Revision as of 10:57, 4 August 2016

auditlogs

auditlogs
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes No
LOG_USER double 15,2 No No No
AHSALLO varchar 25 No No No
LOG_MODULE varchar 50 No No No
LOG_DATE datetime 0 No No No
LOG_TBL varchar 50 No No No
LOG_KEYREC varchar 50 No No No
LOG_FIELD varchar 25 No No No
LOG_OLDVAL longtext 0 No No No
LOG_NEWVAL longtext 0 No No No
LOG_CHANGE varchar 25 No No No
LOG_SQLEXEC longtext 0 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=Myleave&oldid=2393"