Mensclub

Tables (8)

Bookmark

  • idi (id) — INT — Primary key — NOT NULL
  • 유저 id (user_id) — INT — Foreign key → Members.id — NOT NULL
  • 추천 id (recommend_id) — INT — Foreign key → Recommend.id — NOT NULL

Clothes

  • id — INT — Primary key — NOT NULL

Main_Recommend

  • id — INT — Primary key — NOT NULL
  • top_id — INT — Foreign key → Clothes.id — NOT NULL
  • bottom_id — INT — Foreign key → Clothes.id — NOT NULL
  • outer_id — INT — Foreign key → Clothes.id — NOT NULL
  • shoes_id — INT — Foreign key → Clothes.id — NOT NULL
  • id (id2) — INT — Foreign key → Shoes.id — NOT NULL

Main_bookmark

  • id — Primary key — NOT NULL
  • user_id — INT — Foreign key → Members.id — NOT NULL
  • main_id — INT — Foreign key → Main_Recommend.id — NOT NULL

Members

  • id — INT — Primary key — NOT NULL

Recommend

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → Members.id — NOT NULL
  • top_id — INT — Foreign key → Clothes.id — NOT NULL
  • bottom_id — INT — Foreign key → Clothes.id — NOT NULL
  • outer_id — INT — Foreign key → Clothes.id — NOT NULL
  • shoes_id — INT — Foreign key → Shoes.id — NOT NULL

Shoes

  • id — INT — Primary key — NOT NULL

User_upload

  • id (Key) — Primary key — NOT NULL
  • user_id — INT — Foreign key → Members.id — NOT NULL