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)