TABLES
21
VIEWS
8
COLUMNS
167
Constraints
36
Anomalies
5
Routines
0
Database Properties
Database Type: PostgreSQL - 12.15 (Debian 12.15-1.pgdg110+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| language | 2 | 0 | 3 | 0 | Table | |
| film | 3 | 2 | 14 | 0 | Table | |
| payment_p2022_06 | 0 | 3 | 6 | 0 | Table | |
| payment_p2022_07 | 0 | 3 | 6 | 0 | Table | |
| actor | 2 | 0 | 4 | 0 | Table | |
| city | 1 | 1 | 4 | 0 | Table | |
| country | 1 | 0 | 3 | 0 | Table | |
| inventory | 1 | 2 | 4 | 0 | Table | |
| category | 1 | 0 | 3 | 0 | Table | |
| address | 3 | 1 | 8 | 0 | Table | |
| payment_p2022_02 | 0 | 3 | 6 | 0 | Table | |
| staff | 9 | 2 | 11 | 0 | Table | |
| store | 3 | 2 | 4 | 0 | Table | |
| customer | 8 | 2 | 10 | 0 | Table | |
| payment_p2022_03 | 0 | 3 | 6 | 0 | Table | |
| payment_p2022_04 | 0 | 3 | 6 | 0 | Table | |
| rental | 7 | 3 | 7 | 0 | Table | |
| film_actor | 0 | 2 | 3 | 0 | Table | |
| payment_p2022_05 | 0 | 3 | 6 | 0 | Table | |
| film_category | 0 | 2 | 3 | 0 | Table | |
| payment_p2022_01 | 0 | 3 | 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 | |
| rental_by_category | 0 | 0 | 2 | 0 | View | |
| staff_list | 0 | 0 | 8 | 0 | View | |
| sales_by_store | 0 | 0 | 3 | 0 | View |