gildongmu
Tables (10)
TravelLocation (Untitled2)
- travel_location_id (Key) — Primary key — NOT NULL
- travel_log_id (Key2) — Foreign key → TravelLog.travel_log_id — NOT NULL
- user_id — int — Foreign key → TravelLog.user_id — NOT NULL
- sequence (Field)
- name (Field3)
- latitude (Field2)
- longitude (Field5)
- congestion (Field4)
TravelLog (Untitled)
- travel_log_id (Key) — Primary key — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- title (Field)
TravelLogTag (Untitled9)
- id (Key2) — Primary key — NOT NULL
- travel_log_id (Key) — Foreign key → TravelLog.travel_log_id — NOT NULL
- user_id — int — Foreign key → TravelLog.user_id — NOT NULL
- tag (Field)
TravelReview (Untitled4)
- travel_review_id (Key2) — Primary key — NOT NULL
- travel_log_id (Key) — Foreign key → TravelLog.travel_log_id — NOT NULL
- user_id — int — Foreign key → TravelLog.user_id — NOT NULL
- title (Field4)
- rating (Field2)
- weather (Field5)
- mood_score (Field)
- tag (Field3)
- note (Field7)
- song (Field6)
TravelReviewPhoto (후기 사진)
- id (Key) — Primary key — NOT NULL
- travel_review_id (Key2) — Foreign key → TravelReview.travel_review_id — NOT NULL
- travel_log_id (Key3) — Foreign key → TravelReview.travel_log_id — NOT NULL
- user_id — int — Foreign key → TravelReview.user_id — NOT NULL
- review_photo_link (Field) — aws s3?
TravelReviewTag (Untitled5)
- travel_tag_id (Key3) — Primary key — NOT NULL
- travel_review_id (Key2) — Foreign key → TravelReview.travel_review_id — NOT NULL
- travel_log_id (Key) — Foreign key → TravelReview.travel_log_id — NOT NULL
- user_id — int — Foreign key → TravelReview.user_id — NOT NULL
- tag (Field)
TravelStamp (Untitled3)
- travel_stamp_id (Key) — Primary key — NOT NULL
- travel_location_id (Key2) — Foreign key → TravelLocation.travel_location_id — NOT NULL
- travel_log_id (Key22) — Foreign key → TravelLocation.travel_log_id — NOT NULL
- user_id — int — Foreign key → TravelLocation.user_id — NOT NULL
- title (Field3)
- is_stamped (Field2) — boolean
- stamped_at (Field4)
TravelStay (Untitled8)
- id (Key) — Primary key — NOT NULL
- travel_log_id (Key2) — Foreign key → TravelLog.travel_log_id — NOT NULL
- user_id — int — Foreign key → TravelLog.user_id — NOT NULL
- title (Field)
- description (Field2)
- logitude (Field3)
- latitude (Field4)
User
- id (user_id) — int — Primary key — NOT NULL
- name (Field) — string
- password (Field2) — NOT NULL — encrypted pw; null for social login/sign up
- nickname (Field3) — string — figma를 다시 확인 음
- profile_photo (Field4) — string — NOT NULL — aws s3/등
- intro (Field5) — text — NOT NULL
- language_cd (Field6) — ENUM("KO", "EN",..)