qqqq

Tables (16)

Product_cart

  • cart_ID — CHAR(10) — Primary key — NOT NULL
  • product_ID — CHAR(10)

Untitled

  • Key — VARCHAR(255) — Primary key — NOT NULL

color

  • color_id — CHAR(10) — Primary key — NOT NULL
  • color — CHAR(10)

coupon

  • coupon_id — CHAR(20) — Primary key — NOT NULL
  • discount_price — CHAR(6)
  • user_id — VARCHAR(20) — NOT NULL

event

  • event_id — CHAR(15) — Primary key — NOT NULL
  • event_name — CHAR(20)

exchange

  • exchange_id — CHAR(10) — Primary key — NOT NULL
  • exchange_issue — VARCHAR(100)
  • oder_id — CHAR(10) — NOT NULL

main_category

  • main_category_id — CHAR(10) — Primary key — NOT NULL
  • category — VARCHAR(100)

product

  • product_id — CHAR(10) — Primary key — NOT NULL
  • product_name — VARCHAR(100)
  • desc — VARCHAR(100)
  • product_price — INT
  • thumnail_image — VARCHAR(100)
  • isSoldout — TINYINT(1)
  • cart_ID — CHAR(10) — NOT NULL
  • sub_category — CHAR(10) — NOT NULL
  • proudctTag — CHAR(5) — NOT NULL

productTag

  • proudctTag — CHAR(5) — Primary key — NOT NULL
  • TagName — CHAR(10)
  • product_id — CHAR(10) — NOT NULL

product_detail

  • product_detail_id — CHAR(10) — Primary key — NOT NULL
  • season — VARCHAR(100)
  • gender — VARCHAR(100)
  • size — CHAR(4)
  • brand — VARCHAR(100)
  • origin — VARCHAR(100)
  • stock — INT
  • color — CHAR(10)
  • product_id — CHAR(10) — NOT NULL

product_like

  • producLike_id — CHAR(10) — Primary key — NOT NULL
  • grade — VARCHAR(100)
  • review — VARCHAR(100)
  • like — INT
  • isdiscount — CHAR(4)
  • discount — INT
  • ranking — INT
  • sales_rate — CHAR(8)
  • product_id2 — CHAR(10) — NOT NULL

product_order

  • product_id — CHAR(10) — NOT NULL
  • oder_id — CHAR(10) — NOT NULL

recipe

  • oder_id — CHAR(10) — Primary key — NOT NULL
  • delivery — CHAR(5)
  • invoice_number — VARCHAR(100)
  • address — VARCHAR(30)
  • delivery_company — CHAR(10)
  • user_id — VARCHAR(20) — NOT NULL
  • cart_ID — VARCHAR(20) — NOT NULL

refund

  • refund_id — CHAR(10) — Primary key — NOT NULL
  • refund_issue — VARCHAR(100)
  • product_photo — VARCHAR(100)
  • isphoto — TINYINT(1)
  • oder_id — VARCHAR(20) — NOT NULL

sub_category

  • sub_category — CHAR(10) — Primary key — NOT NULL
  • sub_category_name — VARCHAR(100)
  • main_category_id — CHAR(10) — NOT NULL

user

  • user_id — VARCHAR(20) — Primary key — NOT NULL
  • user_pw — VARCHAR(30)
  • user_email — VARCHAR(40)
  • user_phone — CHAR(13)
  • user_address — VARCHAR(100)
  • user_personal — CHAR(15)
  • nickname — CHAR(10)
  • profile_photo — VARCHAR(100)
  • photo_check — TINYINT
  • first_message — VARCHAR(100)