TABLES
17
VIEWS
7
COLUMNS
133
Constraints
22
Anomalies
2
Routines
6
Database Properties
Database Type: MySQL - 5.7.37
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| language | 2 | 0 | 3 | 0 | Table | |
| payment | 0 | 3 | 7 | 0 | Table | |
| film | 3 | 2 | 13 | 0 | Table | |
| film_text | 0 | 0 | 3 | 0 | Table | |
| actor | 2 | 0 | 4 | 0 | Table | |
| city | 1 | 1 | 4 | 0 | Table | |
| inventory | 1 | 2 | 4 | 0 | Table | |
| country | 1 | 0 | 3 | 0 | Table | |
| category | 1 | 0 | 3 | 0 | Table | |
| address | 3 | 1 | 9 | 0 | Table | |
| store | 3 | 2 | 4 | 0 | Table | |
| staff | 3 | 2 | 11 | 0 | Table | |
| customer | 2 | 2 | 9 | 0 | Table | |
| schema_migrations | 0 | 0 | 1 | 2 | Table | |
| rental | 1 | 3 | 7 | 0 | Table | |
| film_actor | 0 | 2 | 3 | 0 | Table | |
| film_category | 0 | 2 | 3 | 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 |