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)