FitYou

Tables (6)

category

  • seq — BIGINT — Primary key — NOT NULL
  • name — VARCHAR
  • style_code — BIGINT

member

  • username — VARCHAR — Primary key
  • pwd — VARCHAR
  • age — INT
  • cus_num — INT
  • role — ENUM
  • regidate — VARCHAR

member_detail

  • seq — BIGINT — Primary key — NOT NULL
  • sell_dt — VARCHAR
  • sell_num — INT
  • shop_code — VARCHAR
  • color_name — VARCHAR
  • size — VARCHAR
  • sell_count — INT
  • cus_num — INT
  • prod_code (prod_code2) — VARCHAR — Foreign key → product.prod_code — NOT NULL

member_like

  • seq — BIGINT — Primary key — NOT NULL
  • category_seq — BIGINT — Foreign key → category.seq — NOT NULL
  • username — VARCHAR — Foreign key → member.username

product

  • prod_code — VARCHAR — Primary key — NOT NULL
  • image_url — VARCHAR
  • style_code — BIGINT
  • prod_name — VARCHAR
  • prod_price — VARCHAR
  • prod_category — VARCHAR

product_rank

  • prod_code — VARCHAR — Primary key — NOT NULL
  • cnt — INT