Schema Overview
Schema sakila
Back to overview
Columns (139)
actor
.actor_id
actor
.first_name
actor
.last_name
actor
.last_update
address
.address_id
address
.address
address
.address2
address
.district
address
.city_id
address
.postal_code
address
.phone
address
.last_update
category
.category_id
category
.name
category
.last_update
city
.city_id
city
.city
city
.country_id
city
.last_update
country
.country_id
country
.country
country
.last_update
customer
.customer_id
customer
.store_id
customer
.first_name
customer
.last_name
customer
.email
customer
.address_id
customer
.active
customer
.create_date
customer
.last_update
film
.film_id
film
.title
film
.description
film
.release_year
film
.language_id
film
.original_language_id
film
.rental_duration
film
.rental_rate
film
.length
film
.replacement_cost
film
.rating
film
.special_features
film
.last_update
film_actor
.actor_id
film_actor
.film_id
film_actor
.last_update
film_category
.film_id
film_category
.category_id
film_category
.last_update
film_text
.film_id
film_text
.title
film_text
.description
inventory
.inventory_id
inventory
.film_id
inventory
.store_id
inventory
.last_update
language
.language_id
language
.name
language
.last_update
payment
.payment_id
payment
.customer_id
payment
.staff_id
payment
.rental_id
payment
.amount
payment
.payment_date
payment
.last_update
rental
.rental_id
rental
.rental_date
rental
.inventory_id
rental
.customer_id
rental
.return_date
rental
.staff_id
rental
.last_update
staff
.staff_id
staff
.first_name
staff
.last_name
staff
.address_id
staff
.picture
staff
.email
staff
.store_id
staff
.active
staff
.username
staff
.password
staff
.last_update
store
.store_id
store
.manager_staff_id
store
.address_id
store
.last_update
Indices (56)
actor
.PRIMARY
actor
.idx_actor_last_name
address
.PRIMARY
address
.idx_fk_city_id
category
.PRIMARY
city
.PRIMARY
city
.idx_fk_country_id
country
.PRIMARY
customer
.PRIMARY
customer
.idx_fk_store_id
customer
.idx_fk_address_id
customer
.idx_last_name
film
.idx_title
film
.idx_fk_language_id
film
.idx_fk_original_language_id
film
.PRIMARY
film_actor
.PRIMARY
film_actor
.idx_fk_film_id
film_actor
.fk_film_actor_actor_idx
film_category
.PRIMARY
film_category
.fk_film_category_category_idx
film_category
.fk_film_category_film_idx
film_text
.PRIMARY
film_text
.idx_title_description
film_text
.fk_film_text_idx
inventory
.PRIMARY
inventory
.idx_fk_film_id
inventory
.idx_store_id_film_id
inventory
.fk_inventory_store_idx
language
.PRIMARY
payment
.PRIMARY
payment
.idx_fk_staff_id
payment
.idx_fk_customer_id
payment
.fk_payment_rental_idx
rental
.PRIMARY
rental
.
rental
.idx_fk_inventory_id
rental
.idx_fk_customer_id
rental
.idx_fk_staff_id
staff
.PRIMARY
staff
.idx_fk_store_id
staff
.idx_fk_address_id
store
.PRIMARY
store
.idx_unique_manager
store
.idx_fk_address_id
Foreign Keys ()
address
.fk_address_city
city
.fk_city_country
customer
.fk_customer_address
customer
.fk_customer_store
film
.fk_film_language
film
.fk_film_language_original
film_actor
.fk_film_actor_actor
film_actor
.fk_film_actor_film
film_category
.fk_film_category_film
film_category
.fk_film_category_category
film_text
.fk_film_text
inventory
.fk_inventory_store
inventory
.fk_inventory_film
payment
.fk_payment_rental
payment
.fk_payment_customer
payment
.fk_payment_staff
rental
.fk_rental_staff
rental
.fk_rental_inventory
rental
.fk_rental_customer
staff
.fk_staff_store
staff
.fk_staff_address
store
.fk_store_staff
store
.fk_store_address
Triggers (3)
film
.ins_film
film
.upd_film
film
.del_film
Schema test
Back to overview
Columns (139)
t
.id
t
.col1
Indices (56)
t
.PRIMARY
Foreign Keys ()
Triggers (3)
Schema world
Back to overview
Columns (139)
city
.ID
city
.Name
city
.CountryCode
city
.District
city
.Population
country
.Code
country
.Name
country
.Continent
country
.Region
country
.SurfaceArea
country
.IndepYear
country
.Population
country
.LifeExpectancy
country
.GNP
country
.GNPOld
country
.LocalName
country
.GovernmentForm
country
.HeadOfState
country
.Capital
country
.Code2
countrylanguage
.CountryCode
countrylanguage
.Language
countrylanguage
.IsOfficial
countrylanguage
.Percentage
Indices (56)
city
.PRIMARY
city
.CountryCode
country
.PRIMARY
countrylanguage
.PRIMARY
countrylanguage
.CountryCode
Foreign Keys ()
city
.city_ibfk_1
countrylanguage
.countryLanguage_ibfk_1
Triggers (3)
Schema world2
Back to overview
Columns (139)
city
.ID
city
.Name
city
.CountryCode
city
.District
city
.Population
country
.Code
country
.Name
country
.Continent
country
.Region
country
.SurfaceArea
country
.IndepYear
country
.Population
country
.LifeExpectancy
country
.GNP
country
.GNPOld
country
.LocalName
country
.GovernmentForm
country
.HeadOfState
country
.Capital
country
.Code2
countrylanguage
.CountryCode
countrylanguage
.Language
countrylanguage
.IsOfficial
countrylanguage
.Percentage
Indices (56)
city
.PRIMARY
city
.CountryCode
country
.PRIMARY
countrylanguage
.PRIMARY
countrylanguage
.CountryCode
Foreign Keys ()
city
.city_ibfk_1
countrylanguage
.countryLanguage_ibfk_1
Triggers (3)