travel

Tables (6)

Hotel (숙박)

  • Hotel_ID (Key) — Long — Primary key — NOT NULL
  • Hotel_Name (Field) — String
  • Check_In_time (Field2) — LocalTime
  • Check_Out_Time (Field3) — LocalTime

Itinerary (여정)

  • Itinerary_ID (Key2) — Primary key — NOT NULL
  • Transfortation_ID (Key3) — Long — Foreign key → Transfortation.Transfortation_ID — NOT NULL
  • Hotel_ID (Key4) — Long — Foreign key → Hotel.Hotel_ID — NOT NULL
  • Trip_ID (Key) — Long — Foreign key → Travel.Trip_ID — NOT NULL
  • Hotel_ID (Key5) — Long — Foreign key → Visit.Visit_ID — NOT NULL
  • ItineraryName (Field) — String

Transfortation (이동)

  • Transfortation_ID (Key) — Long — Primary key — NOT NULL
  • From_Place (Field) — String
  • To_Place (Field2) — String
  • Depart_Time (Field3) — LocalTime
  • Arrive_time (Field4) — LocalTime

Travel (여행)

  • Trip_ID (Key) — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → User.user_id — NOT NULL
  • Trip_Name (Field) — varchar(255)
  • Depart_Time (Field2) — LocalTime
  • Arrived_TIme (Field3) — LocalTime
  • isDomestic (Field4) — Boolean

User (사용자)

  • user_id (Key) — Long — Primary key — NOT NULL
  • user_name (Field) — varchar(255)
  • user_email (Field2) — varchar(255)
  • user_age (Field3) — Integer

Visit (체류기간)

  • Visit_ID (Key) — Long — Primary key — NOT NULL
  • Place_name (Field3)
  • Depart_Time (Field) — LocalTime
  • Arrive_Time (Field2) — LocalTime