SeeFit
Tables (6)
CATEGORY_AGE (연령대 카테고리)
- id (Key) — long — Primary key — NOT NULL
- name (Field) — VARCHAR(200)
CATEGORY_FRAME (프레임 종류 카테고리)
- id (Key) — long — Primary key — NOT NULL
- name (Field) — VARCHAR(200)
LIKE (좋아하는 상품)
- id (PK) — long — Primary key — NOT NULL
- id (Key2) — Long — Foreign key → USER.id — NOT NULL
- id (PK2) — long — Foreign key → PRODUCT.id — NOT NULL
- shop_id (FK) — long — Foreign key → PRODUCT.shop_id — NOT NULL
PRODUCT (상품)
- id (PK) — long — Primary key — NOT NULL
- shop_id (FK) — long — Foreign key → SHOP.id — NOT NULL
- name (Field) — VARCHAR(200)
- price (Field2) — long
- model (Field3)
- link (Field4) — VARCHAR(400)
- id (FK2) — long — Foreign key → CATEGORY_AGE.id — NOT NULL
- id (FK3) — long — Foreign key → CATEGORY_FRAME.id — NOT NULL
SHOP (브랜드)
- id (PK) — long — Primary key — NOT NULL
- name (Field) — VARCHAR(30)
- description (Field2) — VARCHAR(1000)
- business_number (Field3) — VARCHAR(50)
- role (Field4) — ENUM
USER (유저)
- id (Key) — Long — Primary key — NOT NULL
- social_account (Field1) — VARCHAR(200)
- nickname (Field2) — VARCHAR(20)