SHOP_ERD
Tables (17)
answer
- answer_pk_num — INT
- answer_content — TEXT — NOT NULL
- answer_regdate — DATETIME — NOT NULL
- answer_fk_question_num — INT — NOT NULL
- answer_fk_user_num — INT — NOT NULL
brand
- brand_pk_num — INT
- brand_name — VARCHAR(20) — NOT NULL
- brand_pic — VARCHAR(255)
cart
- cart_pk_num — INT
- cart_quantity — INT — NOT NULL
- cart_fk_product_num — INT — NOT NULL
- cart_fk_size_num — INT — NOT NULL
- cart_fk_user_num — INT — NOT NULL
category
- category_pk_num — INT
- category_name — VARCHAR(255) — NOT NULL
coupon
- coupon_pk_num — INT
- coupon_code — VARCHAR(100) — NOT NULL
- coupon_type — ENUM('percentage', 'fixed') — NOT NULL
- coupon_value — INT — NOT NULL
- coupon_start — DATE — NOT NULL
- coupon_end — DATE — NOT NULL
- coupon_minimum — INT
notice
- notice_pk_num — INT
- notice_title — VARCHAR(255) — NOT NULL
- notice_content — TEXT
- notice_regdate — DATETIME — NOT NULL
- notice_import — TINYINT
order
- order_pk_num — INT
- order_date — DATETIME — NOT NULL
- order_status — ENUM('결제대기', '배송준비중', '배송중', '배송완료') — NOT NULL
- order_location — TEXT
- order_totalprice — DOUBLE — NOT NULL
- order_fk_user_num — INT — NOT NULL
- order_fk_coupon_num — INT
orderhistory
- orderhis_pk_num — INT
- orderhis_quantity — INT — NOT NULL
- orderhis_price — INT — NOT NULL
- orderhis_review — TINYINT
- orderhis_fk_product_num — INT — NOT NULL
- orderhis_fk_size_num — INT — NOT NULL
- orderhis_fk_order_num — INT — NOT NULL
product
- product_pk_num — INT
- product_name — VARCHAR(255) — NOT NULL
- product_description — TEXT
- product_price — INT — NOT NULL
- product_stock — INT — NOT NULL
- product_sale — INT
- product_promotion — TINYINT
- product_fk_brand_num — INT
- product_fk_category_num — INT
- product_fk_target_num — INT
productpic
- propic_pk_num — INT
- propic_path — VARCHAR(255) — NOT NULL
- propic_fk_product_num — INT — NOT NULL
productsize
- prosize_pk_num — INT
- prosize_fk_size_num — INT — NOT NULL
- prosize_fk_product_num — INT — NOT NULL
question
- question_pk_num — INT
- question_title — VARCHAR(255) — NOT NULL
- question_content — TEXT — NOT NULL
- question_regdate — DATETIME — NOT NULL
- question_private — TINYINT
- question_fk_user_num — INT — NOT NULL
- question_fk_product_num — INT
review
- review_pk_num — INT
- review_content — TEXT
- review_rating — ENUM('1', '2', '3', '4', '5')
- review_date — DATETIME — NOT NULL
- review_pic — VARCHAR(255)
- review_fk_user_num — INT — NOT NULL
- review_fk_product_num — INT — NOT NULL
size
- size_pk_num — INT
- size_value — VARCHAR(20) — NOT NULL
target
- target_pk_num — INT
- target_name — VARCHAR(10) — NOT NULL
user
- user_pk_num — INT
- user_id — VARCHAR(30) — NOT NULL
- user_pw — VARCHAR(30) — NOT NULL
- user_birth — DATE
- user_addr — TEXT
- user_name — VARCHAR(10) — NOT NULL
- user_tel — VARCHAR(20)
- user_mail — VARCHAR(50)
- user_roll — VARCHAR(20)
usercoupon
- usercoup_pk_num — INT
- usercoup_fk_user_num — INT — NOT NULL
- usercoup_fk_coupon_num — INT — NOT NULL
- usercoup_possible — TINYINT