Difference between revisions of "Myleave"
From SPGC Document Wiki
| Line 263: | Line 263: | ||
|No | |No | ||
|} | |} | ||
| + | |||
| + | ==lv2013== | ||
| + | {| class="wikitable" \ | ||
| + | !colspan="7" |lv2013 | ||
| + | |- | ||
| + | ! style="text-align:left;" | Column Name | ||
| + | ! Data Type | ||
| + | ! Length | ||
| + | ! Is PrimaryKey | ||
| + | ! Is Not Null | ||
| + | ! Auto Increment | ||
| + | |- | ||
Revision as of 11:16, 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 | |
depthd
| depthd | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
| recid | int | 30 | Yes | Yes | No | |
| DEPT_CODE | varchar | 25 | No | No | No | |
| DEPT_NAME | varchar | 150 | No | No | No | |
| DEPT_DIVHEAD | varchar | 150 | No | No | No | |
lv2013
| lv2013 | ||||||
|---|---|---|---|---|---|---|
| Column Name | Data Type | Length | Is PrimaryKey | Is Not Null | Auto Increment | |
