Tabela: actor -

Atributos
Nome	Tipo	Nao Nulo	PK	FK	Default	Significado
actor_id	SMALLINT	Sim	Sim	Nao
first_name	VARCHAR(45)	Sim	Nao	Nao
last_name	VARCHAR(45)	Sim	Nao	Nao
last_update	TIMESTAMP	Sim	Nao	Nao	CURRENT_TIMESTAMP

Tabela: address -

Atributos
Nome	Tipo	Nao Nulo	PK	FK	Default	Significado
address_id	SMALLINT	Sim	Sim	Nao
address	VARCHAR(50)	Sim	Nao	Nao
address2	VARCHAR(50)	Nao	Nao	Nao	NULL
district	VARCHAR(20)	Sim	Nao	Nao
city_id	SMALLINT	Sim	Nao	Sim
postal_code	VARCHAR(10)	Nao	Nao	Nao	NULL
phone	VARCHAR(20)	Sim	Nao	Nao
last_update	TIMESTAMP	Sim	Nao	Nao	CURRENT_TIMESTAMP

Tabela: category -

Atributos
Nome	Tipo	Nao Nulo	PK	FK	Default	Significado
category_id	TINYINT	Sim	Sim	Nao
name	VARCHAR(25)	Sim	Nao	Nao
last_update	TIMESTAMP	Sim	Nao	Nao	CURRENT_TIMESTAMP

Tabela: city -

Atributos
Nome	Tipo	Nao Nulo	PK	FK	Default	Significado
city_id	SMALLINT	Sim	Sim	Nao
city	VARCHAR(50)	Sim	Nao	Nao
country_id	SMALLINT	Sim	Nao	Sim
last_update	TIMESTAMP	Sim	Nao	Nao	CURRENT_TIMESTAMP

Tabela: country -

Atributos
Nome	Tipo	Nao Nulo	PK	FK	Default	Significado
country_id	SMALLINT	Sim	Sim	Nao
country	VARCHAR(50)	Sim	Nao	Nao
last_update	TIMESTAMP	Sim	Nao	Nao	CURRENT_TIMESTAMP

Tabela: customer - Table storing all customers. Holds foreign keys to the address table and the store table where this customer is registered. Basic information about the customer like first and last name are stored in the table itself. Same for the date the record was created and when the information was last updated.

Atributos
Nome	Tipo	Nao Nulo	PK	FK	Default	Significado
customer_id	SMALLINT	Sim	Sim	Nao
store_id	TINYINT	Sim	Nao	Sim
first_name	VARCHAR(45)	Sim	Nao	Nao
last_name	VARCHAR(45)	Sim	Nao	Nao
email	VARCHAR(50)	Nao	Nao	Nao	NULL
address_id	SMALLINT	Sim	Nao	Sim
active	TINYINT(1)	Sim	Nao	Nao	TRUE
create_date	DATETIME	Sim	Nao	Nao
last_update	TIMESTAMP	Nao	Nao	Nao	CURRENT_TIMESTAMP

Tabela: film -

Atributos
Nome	Tipo	Nao Nulo	PK	FK	Default	Significado
film_id	SMALLINT	Sim	Sim	Nao
title	VARCHAR(255)	Sim	Nao	Nao
description	TEXT	Nao	Nao	Nao
release_year	YEAR	Nao	Nao	Nao
language_id	TINYINT	Sim	Nao	Sim
original_language_id	TINYINT	Nao	Nao	Sim	NULL
rental_duration	TINYINT	Sim	Nao	Nao	3
rental_rate	DECIMAL(4,2)	Sim	Nao	Nao	4.99
length	SMALLINT	Nao	Nao	Nao	NULL
replacement_cost	DECIMAL(5,2)	Sim	Nao	Nao	19.99
rating	ENUM('G','PG','PG-13','R','NC-17')	Nao	Nao	Nao	'G'
special_features	SET('Trailers','Commentaries','Deleted Scenes','Behind the Scenes')	Nao	Nao	Nao
last_update	TIMESTAMP	Sim	Nao	Nao	CURRENT_TIMESTAMP

