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)