Difference between revisions of "Qoutabase"

From SPGC Document Wiki
Jump to: navigation, search
(→‎pd2016)
Line 1,420: Line 1,420:
 
|datetime
 
|datetime
 
|0
 
|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
 +
|-
 +
|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
 
|No
 
|No
 
|No
 
|}
 
|}

Revision as of 14:48, 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
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
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Qoutabase&oldid=2656"