WeatherFit
Tables (4)
Feed (Untitled2)
- id (Key2) — long — Primary key — NOT NULL
- member_id (Key) — long — Foreign key → Member.id — NOT NULL
- photo (Field) — string
- post (Field2) — int
- outfit_date (Field4) — date
- outfit_region (Field5) — enum
- temp_range (Field7) — enum
- created_at (Field3) — datetime
- updated_at (Field6) — datetime
Like (Untitled4)
- feed_id (Key2) — long — Foreign key → Feed.id — NOT NULL
- member_id (Key) — long — Foreign key → Member.id — NOT NULL
- created_at (Field2) — datetime
Member (Untitled)
- id (Key) — long — Primary key — NOT NULL
- email (Field) — string
- password (Field2) — string
- nickname (Field3) — string
- gender (Field6) — enum
- profile_photo (Field9) — string
- created_at (Field7) — datetime
- updated_at (Field8) — datetime
Outfit (Untitled3)
- id (Key) — long — Primary key — NOT NULL
- feed_id (Key2) — long — Foreign key → Feed.id — NOT NULL
- top_category (Field) — enum
- bottom_category (Field2) — enum