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