Difference between revisions of "Myleave"

From SPGC Document Wiki
Jump to: navigation, search
Line 461: Line 461:
 
{| class="wikitable" \
 
{| class="wikitable" \
 
!colspan="7" | lv2014
 
!colspan="7" | lv2014
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|RECID
 +
|int
 +
|11
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|LOANUMB
 +
|varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOADATE
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOAOPTN
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOACODE
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOAHOUR
 +
|double
 +
|15,5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOAHRPD
 +
|double
 +
|15,5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOAASTA
 +
|varchar
 +
|1
 +
|no
 +
|Yes
 +
|No
 +
|-
 +
|LOAASTADT
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOAASTADTVW
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOAASTADISR
 +
|longtext
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOAAREC
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|LOADISREAS
 +
|longtext
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOAARECDT
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOAARECDTVW
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOADTFLD
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOAREASON
 +
|longtext
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOARELIEV
 +
|varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOARNUMB
 +
|varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOAFNUMB
 +
|varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOACOCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOAEMAIL
 +
|varchar
 +
|20
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|LOASECCD
 +
|varchar
 +
|20
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOADEPCD
 +
|varchar
 +
|20
 +
|No
 +
|No
 +
|No
 +
|-
 +
|LOASAVED
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|LOATRANS
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|}
 +
 +
 +
==lv2015==
 +
{| class="wikitable" \
 +
!colspan="7" | lv2015
 
|-
 
|-
 
! style="text-align:left;" | Column Name
 
! style="text-align:left;" | Column Name

Revision as of 12:46, 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
RECID int 11 Yes Yes No
LOANUMB varchar 15 No No No
LOADATE datetime 0 No No No
LOAOPTN varchar 1 No No No
LOACODE varchar 1 No No No
LOAHOUR double 15,5 No No No
LOAHRPD double 15,5 No No No
LOAASTA varchar 1 no Yes No
LOAASTADT datetime 0 No No No
LOAASTADTVW datetime 0 No No No
LOAASTADISR longtext 0 No No No
LOAAREC varchar 1 No Yes No
LOADISREAS longtext 0 No No No
LOAARECDT datetime 0 No No No
LOAARECDTVW datetime 0 No No No
LOADTFLD datetime 0 No No No
LOAREASON longtext 0 No No No
LOARELIEV varchar 15 No No No
LOARNUMB varchar 15 No No No
LOAFNUMB varchar 15 No No No
LOACOCD varchar 1 No No No
LOAEMAIL varchar 20 No Yes No
LOASECCD varchar 20 No No No
LOADEPCD varchar 20 No No No
LOASAVED varchar 1 No Yes No
LOATRANS varchar 1 No Yes No

lv2014

lv2014
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
RECID int 11 Yes Yes No
LOANUMB varchar 15 No No No
LOADATE datetime 0 No No No
LOAOPTN varchar 1 No No No
LOACODE varchar 1 No No No
LOAHOUR double 15,5 No No No
LOAHRPD double 15,5 No No No
LOAASTA varchar 1 no Yes No
LOAASTADT datetime 0 No No No
LOAASTADTVW datetime 0 No No No
LOAASTADISR longtext 0 No No No
LOAAREC varchar 1 No Yes No
LOADISREAS longtext 0 No No No
LOAARECDT datetime 0 No No No
LOAARECDTVW datetime 0 No No No
LOADTFLD datetime 0 No No No
LOAREASON longtext 0 No No No
LOARELIEV varchar 15 No No No
LOARNUMB varchar 15 No No No
LOAFNUMB varchar 15 No No No
LOACOCD varchar 1 No No No
LOAEMAIL varchar 20 No Yes No
LOASECCD varchar 20 No No No
LOADEPCD varchar 20 No No No
LOASAVED varchar 1 No Yes No
LOATRANS varchar 1 No Yes No


lv2015

lv2015
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
RECID int 11 Yes Yes No
LOANUMB varchar 15 No No No
LOADATE datetime 0 No No No
LOAOPTN varchar 1 No No No
LOACODE varchar 1 No No No
LOAHOUR double 15,5 No No No
LOAHRPD double 15,5 No No No
LOAASTA varchar 1 no Yes No
LOAASTADT datetime 0 No No No
LOAASTADTVW datetime 0 No No No
LOAASTADISR longtext 0 No No No
LOAAREC varchar 1 No Yes No
LOADISREAS longtext 0 No No No
LOAARECDT datetime 0 No No No
LOAARECDTVW datetime 0 No No No
LOADTFLD datetime 0 No No No
LOAREASON longtext 0 No No No
LOARELIEV varchar 15 No No No
LOARNUMB varchar 15 No No No
LOAFNUMB varchar 15 No No No
LOACOCD varchar 1 No No No
LOAEMAIL varchar 20 No Yes No
LOASECCD varchar 20 No No No
LOADEPCD varchar 20 No No No
LOASAVED varchar 1 No Yes No
LOATRANS varchar 1 No Yes No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Myleave&oldid=2409"