teamproject
Tables (3)
config (환경설정)
- idx (int) — auto_increment — Primary key — NOT NULL
- title (varchar(100))
- aemail (varchar(100)-2)
- ptuse (enum('Y','N'))
- wpoint (int(4))
- wlevel (int(2))
- comname (varchar(50))
- comnum (varchar(12))
- ceoname (varchar(50)-2)
- cstel (varchar(17))
- comfirmno (varchar(50)-3)
- addno (varchar(50)-4)
- zipcode (varchar(5))
- address (varchar(100)-3)
- masternm (varchar(50)-5)
- masteremail (varchar(100)-4)
- banknm (varchar(20))
- accountno (int (15))
- carduse (enum('Y','N')-2)
- teluse (enum('Y','N')-3)
- giftuse (enum('Y','N')-4)
- minpoint (int(4)-2)
- maxpoint (int(4)-3)
- receipt (enum('Y','N')-5)
- shipcom (varchar(50)-6)
- shipfee (int(5))
- shipdate (enum('Y','N')-6)
- regtime (timestamp) — current_timestamp
member (회원)
- midx (int) — auto_increment — Primary key — NOT NULL
- mid (varchar(30))
- mpass (varchar(100))
- mname (char(30))
- memail (varchar(50))
- mtel (char(11))
- mdate (timestamp) — current_timestamp
- muse (enum('Y','N'))
- email_use (enum('Y','N')-2)
- sms_use (enum('Y','N')-3)
product (상품)
- pidx (int) — auto_increment — Primary key — NOT NULL
- pdm (varchar(30))
- psm (varchar(30)-2)
- pid (varchar(50))
- pname (varchar(100))
- ptext (text)
- pmoney (int(7))
- psale (int(3))
- psmoney (int(7)-2)
- pnum (int(4))
- penum (enum('Y','N')) — default Y
- psold (enum('Y','N')-2) — default N
- pimg (text-2)
- ptextl (text-3)
- pdate (timestamp) — current_timestamp