Column actor_id
General Info
Schema Name sakila
Table Name actor
Key Part Primary key
Nullable No
Default Value
Auto Increment Yes
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column first_name
General Info
Schema Name sakila
Table Name actor
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(45)
Is User Type No

Column last_name
General Info
Schema Name sakila
Table Name actor
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(45)
Is User Type No

Column last_update
General Info
Schema Name sakila
Table Name actor
Key Part
Nullable No
Default Value CURRENT_TIMESTAMP
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TIMESTAMP
Is User Type No

Column address_id
General Info
Schema Name sakila
Table Name address
Key Part Primary key
Nullable No
Default Value
Auto Increment Yes
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column address
General Info
Schema Name sakila
Table Name address
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(50)
Is User Type No

Column address2
General Info
Schema Name sakila
Table Name address
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(50)
Is User Type No

Column district
General Info
Schema Name sakila
Table Name address
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(20)
Is User Type No

Column city_id
General Info
Schema Name sakila
Table Name address
Key Part Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column postal_code
General Info
Schema Name sakila
Table Name address
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(10)
Is User Type No

Column phone
General Info
Schema Name sakila
Table Name address
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(20)
Is User Type No

Column last_update
General Info
Schema Name sakila
Table Name address
Key Part
Nullable No
Default Value CURRENT_TIMESTAMP
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TIMESTAMP
Is User Type No

Column category_id
General Info
Schema Name sakila
Table Name category
Key Part Primary key
Nullable No
Default Value
Auto Increment Yes
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TINYINT
Is User Type No

Column name
General Info
Schema Name sakila
Table Name category
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(25)
Is User Type No

Column last_update
General Info
Schema Name sakila
Table Name category
Key Part
Nullable No
Default Value CURRENT_TIMESTAMP
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TIMESTAMP
Is User Type No

Column city_id
General Info
Schema Name sakila
Table Name city
Key Part Primary key
Nullable No
Default Value
Auto Increment Yes
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column city
General Info
Schema Name sakila
Table Name city
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(50)
Is User Type No

Column country_id
General Info
Schema Name sakila
Table Name city
Key Part Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column last_update
General Info
Schema Name sakila
Table Name city
Key Part
Nullable No
Default Value CURRENT_TIMESTAMP
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TIMESTAMP
Is User Type No

Column country_id
General Info
Schema Name sakila
Table Name country
Key Part Primary key
Nullable No
Default Value
Auto Increment Yes
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column country
General Info
Schema Name sakila
Table Name country
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(50)
Is User Type No

Column last_update
General Info
Schema Name sakila
Table Name country
Key Part
Nullable No
Default Value CURRENT_TIMESTAMP
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TIMESTAMP
Is User Type No

Column customer_id
General Info
Schema Name sakila
Table Name customer
Key Part Primary key
Nullable No
Default Value
Auto Increment Yes
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column store_id
General Info
Schema Name sakila
Table Name customer
Key Part Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TINYINT
Is User Type No

Column first_name
General Info
Schema Name sakila
Table Name customer
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(45)
Is User Type No

Column last_name
General Info
Schema Name sakila
Table Name customer
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(45)
Is User Type No

Column email
General Info
Schema Name sakila
Table Name customer
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(50)
Is User Type No

Column address_id
General Info
Schema Name sakila
Table Name customer
Key Part Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column active
General Info
Schema Name sakila
Table Name customer
Key Part
Nullable No
Default Value TRUE
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype BOOLEAN
Is User Type Yes

Column create_date
General Info
Schema Name sakila
Table Name customer
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype DATETIME
Is User Type No

Column last_update
General Info
Schema Name sakila
Table Name customer
Key Part
Nullable Yes
Default Value CURRENT_TIMESTAMP
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TIMESTAMP
Is User Type No

Column film_id
General Info
Schema Name sakila
Table Name film
Key Part Primary key
Nullable No
Default Value
Auto Increment Yes
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column title
General Info
Schema Name sakila
Table Name film
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(255)
Is User Type No

Column description
General Info
Schema Name sakila
Table Name film
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TEXT
Is User Type No

