Hotel reservation sample database — MongoDB, embedded (3,025 rows)

Tables that belong to another are folded into it as arrays, so the documents read the way the application uses them. The rest are collections of their own, joined by key as in the flat version.

Load it:
  sh import.sh                    (into mongodb://localhost:27017)
  sh import.sh "<connection string>"

Or one collection at a time: mongoimport --db hotel-reservation --collection <name> --file <name>.ndjson

Collections:
  amenities — 24 documents
  applied_promotions — 40 documents
  conference_room_bookings — 10 documents
  conference_rooms — 10 documents
  dining_orders — 100 documents, each with its dining_order_items
  employees — 10 documents
  feedback — 100 documents
  guests — 120 documents, each with its guest_event_participation
  hotel_branches — 12 documents
  hotel_events — 10 documents
  housekeeping — 350 documents
  inventory — 10 documents
  loyalty_program — 30 documents
  maintenance_requests — 15 documents
  menu_items — 40 documents
  payments — 300 documents
  promotions — 10 documents
  refunds — 10 documents
  reservations — 300 documents
  room_types — 8 documents
  rooms — 10 documents, each with its room_amenities, its room_inventory
  service_usage — 1,000 documents
  services — 16 documents
  suppliers — 40 documents
  vehicle_rentals — 10 documents

Folded in (no collection of their own):
  dining_order_items — 400 rows, as the "dining_order_items" array on dining_orders (its order_id is the parent's _id)
  guest_event_participation — 20 rows, as the "guest_event_participation" array on guests (its guest_id is the parent's _id)
  room_amenities — 10 rows, as the "room_amenities" array on rooms (its room_id is the parent's _id)
  room_inventory — 10 rows, as the "room_inventory" array on rooms (its room_id is the parent's _id)

Types: numeric columns are Decimal128, so totals stay exact; dates and timestamps are
Date values read as UTC (the data has no time zone); times and UUIDs are strings;
JSON columns are embedded objects.

Synthetic data, CC0-1.0, from databasesample.com. The same rows as the SQL and CSV files.
