Difference between revisions of "Myclearance"
From SPGC Document Wiki
(→auditlogs) |
|||
| Line 1: | Line 1: | ||
| − | == | + | ==executive_users== |
{| class="wikitable" \ | {| class="wikitable" \ | ||
| − | !colspan="7" | | + | !colspan="7" | executive_users |
|- | |- | ||
! style="text-align:left;" | Column Name | ! style="text-align:left;" | Column Name | ||
Revision as of 16:59, 4 August 2016
executive_users
| executive_users | ||||||
|---|---|---|---|---|---|---|
| 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 | Yes | No | |
| LOG_PRNT | varchar | 25 | No | Yes | No | |
