Qoutabase

From SPGC Document Wiki

Revision as of 15:19, 8 August 2016 by Ojt1 (Talk | contribs) (→‎pmmcmpy)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Jump to: navigation, search

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

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