swuweb.first

Tables (6)

Like (Untitled2)

  • like_id (Key) — Primary key — NOT NULL
  • user_id (Field)
  • post_id (Field2)
  • created_at (Field3)

LoginLog (Untitled3)

  • log_id (Key) — Primary key — NOT NULL
  • user_id (Field)
  • login_time (Field2)
  • logout_time (Field3)

Post (Untitled)

  • post_id (Key) — Primary key — NOT NULL
  • like_id (Key2) — Foreign key → Like.like_id — NOT NULL
  • user_id (Field)
  • photo_url (Field2)
  • comment (Field3)
  • feeling_temp (Field4)
  • is_public (Field5)
  • weather_info (Field6)
  • region (Field7)
  • created_at (Field8)

Untitled5

  • Key — Primary key — NOT NULL

User (회원)

  • user_id (Key2) — BIGINIT — Primary key — NOT NULL
  • post_id (Key) — Foreign key → Post.post_id — NOT NULL
  • like_id (Key3) — Foreign key → Like.like_id — NOT NULL
  • like_id (Key22) — Foreign key → Post.like_id — NOT NULL
  • log_id (Key4) — Foreign key → LoginLog.log_id — NOT NULL
  • username (Field)
  • password (Field2) — VARCHAR(100)
  • nickname (Field3) — VARCHAR(100)
  • birthdaydate (Field4)
  • email (Field5) — VARCHAR(100)
  • location (Field6)
  • created_at (Field7)

WeatherInfo (Untitled4)

  • weather_id (Key) — Primary key — NOT NULL
  • region (Field)
  • temperature (Field2)
  • humidity (Field3)
  • rain_probability (Field4)
  • feels_like_temp (Field5)
  • date (Field6)