test

Tables (10)

cart

  • cart_num — int(11) — Primary key — NOT NULL
  • cust_num — int(11) — Foreign key → customer.cust_num — NOT NULL

cart_item

  • cart_item_num — int(11) — Primary key — NOT NULL
  • cart_num — int(11) — Foreign key → cart.cart_num — NOT NULL
  • item_num — int(11) — Foreign key → item.item_num — NOT NULL
  • count — int(11) — NOT NULL

category

  • category_name — varchar(30) — Primary key — NOT NULL

customer

  • cust_num — int(11) — Primary key — NOT NULL
  • grade — varchar(50) — Foreign key → grade.grade_name — NOT NULL — 'BRONZE', 'SILVER', 'GOLD', 'PLATINUM'
  • cust_name — varchar(15) — NOT NULL
  • cust_id — varchar(15) — NOT NULL
  • cust_pw — varchar(100) — NOT NULL
  • cust_tel — varchar(15)
  • total_price — int(11) — NOT NULL
  • role — varchar(30)

grade

  • grade_name — varchar(30) — Primary key — NOT NULL
  • min — int(11)
  • max — int(11)

item

  • item_num — int(11) — Primary key — NOT NULL
  • category_name — varchar(30) — Foreign key → category.category_name — NOT NULL
  • item_name — varchar(500) — NOT NULL
  • item_price — int(11) — NOT NULL
  • item_cnt — int(11) — NOT NULL
  • item_image — varchar(500)
  • item_info — varchar(500)

notice

  • notice_num — int(11) — Primary key — NOT NULL
  • notice_title — varchar(100) — NOT NULL
  • hit — int(11) — NOT NULL
  • notice_date — datetime — NOT NULL
  • notice_content — varchar(300) — NOT NULL

order

  • order_num — int(11) — Primary key — NOT NULL
  • cust_num — int(11) — Foreign key → customer.cust_num — NOT NULL
  • order_date — datetime — NOT NULL
  • address — varchar(500) — NOT NULL
  • order_req — varchar(500)

orders_detail

  • order_detail_num — int(11) — Primary key — NOT NULL
  • order_num — int(11) — Foreign key → order.order_num — NOT NULL
  • item_num — int(11) — Foreign key → item.item_num — NOT NULL
  • item_cnt — int(11) — NOT NULL
  • order_status — varchar(50) — NOT NULL
  • price — int(11) — NOT NULL

review

  • review_num — int(11) — Primary key — NOT NULL
  • order_detail_num — int(11) — Foreign key → orders_detail.order_detail_num — NOT NULL
  • cust_num — int(11) — Foreign key → customer.cust_num — NOT NULL
  • item_num — int(11) — Foreign key → item.item_num — NOT NULL
  • review_title — varchar(100) — NOT NULL
  • review_date — datetime — NOT NULL
  • review_content — varchar(300) — NOT NULL
  • review_img — varchar(600)