DDemoDB Employees (browser edition)

Data structure

Schema

6 tables and 2 views from the pinned source fixture. Names and relationships retain the source database’s native shape.

Download schema JSON Browse recordsets

Tables

6 native tables.

departments2 columns · 9 rows0 foreign-key relationshipsdept_emp4 columns · 1,127 rows2 foreign-key relationshipsdept_manager4 columns · 24 rows2 foreign-key relationshipsemployees6 columns · 1,024 rows0 foreign-key relationshipssalaries4 columns · 9,876 rows1 foreign-key relationshipstitles4 columns · 1,524 rows1 foreign-key relationships

Views

2 database views.

current_dept_emp4 columns · 1,024 rowsNative view definition preserveddept_emp_latest_date3 columns · 1,024 rowsNative view definition preserved

Foreign keys

6 declared relationships.

Including self-references and composite-key tables.
dept_empdept_no→departmentsdept_no
dept_empemp_no→employeesemp_no
dept_managerdept_no→departmentsdept_no
dept_manageremp_no→employeesemp_no
salariesemp_no→employeesemp_no
titlesemp_no→employeesemp_no