example
Tables (8)
Cart
- cart_no — int(50) — Primary key — NOT NULL
- cart_m_id — varchar(15) — Foreign key → Customer.m_id — NOT NULL
- cart_p_no — varchar(30) — Foreign key → Product.p_no — NOT NULL
- cart_amount — int(50)
Customer
- m_id — varchar(15) — Primary key — NOT NULL
- m_pw — varchar(20)
- m_name — varchar(10)
- m_phone — varchar(20)
- m_address — varchar(40)
- m_email — varchar(30)
- m_regdate — date
- m_savemoney — int(30)
Event_product
- e_no — varchar(30) — Primary key — NOT NULL
- e_sotck — int(20)
- e_name — varchar(100)
- e_cost — int(100)
- e_description — varchar(150)
- e_date — date
- e_company — varchar(20)
- e_image — mediumblob
- e_color — varchar(30)
- e_discount_rate — varchar(30)
- e_buy_count — int(200)
Order
- order_no — varchar(20) — Primary key — NOT NULL
- order_m_id — varchar(15) — Foreign key → Customer.m_id — NOT NULL
- order_recv_name — varchar(30)
- order_recv_address — varchar(100)
- order_recv_phone — vharchar(30)
- order_date — date
- order_requirement — varchar(100)
- order_total_cost — int(30)
Order_detail
- p_no — varchar(30) — NOT NULL
- order_no — varchar(20) — NOT NULL
- count — int(30)
Product
- p_no — varchar(30) — Primary key — NOT NULL
- p_sotck — int(20)
- p_name — varchar(100)
- p_cost — int(100)
- p_description — varchar(150)
- p_date — date
- p_company — varchar(20)
- p_category_code — varchar(50) — NOT NULL
- p_image — mediumblob
- p_color — varchar(30)
- p_size — varchar(20)
- p_star — varchar(20)
- p_discount_rate — varchar(30)
- p_buy_count — int(200)
Product_category
- p_category_code — vharchar(50) — Primary key — NOT NULL
- p_category_name — varchar(50)
Review
- r_no — vharchar(30) — Primary key — NOT NULL
- p_no — varchar(30) — NOT NULL
- r_date — date
- r_title — varchar(50)
- r_content — varchar(50)
- r_image — mediumblob