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