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)