Column release_year
General Info
Schema Name sakila
Table Name film
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype YEAR
Is User Type No

Column language_id
General Info
Schema Name sakila
Table Name film
Key Part Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TINYINT
Is User Type No

Column original_language_id
General Info
Schema Name sakila
Table Name film
Key Part Foreign key
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TINYINT
Is User Type No

Column rental_duration
General Info
Schema Name sakila
Table Name film
Key Part
Nullable No
Default Value 3
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TINYINT
Is User Type No

Column rental_rate
General Info
Schema Name sakila
Table Name film
Key Part
Nullable No
Default Value 4.99
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype DECIMAL(4,2)
Is User Type No

Column length
General Info
Schema Name sakila
Table Name film
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column replacement_cost
General Info
Schema Name sakila
Table Name film
Key Part
Nullable No
Default Value 19.99
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype DECIMAL(5,2)
Is User Type No

Column rating
General Info
Schema Name sakila
Table Name film
Key Part
Nullable Yes
Default Value 'G'
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype ENUM('G','PG','PG-13','R','NC-17')
Is User Type No

Column special_features
General Info
Schema Name sakila
Table Name film
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SET('Trailers','Commentaries','Deleted Scenes','Behind the Scenes')
Is User Type No

Column last_update
General Info
Schema Name sakila
Table Name film
Key Part
Nullable No
Default Value CURRENT_TIMESTAMP
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TIMESTAMP
Is User Type No

Column actor_id
General Info
Schema Name sakila
Table Name film_actor
Key Part Primary key, Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column film_id
General Info
Schema Name sakila
Table Name film_actor
Key Part Primary key, Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column last_update
General Info
Schema Name sakila
Table Name film_actor
Key Part
Nullable No
Default Value CURRENT_TIMESTAMP
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TIMESTAMP
Is User Type No

Column film_id
General Info
Schema Name sakila
Table Name film_category
Key Part Primary key, Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column category_id
General Info
Schema Name sakila
Table Name film_category
Key Part Primary key, Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TINYINT
Is User Type No

Column last_update
General Info
Schema Name sakila
Table Name film_category
Key Part
Nullable No
Default Value CURRENT_TIMESTAMP
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TIMESTAMP
Is User Type No

Column film_id
General Info
Schema Name sakila
Table Name film_text
Key Part Primary key, Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column title
General Info
Schema Name sakila
Table Name film_text
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(255)
Is User Type No

Column description
General Info
Schema Name sakila
Table Name film_text
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TEXT
Is User Type No

Column inventory_id
General Info
Schema Name sakila
Table Name inventory
Key Part Primary key
Nullable No
Default Value
Auto Increment Yes
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype MEDIUMINT
Is User Type No

Column film_id
General Info
Schema Name sakila
Table Name inventory
Key Part Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column store_id
General Info
Schema Name sakila
Table Name inventory
Key Part Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TINYINT
Is User Type No

Column last_update
General Info
Schema Name sakila
Table Name inventory
Key Part
Nullable No
Default Value CURRENT_TIMESTAMP
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TIMESTAMP
Is User Type No

Column language_id
General Info
Schema Name sakila
Table Name language
Key Part Primary key
Nullable No
Default Value
Auto Increment Yes
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TINYINT
Is User Type No

Column name
General Info
Schema Name sakila
Table Name language
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(20)
Is User Type No

Column last_update
General Info
Schema Name sakila
Table Name language
Key Part
Nullable No
Default Value CURRENT_TIMESTAMP
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TIMESTAMP
Is User Type No

Column payment_id
General Info
Schema Name sakila
Table Name payment
Key Part Primary key
Nullable No
Default Value
Auto Increment Yes
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column customer_id
General Info
Schema Name sakila
Table Name payment
Key Part Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column staff_id
General Info
Schema Name sakila
Table Name payment
Key Part Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TINYINT
Is User Type No

Column rental_id
General Info
Schema Name sakila
Table Name payment
Key Part Foreign key
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype INT
Is User Type No

Column amount
General Info
Schema Name sakila
Table Name payment
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype DECIMAL(5,2)
Is User Type No

