Data model

Sakila video rental sample

Logical record types and their declared fields.

How to author a DataModel

draftModule version 0.1.0

Registered DataModel

Provenance

draftModule version 0.1.0BSD-3-Clause

Module: github.com/demo-db/sakila/sakila
Version: 0.1.0
Repository: https://github.com/demo-db/sakila
Source commit: 113e54ad83c3e003a4fd195c893f2b19a921435c
MeaningGraph revision: 2d0c72a8b2edd295c494ab8bdcc9aba03235a9d62790b687ee77dd7be08b0cd1
ModelSpec source: model/sakila.modelspec.hcl
ModelSpec AST: model/sakila.modelspec.json
Archived definition: Download the exact registered definition
Archived source files: LICENSE model/sakila.modelspec.hcl model/sakila.modelspec.json

Logical structure

Record types

Record type

actor

Key: actor_id

actor_idintKey field
first_namestringRequired
last_namestringRequired
last_updatestringRequired

Record type

address

Key: address_id

address_idintKey field
addressstringRequired
address2string
districtstringRequired
city_idrecord referenceRecord: cityRequired
postal_codestring
phonestringRequired
locationdocumentRequired
last_updatestringRequired

Record type

city

Key: city_id

city_idintKey field
citystringRequired
country_idrecord referenceRecord: countryRequired
last_updatestringRequired

Record type

country

Key: country_id

country_idintKey field
countrystringRequired
last_updatestringRequired

Record type

customer

Key: customer_id

customer_idintKey field
store_idrecord referenceRecord: storeRequired
first_namestringRequired
last_namestringRequired
emailstring
address_idrecord referenceRecord: addressRequired
activeintRequired
create_datestringRequired
last_updatestring

Record type

film

Key: film_id

film_idintKey field
titlestringRequired
descriptionstring
release_yearstring
language_idrecord referenceRecord: languageRequired
original_language_idrecord referenceRecord: language
rental_durationintRequired
rental_ratedecimalRequired
lengthint
replacement_costdecimalRequired
ratingstring
special_featuresstring
last_updatestringRequired

Record type

film_actor

Key: actor_idfilm_id

actor_idrecord referenceRecord: actorRequiredKey field
film_idrecord referenceRecord: filmRequiredKey field
last_updatestringRequired

Record type

film_category

Key: film_idcategory_id

film_idrecord referenceRecord: filmRequiredKey field
category_idrecord referenceRecord: categoryRequiredKey field
last_updatestringRequired

Record type

film_text

Key: film_id

film_idintRequiredKey field
titlestringRequired
descriptionstring

Record type

inventory

Key: inventory_id

inventory_idintKey field
film_idrecord referenceRecord: filmRequired
store_idrecord referenceRecord: storeRequired
last_updatestringRequired

Record type

language

Key: language_id

language_idintKey field
namestringRequired
last_updatestringRequired

Record type

payment

Key: payment_id

payment_idintKey field
customer_idrecord referenceRecord: customerRequired
staff_idrecord referenceRecord: staffRequired
rental_idrecord referenceRecord: rental
amountdecimalRequired
payment_datestringRequired
last_updatestring

Record type

rental

Key: rental_id

rental_idintKey field
rental_datestringRequired
inventory_idrecord referenceRecord: inventoryRequired
customer_idrecord referenceRecord: customerRequired
return_datestring
staff_idrecord referenceRecord: staffRequired
last_updatestringRequired

Record type

staff

Key: staff_id

staff_idintKey field
first_namestringRequired
last_namestringRequired
address_idrecord referenceRecord: addressRequired
picturedocument
emailstring
store_idrecord referenceRecord: storeRequired
activeintRequired
usernamestringRequired
passwordstring
last_updatestringRequired

Record type

store

Key: store_id

store_idintKey field
manager_staff_idrecord referenceRecord: staffRequired
address_idrecord referenceRecord: addressRequired
last_updatestringRequired