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