Difference between revisions of "Qoutabase"

From SPGC Document Wiki
Jump to: navigation, search
(→‎pmtempl_20160630)
 
(20 intermediate revisions by the same user not shown)
Line 1,047: Line 1,047:
 
|No
 
|No
 
|-
 
|-
−
|mmenu
+
|group
−
|int
+
|varchar
−
|10
+
|25
 +
|No
 
|No
 
|No
−
|Yes
 
 
|No
 
|No
 
|-
 
|-
Line 1,057: Line 1,057:
 
|varchar
 
|varchar
 
|25
 
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|icon
 +
|varchar
 +
|15
 
|No
 
|No
 
|No
 
|No
Line 1,073: Line 1,080:
 
|No
 
|No
 
|No
 
|No
 +
|No
 +
|}
 +
 +
==menu_sub==
 +
{| class="wikitable" \
 +
!colspan="7" | menu_sub
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|MEN_RECID
 +
|int
 +
|11
 +
|Yes
 +
|Yes
 +
|Yes
 +
|-
 +
|MEN_SNAME
 +
|varchar
 +
|20
 +
|No
 +
|No
 +
|No
 +
|-
 +
|MEN_NAME
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|group
 +
|varchar
 +
|20
 +
|No
 +
|No
 +
|No
 +
|-
 +
|MEN_STAT
 +
|enum
 +
|A,D
 +
|No
 +
|No
 +
|No
 +
|-
 +
|MEN_DESC
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|MEN_URL
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|MEN_SORT
 +
|int
 +
|10
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==myusers==
 +
{| class="wikitable" \
 +
!colspan="7" | myusers
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|myusername
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myuserfulln
 +
|varchar
 +
|50
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myuserpass
 +
|varchar
 +
|50
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myuserlevel
 +
|varchar
 +
|300
 +
|No
 +
|No
 +
|No
 +
|-
 +
|image_url
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myuservalis
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myuservalie
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myusercostc
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myusergroup
 +
|varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myuseracomp
 +
|varchar
 +
|60
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myusertype
 +
|varchar
 +
|7
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myuserrema
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myuserremal
 +
|longtext
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|myuserremcc
 +
|longtext
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|menu
 +
|varchar
 +
|50
 +
|No
 +
|No
 +
|No
 +
|-
 +
|submenu
 +
|varchar
 +
|50
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==newsessions==
 +
{| class="wikitable" \
 +
!colspan="7" | newsessions
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|id
 +
|varchar
 +
|40
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|ip_address
 +
|varchar
 +
|45
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|timestamp
 +
|int
 +
|10
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|data
 +
|blob
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|}
 +
 +
==pd2016==
 +
{| class="wikitable" \
 +
!colspan="7" | pd2016
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|recid
 +
|int
 +
|11
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMCOCD
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMLCCD
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMCOFF
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMFDTE
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMTDTE
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMPOST
 +
|varchar
 +
|7
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMAFDT
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMATDT
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMDAYS
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMADFD
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMADTD
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMSFDT
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMSTDT
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==pdm2015==
 +
{| class="wikitable" \
 +
!colspan="7" | pdm2015
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|PDMCOFF
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMFDTE
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMTDTE
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMPOST
 +
|varchar
 +
|7
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMAFDT
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMATDT
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMDAYS
 +
|int
 +
|11
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMADFD
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMADTD
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==pdm2016==
 +
{| class="wikitable" \
 +
!colspan="7" | pdm2016
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|PDMCOFF
 +
|varchar
 +
|3
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|PDMFDTE
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMTDTE
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMPOST
 +
|varchar
 +
|7
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMAFDT
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMATDT
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMDAYS
 +
|int
 +
|11
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMADFD
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|PDMADTD
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==pmhempl==
 +
{| class="wikitable" \
 +
!colspan="7" | pmhempl
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|EMPNUMB
 +
|varchar
 +
|8
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPLNAM
 +
|varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPFNAM
 +
|varchar
 +
|20
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPMNAM
 +
|varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPPCCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPCOCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPLCCD
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==pmmcmpy==
 +
{| class="wikitable" \
 +
!colspan="7" | pmmcmpy
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|CMPCOCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPNAME
 +
|varchar
 +
|35
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPSSSN
 +
|varchar
 +
|12
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPTINO
 +
|varchar
 +
|12
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPCADD
 +
|varchar
 +
|30
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPSLAC
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPSMEC
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPBKAL
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPOTHR
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPHOLD
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPPIBE
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPTELE
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPBMAK
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPCASH
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPTAXC
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPSMEP
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPABBR
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPMEDP
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPHACC
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPPACC
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPWACC
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPTACC
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPHLAC
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPSACC
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPBACC
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPOIAC
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPSMAC
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPSPAC
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPOSLA
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==pmtempl==
 +
{| class="wikitable" \
 +
!colspan="7" | pmtempl
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|EMPNUMB
 +
|varchar
 +
|15
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|EMPLNAM
 +
|varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPFNAM
 +
|varchar
 +
|12
 +
|No
 +
|No
 +
|No
 +
|-
 +
|CMPTINO
 +
|varchar
 +
|20
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPMNAM
 +
|varchar
 +
|15
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPPCCD
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPCOCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPLCCD
 +
|varchar
 +
|3
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPRDCD
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPSFCD
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPFPER
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPESCD
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPHDTE
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPLTAG
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPTAGR
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPTDPD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPSXCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPTXCD
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPSTAT
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPDPCD
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPPMCD
 +
|varchar
 +
|1
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPBKCD
 +
|varchar
 +
|5
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPAVOL
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPPVOL
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPTINO
 +
|varchar
 +
|11
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPSSNO
 +
|varchar
 +
|12
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPPINO
 +
|varchar
 +
|12
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPBPAY
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|EMPALLO
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|QTACODE
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==pmtempl_20160630==
 +
{| class="wikitable" \
 +
!colspan="7" | pmtempl_20160630
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|EMPNUMB
 +
|varchar
 +
|15
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|EMPLNAM
 +
|varchar
 +
|15
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|EMPFNAM
 +
|varchar
 +
|20
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|title                jfgccccccccccccccccjkrtujhsztaefa
 +
|varchar
 +
|300
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|image_url
 +
|varchar
 +
|300
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|content_brief
 +
|text
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|content
 +
|text
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|publish_time
 +
|timestamp
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|status
 +
|enum
 +
|draft
 +
|No
 +
|Yes
 
|No
 
|No
 
|}
 
|}

Latest revision as of 18:33, 8 August 2016

admin_groups

admin_groups
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id mediumint 8 Yes Yes Yes
name varchar 20 No Yes No
description varchar 100 No Yes No

admin_login_attempts

admin_login_attempts
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 11 Yes Yes Yes
ip_address varchar 15 No Yes No
login varchar 100 No Yes No
time int 30 No No No

admin_users

admin_users
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 11 Yes Yes Yes
ip_address varchar 15 No Yes No
username varchar 100 No No No
password varchar 255 No Yes No
salt varchar 255 No No No
activation_code varchar 40 No No No
forgotten_password_code varchar 40 No No No
forgotten_password_time int 11 No No No
remember_code varchar 40 No No No
created_on int 11 No Yes No
last_login int 11 No No No
active tinyint 1 No Yes No
first_name varchar 50 No No No
last_name varchar 50 No No No
themes varchar 15 No No No
menu varchar 100 No No No
hmenu varchar 100 No No No
location varchar 50 No No No

admin_users_groups

admin_users_groups
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 11 Yes Yes Yes
user_id int 11 No Yes No
group_id mediumint 8 No Yes No

artmaster_filetemp

artmaster_filetemp
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
mcontent varchar 150 No No No

artmaster_logs_upld

artmaster_logs_upld
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 Yes Yes Yes
ARTMU_USER varchar 25 No No No
ARTMU_FILE varchar 100 No No No
ARTMU_DATE datetime 0 No No No
ARTMU_OFILE varchar 100 No No No
ARTMU_RMARK 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
mydate datetime 0 No No No

ccbak

ccbak
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
mydate datetime 0 No No No

demo_blog_categories

demo_blog_categories
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 11 Yes Yes Yes
pos int 11 No Yes No
title varchar 100 No Yes No

demo_blog_posts

demo_blog_posts
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 11 Yes Yes Yes
category_id int 11 No Yes No
author_id int 11 No Yes No
title varchar 300 No Yes No
image_url varchar 300 No Yes No
content_brief text 0 No Yes No
content text 0 No Yes No
publish_time timestamp 0 No Yes No
status enum draft No Yes No

demo_blog_posts_tags

demo_blog_posts_tags
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 11 Yes Yes Yes
post_id int 11 No Yes No
tag_id int 11 No Yes No

demo_blog_tags

demo_blog_tags
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 11 Yes Yes Yes
title varchar 100 No Yes No

demo_cover_photos

demo_cover_photos
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 11 Yes Yes Yes
pos int 11 No Yes No
image_url varchar 300 No Yes No
status enum 0 active Yes No

groups

groups
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 11 Yes Yes Yes
name varchar 20 No Yes No
description varchar 100 No Yes No

hst2016

hst2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
HSTNUMB varchar 15 No No No
HSTCDTE datetime 0 No No No
HSTMPAY double 15,2 No No No
HSTMALL double 15,2 No No No
HSTBPAY double 15,2 No No No
HSTBALL double 15,2 No No No
HSTGPAY double 15,2 No No No
HSTSSSR double 15,2 No No No
HSTSSSE double 15,2 No No No
HSTTAXC double 15,2 No No No
HSTECCM double 15,2 No No No
HSTPIBE double 15,2 No No No
HSTPIBR double 15,2 No No No
HSTMEDE double 15,2 No No No
HSTMEDR double 15,2 No No No
HSTTDED double 15,2 No No No
HSTADON double 15,2 No No No
HSTNSPY double 15,2 No No No
HSTOTNS double 15,2 No No No
HSTOTPY double 15,2 No No No
HSTSLPY double 15,2 No No No
HSTVLPY double 15,2 No No No
HSTDOPY double 15,2 No No No
HSTLHPY double 15,2 No No No
HSTSHPY double 15,2 No No No
HSTCOFF varchar 3 No No No
HSTCOCD varchar 1 No No No
HSTPCCD varchar 1 No No No
HSTHOLD varchar 1 No No No
HSTPYNO varchar 9 No No No
HSTDPCD varchar 10 No No No
HSTLCCD varchar 3 No No No
HSTPMCD varchar 1 No No No
HSTPSNO varchar 1 No No No
HSTBKCD varchar 5 No No No
HSTESCD varchar 1 No No No
HSTFLPY double 15,2 No No No
HSTTDPD varchar 1 No No No

login_attempts

login_attempts
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 11 Yes Yes Yes
ip_address varchar 15 No Yes No
login varchar 100 No Yes No
time int 11 No No No

menu_child

menu_child
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 11 Yes Yes Yes
name varchar 25 No No No
label varchar 25 No No No
mmenu int 10 No Yes No
url varchar 25 No No No
description varchar 25 No No No
orderby int 10 No No No

menu_main

menu_main
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id int 11 Yes Yes Yes
name varchar 25 No No No
label varchar 25 No No No
group varchar 25 No No No
url varchar 25 No No No
icon varchar 15 No No No
description varchar 25 No No No
orderby int 10 No No No

menu_sub

menu_sub
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
MEN_RECID int 11 Yes Yes Yes
MEN_SNAME varchar 20 No No No
MEN_NAME varchar 25 No No No
group varchar 20 No No No
MEN_STAT enum A,D No No No
MEN_DESC varchar 25 No No No
MEN_URL varchar 25 No No No
MEN_SORT int 10 No No No

myusers

myusers
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
myusername varchar 10 No No No
myuserfulln varchar 50 No No No
myuserpass varchar 50 No No No
myuserlevel varchar 300 No No No
image_url varchar 3 No No No
myuservalis datetime 0 No No No
myuservalie datetime 0 No No No
myusercostc varchar 10 No No No
myusergroup varchar 15 No No No
myuseracomp varchar 60 No No No
myusertype varchar 7 No No No
myuserrema varchar 1 No No No
myuserremal longtext 0 No No No
myuserremcc longtext 0 No No No
menu varchar 50 No No No
submenu varchar 50 No No No

newsessions

newsessions
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
id varchar 40 Yes Yes No
ip_address varchar 45 No Yes No
timestamp int 10 No Yes No
data blob 0 No Yes No

pd2016

pd2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 11 No No No
PDMCOCD varchar 25 No No No
PDMLCCD varchar 25 No No No
PDMCOFF varchar 3 No No No
PDMFDTE datetime 0 No No No
PDMTDTE datetime 0 No No No
PDMPOST varchar 7 No No No
PDMAFDT datetime 0 No No No
PDMATDT datetime 0 No No No
PDMDAYS double 15,2 No No No
PDMADFD datetime 0 No No No
PDMADTD datetime 0 No No No
PDMSFDT datetime 0 No No No
PDMSTDT datetime 0 No No No

pdm2015

pdm2015
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
PDMCOFF varchar 3 No No No
PDMFDTE date 0 No No No
PDMTDTE date 0 No No No
PDMPOST varchar 7 No No No
PDMAFDT date 0 No No No
PDMATDT date 0 No No No
PDMDAYS int 11 No No No
PDMADFD date 0 No No No
PDMADTD date 0 No No No

pdm2016

pdm2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
PDMCOFF varchar 3 Yes Yes No
PDMFDTE date 0 No No No
PDMTDTE date 0 No No No
PDMPOST varchar 7 No No No
PDMAFDT date 0 No No No
PDMATDT date 0 No No No
PDMDAYS int 11 No No No
PDMADFD date 0 No No No
PDMADTD date 0 No No No

pmhempl

pmhempl
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB varchar 8 No No No
EMPLNAM varchar 15 No No No
EMPFNAM varchar 20 No No No
EMPMNAM varchar 15 No No No
EMPPCCD varchar 1 No No No
EMPCOCD varchar 1 No No No
EMPLCCD varchar 3 No No No

pmmcmpy

pmmcmpy
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
CMPCOCD varchar 1 No No No
CMPNAME varchar 35 No No No
CMPSSSN varchar 12 No No No
CMPTINO varchar 12 No No No
CMPCADD varchar 30 No No No
CMPSLAC varchar 10 No No No
CMPSMEC varchar 10 No No No
CMPBKAL varchar 10 No No No
CMPOTHR varchar 10 No No No
CMPHOLD varchar 10 No No No
CMPPIBE varchar 10 No No No
CMPTELE varchar 10 No No No
CMPBMAK varchar 10 No No No
CMPCASH varchar 10 No No No
CMPTAXC varchar 10 No No No
CMPSMEP varchar 10 No No No
CMPABBR varchar 5 No No No
CMPMEDP varchar 10 No No No
CMPHACC varchar 3 No No No
CMPPACC varchar 3 No No No
CMPWACC varchar 3 No No No
CMPTACC varchar 3 No No No
CMPHLAC varchar 3 No No No
CMPSACC varchar 3 No No No
CMPBACC varchar 3 No No No
CMPOIAC varchar 3 No No No
CMPSMAC varchar 3 No No No
CMPSPAC varchar 3 No No No
CMPOSLA varchar 3 No No No

pmtempl

pmtempl
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB varchar 15 Yes Yes No
EMPLNAM varchar 15 No No No
EMPFNAM varchar 12 No No No
CMPTINO varchar 20 No No No
EMPMNAM varchar 15 No No No
EMPPCCD varchar 5 No No No
EMPCOCD varchar 1 No No No
EMPLCCD varchar 3 No No No
EMPRDCD varchar 5 No No No
EMPSFCD varchar 5 No No No
EMPFPER varchar 5 No No No
EMPESCD varchar 5 No No No
EMPHDTE date 0 No No No
EMPLTAG varchar 1 No No No
EMPTAGR varchar 1 No No No
EMPTDPD varchar 1 No No No
EMPSXCD varchar 1 No No No
EMPTXCD varchar 10 No No No
EMPSTAT varchar 1 No No No
EMPDPCD varchar 10 No No No
EMPPMCD varchar 1 No No No
EMPBKCD varchar 5 No No No
EMPAVOL varchar 10 No No No
EMPPVOL varchar 10 No No No
EMPTINO varchar 11 No No No
EMPSSNO varchar 12 No No No
EMPPINO varchar 12 No No No
EMPBPAY double 15,2 No No No
EMPALLO double 15,2 No No No
QTACODE varchar 10 No No No

pmtempl_20160630

pmtempl_20160630
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
EMPNUMB varchar 15 Yes Yes No
EMPLNAM varchar 15 No Yes No
EMPFNAM varchar 20 No Yes No
title jfgccccccccccccccccjkrtujhsztaefa varchar 300 No Yes No
image_url varchar 300 No Yes No
content_brief text 0 No Yes No
content text 0 No Yes No
publish_time timestamp 0 No Yes No
status enum draft No Yes No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Qoutabase&oldid=2667"