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 |