Column payment_date
General Info
Schema Name sakila
Table Name payment
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype DATETIME
Is User Type No

Column last_update
General Info
Schema Name sakila
Table Name payment
Key Part
Nullable Yes
Default Value CURRENT_TIMESTAMP
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TIMESTAMP
Is User Type No

Column rental_id
General Info
Schema Name sakila
Table Name rental
Key Part Primary key
Nullable No
Default Value
Auto Increment Yes
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype INT
Is User Type No

Column rental_date
General Info
Schema Name sakila
Table Name rental
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype DATETIME
Is User Type No

Column inventory_id
General Info
Schema Name sakila
Table Name rental
Key Part Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype MEDIUMINT
Is User Type No

Column customer_id
General Info
Schema Name sakila
Table Name rental
Key Part Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column return_date
General Info
Schema Name sakila
Table Name rental
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype DATETIME
Is User Type No

Column staff_id
General Info
Schema Name sakila
Table Name rental
Key Part Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TINYINT
Is User Type No

Column last_update
General Info
Schema Name sakila
Table Name rental
Key Part
Nullable No
Default Value CURRENT_TIMESTAMP
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TIMESTAMP
Is User Type No

Column staff_id
General Info
Schema Name sakila
Table Name staff
Key Part Primary key
Nullable No
Default Value
Auto Increment Yes
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TINYINT
Is User Type No

Column first_name
General Info
Schema Name sakila
Table Name staff
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(45)
Is User Type No

Column last_name
General Info
Schema Name sakila
Table Name staff
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(45)
Is User Type No

Column address_id
General Info
Schema Name sakila
Table Name staff
Key Part Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column picture
General Info
Schema Name sakila
Table Name staff
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype BLOB
Is User Type No

Column email
General Info
Schema Name sakila
Table Name staff
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(50)
Is User Type No

Column store_id
General Info
Schema Name sakila
Table Name staff
Key Part Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TINYINT
Is User Type No

Column active
General Info
Schema Name sakila
Table Name staff
Key Part
Nullable No
Default Value TRUE
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype BOOLEAN
Is User Type Yes

Column username
General Info
Schema Name sakila
Table Name staff
Key Part
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(16)
Is User Type No

Column password
General Info
Schema Name sakila
Table Name staff
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype VARCHAR(40)
Is User Type No

Column last_update
General Info
Schema Name sakila
Table Name staff
Key Part
Nullable No
Default Value CURRENT_TIMESTAMP
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TIMESTAMP
Is User Type No

Column store_id
General Info
Schema Name sakila
Table Name store
Key Part Primary key
Nullable No
Default Value
Auto Increment Yes
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TINYINT
Is User Type No

Column manager_staff_id
General Info
Schema Name sakila
Table Name store
Key Part Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TINYINT
Is User Type No

Column address_id
General Info
Schema Name sakila
Table Name store
Key Part Foreign key
Nullable No
Default Value
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT
Is User Type No

Column last_update
General Info
Schema Name sakila
Table Name store
Key Part
Nullable No
Default Value CURRENT_TIMESTAMP
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype TIMESTAMP
Is User Type No

Index PRIMARY
General Info
Schema Name sakila
Table Name actor
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
actor_id Ascending no comment

Index idx_actor_last_name
General Info
Schema Name sakila
Table Name actor
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
last_name Ascending no comment

Index PRIMARY
General Info
Schema Name sakila
Table Name address
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
address_id Ascending no comment

Index idx_fk_city_id
General Info
Schema Name sakila
Table Name address
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
city_id Ascending no comment

Index PRIMARY
General Info
Schema Name sakila
Table Name category
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
category_id Ascending no comment

Index PRIMARY
General Info
Schema Name sakila
Table Name city
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
city_id Ascending no comment

Index idx_fk_country_id
General Info
Schema Name sakila
Table Name city
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
country_id Ascending no comment

Index PRIMARY
General Info
Schema Name sakila
Table Name country
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
country_id Ascending no comment

Index PRIMARY
General Info
Schema Name sakila
Table Name customer
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
customer_id Ascending no comment

