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