cURL API Examples

Schema

This is a DVD Rentals example database schema from PostgreSQL Tutorial.

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.

Here is the ERD of the sample DVD rentals database:

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

JSON Schema

GET endpoint examples

  • Get All Actors

  • Get specific actor(s)

  • Get 10 Customers

  • Get Films & Actors

  • Get Stores & Employees

  • Get 5 Rentals and Films

  • Get 3 Films By Category

POST endpoint examples

  • Create New Actor

  • Create many Rentals

  • Create One Film & Related

PATCH endpoint examples

  • Update a film

DELETE endpoint examples

  • Delete an actor

  • Delete films by name

Last updated