Index idx_fk_store_id
General Info
Schema Name sakila
Table Name customer
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
store_id Ascending no comment

Index idx_fk_address_id
General Info
Schema Name sakila
Table Name customer
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
address_id Ascending no comment

Index idx_last_name
General Info
Schema Name sakila
Table Name customer
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
last_name Ascending no comment

Index idx_title
General Info
Schema Name sakila
Table Name film
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
title Ascending no comment

Index idx_fk_language_id
General Info
Schema Name sakila
Table Name film
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
language_id Ascending no comment

Index idx_fk_original_language_id
General Info
Schema Name sakila
Table Name film
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
original_language_id Ascending no comment

Index PRIMARY
General Info
Schema Name sakila
Table Name film
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
film_id Ascending no comment

Index PRIMARY
General Info
Schema Name sakila
Table Name film_actor
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
actor_id Ascending no comment
film_id Ascending no comment

Index idx_fk_film_id
General Info
Schema Name sakila
Table Name film_actor
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
film_id Ascending no comment

Index fk_film_actor_actor_idx
General Info
Schema Name sakila
Table Name film_actor
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
actor_id Ascending no comment

Index PRIMARY
General Info
Schema Name sakila
Table Name film_category
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
film_id Ascending no comment
category_id Ascending no comment

Index fk_film_category_category_idx
General Info
Schema Name sakila
Table Name film_category
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
category_id Ascending no comment

Index fk_film_category_film_idx
General Info
Schema Name sakila
Table Name film_category
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
film_id Ascending no comment

Index PRIMARY
General Info
Schema Name sakila
Table Name film_text
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
film_id Ascending no comment

Index idx_title_description
General Info
Schema Name sakila
Table Name film_text
Is Primary Key No
Is Unique No
Type FULLTEXT
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
title Ascending no comment
description Ascending no comment

Index fk_film_text_idx
General Info
Schema Name sakila
Table Name film_text
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
film_id Ascending no comment

Index PRIMARY
General Info
Schema Name sakila
Table Name inventory
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
inventory_id Ascending no comment

Index idx_fk_film_id
General Info
Schema Name sakila
Table Name inventory
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
film_id Ascending no comment

Index idx_store_id_film_id
General Info
Schema Name sakila
Table Name inventory
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
store_id Ascending no comment
film_id Ascending no comment

Index fk_inventory_store_idx
General Info
Schema Name sakila
Table Name inventory
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
store_id Ascending no comment

Index PRIMARY
General Info
Schema Name sakila
Table Name language
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
language_id Ascending no comment

Index PRIMARY
General Info
Schema Name sakila
Table Name payment
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
payment_id Ascending no comment

Index idx_fk_staff_id
General Info
Schema Name sakila
Table Name payment
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
staff_id Ascending no comment

Index idx_fk_customer_id
General Info
Schema Name sakila
Table Name payment
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
customer_id Ascending no comment

Index fk_payment_rental_idx
General Info
Schema Name sakila
Table Name payment
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
rental_id Ascending no comment

Index PRIMARY
General Info
Schema Name sakila
Table Name rental
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
rental_id Ascending no comment

Index
General Info
Schema Name sakila
Table Name rental
Is Primary Key No
Is Unique Yes
Type UNIQUE
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
rental_date Ascending no comment
inventory_id Ascending no comment
customer_id Ascending no comment

Index idx_fk_inventory_id
General Info
Schema Name sakila
Table Name rental
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
inventory_id Ascending no comment

Index idx_fk_customer_id
General Info
Schema Name sakila
Table Name rental
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
customer_id Ascending no comment

Index idx_fk_staff_id
General Info
Schema Name sakila
Table Name rental
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
staff_id Ascending no comment

Index PRIMARY
General Info
Schema Name sakila
Table Name staff
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
staff_id Ascending no comment

Index idx_fk_store_id
General Info
Schema Name sakila
Table Name staff
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
store_id Ascending no comment

Index idx_fk_address_id
General Info
Schema Name sakila
Table Name staff
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
address_id Ascending no comment

Index PRIMARY
General Info
Schema Name sakila
Table Name store
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
store_id Ascending no comment

