TravelApp2
Tables (5)
Itinerary
- id — BIGINT — Primary key — NOT NULL
- trip_id — BIGINT — Foreign key → Trip.id — NOT NULL
- event_type — ENUM('Move', 'Lodge', 'Stay') — NOT NULL
- event_id — BIGINT — NOT NULL
Lodge
- id — BIGINT — Primary key — NOT NULL
- lodging_name — VARCHAR(100) — NOT NULL
- checkin_datetime — DATETIME — NOT NULL
- checkout_datetime — DATETIME — NOT NULL
Move
- id — BIGINT — Primary key — NOT NULL
- transportation — VARCHAR(100) — NOT NULL
- departured_place_name — VARCHAR(100) — NOT NULL
- arrived_place_name — VARCHAR(100) — NOT NULL
- departure_datetime — DATETIME — NOT NULL
- arrival_datetime — DATETIME — NOT NULL
Stay
- id — BIGINT — Primary key — NOT NULL
- place_name — VARCHAR(100) — NOT NULL
- arrival_datetime — DATETIME — NOT NULL
- departure_datetime — DATETIME — NOT NULL
Trip
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(100) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- is_foreign — TINYINT(1) — NOT NULL