table
employees
The selected employees from the pinned Employees sample, retaining their source identifiers and demographics.
emp_noINTEGER · PKbirth_dateTEXTfirst_nameTEXTlast_nameTEXTgenderTEXThire_dateTEXTOpenVaultDB database
Employees (browser edition)
A reproducible, FK-closed browser-sized edition of the MySQL Employees sample, retaining 1,024 selected employees and their associated employment history.
Published collections
6 read-only collections
6 declared foreign-key relationships. Names and keys preserve the source database schema. The database site includes the complete native schema, including views.
Published recordsets
Read-only collections
6 columns · 1,024 rows
table
departments
All nine departments in the source sample.
dept_noTEXT · PKdept_nameTEXTtable
dept_emp
Department assignments and date ranges for selected employees.
emp_noINTEGER · PKdept_noTEXT · PKfrom_dateTEXTto_dateTEXTReferences departments.dept_no, employees.emp_no
table
dept_manager
All manager assignments in the source sample.
emp_noINTEGER · PKdept_noTEXT · PKfrom_dateTEXTto_dateTEXTReferences departments.dept_no, employees.emp_no
table
titles
Title history for selected employees.
emp_noINTEGER · PKtitleTEXT · PKfrom_dateTEXT · PKto_dateTEXT · nullableReferences employees.emp_no
table
salaries
Salary history for selected employees.
emp_noINTEGER · PKsalaryINTEGERfrom_dateTEXT · PKto_dateTEXTReferences employees.emp_no
Provenance
Published data
Source: https://github.com/datacharmer/test_db at e324b56193ca506ab7cc1ab143a9153d8c4535d7.
Source licence: CC-BY-SA-3.0. Model licence: CC-BY-SA-3.0. Meaning licence: CC-BY-SA-3.0.
Published by DemoDB; provider repository ↗.
Browser-sized subset of the upstream MySQL Employees sample, not a copy of the full dataset. The exact source header credits MySQL AB (2007/2008), original temporal data to Fusheng Wang and Carlo Zaniolo, the current schema to Giuseppe Maxia, and XML-to-relational conversion to Patrick Crews; it states CC BY-SA 3.0 Unported and says the data is fabricated. The selected employee set is IDs 10001 through 11000 inclusive plus every distinct employee ID listed in the source dept_manager rows (1,024 total). All nine departments and all 24 manager assignments are included, with every dept_emp, titles, and salaries row for those employees. All six native tables and both native views are retained. The source repo inserts in batches, and salaries span three dump files; CI downloads every exact upstream source file at the pinned commit, checks its hash, rebuilds the subset, and compares the full logical SQLite database. SQLite fixture file bytes can vary by SQLite library version; the committed gzip is checked by its exact compressed and decoded hashes and by full logical contents. The upstream sample says its data is fabricated and does not correspond to real people. The sha256 identifies the decoded SQLite fixture; source.inputSha256 identifies the compressed dataFile bytes.
Semantic references