Index idx_unique_manager
General Info
Schema Name sakila
Table Name store
Is Primary Key No
Is Unique Yes
Type UNIQUE
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
manager_staff_id Ascending no comment

Index idx_fk_address_id
General Info
Schema Name sakila
Table Name store
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
address_id Ascending no comment

Foreign Key fk_address_city
General Info
Parent Table city
Child Table address
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_city_country
General Info
Parent Table country
Child Table city
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_customer_address
General Info
Parent Table address
Child Table customer
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_customer_store
General Info
Parent Table store
Child Table customer
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_film_language
General Info
Parent Table language
Child Table film
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_film_language_original
General Info
Parent Table language
Child Table film
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_film_actor_actor
General Info
Parent Table actor
Child Table film_actor
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_film_actor_film
General Info
Parent Table film
Child Table film_actor
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_film_category_film
General Info
Parent Table film
Child Table film_category
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_film_category_category
General Info
Parent Table category
Child Table film_category
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_film_text
General Info
Parent Table inventory
Child Table film_text
Cardinality 1:n
Delete Rule NO ACTION
Update Rule NO ACTION
Is Mandatory Yes

Foreign Key fk_inventory_store
General Info
Parent Table store
Child Table inventory
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_inventory_film
General Info
Parent Table film
Child Table inventory
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_payment_rental
General Info
Parent Table rental
Child Table payment
Cardinality 1:n
Delete Rule SET NULL
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_payment_customer
General Info
Parent Table customer
Child Table payment
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_payment_staff
General Info
Parent Table staff
Child Table payment
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_rental_staff
General Info
Parent Table staff
Child Table rental
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_rental_inventory
General Info
Parent Table inventory
Child Table rental
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_rental_customer
General Info
Parent Table customer
Child Table rental
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_staff_store
General Info
Parent Table store
Child Table staff
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_staff_address
General Info
Parent Table address
Child Table staff
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_store_staff
General Info
Parent Table staff
Child Table store
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Foreign Key fk_store_address
General Info
Parent Table address
Child Table store
Cardinality 1:n
Delete Rule RESTRICT
Update Rule CASCADE
Is Mandatory Yes

Trigger ins_film
General Info
Enabled yes
Definer
Condition 0
Event INSERT
Order 0
Orientation ROW
Timing AFTER
Reference new .
Reference old .
DDL script
USE `sakila`$$


CREATE TRIGGER `ins_film` AFTER INSERT ON `film` FOR EACH ROW BEGIN
INSERT INTO film_text (film_id, title, description)
VALUES (new.film_id, new.title, new.description);
END

Trigger upd_film
General Info
Enabled yes
Definer
Condition 0
Event UPDATE
Order 0
Orientation ROW
Timing AFTER
Reference new .
Reference old .
DDL script
USE `sakila`$$


CREATE TRIGGER `upd_film` AFTER UPDATE ON `film` FOR EACH ROW BEGIN
IF (old.title != new.title) or (old.description != new.description)
THEN
UPDATE film_text
SET title=new.title,
description=new.description,
film_id=new.film_id
WHERE film_id=old.film_id;
END IF;
END

Trigger del_film
General Info
Enabled yes
Definer
Condition 0
Event DELETE
Order 0
Orientation ROW
Timing AFTER
Reference new .
Reference old .
DDL script
USE `sakila`$$


CREATE TRIGGER `del_film` AFTER DELETE ON `film` FOR EACH ROW BEGIN
DELETE FROM film_text WHERE film_id = old.film_id;
END

Column id
General Info
Schema Name test
Table Name t
Key Part Primary key
Nullable No
Default Value
Auto Increment Yes
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype INT(11)
Is User Type No

Column col1
General Info
Schema Name test
Table Name t
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(20)
Is User Type No

Index PRIMARY
General Info
Schema Name test
Table Name t
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
id Ascending no comment

Column ID
General Info
Schema Name world
Table Name city
Key Part Primary key
Nullable No
Default Value
Auto Increment Yes
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype INT(11)
Is User Type No

