Pharmacy sample database — MongoDB, flat (209,275 rows)

A collection per table. Each primary key is the document _id; foreign keys are fields under their own names, so the SQL version's joins become $lookup stages.

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

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

Collections:
  active_ingredients — 50 documents
  branches — 15 documents
  coupon_usages — 3,000 documents
  coupons — 60 documents
  customer_loyalty — 2,000 documents
  customers — 6,000 documents
  delivery_details — 4,000 documents
  doctors — 200 documents
  dosage_forms — 8 documents
  employees — 100 documents
  insurance_claims — 5,000 documents
  insurance_providers — 8 documents
  inventory_stocks — 400 documents
  manufacturers — 30 documents
  medicine_categories — 12 documents
  medicine_ingredients — 300 documents
  medicines — 240 documents
  packaging_types — 6 documents
  payment_methods — 5 documents
  payments — 29,000 documents
  prescription_items — 15,000 documents
  prescriptions — 8,000 documents
  purchase_order_items — 1,500 documents
  purchase_orders — 300 documents
  return_items — 900 documents
  returns — 600 documents
  roles — 6 documents
  sale_items — 100,000 documents
  sales — 30,000 documents
  shelves — 150 documents
  shifts — 1,200 documents
  stock_adjustments — 600 documents
  supplier_invoices — 300 documents
  suppliers — 25 documents
  user_roles — 140 documents
  users — 120 documents

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.
