Difference between revisions of "Myleave"
From SPGC Document Wiki
(→auditlogs) |
|||
| Line 18: | Line 18: | ||
|- | |- | ||
|LOG_USER | |LOG_USER | ||
| − | | | + | |varchar |
| − | | | + | |25 |
|No | |No | ||
|No | |No | ||
Revision as of 11:09, 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 | 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 | |
ccback
| ccback | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| mymodule | varchar | 20 | No | No | No | |
| myremark | varchar | 1 | No | No | No | |
| myuser | varchar | 10 | No | No | No | |
| myppdte | datetime | 0 | No | No | No | |
| mydate | datetime | 0 | No | No | No | |
| mycomp | varchar | 10 | No | No | No | |
dept_sect_emp_tag
| dept_sect_emp_tag | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | No | |
| SECT_CODE | varchar | 25 | No | No | No | |
| DEPT_CODE | varchar | 25 | No | No | No | |
| EMPNUMB | varchar | 25 | No | No | No | |
| TAGGED_FA | varchar | 1 | No | No | No | |
| TAGGED_IA | varchar | 1 | No | No | No | |
| TAGGED_RL | varchar | 1 | No | No | No | |
| TAGGED_ACTV | varchar | 1 | No | No | No | |
