shoppingmall
Tables (15)
address
- address_no — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → user.user_id
- name — varchar(255) — NOT NULL
- zip_code — varchar(255) — NOT NULL
- address — varchar(255) — NOT NULL
- detail_addr — varchar(255) — NOT NULL
- default_addr — enum('Y','N') — NOT NULL
- deliveryMsg — varchar(300)
admin
- admin_id — int(11) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- role — enum('admin','moderator') — NOT NULL
- create_at — datetime — NOT NULL
- update_at — datetime
cart
- cart_id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → user.user_id
- option_id — int(11) — Foreign key → product_option.option_id — NOT NULL
- quantity — int(11) — NOT NULL
- create_at — datetime — NOT NULL
helpful_review
- review_no — int(11) — Foreign key → review.review_no — NOT NULL
- user_id — int(11) — Foreign key → user.user_id — NOT NULL
- product_no — int(11) — Foreign key → product.product_id — NOT NULL
- press_at — datetime
like_product
- product_no — int(11) — Foreign key → product.product_id — NOT NULL
- user_id — int(11) — Foreign key → user.user_id — NOT NULL
- like_at — datetime
order
- order_no — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → user.user_id
- quantity — int(11) — NOT NULL
- order_state — enum('주문 완료','배송 중','배송 완료','환불 진행 중','환불 완료') — NOT NULL
- refund_reason — varchar(255)
- address_no — int(11) — Foreign key → address.address_no
- payment_method — varchar(255) — NOT NULL
- total_price — int(11) — NOT NULL
- order_at — datetime — NOT NULL
order_items
- orderItem_no — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → user.user_id
- order_no — int(11) — Foreign key → order.order_no
- option_id — int(11) — Foreign key → product_option.option_id — NOT NULL
- quantity — int(11) — NOT NULL
- unit_price — int(11) — NOT NULL
- total_price — int(11) — NOT NULL
- review_status — tinyint(1) — NOT NULL
- create_at — datetime — NOT NULL
product
- product_id — int(11) — Primary key — NOT NULL
- product_category — int(11) — Foreign key → product_categories.category_id
- brand — varchar(100) — NOT NULL
- product_name — varchar(255) — NOT NULL
- product_content — varchar(255) — NOT NULL
- gender — enum('남성','여성','남녀공용') — NOT NULL
- price — int(11) — NOT NULL
- sale_price — int(11)
- reg_at — datetime — NOT NULL
- update_at — datetime
product_categories
- category_id — int(11) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- description — varchar(255) — NOT NULL
- parent_id — int(11) — Foreign key → product_categories.category_id
product_option
- option_id — int(11) — Primary key — NOT NULL
- product_no — int(11) — Foreign key → product.product_id — NOT NULL
- color — varchar(50) — NOT NULL
- size — enum('XS(85)'
- XXL(110)) — COLLATE
- stock — int(11)
- reg_at — datetime
- update_at — datetime
qna
- qna_no — int(11) — Primary key — NOT NULL
- product_no — int(11) — Foreign key → product.product_id
- option_id — int(11) — Foreign key → product_option.option_id — NOT NULL
- user_id — int(11) — Foreign key → user.user_id
- title — varchar(50) — NOT NULL
- content — varchar(1000) — NOT NULL
- private — tinyint(1) — NOT NULL
- private_pwd — varchar(255)
- answer_yn — tinyint(1) — NOT NULL
- write_at — datetime — NOT NULL
qna_answer
- qna_answer_no — int(11) — Primary key — NOT NULL
- admin_no — int(11) — Foreign key → admin.admin_id
- qna_no — int(11) — Foreign key → qna.qna_no
- contents — varchar(1000) — NOT NULL
- write_at — datetime — NOT NULL
review
- review_no — int(11) — Primary key — NOT NULL
- product_no — int(11) — Foreign key → product.product_id
- option_id — int(11) — Foreign key → product_option.option_id — NOT NULL
- user_id — int(11) — Foreign key → user.user_id
- scope — decimal(2,1) — NOT NULL
- write_at — datetime — NOT NULL
- contents — varchar(1000) — NOT NULL
user
- user_id — int(11) — Primary key — NOT NULL
- name — varchar(255) — NOT NULL
- phone — varchar(11) — NOT NULL
- email — varchar(255) — NOT NULL
- password — varchar(255) — NOT NULL
- create_at — datetime — NOT NULL
- update_at — datetime
user_token
- token_id — int(11) — Primary key — NOT NULL
- user_id — int(11) — Foreign key → user.user_id — NOT NULL
- token — varchar(255) — NOT NULL
- device_id — varchar(255) — NOT NULL
- create_at — timestamp — NOT NULL
- expires_at — datetime — NOT NULL