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