여행 플래너

테이블 (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