Column | Type | Null | Default | Comments |
---|---|---|---|---|
actor_id (Primary) | smallint(5) | No | ||
first_name | varchar(45) | No | ||
last_name | varchar(45) | No | ||
last_update | timestamp | No | CURRENT_TIMESTAMP |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | actor_id | 200 | A | No | |
idx_actor_last_name | BTREE | No | No | last_name | 121 | A | No |
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
actor_id | smallint(5) | No | 0 | |
first_name | varchar(45) | No | ||
last_name | varchar(45) | No | ||
film_info | text | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
address_id (Primary) | smallint(5) | No | ||
address | varchar(50) | No | ||
address2 | varchar(50) | Yes | NULL | |
district | varchar(20) | No | ||
city_id | smallint(5) | No | ||
postal_code | varchar(10) | Yes | NULL | |
phone | varchar(20) | No | ||
last_update | timestamp | No | CURRENT_TIMESTAMP |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | address_id | 603 | A | No | |
idx_fk_city_id | BTREE | No | No | city_id | 599 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
category_id (Primary) | tinyint(3) | No | ||
name | varchar(25) | No | ||
last_update | timestamp | No | CURRENT_TIMESTAMP |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | category_id | 16 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
city_id (Primary) | smallint(5) | No | ||
city | varchar(50) | No | ||
country_id | smallint(5) | No | ||
last_update | timestamp | No | CURRENT_TIMESTAMP |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | city_id | 600 | A | No | |
idx_fk_country_id | BTREE | No | No | country_id | 109 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
country_id (Primary) | smallint(5) | No | ||
country | varchar(50) | No | ||
last_update | timestamp | No | CURRENT_TIMESTAMP |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | country_id | 109 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
customer_id (Primary) | smallint(5) | No | ||
store_id | tinyint(3) | No | ||
first_name | varchar(45) | No | ||
last_name | varchar(45) | No | ||
varchar(50) | Yes | NULL | ||
address_id | smallint(5) | No | ||
active | tinyint(1) | No | 1 | |
create_date | datetime | No | ||
last_update | timestamp | Yes | CURRENT_TIMESTAMP |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | customer_id | 599 | A | No | |
idx_fk_store_id | BTREE | No | No | store_id | 2 | A | No | |
idx_fk_address_id | BTREE | No | No | address_id | 599 | A | No | |
idx_last_name | BTREE | No | No | last_name | 599 | A | No |
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
ID | smallint(5) | No | 0 | |
name | varchar(91) | Yes | NULL | |
address | varchar(50) | No | ||
zip code | varchar(10) | Yes | NULL | |
phone | varchar(20) | No | ||
city | varchar(50) | No | ||
country | varchar(50) | No | ||
notes | varchar(6) | No | ||
SID | tinyint(3) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
film_id (Primary) | smallint(5) | No | ||
title | varchar(255) | No | ||
description | text | Yes | NULL | |
release_year | year(4) | Yes | NULL | |
language_id | tinyint(3) | No | ||
original_language_id | tinyint(3) | Yes | NULL | |
rental_duration | tinyint(3) | No | 3 | |
rental_rate | decimal(4,2) | No | 4.99 | |
length | smallint(5) | Yes | NULL | |
replacement_cost | decimal(5,2) | No | 19.99 | |
rating | enum('G', 'PG', 'PG-13', 'R', 'NC-17') | Yes | G | |
special_features | set('Trailers', 'Commentaries', 'Deleted Scenes', 'Behind the Scenes') | Yes | NULL | |
last_update | timestamp | No | CURRENT_TIMESTAMP |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | film_id | 1000 | A | No | |
idx_title | BTREE | No | No | title | 1000 | A | No | |
idx_fk_language_id | BTREE | No | No | language_id | 1 | A | No | |
idx_fk_original_language_id | BTREE | No | No | original_language_id | 1 | A | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
actor_id (Primary) | smallint(5) | No | ||
film_id (Primary) | smallint(5) | No | ||
last_update | timestamp | No | CURRENT_TIMESTAMP |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | actor_id | 200 | A | No | |
film_id | 5462 | A | No | |||||
idx_fk_film_id | BTREE | No | No | film_id | 997 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
film_id (Primary) | smallint(5) | No | ||
category_id (Primary) | tinyint(3) | No | ||
last_update | timestamp | No | CURRENT_TIMESTAMP |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | film_id | 1000 | A | No | |
category_id | 1000 | A | No | |||||
fk_film_category_category | BTREE | No | No | category_id | 16 | A | No |
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
FID | smallint(5) | Yes | 0 | |
title | varchar(255) | Yes | NULL | |
description | text | Yes | NULL | |
category | varchar(25) | No | ||
price | decimal(4,2) | Yes | 4.99 | |
length | smallint(5) | Yes | NULL | |
rating | enum('G', 'PG', 'PG-13', 'R', 'NC-17') | Yes | G | |
actors | text | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
film_id (Primary) | smallint(6) | No | ||
title | varchar(255) | No | ||
description | text | Yes | NULL |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | film_id | 1000 | A | No | |
idx_title_description | FULLTEXT | No | No | title | No | |||
description | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
inventory_id (Primary) | mediumint(8) | No | ||
film_id | smallint(5) | No | ||
store_id | tinyint(3) | No | ||
last_update | timestamp | No | CURRENT_TIMESTAMP |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | inventory_id | 4581 | A | No | |
idx_fk_film_id | BTREE | No | No | film_id | 958 | A | No | |
idx_store_id_film_id | BTREE | No | No | store_id | 2 | A | No | |
film_id | 1521 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
language_id (Primary) | tinyint(3) | No | ||
name | char(20) | No | ||
last_update | timestamp | No | CURRENT_TIMESTAMP |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | language_id | 6 | A | No |
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
FID | smallint(5) | Yes | 0 | |
title | varchar(255) | Yes | NULL | |
description | text | Yes | NULL | |
category | varchar(25) | No | ||
price | decimal(4,2) | Yes | 4.99 | |
length | smallint(5) | Yes | NULL | |
rating | enum('G', 'PG', 'PG-13', 'R', 'NC-17') | Yes | G | |
actors | text | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
payment_id (Primary) | smallint(5) | No | ||
customer_id | smallint(5) | No | ||
staff_id | tinyint(3) | No | ||
rental_id | int(11) | Yes | NULL | |
amount | decimal(5,2) | No | ||
payment_date | datetime | No | ||
last_update | timestamp | Yes | CURRENT_TIMESTAMP |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | payment_id | 16086 | A | No | |
idx_fk_staff_id | BTREE | No | No | staff_id | 2 | A | No | |
idx_fk_customer_id | BTREE | No | No | customer_id | 599 | A | No | |
fk_payment_rental | BTREE | No | No | rental_id | 16045 | A | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
rental_id (Primary) | int(11) | No | ||
rental_date | datetime | No | ||
inventory_id | mediumint(8) | No | ||
customer_id | smallint(5) | No | ||
return_date | datetime | Yes | NULL | |
staff_id | tinyint(3) | No | ||
last_update | timestamp | No | CURRENT_TIMESTAMP |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | rental_id | 16005 | A | No | |
rental_date | BTREE | Yes | No | rental_date | 15815 | A | No | |
inventory_id | 16005 | A | No | |||||
customer_id | 16005 | A | No | |||||
idx_fk_inventory_id | BTREE | No | No | inventory_id | 4580 | A | No | |
idx_fk_customer_id | BTREE | No | No | customer_id | 599 | A | No | |
idx_fk_staff_id | BTREE | No | No | staff_id | 2 | A | No |
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
category | varchar(25) | No | ||
total_sales | decimal(27,2) | Yes | NULL |
No index defined!
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
store | varchar(101) | Yes | NULL | |
manager | varchar(91) | Yes | NULL | |
total_sales | decimal(27,2) | Yes | NULL |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
staff_id (Primary) | tinyint(3) | No | ||
first_name | varchar(45) | No | ||
last_name | varchar(45) | No | ||
address_id | smallint(5) | No | ||
picture | blob | Yes | NULL | |
varchar(50) | Yes | NULL | ||
store_id | tinyint(3) | No | ||
active | tinyint(1) | No | 1 | |
username | varchar(16) | No | ||
password | varchar(40) | Yes | NULL | |
last_update | timestamp | No | CURRENT_TIMESTAMP |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | staff_id | 2 | A | No | |
idx_fk_store_id | BTREE | No | No | store_id | 2 | A | No | |
idx_fk_address_id | BTREE | No | No | address_id | 2 | A | No |
Table comments: VIEW
Column | Type | Null | Default | Comments |
---|---|---|---|---|
ID | tinyint(3) | No | 0 | |
name | varchar(91) | Yes | NULL | |
address | varchar(50) | No | ||
zip code | varchar(10) | Yes | NULL | |
phone | varchar(20) | No | ||
city | varchar(50) | No | ||
country | varchar(50) | No | ||
SID | tinyint(3) | No |
No index defined!
Column | Type | Null | Default | Comments |
---|---|---|---|---|
store_id (Primary) | tinyint(3) | No | ||
manager_staff_id | tinyint(3) | No | ||
address_id | smallint(5) | No | ||
last_update | timestamp | No | CURRENT_TIMESTAMP |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | store_id | 2 | A | No | |
idx_unique_manager | BTREE | Yes | No | manager_staff_id | 2 | A | No | |
idx_fk_address_id | BTREE | No | No | address_id | 2 | A | No |