Difference between revisions of "Myleave"

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

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