AI플래너

테이블 (10)

Accommodation (Untitled8)

  • accommodation_id (Key) — Long — 기본 키 — NOT NULL
  • name (Field) — String
  • address (Field2) — String
  • classification (Field3) — int
  • price (Field4) — int

Ai_Recommend_Trip (Untitled7)

  • ai_recommend_trip_id (Key) — Long — 기본 키 — NOT NULL
  • title (Field) — String
  • thumbnail_image (Field2) — String
  • theme (Field3) — String
  • created_at (Field4) — Datetiem

My_Saved_Trip (Untitled5)

  • my_saved_trip_id (Key) — Long — 기본 키 — NOT NULL
  • user_id (Key2) — Long — 외래 키 → User.user_id — NOT NULL
  • ai_recommend_trip_id (Key3) — Long — 외래 키 → Ai_Recommend_Trip.ai_recommend_trip_id — NOT NULL

My_Trip (Untitled2)

  • my_trip_id (Key3) — Long — 기본 키 — NOT NULL
  • start_date (Field2) — Datetime
  • end_date (Field3) — Datetime
  • headcount (Field6) — int
  • created_at (Field7) — Datetime
  • start_location (Field8) — String
  • end_location (Field9) — String
  • user_id (Key) — Long — 외래 키 → User.user_id — NOT NULL
  • ai_recommend_trip_id (Key2) — Long — 외래 키 → Ai_Recommend_Trip.ai_recommend_trip_id — NOT NULL

Reservation (Untitled9)

  • user_id (Key) — Long — 외래 키 → User.user_id — NOT NULL
  • accommodation_id (Key2) — Long — 외래 키 → Accommodation.accommodation_id — NOT NULL
  • start_date (Field) — Datetime
  • end_date (Field2) — Datetime
  • price (Field3) — int
  • created_at (Field4) — Datetime
  • is_canceled (Field5) — Boolean
  • canceled_date (Field6) — Datetime

Review (Untitled6)

  • review_id (Key3) — Long — 기본 키 — NOT NULL
  • my_trip_id (Key32) — Long — 외래 키 → My_Trip.my_trip_id — NOT NULL
  • ai_recommend_trip_id (Key) — Long — 외래 키 → Ai_Recommend_Trip.ai_recommend_trip_id — NOT NULL
  • score (Field) — int
  • content (Field2) — String
  • emotion (Field3) — int

Schedule (Untitled3)

  • schedule_id (Key2) — Long — 기본 키 — NOT NULL
  • ai_recommend_trip_id (Key3) — Long — 외래 키 → Ai_Recommend_Trip.ai_recommend_trip_id — NOT NULL
  • nth_day (Field) — Datetime
  • start_time (Field2) — Datetime
  • end_time (Field3) — Datetime

Schedule_Detail (Untitled4)

  • schedule_detail_id (Key) — Long — 기본 키 — NOT NULL
  • schedule_id (Key2) — Long — 외래 키 → Schedule.schedule_id — NOT NULL
  • location_name (Field) — String
  • start_time (Field2) — Datetime
  • end_time (Field3) — Datetime
  • how_to_go (Field4) — String
  • how_long_go (Field5) — int
  • location_image (Field6) — String

Sharing_Trip (Untitled10)

  • sharing_trip_id (Key) — Long — 기본 키 — NOT NULL
  • shared_at (Field) — Datetime
  • user_id (Key2) — Long — 외래 키 → User.user_id — NOT NULL
  • Key3 (Key32) — 외래 키 → My_Trip.my_trip_id — NOT NULL

User (Untitled)

  • user_id (Key) — Long — 기본 키 — NOT NULL
  • email (Field) — String — NOT NULL
  • password (Field8) — String
  • social_type (Field2) — String
  • created_at (Field3) — Datetime
  • deactived_at (Field5) — Datetime
  • is_active (Field4) — Boolean
  • nickname (Field6) — String
  • location (Field7) — String
  • last_login (Field9) — Datetime