Data model

Chinook music store

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/chinook/model/chinook
Version: 0.1.0
Repository: https://github.com/demo-db/chinook
Source commit: 3e7bb316d8a438eb7e5930067997a4e4543a275c
MeaningGraph revision: 770b32928920e4c4b0f389ecc6473eb18222be0bf61fecf90407bf24b98c2427
ModelSpec source: model/chinook.modelspec.hcl
ModelSpec AST: model/chinook.modelspec.json
Archived definition: Download the exact registered definition
Archived source files: data-source/LICENSE.md LICENSE LICENSE-CC0 model/chinook.modelspec.hcl model/chinook.modelspec.json

Logical structure

Record types

Record type

Artist

Key: ArtistId

ArtistIdintRequiredKey field
Namestring
max_len
120

Record type

Album

Key: AlbumId

AlbumIdintRequiredKey field
TitlestringRequired
max_len
160
ArtistIdrecord referenceRecord: ArtistRequired

Record type

Track

Key: TrackId

TrackIdintRequiredKey field
NamestringRequired
max_len
200
AlbumIdrecord referenceRecord: Album
MediaTypeIdrecord referenceRecord: MediaTypeRequired
GenreIdrecord referenceRecord: Genre
Composerstring
max_len
220
MillisecondsintRequired
Bytesint
UnitPricedecimalRequired

Record type

Genre

Key: GenreId

GenreIdintRequiredKey field
Namestring
max_len
120

Record type

MediaType

Key: MediaTypeId

MediaTypeIdintRequiredKey field
Namestring
max_len
120

Record type

Playlist

Key: PlaylistId

PlaylistIdintRequiredKey field
Namestring
max_len
120

Record type

PlaylistTrack

Key: PlaylistIdTrackId

PlaylistIdrecord referenceRecord: PlaylistRequiredKey field
TrackIdrecord referenceRecord: TrackRequiredKey field

Record type

Customer

Key: CustomerId

CustomerIdintRequiredKey field
FirstNamestringRequired
max_len
40
LastNamestringRequired
max_len
20
Companystring
max_len
80
Addressstring
max_len
70
Citystring
max_len
40
Statestring
max_len
40
Countrystring
max_len
40
PostalCodestring
max_len
10
Phonestring
max_len
24
Faxstring
max_len
24
EmailstringRequired
max_len
60
format
email
SupportRepIdrecord referenceRecord: Employee

Record type

Employee

Key: EmployeeId

EmployeeIdintRequiredKey field
LastNamestringRequired
max_len
20
FirstNamestringRequired
max_len
20
Titlestring
max_len
30
ReportsTorecord referenceRecord: Employee
BirthDatedatetime
HireDatedatetime
Addressstring
max_len
70
Citystring
max_len
40
Statestring
max_len
40
Countrystring
max_len
40
PostalCodestring
max_len
10
Phonestring
max_len
24
Faxstring
max_len
24
Emailstring
max_len
60
format
email

Record type

Invoice

Key: InvoiceId

InvoiceIdintRequiredKey field
CustomerIdrecord referenceRecord: CustomerRequired
InvoiceDatedatetimeRequired
BillingAddressstring
max_len
70
BillingCitystring
max_len
40
BillingStatestring
max_len
40
BillingCountrystring
max_len
40
BillingPostalCodestring
max_len
10
TotaldecimalRequired

Record type

InvoiceLine

Key: InvoiceLineId

InvoiceLineIdintRequiredKey field
InvoiceIdrecord referenceRecord: InvoiceRequired
TrackIdrecord referenceRecord: TrackRequired
UnitPricedecimalRequired
QuantityintRequired