TABLES
21
VIEWS
7
COLUMNS
165
Constraints
40
Anomalies
7
Routines
10
Database Properties
Database Type: PostgreSQL - 13.2 (Debian 13.2-1.pgdg100+1)
Schema public
Standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| language | 2 | 0 | 3 | 0 | Table | |
| payment | 6 | 3 | 6 | 0 | Table | |
| film | 3 | 2 | 14 | 0 | Table | |
| actor | 2 | 0 | 4 | 200 | Table | |
| payment_p2007_05 | 0 | 4 | 6 | 0 | Table | |
| payment_p2007_06 | 0 | 4 | 6 | 0 | Table | |
| inventory | 1 | 2 | 4 | 0 | Table | |
| country | 1 | 0 | 3 | 109 | Table | |
| city | 1 | 1 | 4 | 0 | Table | |
| category | 1 | 0 | 3 | 16 | Table | |
| address | 3 | 1 | 8 | 0 | Table | |
| store | 3 | 2 | 4 | 0 | Table | |
| staff | 9 | 2 | 11 | 0 | Table | |
| customer | 8 | 2 | 10 | 0 | Table | |
| rental | 7 | 3 | 7 | 0 | Table | |
| film_actor | 0 | 2 | 3 | 0 | Table | |
| payment_p2007_03 | 0 | 4 | 6 | 0 | Table | |
| film_category | 0 | 2 | 3 | 0 | Table | |
| payment_p2007_04 | 0 | 4 | 6 | 0 | Table | |
| payment_p2007_01 | 0 | 4 | 6 | 0 | Table | |
| payment_p2007_02 | 0 | 4 | 6 | 0 | Table | |
| actor_info | 0 | 1 | 4 | 0 | View | |
| film_list | 0 | 0 | 8 | 0 | View | |
| sales_by_film_category | 0 | 0 | 2 | 0 | View | |
| nicer_but_slower_film_list | 0 | 0 | 8 | 0 | View | |
| customer_list | 0 | 0 | 9 | 0 | View | |
| staff_list | 0 | 0 | 8 | 0 | View | |
| sales_by_store | 0 | 0 | 3 | 0 | View |