Difference between revisions of "Quotabase"

From SPGC Document Wiki
Jump to: navigation, search
(→‎quota_entry)
 
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[DB_Specs | DB Specs]] > [[202.2.2.52 | 202.2.2.52]]
 +
 
==admin_groups==
 
==admin_groups==
 
{| class="wikitable" \
 
{| class="wikitable" \
Line 3,397: Line 3,399:
 
|No
 
|No
 
|}
 
|}
 +
 +
==quota_entry_copy==
 +
{| class="wikitable" \
 +
!colspan="7" | quota_entry_copy
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|emp_no
 +
|varchar
 +
|30
 +
|No
 +
|No
 +
|No
 +
|-
 +
|actual_date
 +
|date
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code1
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_actual_quota1
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code2
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_actual_quota2
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code3
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_actual_quota3
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_acutal_quota4
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code4
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code_ot1
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_actual_quota_ot1
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code_ot2
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_actual_quota_ot2
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_quota_code_ot3
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|N
 +
|-
 +
|reg_actual_quota_ot3
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_actual_quota_ot4
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|reg_actual_quota_ot4
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|sh_quota_code1                             
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|sh_quota_code2
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|sh_quota_code3
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|sh_quota_code4
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|sh_actual_quota1
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|sh_actual_quota2
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|sh_actual_quota3
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|sh_actual_quota4
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|sh_quota_code_ot1
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|sh_quota_code_ot2
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|sh_quota_code_ot3
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|sh_quota_code_ot4
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|sh_actual_quota_ot1
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|sh_actual_quota_ot2
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|sh_actual_quota_ot3
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|sh_actual_quota_ot4
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|N
 +
|-
 +
|lh_quota_code1
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|lh_quota_code2
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|lh_quota_code3                   
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|lh_quota_code4
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|lh_actual_quota1
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|lh_actual_quota2
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|lh_actual_quota3
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|N
 +
|-
 +
|lh_actual_quota4
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|lh_quota_code_ot1
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|lh_quota_code_ot2
 +
|varbinary
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|lh_quota_code_ot3                             
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|lh_quota_code_ot4
 +
|varchar
 +
|10
 +
|No
 +
|No
 +
|No
 +
|-
 +
|lh_actual_quota_ot1
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|lh_actual_quota_ot2
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|lh_actual_quota_ot3
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|-
 +
|lh_actual_quota_ot4
 +
|double
 +
|15,2
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==syslogs==
 +
{| class="wikitable" \
 +
!colspan="7" | syslogs
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|recid
 +
|int
 +
|30
 +
|Yes
 +
|Yes
 +
|Yes
 +
|-
 +
|errid
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|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
 +
|No
 +
|No
 +
|}
 +
 +
==users==
 +
{| class="wikitable" \
 +
!colspan="7" | users
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|user_id
 +
|int
 +
|11
 +
|Yes
 +
|Yes
 +
|Yes
 +
|-
 +
|username
 +
|varchar
 +
|25
 +
|No
 +
|No
 +
|No
 +
|-
 +
|password
 +
|varchar
 +
|60
 +
|No
 +
|No
 +
|No
 +
|}
 +
 +
==users_groups==
 +
{| class="wikitable" \
 +
!colspan="7" | users_groups
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|id
 +
|int
 +
|11
 +
|Yes
 +
|Yes
 +
|Yes
 +
|-
 +
|user_id
 +
|int
 +
|11
 +
|No
 +
|Yes
 +
|Yes
 +
|-
 +
|group_id
 +
|mediumint
 +
|8
 +
|No
 +
|Yes
 +
|Yes
 +
|}
 +
 +
[[Main_Page | Main Page]] > [[Application_Development_Team | Application Development Team]] > [[DB_Specs | DB Specs]] > [[202.2.2.52 | 202.2.2.52]]

Latest revision as of 09:21, 1 September 2016

Main Page > Application Development Team > DB Specs > 202.2.2.52

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 No No
EMPFNAM varchar 20 No No No
EMPMNAM varchar 15 No No No
EMPTXCD varchar 10 No No No
EMPSSNO varchar 12 No No No
EMPTINO varchar 11 No No No
EMPPMCD varchar 1 No No No
EMPCOCD varchar 1 No No No
EMPLCCD varchar 3 No No No
EMPSTAT varchar 1 No No No
EMPPINO varchar 12 No No No
EMPDPCD varchar 10 No No No
QTACODE varchar 10 No No No

pmtemve

pmtemve
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 25 Yes Yes Yes
EMVNUMB varchar 15 No No No
EMVEDTE datetime 0 No No No
EMVSCCD varchar 2 No No No
EMVSFCD varchar 3 No No No
EMVLCCD varchar 3 No No No
EMVDPCD varchar 10 No No No
EMVPSCD varchar 3 No No No
EMVBPAY double 15,5 No No No
EMVALLO double 15,5 No No No
EMVRDCD varchar 2 No No No
EMVESCD varchar 1 No No No
EMVFLAG tinyint 1 No No No
EMVPCCD varchar 1 No No No
EMVCOCD varchar 1 No No No
EMVFPER varchar 1 No No No
EMVPACD varchar 2 No No No
EMVDPCC varchar 10 No No No
EMVPADT datetime 0 No No No
EMVTDPD varchar 1 No No No
EMVBLOC varchar 3 No No No
OCODE varchar 3 No No No
EMVWSCD varchar 25 No No No

pmtgrup

pmtgrup
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
GRPCODE varchar 6 Yes Yes No
GRPDESC varchar 35 No No No

pmtproc

pmtproc
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
PROCODE varchar 5 Yes Yes No
PRODESC varchar 35 No No No
PROGRP varchar 5 No Yes No
PROABBR varchar 5 No Yes No

pmtqota

pmtqota
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
QTACODE varchar 5 Yes Yes No
QTAEDTE date 0 No No No
QTAREG bigint 20 No No No
QTARTEQT double 0 No No No
QTARTEPC double 0 No No No
QTAOTQ bigint 20 No No No

pmtqota_20160629

pmtqota_20160629
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
QTACODE varchar 5 Yes Yes No
QTAEDTE date 0 No No No
QTAREG bigint 20 No No No
QTARTEQT double 0 No No No
QTARTEPC double 0 No No No

pmtqota_bk

pmtqota_bk
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
QTACODE varchar 5 Yes Yes No
QTAEDTE date 0 No No No
QTAREG bigint 20 No No No
QTAOT double 0 No No No
QTARTEPC double 0 No No No

pmtqota_bk_copy

pmtqota_bk_copy
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
QTACODE varchar 5 Yes Yes No
QTAEDTE date 0 No No No
QTAREG bigint 20 No No No
QTAOT double 0 No No No
QTARTEPC double 0 No No No

pymbank

pymbank
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
BNKBKCD varchar 5 No No No
BNKDESC varchar 30 No No No
BNKADDR varchar 30 No Yes No
BNKTCSH double 0 No No No
BNKACDE varchar 3 No No No

pytchro

pytchro
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
CRONUMB varchar 8 No No No
CROCRNO varchar 12 No No No

qta2015

qta2015
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
QTANUMB varchar 8 No No No
QTACDTE date 0 No No No
QTARP01 varchar 5 No No No
QTARO01 bigint 20 No No No
QTARP02 varchar 5 No No No
QTARO02 bigint 20 No No No
QTARP03 varchar 5 No No No
QTARO03 bigint 20 No No No
QTARP04 varchar 5 No No No
QTARO04 bigint 20 No No No
QTARP05 varchar 5 No No No
QTARO05 bigint 20 No No No
QTARP06 varchar 5 No No No
QTARO06 bigint 20 No No No
QTAOP01 varchar 5 No No No
QTAOO01 bigint 20 No No N
QTAOP02 varchar 5 No No No
QTAOO02 bigint 20 No No No
QTAOP03 varchar 5 No No No
QTAOO03 bigint 20 No No No
QTAOP04 varchar 5 No No No
QTAOO04 bigint 20 No No No
QTAOP05 varchar 5 No No No
QTAOO05 bigint 20 No No No
QTAOP06 varchar 5 No No No
QTAOO06 bigint 20 No No No
QTAHP01 varchar 5 No No No
QTAHO01 bigint 20 No No No
QTAHP02 varchar 5 No No No
QTAHO02 bigint 20 No No No
QTAHP03 varchar 5 No No No
QTAHO03 bigint 20 No No No
QTAHP04 varchar 5 No No No
QTAHO04 bigint 20 No No No
QTAHP05 varchar 5 No No No
QTAHO05 bigint 20 No No N
QTAHP06 varchar 5 No No No
QTAHO06 bigint 20 No No No

qta2016

qta2016
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
QTANUMB varchar 8 No No No
QTACDTE date 0 No No No
QTARP01 varchar 5 No No No
QTARO01 bigint 20 No No No
QTARP02 varchar 5 No No No
QTARO02 bigint 20 No No No
QTARP03 varchar 5 No No No
QTARO03 bigint 20 No No No
QTARP04 varchar 5 No No No
QTARO04 bigint 20 No No No
QTARP05 varchar 5 No No No
QTARO05 bigint 20 No No No
QTARP06 varchar 5 No No No
QTARO06 bigint 20 No No No
QTAOP01 varchar 5 No No No
QTAOO01 bigint 20 No No N
QTAOP02 varchar 5 No No No
QTAOO02 bigint 20 No No No
QTAOP03 varchar 5 No No No
QTAOO03 bigint 20 No No No
QTAOP04 varchar 5 No No No
QTAOO04 bigint 20 No No No
QTAOP05 varchar 5 No No No
QTAOO05 bigint 20 No No No
QTAOP06 varchar 5 No No No
QTAOO06 bigint 20 No No No
QTAHP01 varchar 5 No No No
QTAHO01 bigint 20 No No No
QTAHP02 varchar 5 No No No
QTAHO02 bigint 20 No No No
QTAHP03 varchar 5 No No No
QTAHO03 bigint 20 No No No
QTAHP04 varchar 5 No No No
QTAHO04 bigint 20 No No No
QTAHP05 varchar 5 No No No
QTAHO05 bigint 20 No No N
QTAHP06 varchar 5 No No No
QTAHO06 bigint 20 No No No

quota_entry

quota_entry
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
emp_no varchar 30 No No No
actual_date date 0 No No No
day_type varchar 5 No No No
reg_quota_code1 varchar 10 No No No
reg_actual_quota1 varchar 10 No No No
reg_quota_code2 varchar 10 No No No
reg_actual_quota2 varchar 10 No No No
reg_quota_code3 varchar 10 No No No
reg_actual_quota3 varchar 10 No No No
reg_acutal_quota4 varchar 10 No No No
reg_quota_code4 varchar 10 No No No
reg_quota_code_ot1 varchar 10 No No No
reg_actual_quota_ot1 varchar 10 No No No
reg_quota_code_ot2 varchar 10 No No No
reg_actual_quota_ot2 varchar 10 No No No
reg_quota_code_ot3 varchar 10 No No N
reg_actual_quota_ot3 varchar 10 No No No
reg_actual_quota_ot4 varchar 10 No No No
remarks varchar 50 No No No
location varchar 10 No No No

quota_entry_copy

quota_entry_copy
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
emp_no varchar 30 No No No
actual_date date 0 No No No
reg_quota_code1 varchar 10 No No No
reg_actual_quota1 double 15,2 No No No
reg_quota_code2 varchar 10 No No No
reg_actual_quota2 double 15,2 No No No
reg_quota_code3 varchar 10 No No No
reg_actual_quota3 double 15,2 No No No
reg_acutal_quota4 double 15,2 No No No
reg_quota_code4 varchar 10 No No No
reg_quota_code_ot1 varchar 10 No No No
reg_actual_quota_ot1 double 15,2 No No No
reg_quota_code_ot2 varchar 10 No No No
reg_actual_quota_ot2 double 15,2 No No No
reg_quota_code_ot3 varchar 10 No No N
reg_actual_quota_ot3 double 15,2 No No No
reg_actual_quota_ot4 varchar 10 No No No
reg_actual_quota_ot4 double 15,2 No No No
sh_quota_code1 varchar 10 No No No
sh_quota_code2 varchar 10 No No No
sh_quota_code3 varchar 10 No No No
sh_quota_code4 varchar 10 No No No
sh_actual_quota1 double 15,2 No No No
sh_actual_quota2 double 15,2 No No No
sh_actual_quota3 double 15,2 No No No
sh_actual_quota4 double 15,2 No No No
sh_quota_code_ot1 varchar 10 No No No
sh_quota_code_ot2 varchar 10 No No No
sh_quota_code_ot3 varchar 10 No No No
sh_quota_code_ot4 varchar 10 No No No
sh_actual_quota_ot1 double 15,2 No No No
sh_actual_quota_ot2 double 15,2 No No No
sh_actual_quota_ot3 double 15,2 No No No
sh_actual_quota_ot4 double 15,2 No No N
lh_quota_code1 varchar 10 No No No
lh_quota_code2 varchar 10 No No No
lh_quota_code3 varchar 10 No No No
lh_quota_code4 varchar 10 No No No
lh_actual_quota1 double 15,2 No No No
lh_actual_quota2 double 15,2 No No No
lh_actual_quota3 double 15,2 No No N
lh_actual_quota4 double 15,2 No No No
lh_quota_code_ot1 varchar 10 No No No
lh_quota_code_ot2 varbinary 10 No No No
lh_quota_code_ot3 varchar 10 No No No
lh_quota_code_ot4 varchar 10 No No No
lh_actual_quota_ot1 double 15,2 No No No
lh_actual_quota_ot2 double 15,2 No No No
lh_actual_quota_ot3 double 15,2 No No No
lh_actual_quota_ot4 double 15,2 No No No

syslogs

syslogs
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
recid int 30 Yes Yes Yes
errid varchar 25 No No 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 No No

users

users
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
user_id int 11 Yes Yes Yes
username varchar 25 No No No
password varchar 60 No No No

users_groups

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 Yes
group_id mediumint 8 No Yes Yes

Main Page > Application Development Team > DB Specs > 202.2.2.52

Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Quotabase&oldid=3954"