University sample database — MongoDB, embedded (280,887 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 — 5,000 documents
  assignments — 12,000 documents
  book_loans — 10,000 documents
  books — 2,000 documents
  buildings — 12 documents
  club_memberships — 3,000 documents
  clubs — 40 documents
  course_prerequisites — 300 documents
  courses — 600 documents, each with its course_materials
  departments — 14 documents
  enrollments — 100,000 documents
  exams — 8,000 documents, each with its exam_results
  fee_types — 6 documents
  instructors — 200 documents
  invoices — 10,000 documents, each with its invoice_items
  library_cards — 3,000 documents
  payments — 9,000 documents
  people — 5,500 documents
  programs — 40 documents
  rooms — 240 documents
  schedules — 6,000 documents
  scholarships — 25 documents
  sections — 4,000 documents
  semesters — 10 documents
  students — 5,000 documents, each with its student_scholarships
  submissions — 40,000 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 — 30,000 rows, as the "exam_results" array on exams (its exam_id is the parent's _id)
  invoice_items — 25,000 rows, as the "invoice_items" array on invoices (its invoice_id is the parent's _id)
  student_scholarships — 1,000 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.
