| SchemaSpy Analysis of sakila | Generated by SchemaSpy |
| Generated by SchemaSpy on Thu Aug 12 09:42 MDT 2010 | |
| Database Type: MySQL - 5.1.35-community |
|
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 | 589 | |
| category | 1 | 3 | 16 | ||
| city | 1 | 1 | 4 | 427 | |
| country | 1 | 3 | 109 | ||
| customer | 2 | 2 | 9 | 541 | |
| customer_list | 9 | view | |||
| film | 3 | 2 | 13 | 951 | |
| film_actor | 2 | 3 | 5,143 | ||
| film_category | 2 | 3 | 895 | ||
| film_list | 8 | view | |||
| film_text | 3 | 1,000 | |||
| inventory | 1 | 2 | 4 | 5,007 | |
| language | 2 | 3 | 6 | ||
| nicer_but_slower_film_list | 8 | view | |||
| payment | 3 | 7 | 15,123 | ||
| rental | 1 | 3 | 7 | 16,325 | |
| sales_by_film_category | 2 | view | |||
| sales_by_store | 3 | view | |||
| staff | 3 | 2 | 11 | 1 | |
| staff_list | 8 | view | |||
| store | 3 | 2 | 4 | 2 | |
| 16 Tables | 89 | 46,335 | |||
| 7 Views | 42 |