Cinema sample database — MongoDB, embedded (15,586 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 cinema --collection <name> --file <name>.ndjson

Collections:
  addresses — 12 documents
  chains — 3 documents
  cities — 8 documents
  concession_items — 15 documents
  content_ratings — 5 documents
  countries — 1 documents
  device_tokens — 50 documents
  facilities — 8 documents
  genres — 10 documents
  movies — 120 documents, each with its movie_crews, its movie_genres
  notifications — 50 documents
  orders — 450 documents, each with its order_concessions
  payment_methods — 5 documents
  people — 600 documents
  promotions — 8 documents
  reviews — 20 documents
  screens — 60 documents
  seat_types — 4 documents
  seats — 10,800 documents
  shows — 15 documents
  theaters — 12 documents, each with its theater_facilities
  tickets — 1,000 documents
  transactions — 450 documents
  user_refunds — 10 documents
  users — 80 documents, each with its user_favorites

Folded in (no collection of their own):
  movie_crews — 1,200 rows, as the "movie_crews" array on movies (its movie_id is the parent's _id)
  movie_genres — 220 rows, as the "movie_genres" array on movies (its movie_id is the parent's _id)
  order_concessions — 300 rows, as the "order_concessions" array on orders (its order_id is the parent's _id)
  theater_facilities — 40 rows, as the "theater_facilities" array on theaters (its theater_id is the parent's _id)
  user_favorites — 30 rows, as the "user_favorites" array on users (its user_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.
