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