Difference between revisions of "A"

From SPGC Document Wiki
Jump to: navigation, search
(→‎un2013)
Line 251: Line 251:
 
{| class="wikitable" \
 
{| class="wikitable" \
 
!colspan="7" | un2013
 
!colspan="7" | un2013
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|RECID
 +
|int
 +
|11
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|UNTNUMB
 +
|varchar
 +
|15
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTDATE
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTSTME
 +
|varchar
 +
|4
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTETME
 +
|varchar
 +
|4
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTPURP
 +
|longtext
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTIAPP
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTIAPPDT
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTIAPPDTVW
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|UNTIAPPDISP
 +
|longtext
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTFAPP
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTFAPPDT
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTFAPPDTVW
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTFAPPDISP
 +
|longtext
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTDTFLD
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTRNUMB
 +
|varchar
 +
|20
 +
|No
 +
|No
 +
|No
 +
|-
 +
|UNTFNUMB
 +
|varchar
 +
|20
 +
|No
 +
|No
 +
|No
 +
|-
 +
|UNTCOCD
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTSECCD
 +
|varchar
 +
|20
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTDEPT
 +
|varchar
 +
|20
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTSAVED
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTTRANS
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|}
 +
 +
 +
==un2014==
 +
{| class="wikitable" \
 +
!colspan="7" | un2014
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|RECID
 +
|int
 +
|11
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|UNTNUMB
 +
|varchar
 +
|15
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTDATE
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTSTME
 +
|varchar
 +
|4
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTETME
 +
|varchar
 +
|4
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTPURP
 +
|longtext
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTIAPP
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTIAPPDT
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTIAPPDTVW
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|UNTIAPPDISP
 +
|longtext
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTFAPP
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTFAPPDT
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTFAPPDTVW
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTFAPPDISP
 +
|longtext
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTDTFLD
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTRNUMB
 +
|varchar
 +
|20
 +
|No
 +
|No
 +
|No
 +
|-
 +
|UNTFNUMB
 +
|varchar
 +
|20
 +
|No
 +
|No
 +
|No
 +
|-
 +
|UNTCOCD
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTSECCD
 +
|varchar
 +
|20
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTDEPT
 +
|varchar
 +
|20
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTSAVED
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTTRANS
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|}
 +
 +
 +
==un2015==
 +
{| class="wikitable" \
 +
!colspan="7" | un2015
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|RECID
 +
|int
 +
|11
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|UNTNUMB
 +
|varchar
 +
|15
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTDATE
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTSTME
 +
|varchar
 +
|4
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTETME
 +
|varchar
 +
|4
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTPURP
 +
|longtext
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTIAPP
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTIAPPDT
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTIAPPDTVW
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|UNTIAPPDISP
 +
|longtext
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTFAPP
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTFAPPDT
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTFAPPDTVW
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTFAPPDISP
 +
|longtext
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTDTFLD
 +
|datetime
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTRNUMB
 +
|varchar
 +
|20
 +
|No
 +
|No
 +
|No
 +
|-
 +
|UNTFNUMB
 +
|varchar
 +
|20
 +
|No
 +
|No
 +
|No
 +
|-
 +
|UNTCOCD
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTSECCD
 +
|varchar
 +
|20
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTDEPT
 +
|varchar
 +
|20
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTSAVED
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|UNTTRANS
 +
|varchar
 +
|1
 +
|No
 +
|Yes
 +
|No
 +
|}
 +
 +
 +
==un2016==
 +
{| class="wikitable" \
 +
!colspan="7" | un2016
 
|-
 
|-
 
! style="text-align:left;" | Column Name
 
! style="text-align:left;" | Column Name

Revision as of 15:25, 4 August 2016

secthd

secthd
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
SECT_CODE varchar 25 No No No
SECT_NAME varchar 150 No No No


syslogs

syslogs
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes No
LOG_USER varchar 25 No Yes No
LOG_MODULE varchar 25 No Yes No
LOG_DATE datetime 0 No Yes No
LOG_ENUMB varchar 25 No Yes No
LOG_FIELD varchar 25 No Yes No
LOG_OLDVAL varchar 25 No Yes No
LOG_NEWVAL varchar 25 No Yes No
LOG_SQLEXEC longtext 0 No No No
LOG_CHANGE varchar 25 No Yes No
LOG_IPADDR varchar 25 No Yes No
LOG_PRNT varchar 25 No Yes No


tblclrlog

tblclrlog
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 20 Yes Yes No
LOG_ENUMB varchar 25 No No No
LOG_RCP varchar 150 No No No
LOG_RCPID datetime 20 No No No
LOG_SENDER varchar 150 No No No
LOG_RCPDVIEW datetime 0 No No No
LOG_RCPCLEARED varchar 1 No No No
LOG_RCPCLEARED_DATE datetime 0 No No No
LOG_RCPREMK longtext 0 No No No
LOG_USER varchar 50 No No No
LOG_IDENC varchar 50 No No No
LOG_SEND_DATE datetime 0 No No No
LOG_DATE_APP date 0 No No No
LOG_MODULE varchar 25 No No No


un2013

un2013
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
RECID int 11 Yes Yes No
UNTNUMB varchar 15 No Yes No
UNTDATE datetime 0 No Yes No
UNTSTME varchar 4 No Yes No
UNTETME varchar 4 No Yes No
UNTPURP longtext 0 No Yes No
UNTIAPP varchar 1 No Yes No
UNTIAPPDT datetime 0 No Yes No
UNTIAPPDTVW datetime 0 No No No
UNTIAPPDISP longtext 0 No Yes No
UNTFAPP varchar 1 No Yes No
UNTFAPPDT datetime 0 No Yes No
UNTFAPPDTVW datetime 0 No Yes No
UNTFAPPDISP longtext 0 No Yes No
UNTDTFLD datetime 0 No Yes No
UNTRNUMB varchar 20 No No No
UNTFNUMB varchar 20 No No No
UNTCOCD varchar 1 No Yes No
UNTSECCD varchar 20 No Yes No
UNTDEPT varchar 20 No Yes No
UNTSAVED varchar 1 No Yes No
UNTTRANS varchar 1 No Yes No


un2014

un2014
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
RECID int 11 Yes Yes No
UNTNUMB varchar 15 No Yes No
UNTDATE datetime 0 No Yes No
UNTSTME varchar 4 No Yes No
UNTETME varchar 4 No Yes No
UNTPURP longtext 0 No Yes No
UNTIAPP varchar 1 No Yes No
UNTIAPPDT datetime 0 No Yes No
UNTIAPPDTVW datetime 0 No No No
UNTIAPPDISP longtext 0 No Yes No
UNTFAPP varchar 1 No Yes No
UNTFAPPDT datetime 0 No Yes No
UNTFAPPDTVW datetime 0 No Yes No
UNTFAPPDISP longtext 0 No Yes No
UNTDTFLD datetime 0 No Yes No
UNTRNUMB varchar 20 No No No
UNTFNUMB varchar 20 No No No
UNTCOCD varchar 1 No Yes No
UNTSECCD varchar 20 No Yes No
UNTDEPT varchar 20 No Yes No
UNTSAVED varchar 1 No Yes No
UNTTRANS varchar 1 No Yes No


un2015

un2015
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
RECID int 11 Yes Yes No
UNTNUMB varchar 15 No Yes No
UNTDATE datetime 0 No Yes No
UNTSTME varchar 4 No Yes No
UNTETME varchar 4 No Yes No
UNTPURP longtext 0 No Yes No
UNTIAPP varchar 1 No Yes No
UNTIAPPDT datetime 0 No Yes No
UNTIAPPDTVW datetime 0 No No No
UNTIAPPDISP longtext 0 No Yes No
UNTFAPP varchar 1 No Yes No
UNTFAPPDT datetime 0 No Yes No
UNTFAPPDTVW datetime 0 No Yes No
UNTFAPPDISP longtext 0 No Yes No
UNTDTFLD datetime 0 No Yes No
UNTRNUMB varchar 20 No No No
UNTFNUMB varchar 20 No No No
UNTCOCD varchar 1 No Yes No
UNTSECCD varchar 20 No Yes No
UNTDEPT varchar 20 No Yes No
UNTSAVED varchar 1 No Yes No
UNTTRANS varchar 1 No Yes No


un2016

un2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
RECID int 11 Yes Yes No
UNTNUMB varchar 15 No Yes No
UNTDATE datetime 0 No Yes No
UNTSTME varchar 4 No Yes No
UNTETME varchar 4 No Yes No
UNTPURP longtext 0 No Yes No
UNTIAPP varchar 1 No Yes No
UNTIAPPDT datetime 0 No Yes No
UNTIAPPDTVW datetime 0 No No No
UNTIAPPDISP longtext 0 No Yes No
UNTFAPP varchar 1 No Yes No
UNTFAPPDT datetime 0 No Yes No
UNTFAPPDTVW datetime 0 No Yes No
UNTFAPPDISP longtext 0 No Yes No
UNTDTFLD datetime 0 No Yes No
UNTRNUMB varchar 20 No No No
UNTFNUMB varchar 20 No No No
UNTCOCD varchar 1 No Yes No
UNTSECCD varchar 20 No Yes No
UNTDEPT varchar 20 No Yes No
UNTSAVED varchar 1 No Yes No
UNTTRANS varchar 1 No Yes No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=A&oldid=2473"