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