여행 플래너
테이블 (8)
Course (코스)
- place_name (Field) — varchar(100)
- arrive_at (Field2) — LocalDateTime
- longitude (Field3) — double
- latitude (Field4) — double
- place_type (Field5) — enum
- place_id (Field6) — Long
- distance (Field7) — double
Day Schedule (당일 일정)
- id (Key) — Long — 기본 키 — NOT NULL
- schedule_id (Key2) — Long — 외래 키 → Schedule.id — NOT NULL
- course_list (Field) — arraylist
- day (Field2) — LocalDate
- date_number (Field3) — int
- total_latitude (Field4) — double
- total_longitude (Field5) — double
- average_latitude (Field6) — double
- average_longitude (Field7) — double
Heart (좋아요)
- id (Key) — Long — 기본 키 — NOT NULL
- member_id (Key2) — Long — 외래 키 → Member.id — NOT NULL
- place_id (Key3) — Long — 외래 키 → Place.id — NOT NULL
- likedDate (Field) — DATE
Member (회원)
- id (Key) — Long — 기본 키 — NOT NULL
- email (Field) — varchar(50)
- password (Field2) — varchar(50)
- nickname (Field3) — varchar(50)
- profile_url (Field4) — varchar(255)
- is_google_login (Field5) — boolean
Notification (알림)
- id (Key) — Long — 기본 키 — NOT NULL
- member_id (Field2) — Long — 외래 키 → Member.id — NOT NULL
- schedule_id (Field4) — Long — 외래 키 → Schedule.id — NOT NULL
- message (Field3) — varchar(150)
Place (여행지)
- id (Key) — Long — 기본 키 — NOT NULL
- place_name (Field) — varchar(100)
- place_location (Field2) — varchar(100)
- place_address (Field3) — varchar(255)
- place_latitude (Field4) — double
- place_longitude (Field5) — double
- place_image_url (Field6) — varchar(255)
- place_description (Field7) — varchar(255)
- place_heart (Field8) — int
- star (Field9) — double
- total_star (Field10) — double
- place_call_number (Field11) — varchar(50)
- place_type (Field12) — Enum
- review_num (Field13) — int
Review (리뷰)
- id (Key) — Long — 기본 키 — NOT NULL
- place_id (Key2) — Long — 외래 키 → Place.id — NOT NULL
- review_comment (Field1) — varchar(255)
- star (Field2) — double
- review_image_url_list (Field3) — arraylist
- create_at (Field4) — LocalDateTime
- nickName (Field5) — varchar(50)
- member_profile_url (Field6) — varchar(255)
Schedule (여행 스케쥴)
- id (Key) — Long — 기본 키 — NOT NULL
- member_id (Key2) — Long — 외래 키 → Member.id — NOT NULL
- schedule_name (Field) — varchar(50)
- start_at (Field2) — LocalDate
- end_at (Field3) — LocalDate
- day_schedule_list (Field4) — array
- schedule_image_url (Field5) — varchar(255)
- travel_place (Field6) — varchar(50)
- days (Field7) — int