| actor | actor_id
| smallint(5) unsigned
|
|
| actor | first_name
| varchar(45)
|
|
| actor | last_name
| varchar(45)
|
|
| actor | last_update
| timestamp
|
|
| address | address_id
| smallint(5) unsigned
|
|
| address | address
| varchar(50)
|
|
| address | address2
| varchar(50)
|
|
| address | district
| varchar(20)
|
|
| address | city_id
| smallint(5) unsigned
|
|
| address | postal_code
| varchar(10)
|
|
| address | phone
| varchar(20)
|
|
| address | last_update
| timestamp
|
|
| category | category_id
| tinyint(3) unsigned
|
|
| category | name
| varchar(25)
|
|
| category | last_update
| timestamp
|
|
| city | city_id
| smallint(5) unsigned
|
|
| city | city
| varchar(50)
|
|
| city | country_id
| smallint(5) unsigned
|
|
| city | last_update
| timestamp
|
|
| country | country_id
| smallint(5) unsigned
|
|
| country | country
| varchar(50)
|
|
| country | last_update
| timestamp
|
|
| customer | customer_id
| smallint(5) unsigned
|
|
| customer | store_id
| tinyint(3) unsigned
|
|
| customer | first_name
| varchar(45)
|
|
| customer | last_name
| varchar(45)
|
|
| customer | email
| varchar(50)
|
|
| customer | address_id
| smallint(5) unsigned
|
|
| customer | active
| tinyint(1)
|
|
| customer | create_date
| datetime
|
|
| customer | last_update
| timestamp
|
|
| film | film_id
| smallint(5) unsigned
|
|
| film | title
| varchar(255)
|
|
| film | description
| text
|
|
| film | release_year
| year(4)
|
|
| film | language_id
| tinyint(3) unsigned
|
|
| film | original_language_id
| tinyint(3) unsigned
|
|
| film | rental_duration
| tinyint(3) unsigned
|
|
| film | rental_rate
| decimal(4, 2)
|
|
| film | length
| smallint(5) unsigned
|
|
| film | replacement_cost
| decimal(5, 2)
|
|
| film | rating
| enum('G', 'PG', 'PG-13', 'R', 'NC-17')
|
|
| film | special_features
| set('Trailers', 'Commentaries', 'Deleted Scenes', 'Behind the Scenes')
|
|
| film | last_update
| timestamp
|
|
| film_actor | actor_id
| smallint(5) unsigned
|
|
| film_actor | film_id
| smallint(5) unsigned
|
|
| film_actor | last_update
| timestamp
|
|
| film_category | film_id
| smallint(5) unsigned
|
|
| film_category | category_id
| tinyint(3) unsigned
|
|
| film_category | last_update
| timestamp
|
|
| film_text | film_id
| smallint(6)
|
|
| film_text | title
| varchar(255)
|
|
| film_text | description
| text
|
|
| inventory | inventory_id
| mediumint(8) unsigned
|
|
| inventory | film_id
| smallint(5) unsigned
|
|
| inventory | store_id
| tinyint(3) unsigned
|
|
| inventory | last_update
| timestamp
|
|
| language | language_id
| tinyint(3) unsigned
|
|
| language | name
| char(20)
|
|
| language | last_update
| timestamp
|
|
| payment | payment_id
| smallint(5) unsigned
|
|
| payment | customer_id
| smallint(5) unsigned
|
|
| payment | staff_id
| tinyint(3) unsigned
|
|
| payment | rental_id
| int(11)
|
|
| payment | amount
| decimal(5, 2)
|
|
| payment | payment_date
| datetime
|
|
| payment | last_update
| timestamp
|
|
| rental | rental_id
| int(11)
|
|
| rental | rental_date
| datetime
|
|
| rental | inventory_id
| mediumint(8) unsigned
|
|
| rental | customer_id
| smallint(5) unsigned
|
|
| rental | return_date
| datetime
|
|
| rental | staff_id
| tinyint(3) unsigned
|
|
| rental | last_update
| timestamp
|
|
| staff | staff_id
| tinyint(3) unsigned
|
|
| staff | first_name
| varchar(45)
|
|
| staff | last_name
| varchar(45)
|
|
| staff | address_id
| smallint(5) unsigned
|
|
| staff | picture
| blob
|
|
| staff | email
| varchar(50)
|
|
| staff | store_id
| tinyint(3) unsigned
|
|
| staff | active
| tinyint(1)
|
|
| staff | username
| varchar(16)
|
|
| staff | password
| varchar(40)
|
|
| staff | last_update
| timestamp
|
|
| store | store_id
| tinyint(3) unsigned
|
|
| store | manager_staff_id
| tinyint(3) unsigned
|
|
| store | address_id
| smallint(5) unsigned
|
|
| store | last_update
| timestamp
|
|
| zzz_object_comments | LevelZeroName
| varchar(100)
|
|
| zzz_object_comments | LevelZeroType
| varchar(100)
|
|
| zzz_object_comments | LevelOneName
| varchar(100)
|
|
| zzz_object_comments | LevelOneType
| varchar(100)
|
|
| zzz_object_comments | LevelTwoName
| varchar(100)
|
|
| zzz_object_comments | LevelTwoType
| varchar(100)
|
|
| zzz_object_comments | PropName
| varchar(100)
|
|
| zzz_object_comments | PropVal
| varchar(2048)
|
|
| actor_info | actor_id
| smallint(5) unsigned
|
|
| actor_info | first_name
| varchar(45)
|
|
| actor_info | last_name
| varchar(45)
|
|
| actor_info | film_info
| varchar(341)
|
|
| customer_list | ID
| smallint(5) unsigned
|
|
| customer_list | name
| varchar(91)
|
|
| customer_list | address
| varchar(50)
|
|
| customer_list | zip code
| varchar(10)
|
|
| customer_list | phone
| varchar(20)
|
|
| customer_list | city
| varchar(50)
|
|
| customer_list | country
| varchar(50)
|
|
| customer_list | notes
| varchar(6)
|
|
| customer_list | SID
| tinyint(3) unsigned
|
|
| film_list | FID
| smallint(5) unsigned
|
|
| film_list | title
| varchar(255)
|
|
| film_list | description
| text
|
|
| film_list | category
| varchar(25)
|
|
| film_list | price
| decimal(4, 2)
|
|
| film_list | length
| smallint(5) unsigned
|
|
| film_list | rating
| enum('G', 'PG', 'PG-13', 'R', 'NC-17')
|
|
| film_list | actors
| varchar(341)
|
|
| nicer_but_slower_film_list | FID
| smallint(5) unsigned
|
|
| nicer_but_slower_film_list | title
| varchar(255)
|
|
| nicer_but_slower_film_list | description
| text
|
|
| nicer_but_slower_film_list | category
| varchar(25)
|
|
| nicer_but_slower_film_list | price
| decimal(4, 2)
|
|
| nicer_but_slower_film_list | length
| smallint(5) unsigned
|
|
| nicer_but_slower_film_list | rating
| enum('G', 'PG', 'PG-13', 'R', 'NC-17')
|
|
| nicer_but_slower_film_list | actors
| varchar(341)
|
|
| sales_by_film_category | category
| varchar(25)
|
|
| sales_by_film_category | total_sales
| decimal(27, 2)
|
|
| sales_by_store | store
| varchar(101)
|
|
| sales_by_store | manager
| varchar(91)
|
|
| sales_by_store | total_sales
| decimal(27, 2)
|
|
| staff_list | ID
| tinyint(3) unsigned
|
|
| staff_list | name
| varchar(91)
|
|
| staff_list | address
| varchar(50)
|
|
| staff_list | zip code
| varchar(10)
|
|
| staff_list | phone
| varchar(20)
|
|
| staff_list | city
| varchar(50)
|
|
| staff_list | country
| varchar(50)
|
|
| staff_list | SID
| tinyint(3) unsigned
|
|