Itk
From SPGC Document Wiki
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 |