1 Sample Layout This is an interactive HTML5 image. Move the mouse over tables to read the comments. Powered by DbSchema Fk fk_film_language film ref language ( language_id ) Fk fk_film_language_original film ref language ( original_language_id -> language_id ) Fk fk_film_actor_actor film_actor ref actor ( actor_id ) Fk fk_film_actor_film film_actor ref film ( film_id ) Fk fk_film_category_category film_category ref category ( category_id ) Fk fk_film_category_film film_category ref film ( film_id ) filmTable sakila.film Pk pk_film ( film_id ) film_idfilm_id * smallint Referred by film_actor ( film_id ) Referred by film_category ( film_id ) Referred by inventory ( film_id ) idx_title ( title ) titletitle * varchar(255) descriptiondescription text release_yearrelease_year year idx_fk_language_id ( language_id ) language_idlanguage_id * tinyint References language ( language_id ) idx_fk_original_language_id ( original_language_id ) original_language_idoriginal_language_id tinyint References language ( original_language_id -> language_id ) rental_durationrental_duration * tinyint default 3 rental_raterental_rate * decimal(4,2) default 4.99 lengthlength smallint replacement_costreplacement_cost * decimal(5,2) default 19.99 ratingrating enum('g','pg','pg-13','r','nc-17') default 'G' special_featuresspecial_features set('trailers','commentaries','deleted scenes','behind the scenes') last_updatelast_update * timestamp default CURRENT_TIMESTAMP actorTable sakila.actor This table stores the actors. Pk pk_actor ( actor_id ) actor_idactor_id * smallint Referred by film_actor ( actor_id ) first_namefirst_name * varchar(45) idx_actor_last_name ( last_name ) last_namelast_name * varchar(45) last_updatelast_update * timestamp default CURRENT_TIMESTAMP film_actorTable sakila.film_actor The many-to-many relation between actors and films. The films in which one actor played. Pk pk_film_actor ( actor_id, film_id ) actor_idactor_id * smallint References actor ( actor_id ) Pk pk_film_actor ( actor_id, film_id ) idx_fk_film_id ( film_id ) film_idfilm_id * smallint References film ( film_id ) last_updatelast_update * timestamp default CURRENT_TIMESTAMP categoryTable sakila.category Different categoreis of a film Pk pk_category ( category_id ) category_idcategory_id * tinyint Referred by film_category ( category_id ) namename * varchar(25) last_updatelast_update * timestamp default CURRENT_TIMESTAMP film_categoryTable sakila.film_category One film may have multiple categories. Pk pk_film_category ( film_id, category_id ) film_idfilm_id * smallint References film ( film_id ) Pk pk_film_category ( film_id, category_id ) fk_film_category_category ( category_id ) category_idcategory_id * tinyint References category ( category_id ) last_updatelast_update * timestamp default CURRENT_TIMESTAMP languageTable sakila.language A film has an original languages as translations into other languages. Pk pk_language ( language_id ) language_idlanguage_id * tinyint Referred by film ( language_id ) Referred by film ( original_language_id -> language_id ) namename * char(20) last_updatelast_update * timestamp default CURRENT_TIMESTAMP