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