minimim
Tables (6)
order
- order_num — int — NOT NULL
- user_id — varchar(50) — Foreign key → user.user_id — NOT NULL
- order_date — date — NOT NULL
order_details
- order_details_num — int — NOT NULL
- order_num — int — Foreign key → order.order_num — NOT NULL
- pro_num — int — Foreign key → product.pro_num — NOT NULL
- order_quantity — int — NOT NULL
- order_status — int — NOT NULL
product
- pro_num — int — NOT NULL
- pro_name — varchar(30) — NOT NULL
- pro_type — varchar(30) — NOT NULL
- cost_price — int — NOT NULL
- sell_price — int — NOT NULL
- profit — int — NOT NULL
- pro_detail — varchar(255) — NOT NULL
- pro_pic — varchar(255) — NOT NULL
- delete_or_not — int — NOT NULL
- pro_date — date — NOT NULL
- pro_quantity — int — NOT NULL
qna
- qna_num — int — NOT NULL
- qna_title — varchar(255) — NOT NULL
- q_detail — varchar(255) — NOT NULL
- a_detail — varchar(255) — NOT NULL
- user_id — varchar(50) — NOT NULL
- qna_status — int — NOT NULL
- qna_date — date — NOT NULL
- user_id (user_id2) — varchar(50) — Foreign key → user.user_id — NOT NULL
shop_basket
- basket_num — int(10) — NOT NULL
- user_id — varchar(50) — Foreign key → user.user_id — NOT NULL
- pro_num — int — Foreign key → product.pro_num — NOT NULL
- basket_quantity — int — NOT NULL
- basket_status — int — NOT NULL
- basket_date — date — NOT NULL
user
- user_id — varchar(50) — Primary key — NOT NULL
- user_pw — varchar(50) — NOT NULL
- user_name — varchar(20) — NOT NULL
- email — varchar(50) — NOT NULL
- phone_num — varchar(50) — NOT NULL
- addr_num — int — NOT NULL
- addr — varchar(200) — NOT NULL
- status — int — NOT NULL
- joindate — date — NOT NULL