Myclearance

From SPGC Document Wiki
Revision as of 16:23, 4 August 2016 by Ojt1 (Talk | contribs) (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 |...")

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

auditlogs

auditlogs
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes Yes
LOG_USER varchar 25 No Yes No
LOG_MODULE varchar 50 No Yes No
LOG_KEYREC varchar 50 No No No
LOG_TBL varchar 50 No No No
LOG_DATE datetime 0 Yes No No
LOG_ENUMB varchar 25 No Yes No
LOG_MODFLD longtext 0 No Yes No
LOG_FIELD varchar 25 No Yes No
LOG_OLDVAL varchar 40 No Yes No
LOG_NEWVAL varchar 40 No Yes No
LOG_SQLEXEC longtext 0 No No No
LOG_CHANGE varchar 25 No Yes No
LOG_IPADDR varchar 25 No No No
LOG_PRNT varchar 25 No Yes No