siumall
Tables (19)
sm_customer
- id — INT — Primary key — NOT NULL
- customer_id — VARCHAR(100)
- password — VARCHAR(200)
- nickname — VARCHAR(30)
- gender — VARCHAR(1)
- created_at — DATETIME
sm_customer_address
- id — INT — Primary key — NOT NULL
- address — VARCHAR(400)
- created_at — DATETIME
- customer_id — INT — Foreign key → sm_customer.id — NOT NULL
sm_customer_cart
- id — INT — Primary key — NOT NULL
- created_at — DATETIME
- customer_id — INT — Foreign key → sm_customer.id — NOT NULL
- product_id — INT — Foreign key → sm_product.id — NOT NULL
sm_customer_saved_product
- id — INT — Primary key — NOT NULL
- created_at — DATETIME
- product_id — INT — Foreign key → sm_product.id — NOT NULL
- customer_id — INT — Foreign key → sm_customer.id — NOT NULL
sm_customer_saved_seller
- id — INT — Primary key — NOT NULL
- created_at — DATETIME
- customer_id — INT — Foreign key → sm_customer.id — NOT NULL
- seller_id — INT — Foreign key → sm_seller.id — NOT NULL
sm_option_choice
- id — INT — Primary key — NOT NULL
- option1_id — INT — Foreign key → sm_option_detail.id — NOT NULL
- option2_id — INT — Foreign key → sm_option_detail.id — NOT NULL
- option3_id — INT — Foreign key → sm_option_detail.id — NOT NULL
- product_id — INT
- sales_count — INT
- price — INT
- created_at — DATE
sm_option_detail (Untitled3)
- id — INT — Primary key — NOT NULL
- parent_option_id — INT — Foreign key → sm_product_option_category.id — NOT NULL
- option_name — VARCHAR(50)
- created_at — DATE
sm_order
- id — INT — Primary key — NOT NULL
- quantity — INT
- order_address — VARCHAR(400)
- progress — VARCHAR(10)
- ordered_at — DATETIME
- product_id — INT — Foreign key → sm_product.id — NOT NULL
- customer_id — INT — Foreign key → sm_customer.id — NOT NULL
- option_choice_id — INT — Foreign key → sm_option_choice.id — NOT NULL
sm_product
- id — INT — Primary key — NOT NULL
- name — VARCHAR(80)
- detail — VARCHAR(1000)
- price — INT
- product_main_image — VARCHAR(2000)
- sales_count — INT
- created_at — DATETIME
- seller_id — INT — Foreign key → sm_seller.id — NOT NULL
- category_id — INT — Foreign key → sm_product_sub_category.id — NOT NULL
sm_product_category
- id — INT — Primary key — NOT NULL
- category_name — VARCHAR(30)
- created_at — DATE
sm_product_image
- id — INT — Primary key — NOT NULL
- image_link — VARCHAR(2000)
- product_id — INT — Foreign key → sm_product.id — NOT NULL
sm_product_option_category (Untitled)
- id — INT — Primary key — NOT NULL
- product_id — INT — Foreign key → sm_product.id — NOT NULL
- option_category_name — VARCHAR(50)
- created_at — DATE
sm_product_sub_category
- id — INT — Primary key — NOT NULL
- category_name — VARCHAR(30)
- parent_category_id — INT — Foreign key → sm_product_category.id — NOT NULL
sm_qna (Untitled4)
- id (Key) — Primary key — NOT NULL
- customer_id — INT — Foreign key → sm_customer.id — NOT NULL
- product_id — INT — Foreign key → sm_product.id — NOT NULL
- content — VARCHAR(5000
- created_at — DATE
sm_review
- id — INT — Primary key — NOT NULL
- content — VARCHAR(4000)
- rating — INT
- created_at — DATETIME
- seller_comment — VARCHAR(4000) — ARCHAR(4000
- replied_at — DATETIME
- customer_id — INT — Foreign key → sm_customer.id — NOT NULL
- product_id — INT — Foreign key → sm_product.id — NOT NULL
sm_review_image
- id — INT — Primary key — NOT NULL
- image_link — VARCHAR(2000)
- review_id — INT — Foreign key → sm_review.id — NOT NULL
sm_seller
- id — INT — Primary key — NOT NULL
- seller_id — VARCHAR(100)
- password — VARCHAR(200)
- shop_name — VARCHAR(30)
- created_at — DATETIME
sm_seller_image (Untitled2)
- id — INT — Primary key — NOT NULL
- seller_id — INT — Foreign key → sm_seller.id — NOT NULL
- detail — VARCHAR(500)
- image_link — VARCHAR(2000)
- created_at — DATE
sm_seller_qna_reply (Untitled5)
- id — INT — Primary key — NOT NULL
- seller_id — INT — Foreign key → sm_seller.id — NOT NULL
- qna_id — INT — Foreign key → sm_qna.id — NOT NULL
- contet (content) — VARCHAR(5000)
- created_at — DATE