dataset
Parcel Ops dataset
Parcel Ops is a fictional SQL Trail data world used for operational timeline investigations with scan order and sla boundaries. It includes visible and hidden deterministic variants for practice.
Purpose and provenance
Parcel Ops is a fictional-domain SQL Trail dataset used for operational timeline investigations with scan order and sla boundaries.
Creator/publisher: SQL Trail. Dataset revision/version: parcel-ops-2026-06-21.
License/distribution policy: SQL Trail original educational content; public reuse and citation policy are documented in Content Standards.
The data is intentionally small, deterministic, and designed to expose nulls, ties, missing relationships, and fan-out traps.
Schema image: /illustrations/datasets/parcel-ops.webp. The accessible relationship summary below is the canonical text alternative.
Tables, grains, keys, relationships, and row counts
Each table has a stated grain, primary key, foreign-key summary, row count, and column count so learners can reason about joins before writing SQL.
| Table | Grain | Primary key | Foreign keys | Row count | Columns |
|---|---|---|---|---|---|
| calendar_days | one row per operational day | day | none | 5 | 1 |
| carriers | one row per carrier | carrier_id | none | 2 | 2 |
| exceptions | one row per exception event | exception_id | package_id -> packages.package_id | 2 | 4 |
| facilities | one row per logistics facility | facility_id | none | 3 | 3 |
| packages | one row per package in a shipment | package_id | shipment_id -> shipments.shipment_id | 3 | 3 |
| routes | one row per facility-to-facility route | route_id | carrier_id -> carriers.carrier_id; destination_facility_id -> facilities.facility_id; origin_facility_id -> facilities.facility_id | 2 | 4 |
| scans | one row per carrier scan event | scan_id | facility_id -> facilities.facility_id; package_id -> packages.package_id | 5 | 6 |
| service_levels | one row per promised service level | service_level_id | none | 2 | 3 |
| shipments | one row per shipment | shipment_id | route_id -> routes.route_id; service_level_id -> service_levels.service_level_id | 2 | 5 |
Intentional edge cases and relationship summary
Relationship summary is provided as text so the page remains useful without inspecting the schema image.
Relationships: exceptions.package_id -> packages.package_id; packages.shipment_id -> shipments.shipment_id; routes.carrier_id -> carriers.carrier_id; routes.destination_facility_id -> facilities.facility_id; routes.origin_facility_id -> facilities.facility_id; scans.facility_id -> facilities.facility_id; scans.package_id -> packages.package_id; shipments.route_id -> routes.route_id; shipments.service_level_id -> service_levels.service_level_id.
Intentional edge cases include nulls, ties, missing relationships, boundary rows, and fan-out traps when the domain can teach them.
| Table | Relationship check |
|---|---|
| calendar_days | source or lookup table with no outgoing foreign key |
| carriers | source or lookup table with no outgoing foreign key |
| exceptions | package_id references packages.package_id |
| facilities | source or lookup table with no outgoing foreign key |
| packages | shipment_id references shipments.shipment_id |
| routes | carrier_id references carriers.carrier_id; destination_facility_id references facilities.facility_id; origin_facility_id references facilities.facility_id |
| scans | facility_id references facilities.facility_id; package_id references packages.package_id |
| service_levels | source or lookup table with no outgoing foreign key |
| shipments | route_id references routes.route_id; service_level_id references service_levels.service_level_id |
Downloadable distributions
Downloadable SQL distributions are published as deterministic seed files for visible, boundary, null, tie, and project variants.
CSV distributions are not published in this release; result-grid CSV export is separate from dataset landing-page downloads.
Do not invent or link a CSV package until the product actually exposes one.
- SQL distribution asset: /sql-datasets/parcel_ops/visible.sql
- SQL distribution asset: /sql-datasets/parcel_ops/boundary.sql
- SQL distribution asset: /sql-datasets/parcel_ops/nulls.sql
- SQL distribution asset: /sql-datasets/parcel_ops/ties.sql
- SQL distribution asset: /sql-datasets/parcel_ops/project.sql
Modules, projects, and update history
Modules that use this dataset include M00, M06, M11, M16, M20, M21, and more.
Projects that use this dataset: Parcel Operations Reliability Investigation.
Update history: parcel-ops-2026-06-21 is the launch revision for this public dataset page and generated SQL seed files.