Tabela: film_actor -

Atributos
Nome	Tipo	Nao Nulo	PK	FK	Default	Significado
actor_id	SMALLINT	Sim	Sim	Sim
film_id	SMALLINT	Sim	Sim	Sim
last_update	TIMESTAMP	Sim	Nao	Nao	CURRENT_TIMESTAMP

Tabela: film_category -

Atributos
Nome	Tipo	Nao Nulo	PK	FK	Default	Significado
film_id	SMALLINT	Sim	Sim	Sim
category_id	TINYINT	Sim	Sim	Sim
last_update	TIMESTAMP	Sim	Nao	Nao	CURRENT_TIMESTAMP

Tabela: film_text -

Atributos
Nome	Tipo	Nao Nulo	PK	FK	Default	Significado
film_id	SMALLINT	Sim	Sim	Sim
title	VARCHAR(255)	Sim	Nao	Nao
description	TEXT	Nao	Nao	Nao

Tabela: inventory -

Atributos
Nome	Tipo	Nao Nulo	PK	FK	Default	Significado
inventory_id	MEDIUMINT	Sim	Sim	Nao
film_id	SMALLINT	Sim	Nao	Sim
store_id	TINYINT	Sim	Nao	Sim
last_update	TIMESTAMP	Sim	Nao	Nao	CURRENT_TIMESTAMP

Tabela: language -

Atributos
Nome	Tipo	Nao Nulo	PK	FK	Default	Significado
language_id	TINYINT	Sim	Sim	Nao
name	CHAR(20)	Sim	Nao	Nao
last_update	TIMESTAMP	Sim	Nao	Nao	CURRENT_TIMESTAMP

Tabela: payment -

Atributos
Nome	Tipo	Nao Nulo	PK	FK	Default	Significado
payment_id	SMALLINT	Sim	Sim	Nao
customer_id	SMALLINT	Sim	Nao	Sim
staff_id	TINYINT	Sim	Nao	Sim
rental_id	INT	Nao	Nao	Sim	NULL
amount	DECIMAL(5,2)	Sim	Nao	Nao
payment_date	DATETIME	Sim	Nao	Nao
last_update	TIMESTAMP	Nao	Nao	Nao	CURRENT_TIMESTAMP

Tabela: rental -

Atributos
Nome	Tipo	Nao Nulo	PK	FK	Default	Significado
rental_id	INT	Sim	Sim	Nao
rental_date	DATETIME	Sim	Nao	Nao
inventory_id	MEDIUMINT	Sim	Nao	Sim
customer_id	SMALLINT	Sim	Nao	Sim
return_date	DATETIME	Nao	Nao	Nao
staff_id	TINYINT	Sim	Nao	Sim
last_update	TIMESTAMP	Sim	Nao	Nao	CURRENT_TIMESTAMP

Tabela: staff -

Atributos
Nome	Tipo	Nao Nulo	PK	FK	Default	Significado
staff_id	TINYINT	Sim	Sim	Nao
first_name	VARCHAR(45)	Sim	Nao	Nao
last_name	VARCHAR(45)	Sim	Nao	Nao
address_id	SMALLINT	Sim	Nao	Sim
picture	BLOB	Nao	Nao	Nao
email	VARCHAR(50)	Nao	Nao	Nao	NULL
store_id	TINYINT	Sim	Nao	Sim
active	TINYINT(1)	Sim	Nao	Nao	TRUE
username	VARCHAR(16)	Sim	Nao	Nao
password	VARCHAR(40)	Nao	Nao	Nao	NULL
last_update	TIMESTAMP	Sim	Nao	Nao	CURRENT_TIMESTAMP

Tabela: store -

Atributos
Nome	Tipo	Nao Nulo	PK	FK	Default	Significado
store_id	TINYINT	Sim	Sim	Nao
manager_staff_id	TINYINT	Sim	Nao	Sim
address_id	SMALLINT	Sim	Nao	Sim
last_update	TIMESTAMP	Sim	Nao	Nao	CURRENT_TIMESTAMP