|
|
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" \ |
Revision as of 08:53, 25 August 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
|
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
|
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
|