Data model
Employees (browser edition)
Logical record types and their declared fields.
draftModule version 0.1.0
Registered DataModel
Provenance
draftModule version 0.1.0CC-BY-SA-3.0
- Module
github.com/demo-db/employees/employees- Version
0.1.0- Repository
- https://github.com/demo-db/employees
- Source commit
add7744ddc5cefc535a7cbb09b3dffee41811ade- MeaningGraph revision
7791a019cfad479aeafb926dcea9fb611bdc48303d3bf56b2842cc56f2a4ec43- ModelSpec source
model/employees.modelspec.hcl- ModelSpec AST
model/employees.modelspec.json- Archived definition
- Download the exact registered definition
- Archived source files
LICENSEmodel/employees.modelspec.hclmodel/employees.modelspec.json
Logical structure
Record types
Record type
departments
Key: dept_no
dept_nostringRequiredKey fielddept_namestringRequired
Record type
dept_emp
Key: emp_nodept_no
emp_norecord referenceRecord:employeesRequiredKey fielddept_norecord referenceRecord:departmentsRequiredKey fieldfrom_datestringRequiredto_datestringRequired
Record type
dept_manager
Key: emp_nodept_no
emp_norecord referenceRecord:employeesRequiredKey fielddept_norecord referenceRecord:departmentsRequiredKey fieldfrom_datestringRequiredto_datestringRequired
Record type
employees
Key: emp_no
emp_nointRequiredKey fieldbirth_datestringRequiredfirst_namestringRequiredlast_namestringRequiredgenderstringRequiredhire_datestringRequired
Record type
salaries
Key: emp_nofrom_date
emp_norecord referenceRecord:employeesRequiredKey fieldsalaryintRequiredfrom_datestringRequiredKey fieldto_datestringRequired
Record type
titles
Key: emp_notitlefrom_date
emp_norecord referenceRecord:employeesRequiredKey fieldtitlestringRequiredKey fieldfrom_datestringRequiredKey fieldto_datestring