University sample database — MongoDB, embedded (6,962 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 university --collection <name> --file <name>.ndjson

Collections:
  addresses — 50 documents
  assignments — 120 documents
  book_loans — 100 documents
  books — 2,000 documents
  buildings — 12 documents
  club_memberships — 30 documents
  clubs — 40 documents
  course_prerequisites — 300 documents
  courses — 600 documents, each with its course_materials
  departments — 14 documents
  enrollments — 1,000 documents
  exams — 80 documents, each with its exam_results
  fee_types — 6 documents
  instructors — 10 documents
  invoices — 100 documents, each with its invoice_items
  library_cards — 30 documents
  payments — 90 documents
  people — 55 documents
  programs — 40 documents
  rooms — 240 documents
  schedules — 60 documents
  scholarships — 25 documents
  sections — 40 documents
  semesters — 10 documents
  students — 50 documents, each with its student_scholarships
  submissions — 400 documents

Folded in (no collection of their own):
  course_materials — 900 rows, as the "course_materials" array on courses (its course_id is the parent's _id)
  exam_results — 300 rows, as the "exam_results" array on exams (its exam_id is the parent's _id)
  invoice_items — 250 rows, as the "invoice_items" array on invoices (its invoice_id is the parent's _id)
  student_scholarships — 10 rows, as the "student_scholarships" array on students (its student_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.
