Tabela: actor -
Atributos
Nome Tipo Nao Nulo PK FK Default Significado
actor_idSMALLINTSimSimNao
first_nameVARCHAR(45)SimNaoNao
last_nameVARCHAR(45)SimNaoNao
last_updateTIMESTAMPSimNaoNaoCURRENT_TIMESTAMP

Tabela: address -
Atributos
Nome Tipo Nao Nulo PK FK Default Significado
address_idSMALLINTSimSimNao
addressVARCHAR(50)SimNaoNao
address2VARCHAR(50)NaoNaoNaoNULL
districtVARCHAR(20)SimNaoNao
city_idSMALLINTSimNaoSim
postal_codeVARCHAR(10)NaoNaoNaoNULL
phoneVARCHAR(20)SimNaoNao
last_updateTIMESTAMPSimNaoNaoCURRENT_TIMESTAMP

Tabela: category -
Atributos
Nome Tipo Nao Nulo PK FK Default Significado
category_idTINYINTSimSimNao
nameVARCHAR(25)SimNaoNao
last_updateTIMESTAMPSimNaoNaoCURRENT_TIMESTAMP

Tabela: city -
Atributos
Nome Tipo Nao Nulo PK FK Default Significado
city_idSMALLINTSimSimNao
cityVARCHAR(50)SimNaoNao
country_idSMALLINTSimNaoSim
last_updateTIMESTAMPSimNaoNaoCURRENT_TIMESTAMP

Tabela: country -
Atributos
Nome Tipo Nao Nulo PK FK Default Significado
country_idSMALLINTSimSimNao
countryVARCHAR(50)SimNaoNao
last_updateTIMESTAMPSimNaoNaoCURRENT_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_idSMALLINTSimSimNao
store_idTINYINTSimNaoSim
first_nameVARCHAR(45)SimNaoNao
last_nameVARCHAR(45)SimNaoNao
emailVARCHAR(50)NaoNaoNaoNULL
address_idSMALLINTSimNaoSim
activeTINYINT(1)SimNaoNaoTRUE
create_dateDATETIMESimNaoNao
last_updateTIMESTAMPNaoNaoNaoCURRENT_TIMESTAMP

Tabela: film -
Atributos
Nome Tipo Nao Nulo PK FK Default Significado
film_idSMALLINTSimSimNao
titleVARCHAR(255)SimNaoNao
descriptionTEXTNaoNaoNao
release_yearYEARNaoNaoNao
language_idTINYINTSimNaoSim
original_language_idTINYINTNaoNaoSimNULL
rental_durationTINYINTSimNaoNao3
rental_rateDECIMAL(4,2)SimNaoNao4.99
lengthSMALLINTNaoNaoNaoNULL
replacement_costDECIMAL(5,2)SimNaoNao19.99
ratingENUM('G','PG','PG-13','R','NC-17')NaoNaoNao'G'
special_featuresSET('Trailers','Commentaries','Deleted Scenes','Behind the Scenes')NaoNaoNao
last_updateTIMESTAMPSimNaoNaoCURRENT_TIMESTAMP

Tabela: film_actor -
Atributos
Nome Tipo Nao Nulo PK FK Default Significado
actor_idSMALLINTSimSimSim
film_idSMALLINTSimSimSim
last_updateTIMESTAMPSimNaoNaoCURRENT_TIMESTAMP

Tabela: film_category -
Atributos
Nome Tipo Nao Nulo PK FK Default Significado
film_idSMALLINTSimSimSim
category_idTINYINTSimSimSim
last_updateTIMESTAMPSimNaoNaoCURRENT_TIMESTAMP

Tabela: film_text -
Atributos
Nome Tipo Nao Nulo PK FK Default Significado
film_idSMALLINTSimSimSim
titleVARCHAR(255)SimNaoNao
descriptionTEXTNaoNaoNao

Tabela: inventory -
Atributos
Nome Tipo Nao Nulo PK FK Default Significado
inventory_idMEDIUMINTSimSimNao
film_idSMALLINTSimNaoSim
store_idTINYINTSimNaoSim
last_updateTIMESTAMPSimNaoNaoCURRENT_TIMESTAMP

Tabela: language -
Atributos
Nome Tipo Nao Nulo PK FK Default Significado
language_idTINYINTSimSimNao
nameCHAR(20)SimNaoNao
last_updateTIMESTAMPSimNaoNaoCURRENT_TIMESTAMP

Tabela: payment -
Atributos
Nome Tipo Nao Nulo PK FK Default Significado
payment_idSMALLINTSimSimNao
customer_idSMALLINTSimNaoSim
staff_idTINYINTSimNaoSim
rental_idINTNaoNaoSimNULL
amountDECIMAL(5,2)SimNaoNao
payment_dateDATETIMESimNaoNao
last_updateTIMESTAMPNaoNaoNaoCURRENT_TIMESTAMP

Tabela: rental -
Atributos
Nome Tipo Nao Nulo PK FK Default Significado
rental_idINTSimSimNao
rental_dateDATETIMESimNaoNao
inventory_idMEDIUMINTSimNaoSim
customer_idSMALLINTSimNaoSim
return_dateDATETIMENaoNaoNao
staff_idTINYINTSimNaoSim
last_updateTIMESTAMPSimNaoNaoCURRENT_TIMESTAMP

Tabela: staff -
Atributos
Nome Tipo Nao Nulo PK FK Default Significado
staff_idTINYINTSimSimNao
first_nameVARCHAR(45)SimNaoNao
last_nameVARCHAR(45)SimNaoNao
address_idSMALLINTSimNaoSim
pictureBLOBNaoNaoNao
emailVARCHAR(50)NaoNaoNaoNULL
store_idTINYINTSimNaoSim
activeTINYINT(1)SimNaoNaoTRUE
usernameVARCHAR(16)SimNaoNao
passwordVARCHAR(40)NaoNaoNaoNULL
last_updateTIMESTAMPSimNaoNaoCURRENT_TIMESTAMP

Tabela: store -
Atributos
Nome Tipo Nao Nulo PK FK Default Significado
store_idTINYINTSimSimNao
manager_staff_idTINYINTSimNaoSim
address_idSMALLINTSimNaoSim
last_updateTIMESTAMPSimNaoNaoCURRENT_TIMESTAMP