Example 1 - DVD Rentals

This is a DVD Rentals example database schema from PostgreSQL Tutorial (https://www.postgresqltutorial.com/postgresql-getting-started/postgresql-sample-database)

Overview

There are 15 tables in the DVD Rental database:

  • actor – stores actors data including first name and last name.

  • film – stores film data such as title, release year, length, rating, etc.

  • film_actor – stores the relationships between films and actors.

  • category – stores film’s categories data.

  • film_category- stores the relationships between films and categories.

  • store – contains the store data including manager staff and address.

  • inventory – stores inventory data.

  • rental – stores rental data.

  • payment – stores customer’s payments.

  • staff – stores staff data.

  • customer – stores customer data.

  • address – stores address data for staff and customers

  • city – stores city names.

  • country – stores country names.

ERD

Here is the ERD of the sample DVD rentals database:

Neurelo Schema

This is the schema in the Neurelo Schema Language JSON Specification format

PreviousNeurelo Schema Language (NSL)NextExample 2 - Simple "Posts" App

Last updated