Difference between revisions of "Myleave"

From SPGC Document Wiki
Jump to: navigation, search
(→‎auditlogs)
Line 219: Line 219:
 
|varchar
 
|varchar
 
|1
 
|1
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==depthd==
 +
{| class="wikitable" \
 +
!colspan="7" | depthd
 +
|-
 +
! style="text-align:left;" | 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
 
|No
 
|No
 
|No
 
|}
 
|}

Revision as of 11:15, 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
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Myleave&oldid=2399"