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)

TravleImage (Untitled6)

    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",..)