| SchemaSpy Analysis of postgres.public | Generated by SchemaSpy |
| Generated by SchemaSpy on Mon Feb 20 18:07 CET 2023 | |
| Database Type: PostgreSQL - 15.1 |
|
XML Representation Insertion Order Deletion Order (for database loading/purging scripts) |
| Table / View | Children | Parents | Columns | Rows | Comments |
|---|---|---|---|---|---|
| actor | 1 | 4 | 200 | ||
| actor_info | 4 | view | |||
| address | 3 | 1 | 8 | 603 | |
| category | 1 | 3 | 16 | ||
| city | 1 | 1 | 4 | 600 | |
| country | 1 | 3 | 109 | ||
| customer | 8 | 2 | 10 | 599 | |
| customer_list | 9 | view | |||
| film | 3 | 2 | 14 | 1,000 | |
| film_actor | 2 | 3 | 5,462 | ||
| film_category | 2 | 3 | 1,000 | ||
| film_list | 8 | view | |||
| inventory | 1 | 2 | 4 | 4,581 | |
| language | 2 | 3 | 6 | ||
| nicer_but_slower_film_list | 8 | view | |||
| payment | 3 | 6 | 16,049 | ||
| payment_p2007_01 | 3 | 6 | 1,157 | ||
| payment_p2007_02 | 3 | 6 | 2,312 | ||
| payment_p2007_03 | 3 | 6 | 5,644 | ||
| payment_p2007_04 | 3 | 6 | 6,754 | ||
| payment_p2007_05 | 3 | 6 | 182 | ||
| payment_p2007_06 | 3 | 6 | 0 | ||
| rental | 7 | 3 | 7 | 16,044 | |
| sales_by_film_category | 2 | view | |||
| sales_by_store | 3 | view | |||
| staff | 9 | 2 | 11 | 2 | |
| staff_list | 8 | view | |||
| store | 3 | 2 | 4 | 2 | |
| 21 Tables | 123 | 62,322 | |||
| 7 Views | 42 |