Column Name
General Info
Schema Name world
Table Name city
Key Part
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(35)
Is User Type No

Column CountryCode
General Info
Schema Name world
Table Name city
Key Part Foreign key
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(3)
Is User Type No

Column District
General Info
Schema Name world
Table Name city
Key Part
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(20)
Is User Type No

Column Population
General Info
Schema Name world
Table Name city
Key Part
Nullable No
Default Value '0'
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype INT(11)
Is User Type No

Column Code
General Info
Schema Name world
Table Name country
Key Part Primary key
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(3)
Is User Type No

Column Name
General Info
Schema Name world
Table Name country
Key Part
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(52)
Is User Type No

Column Continent
General Info
Schema Name world
Table Name country
Key Part
Nullable No
Default Value 'Asia'
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype ENUM('Asia','Europe','North America','Africa','Oceania','Antarctica','South America')
Is User Type No

Column Region
General Info
Schema Name world
Table Name country
Key Part
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(26)
Is User Type No

Column SurfaceArea
General Info
Schema Name world
Table Name country
Key Part
Nullable No
Default Value '0.00'
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype FLOAT(10,2)
Is User Type No

Column IndepYear
General Info
Schema Name world
Table Name country
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT(6)
Is User Type No

Column Population
General Info
Schema Name world
Table Name country
Key Part
Nullable No
Default Value '0'
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype INT(11)
Is User Type No

Column LifeExpectancy
General Info
Schema Name world
Table Name country
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype FLOAT(3,1)
Is User Type No

Column GNP
General Info
Schema Name world
Table Name country
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype FLOAT(10,2)
Is User Type No

Column GNPOld
General Info
Schema Name world
Table Name country
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype FLOAT(10,2)
Is User Type No

Column LocalName
General Info
Schema Name world
Table Name country
Key Part
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(45)
Is User Type No

Column GovernmentForm
General Info
Schema Name world
Table Name country
Key Part
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(45)
Is User Type No

Column HeadOfState
General Info
Schema Name world
Table Name country
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(60)
Is User Type No

Column Capital
General Info
Schema Name world
Table Name country
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype INT(11)
Is User Type No

Column Code2
General Info
Schema Name world
Table Name country
Key Part
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(2)
Is User Type No

Column CountryCode
General Info
Schema Name world
Table Name countrylanguage
Key Part Primary key, Foreign key
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(3)
Is User Type No

Column Language
General Info
Schema Name world
Table Name countrylanguage
Key Part Primary key
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(30)
Is User Type No

Column IsOfficial
General Info
Schema Name world
Table Name countrylanguage
Key Part
Nullable No
Default Value 'F'
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype ENUM('T','F')
Is User Type No

Column Percentage
General Info
Schema Name world
Table Name countrylanguage
Key Part
Nullable No
Default Value '0.0'
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype FLOAT(4,1)
Is User Type No

Index PRIMARY
General Info
Schema Name world
Table Name city
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
ID Ascending no comment

Index CountryCode
General Info
Schema Name world
Table Name city
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
CountryCode Ascending no comment

Index PRIMARY
General Info
Schema Name world
Table Name country
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
Code Ascending no comment

Index PRIMARY
General Info
Schema Name world
Table Name countrylanguage
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
CountryCode Ascending no comment
Language Ascending no comment

Index CountryCode
General Info
Schema Name world
Table Name countrylanguage
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
CountryCode Ascending no comment

Foreign Key city_ibfk_1
General Info
Parent Table country
Child Table city
Cardinality 1:n
Delete Rule
Update Rule
Is Mandatory Yes

Foreign Key countryLanguage_ibfk_1
General Info
Parent Table country
Child Table countrylanguage
Cardinality 1:n
Delete Rule
Update Rule
Is Mandatory Yes

Column ID
General Info
Schema Name world2
Table Name city
Key Part Primary key
Nullable No
Default Value
Auto Increment Yes
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype INT(11)
Is User Type No

Column Name
General Info
Schema Name world2
Table Name city
Key Part
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(35)
Is User Type No

Column CountryCode
General Info
Schema Name world2
Table Name city
Key Part Foreign key
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(3)
Is User Type No

