Data model

Pubs publishing database

Logical record types and their declared fields.

How to author a DataModel

draftModule version 0.1.0

Registered DataModel

Provenance

draftModule version 0.1.0MIT

Module: github.com/demo-db/pubs/pubs
Version: 0.1.0
Repository: https://github.com/demo-db/pubs
Source commit: e99ca33330a043e23b2c5a665356fb8ad8d0b508
MeaningGraph revision: 67a8f0ad0135ac5e51785e1899ad9d75761e7adf6bd03ff10afc51f7cd99c449
ModelSpec source: model/pubs.modelspec.hcl
ModelSpec AST: model/pubs.modelspec.json
Archived definition: Download the exact registered definition
Archived source files: data-source/LICENSE.txt LICENSE model/pubs.modelspec.hcl model/pubs.modelspec.json

Logical structure

Record types

Record type

authors

Key: au_id

au_idstringRequiredKey field
au_lnamestringRequired
au_fnamestringRequired
phonestringRequired
addressstring
citystring
statestring
zipstring
contractintRequired

Record type

discounts

No key declared

discounttypestringRequired
stor_idrecord referenceRecord: stores
lowqtyint
highqtyint
discountdecimalRequired

Record type

employee

Key: emp_id

emp_idstringRequiredKey field
fnamestringRequired
minitstring
lnamestringRequired
job_idrecord referenceRecord: jobsRequired
job_lvlint
pub_idrecord referenceRecord: publishersRequired
hire_datestringRequired

Record type

jobs

Key: job_id

job_idintRequiredKey field
job_descstringRequired
min_lvlintRequired
max_lvlintRequired

Record type

pub_info

Key: pub_id

pub_idrecord referenceRecord: publishersRequiredKey field
logodocument
pr_infostring

Record type

publishers

Key: pub_id

pub_idstringRequiredKey field
pub_namestring
citystring
statestring
countrystring

Record type

roysched

No key declared

title_idrecord referenceRecord: titles
lorangeint
hirangeint
royaltyint

Record type

sales

Key: stor_idord_numtitle_id

stor_idrecord referenceRecord: storesRequiredKey field
ord_numstringRequiredKey field
ord_datestringRequired
qtyintRequired
paytermsstringRequired
title_idrecord referenceRecord: titlesRequiredKey field

Record type

stores

Key: stor_id

stor_idstringRequiredKey field
stor_namestring
stor_addressstring
citystring
statestring
zipstring

Record type

titleauthor

Key: au_idtitle_id

au_idrecord referenceRecord: authorsRequiredKey field
title_idrecord referenceRecord: titlesRequiredKey field
au_ordint
royaltyperint

Record type

titles

Key: title_id

title_idstringRequiredKey field
titlestringRequired
typestringRequired
pub_idrecord referenceRecord: publishers
pricedecimal
advancedecimal
royaltyint
ytd_salesint
notesstring
pubdatestringRequired