fc-toy2

Tables (5)

accommodation (숙박)

  • id (여정식별자) — bigint(20) — Foreign key → itinerary.id — NOT NULL
  • accommodation_name (숙소이름) — varchar(255)
  • check_in (체크인일시) — datetime(6)
  • check_out (체크아웃 일시) — datetime(6)
  • accommodation_road_address_name (숙소도로명주소) — varchar(255)

itinerary (여정)

  • id (여정식별자) — bigint(20) — Primary key — NOT NULL
  • dtype (여정종류식별자) — varchar(31)
  • id (여행식별자) — bigint(20) — Foreign key → trip.id — NOT NULL

transportation (이동)

  • id (여정식별자) — bigint(20) — Foreign key → itinerary.id — NOT NULL
  • transportation (이동수단) — varchar(255)
  • departure_place (출발지) — varchar(255)
  • departure_time (출발일시) — datetime(6)
  • departure_place_road_address_name (출발지 도로명주소) — varchar(255)
  • destination (도착지) — varchar(255)
  • arrival_time (도착일시) — datetime(6)
  • destination_road_address_name (도착지도로명주소) — varchar(255)

trip (여행)

  • id (여행식별자) — bigint(20) — Primary key — NOT NULL
  • name (여행이름) — varchar(255)
  • start_date (시작일) — date
  • end_date (종료일) — date
  • is_domestic (국내여행여부) — date

visit (체류)

  • id (여정식별자) — bigint(20) — Foreign key → itinerary.id — NOT NULL
  • place_name (체류장소이름) — varchar(255)
  • arrival_time (도착일시) — datetime(6)
  • departure_time (출발일시) — datetime(6)
  • place_road_address_name (체류장소도로명주소) — varchar(255)