sp
Sample
Tables (24)
tsAdminuser
- auId — INT(11) — Primary key — NOT NULL
- auLoginId — VARCHAR(500)
- auLoginPw — VARCHAR(2000)
- auName — VARCHAR(50)
- auEmail — VARCHAR(50)
- auPhone — VARCHAR(50)
- auActive — VARCHAR(1)
tsboard
- bId — int(11) — Primary key — NOT NULL
- type — varchar(50) — NOT NULL
- idtype — varchar(50)
- title — varchar(200) — NOT NULL
- content — mediumtext
- writer — varchar(50)
- writerId — varchar(500) — NOT NULL
- regdate — datetime
- viewcnt — int(11)
- password — varchar(1000)
- salt — varchar(512)
- secret — varchar(2)
- bMailService — varchar(2)
- bImg — varchar(200)
tsboard_event
- eId — int(11) — Primary key — NOT NULL
- bId — int(11) — Foreign key → tsboard.bId — NOT NULL
- eReply — varchar(10)
- eSecret — varchar(10)
- eAuthority_R — varchar(50)
- eAuthority_W — varchar(50)
- eAuthority_U — varchar(50)
- eWriter_set — varchar(50)
- eWriter_prt — varchar(10)
tscompany
- cId — int(11) — Primary key — NOT NULL
- cCode — varchar(100) — NOT NULL
- cName — varchar(100) — NOT NULL
- cNumber — varchar(100)
- cPhone — varchar(100)
- cPost — varchar(50)
- cAddress — varchar(200)
- cFilePath — varchar(200)
- cFileName — varchar(50)
- cDescription — varchar(1000)
tscompanyuser
- cuId — int(11) — Primary key — NOT NULL
- cId — int(11) — Foreign key → tscompany.cId — NOT NULL
- uId — int(11) — Foreign key → tsuser.uId — NOT NULL
tscontract
- ctId — int(11) — Primary key — NOT NULL
- uId — int(11) — Foreign key → tsuser.uId — NOT NULL
- pdId — int(11) — Foreign key → tsproduct.pdId — NOT NULL
- cId — int(11) — Foreign key → tscompany.cId — NOT NULL
- ctCode — varchar(500) — NOT NULL
- uLoginId — varchar(500) — NOT NULL
- ctPeriodFrom — varchar(10) — NOT NULL
- ctPeriodTo — varchar(100) — NOT NULL
- ctLicense — int(11) — NOT NULL
tscontractadmin
- caId — int(11) — Primary key — NOT NULL
- caLoginId — varchar(500) — NOT NULL
- caLoginPw — varchar(2000) — NOT NULL
- caName — varchar(50) — NOT NULL
- caEmail — varchar(100)
- caPhone — varchar(50)
tsdepth_m
- dmId — int(11) — Primary key — NOT NULL
- dmCode — varchar(50) — NOT NULL
- dmName — varchar(50) — NOT NULL
- dmUse — varchar(1) — NOT NULL
- dmDescription — varchar(8000)
tsdepth_s
- dsId — int(11) — Primary key — NOT NULL
- dmId — int(11) — Foreign key → tsdepth_m.dmId — NOT NULL
- dsName — varchar(50) — NOT NULL
- dsValue — varchar(50) — NOT NULL
- dsUse — varchar(1) — NOT NULL
- dsDescription — varchar(8000)
tsdownload
- dId — int(11) — Primary key — NOT NULL
- pdId — int(11) — Foreign key → tsproduct.pdId — NOT NULL
- uId — int(11) — Foreign key → tsuser.uId — NOT NULL
- pdCode — varchar(50) — NOT NULL
- dIp — varchar(100) — NOT NULL
- dCheckTime — varchar(20) — NOT NULL
tsemail
- emId — int(11) — Primary key — NOT NULL
- emContent — mediumtext
- emTitle — varchar(500)
- emDescription — varchar(500)
tsevent
- eId — int(11) — Primary key — NOT NULL
- eType — varchar(50)
- eTitle — varchar(200) — NOT NULL
- eContent — mediumtext
- eWriterId — varchar(500) — NOT NULL
- eRegdate — datetime
- eImgfile — varchar(200)
- ePlace — varchar(200)
- eStartdate — date — NOT NULL
- eEnddate — date — NOT NULL
- eTime — varchar(200)
- eDate — date — NOT NULL
tsfile
- fId — int(11) — Primary key — NOT NULL
- dsId — int(11) — Foreign key → tsdepth_s.dsId — NOT NULL
- fName — varchar(300)
- fPath — varchar(300)
- fSize — int(11)
- create_dt — timestamp — NOT NULL
tslicenseuser
- luId — int(11) — Primary key — NOT NULL
- uId — int(11) — Foreign key → tsuser.uId — NOT NULL
- cId — int(11) — Foreign key → tscompany.cId — NOT NULL
tslogincheck
- uId — int(11) — Foreign key → tsuser.uId — NOT NULL
- MacAddress — varchar(20) — NOT NULL
- CheckTime — varchar(20) — NOT NULL
tsloginlog
- logId — int(11) — Primary key — NOT NULL
- uId — int(11) — Foreign key → tsuser.uId — NOT NULL
- dIp — varchar(100) — NOT NULL
- dCheckTime — varchar(20) — NOT NULL
tsmenu
- menu_id — int(11) — Primary key — NOT NULL
- dsId — int(11) — Foreign key → tsdepth_s.dsId — NOT NULL
- menu_nm — varchar(300) — NOT NULL
- url — varchar(300) — NOT NULL
- sort — varchar(100) — NOT NULL
- up_menu_id — varchar(100) — NOT NULL
- lv — varchar(1) — NOT NULL
- use_yn — varchar(1) — NOT NULL
tspageview
- pId — int(11) — Primary key — NOT NULL
- pURL — varchar(100) — NOT NULL
- pTime — datetime — NOT NULL
- pIp — varchar(100) — NOT NULL
tsproduct
- pdId — int(11) — Primary key — NOT NULL
- pdCode — varchar(50) — NOT NULL
- pdName — varchar(50) — NOT NULL
- pdAppVersion — varchar(50) — NOT NULL
- pdVersion — varchar(50) — NOT NULL
- pdFile — varchar(50) — NOT NULL
- pdManual — varchar(50) — NOT NULL
- pdUpdateDate — varchar(20) — NOT NULL
- pdDescription — varchar(8000) — NOT NULL
- pdDepth — varchar(50) — NOT NULL
tsproduct_bd
- pbId — int(11) — Primary key — NOT NULL
- pdId — int(11) — Foreign key → tsproduct.pdId — NOT NULL
- pbType — varchar(50) — NOT NULL
- pbTitle — varchar(100)
- pbContent — mediumtext
- pbUpdatedate — datetime
- pbImg — varchar(200)
tsproductuser
- puId — int(11) — Primary key — NOT NULL
- uId — int(11) — Foreign key → tsuser.uId — NOT NULL
- cId — int(11) — Foreign key → tscompany.cId — NOT NULL
- pdId — int(11) — Foreign key → tsproduct.pdId — NOT NULL
tsreply
- rId — int(11) — Primary key — NOT NULL
- bId — int(11) — Foreign key → tsboard.bId — NOT NULL
- reText — mediumtext — NOT NULL
- rewriterId — varchar(50)
- regdate — datetime
- updatedate — datetime
tsuser
- uId — int(11) — Primary key — NOT NULL
- uLoginId — varchar(500) — NOT NULL
- uLoginPw — varchar(2000) — NOT NULL
- uName — varchar(50) — NOT NULL
- uPhone — varchar(50)
- uAgree — varchar(1) — NOT NULL
- cId — int(11)
- uAdmin — varchar(50) — NOT NULL
- uActive — varchar(1) — NOT NULL
- uDept — varchar(50) — NOT NULL
tsvisitor
- vId — int(11) — Primary key — NOT NULL
- vIp — varchar(100) — NOT NULL
- vTime — datetime — NOT NULL
- vRefer — varchar(300) — NOT NULL
- vAgent — varchar(400) — NOT NULL