Column District
General Info
Schema Name world2
Table Name city
Key Part
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(20)
Is User Type No

Column Population
General Info
Schema Name world2
Table Name city
Key Part
Nullable No
Default Value '0'
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype INT(11)
Is User Type No

Column Code
General Info
Schema Name world2
Table Name country
Key Part Primary key
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(3)
Is User Type No

Column Name
General Info
Schema Name world2
Table Name country
Key Part
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(52)
Is User Type No

Column Continent
General Info
Schema Name world2
Table Name country
Key Part
Nullable No
Default Value 'Asia'
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype ENUM('Asia','Europe','North America','Africa','Oceania','Antarctica','South America')
Is User Type No

Column Region
General Info
Schema Name world2
Table Name country
Key Part
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(26)
Is User Type No

Column SurfaceArea
General Info
Schema Name world2
Table Name country
Key Part
Nullable No
Default Value '0.00'
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype FLOAT(10,2)
Is User Type No

Column IndepYear
General Info
Schema Name world2
Table Name country
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype SMALLINT(6)
Is User Type No

Column Population
General Info
Schema Name world2
Table Name country
Key Part
Nullable No
Default Value '0'
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype INT(11)
Is User Type No

Column LifeExpectancy
General Info
Schema Name world2
Table Name country
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype FLOAT(3,1)
Is User Type No

Column GNP
General Info
Schema Name world2
Table Name country
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype FLOAT(10,2)
Is User Type No

Column GNPOld
General Info
Schema Name world2
Table Name country
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype FLOAT(10,2)
Is User Type No

Column LocalName
General Info
Schema Name world2
Table Name country
Key Part
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(45)
Is User Type No

Column GovernmentForm
General Info
Schema Name world2
Table Name country
Key Part
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(45)
Is User Type No

Column HeadOfState
General Info
Schema Name world2
Table Name country
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(60)
Is User Type No

Column Capital
General Info
Schema Name world2
Table Name country
Key Part
Nullable Yes
Default Value NULL
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype INT(11)
Is User Type No

Column Code2
General Info
Schema Name world2
Table Name country
Key Part
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(2)
Is User Type No

Column CountryCode
General Info
Schema Name world2
Table Name countrylanguage
Key Part Primary key, Foreign key
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(3)
Is User Type No

Column Language
General Info
Schema Name world2
Table Name countrylanguage
Key Part Primary key
Nullable No
Default Value ''
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype CHAR(30)
Is User Type No

Column IsOfficial
General Info
Schema Name world2
Table Name countrylanguage
Key Part
Nullable No
Default Value 'F'
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype ENUM('T','F')
Is User Type No

Column Percentage
General Info
Schema Name world2
Table Name countrylanguage
Key Part
Nullable No
Default Value '0.0'
Auto Increment No
Character Set Schema Default
Collation Name Schema Default
Comment
Data Type Details
Datatype FLOAT(4,1)
Is User Type No

Index PRIMARY
General Info
Schema Name world2
Table Name city
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
ID Ascending no comment

Index CountryCode
General Info
Schema Name world2
Table Name city
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
CountryCode Ascending no comment

Index PRIMARY
General Info
Schema Name world2
Table Name country
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
Code Ascending no comment

Index PRIMARY
General Info
Schema Name world2
Table Name countrylanguage
Is Primary Key Yes
Is Unique No
Type PRIMARY
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
CountryCode Ascending no comment
Language Ascending no comment

Index CountryCode
General Info
Schema Name world2
Table Name countrylanguage
Is Primary Key No
Is Unique No
Type INDEX
Kind
Key Block Size 0
Comment
Columns
Column Name Column Order Comment
CountryCode Ascending no comment

Foreign Key city_ibfk_1
General Info
Parent Table country
Child Table city
Cardinality 1:n
Delete Rule
Update Rule
Is Mandatory Yes

Foreign Key countryLanguage_ibfk_1
General Info
Parent Table country
Child Table countrylanguage
Cardinality 1:n
Delete Rule
Update Rule
Is Mandatory Yes