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 |
Datatype | SMALLINT |
Is User Type | No |
Schema Name | sakila |
Table Name | actor |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | VARCHAR(45) |
Is User Type | No |
Schema Name | sakila |
Table Name | actor |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | VARCHAR(45) |
Is User Type | No |
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 |
Datatype | TIMESTAMP |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
Schema Name | sakila |
Table Name | address |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | VARCHAR(50) |
Is User Type | No |
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 |
Datatype | VARCHAR(50) |
Is User Type | No |
Schema Name | sakila |
Table Name | address |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | VARCHAR(20) |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
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 |
Datatype | VARCHAR(10) |
Is User Type | No |
Schema Name | sakila |
Table Name | address |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | VARCHAR(20) |
Is User Type | No |
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 |
Datatype | TIMESTAMP |
Is User Type | No |
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 |
Datatype | TINYINT |
Is User Type | No |
Schema Name | sakila |
Table Name | category |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | VARCHAR(25) |
Is User Type | No |
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 |
Datatype | TIMESTAMP |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
Schema Name | sakila |
Table Name | city |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | VARCHAR(50) |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
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 |
Datatype | TIMESTAMP |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
Schema Name | sakila |
Table Name | country |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | VARCHAR(50) |
Is User Type | No |
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 |
Datatype | TIMESTAMP |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
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 |
Datatype | TINYINT |
Is User Type | No |
Schema Name | sakila |
Table Name | customer |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | VARCHAR(45) |
Is User Type | No |
Schema Name | sakila |
Table Name | customer |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | VARCHAR(45) |
Is User Type | No |
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 |
Datatype | VARCHAR(50) |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
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 |
Datatype | BOOLEAN |
Is User Type | Yes |
Schema Name | sakila |
Table Name | customer |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | DATETIME |
Is User Type | No |
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 |
Datatype | TIMESTAMP |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
Schema Name | sakila |
Table Name | film |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | VARCHAR(255) |
Is User Type | No |
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 |
Datatype | TEXT |
Is User Type | No |
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 |
Datatype | YEAR |
Is User Type | No |
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 |
Datatype | TINYINT |
Is User Type | No |
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 |
Datatype | TINYINT |
Is User Type | No |
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 |
Datatype | TINYINT |
Is User Type | No |
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 |
Datatype | DECIMAL(4,2) |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
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 |
Datatype | DECIMAL(5,2) |
Is User Type | No |
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 |
Datatype | ENUM('G','PG','PG-13','R','NC-17') |
Is User Type | No |
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 |
Datatype | SET('Trailers','Commentaries','Deleted Scenes','Behind the Scenes') |
Is User Type | No |
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 |
Datatype | TIMESTAMP |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
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 |
Datatype | TIMESTAMP |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
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 |
Datatype | TINYINT |
Is User Type | No |
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 |
Datatype | TIMESTAMP |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
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 |
Datatype | VARCHAR(255) |
Is User Type | No |
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 |
Datatype | TEXT |
Is User Type | No |
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 |
Datatype | MEDIUMINT |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
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 |
Datatype | TINYINT |
Is User Type | No |
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 |
Datatype | TIMESTAMP |
Is User Type | No |
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 |
Datatype | TINYINT |
Is User Type | No |
Schema Name | sakila |
Table Name | language |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | CHAR(20) |
Is User Type | No |
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 |
Datatype | TIMESTAMP |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
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 |
Datatype | TINYINT |
Is User Type | No |
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 |
Datatype | INT |
Is User Type | No |
Schema Name | sakila |
Table Name | payment |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | DECIMAL(5,2) |
Is User Type | No |
Schema Name | sakila |
Table Name | payment |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | DATETIME |
Is User Type | No |
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 |
Datatype | TIMESTAMP |
Is User Type | No |
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 |
Datatype | INT |
Is User Type | No |
Schema Name | sakila |
Table Name | rental |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | DATETIME |
Is User Type | No |
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 |
Datatype | MEDIUMINT |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
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 |
Datatype | DATETIME |
Is User Type | No |
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 |
Datatype | TINYINT |
Is User Type | No |
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 |
Datatype | TIMESTAMP |
Is User Type | No |
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 |
Datatype | TINYINT |
Is User Type | No |
Schema Name | sakila |
Table Name | staff |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | VARCHAR(45) |
Is User Type | No |
Schema Name | sakila |
Table Name | staff |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | VARCHAR(45) |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
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 |
Datatype | BLOB |
Is User Type | No |
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 |
Datatype | VARCHAR(50) |
Is User Type | No |
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 |
Datatype | TINYINT |
Is User Type | No |
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 |
Datatype | BOOLEAN |
Is User Type | Yes |
Schema Name | sakila |
Table Name | staff |
Key Part | |
Nullable | No |
Default Value | |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | VARCHAR(16) |
Is User Type | No |
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 |
Datatype | VARCHAR(40) |
Is User Type | No |
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 |
Datatype | TIMESTAMP |
Is User Type | No |
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 |
Datatype | TINYINT |
Is User Type | No |
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 |
Datatype | TINYINT |
Is User Type | No |
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 |
Datatype | SMALLINT |
Is User Type | No |
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 |
Datatype | TIMESTAMP |
Is User Type | No |
Schema Name | sakila |
Table Name | actor |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
actor_id | Ascending | no comment |
Schema Name | sakila |
Table Name | actor |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
last_name | Ascending | no comment |
Schema Name | sakila |
Table Name | address |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
address_id | Ascending | no comment |
Schema Name | sakila |
Table Name | address |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
city_id | Ascending | no comment |
Schema Name | sakila |
Table Name | category |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
category_id | Ascending | no comment |
Schema Name | sakila |
Table Name | city |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
city_id | Ascending | no comment |
Schema Name | sakila |
Table Name | city |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
country_id | Ascending | no comment |
Schema Name | sakila |
Table Name | country |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
country_id | Ascending | no comment |
Schema Name | sakila |
Table Name | customer |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
customer_id | Ascending | no comment |
Schema Name | sakila |
Table Name | customer |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
store_id | Ascending | no comment |
Schema Name | sakila |
Table Name | customer |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
address_id | Ascending | no comment |
Schema Name | sakila |
Table Name | customer |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
last_name | Ascending | no comment |
Schema Name | sakila |
Table Name | film |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
title | Ascending | no comment |
Schema Name | sakila |
Table Name | film |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
language_id | Ascending | no comment |
Schema Name | sakila |
Table Name | film |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
original_language_id | Ascending | no comment |
Schema Name | sakila |
Table Name | film |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
film_id | Ascending | no comment |
Schema Name | sakila |
Table Name | film_actor |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
actor_id | Ascending | no comment |
film_id | Ascending | no comment |
Schema Name | sakila |
Table Name | film_actor |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
film_id | Ascending | no comment |
Schema Name | sakila |
Table Name | film_actor |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
actor_id | Ascending | no comment |
Schema Name | sakila |
Table Name | film_category |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
film_id | Ascending | no comment |
category_id | Ascending | no comment |
Schema Name | sakila |
Table Name | film_category |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
category_id | Ascending | no comment |
Schema Name | sakila |
Table Name | film_category |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
film_id | Ascending | no comment |
Schema Name | sakila |
Table Name | film_text |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
film_id | Ascending | no comment |
Schema Name | sakila |
Table Name | film_text |
Is Primary Key | No |
Is Unique | No |
Type | FULLTEXT |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
title | Ascending | no comment |
description | Ascending | no comment |
Schema Name | sakila |
Table Name | film_text |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
film_id | Ascending | no comment |
Schema Name | sakila |
Table Name | inventory |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
inventory_id | Ascending | no comment |
Schema Name | sakila |
Table Name | inventory |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
film_id | Ascending | no comment |
Schema Name | sakila |
Table Name | inventory |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
store_id | Ascending | no comment |
film_id | Ascending | no comment |
Schema Name | sakila |
Table Name | inventory |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
store_id | Ascending | no comment |
Schema Name | sakila |
Table Name | language |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
language_id | Ascending | no comment |
Schema Name | sakila |
Table Name | payment |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
payment_id | Ascending | no comment |
Schema Name | sakila |
Table Name | payment |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
staff_id | Ascending | no comment |
Schema Name | sakila |
Table Name | payment |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
customer_id | Ascending | no comment |
Schema Name | sakila |
Table Name | payment |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
rental_id | Ascending | no comment |
Schema Name | sakila |
Table Name | rental |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
rental_id | Ascending | no comment |
Schema Name | sakila |
Table Name | rental |
Is Primary Key | No |
Is Unique | Yes |
Type | UNIQUE |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
rental_date | Ascending | no comment |
inventory_id | Ascending | no comment |
customer_id | Ascending | no comment |
Schema Name | sakila |
Table Name | rental |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
inventory_id | Ascending | no comment |
Schema Name | sakila |
Table Name | rental |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
customer_id | Ascending | no comment |
Schema Name | sakila |
Table Name | rental |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
staff_id | Ascending | no comment |
Schema Name | sakila |
Table Name | staff |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
staff_id | Ascending | no comment |
Schema Name | sakila |
Table Name | staff |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
store_id | Ascending | no comment |
Schema Name | sakila |
Table Name | staff |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
address_id | Ascending | no comment |
Schema Name | sakila |
Table Name | store |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
store_id | Ascending | no comment |
Schema Name | sakila |
Table Name | store |
Is Primary Key | No |
Is Unique | Yes |
Type | UNIQUE |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
manager_staff_id | Ascending | no comment |
Schema Name | sakila |
Table Name | store |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
address_id | Ascending | no comment |
Parent Table | city |
Child Table | address |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | country |
Child Table | city |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | address |
Child Table | customer |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | store |
Child Table | customer |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | language |
Child Table | film |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | language |
Child Table | film |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | actor |
Child Table | film_actor |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | film |
Child Table | film_actor |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | film |
Child Table | film_category |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | category |
Child Table | film_category |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | inventory |
Child Table | film_text |
Cardinality | 1:n |
Delete Rule | NO ACTION |
Update Rule | NO ACTION |
Is Mandatory | Yes |
Parent Table | store |
Child Table | inventory |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | film |
Child Table | inventory |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | rental |
Child Table | payment |
Cardinality | 1:n |
Delete Rule | SET NULL |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | customer |
Child Table | payment |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | staff |
Child Table | payment |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | staff |
Child Table | rental |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | inventory |
Child Table | rental |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | customer |
Child Table | rental |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | store |
Child Table | staff |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | address |
Child Table | staff |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | staff |
Child Table | store |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Parent Table | address |
Child Table | store |
Cardinality | 1:n |
Delete Rule | RESTRICT |
Update Rule | CASCADE |
Is Mandatory | Yes |
Enabled | yes |
Definer | |
Condition | 0 |
Event | INSERT |
Order | 0 |
Orientation | ROW |
Timing | AFTER |
Reference new | . |
Reference old | . |
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
Enabled | yes |
Definer | |
Condition | 0 |
Event | UPDATE |
Order | 0 |
Orientation | ROW |
Timing | AFTER |
Reference new | . |
Reference old | . |
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
Enabled | yes |
Definer | |
Condition | 0 |
Event | DELETE |
Order | 0 |
Orientation | ROW |
Timing | AFTER |
Reference new | . |
Reference old | . |
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
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 |
Datatype | INT(11) |
Is User Type | No |
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 |
Datatype | CHAR(20) |
Is User Type | No |
Schema Name | test |
Table Name | t |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
id | Ascending | no comment |
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 |
Datatype | INT(11) |
Is User Type | No |
Schema Name | world |
Table Name | city |
Key Part | |
Nullable | No |
Default Value | '' |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | CHAR(35) |
Is User Type | No |
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 |
Datatype | CHAR(3) |
Is User Type | No |
Schema Name | world |
Table Name | city |
Key Part | |
Nullable | No |
Default Value | '' |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | CHAR(20) |
Is User Type | No |
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 |
Datatype | INT(11) |
Is User Type | No |
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 |
Datatype | CHAR(3) |
Is User Type | No |
Schema Name | world |
Table Name | country |
Key Part | |
Nullable | No |
Default Value | '' |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | CHAR(52) |
Is User Type | No |
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 |
Datatype | ENUM('Asia','Europe','North America','Africa','Oceania','Antarctica','South America') |
Is User Type | No |
Schema Name | world |
Table Name | country |
Key Part | |
Nullable | No |
Default Value | '' |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | CHAR(26) |
Is User Type | No |
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 |
Datatype | FLOAT(10,2) |
Is User Type | No |
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 |
Datatype | SMALLINT(6) |
Is User Type | No |
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 |
Datatype | INT(11) |
Is User Type | No |
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 |
Datatype | FLOAT(3,1) |
Is User Type | No |
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 |
Datatype | FLOAT(10,2) |
Is User Type | No |
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 |
Datatype | FLOAT(10,2) |
Is User Type | No |
Schema Name | world |
Table Name | country |
Key Part | |
Nullable | No |
Default Value | '' |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | CHAR(45) |
Is User Type | No |
Schema Name | world |
Table Name | country |
Key Part | |
Nullable | No |
Default Value | '' |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | CHAR(45) |
Is User Type | No |
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 |
Datatype | CHAR(60) |
Is User Type | No |
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 |
Datatype | INT(11) |
Is User Type | No |
Schema Name | world |
Table Name | country |
Key Part | |
Nullable | No |
Default Value | '' |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | CHAR(2) |
Is User Type | No |
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 |
Datatype | CHAR(3) |
Is User Type | No |
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 |
Datatype | CHAR(30) |
Is User Type | No |
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 |
Datatype | ENUM('T','F') |
Is User Type | No |
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 |
Datatype | FLOAT(4,1) |
Is User Type | No |
Schema Name | world |
Table Name | city |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
ID | Ascending | no comment |
Schema Name | world |
Table Name | city |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
CountryCode | Ascending | no comment |
Schema Name | world |
Table Name | country |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
Code | Ascending | no comment |
Schema Name | world |
Table Name | countrylanguage |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
CountryCode | Ascending | no comment |
Language | Ascending | no comment |
Schema Name | world |
Table Name | countrylanguage |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
CountryCode | Ascending | no comment |
Parent Table | country |
Child Table | city |
Cardinality | 1:n |
Delete Rule | |
Update Rule | |
Is Mandatory | Yes |
Parent Table | country |
Child Table | countrylanguage |
Cardinality | 1:n |
Delete Rule | |
Update Rule | |
Is Mandatory | Yes |
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 |
Datatype | INT(11) |
Is User Type | No |
Schema Name | world2 |
Table Name | city |
Key Part | |
Nullable | No |
Default Value | '' |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | CHAR(35) |
Is User Type | No |
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 |
Datatype | CHAR(3) |
Is User Type | No |
Schema Name | world2 |
Table Name | city |
Key Part | |
Nullable | No |
Default Value | '' |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | CHAR(20) |
Is User Type | No |
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 |
Datatype | INT(11) |
Is User Type | No |
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 |
Datatype | CHAR(3) |
Is User Type | No |
Schema Name | world2 |
Table Name | country |
Key Part | |
Nullable | No |
Default Value | '' |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | CHAR(52) |
Is User Type | No |
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 |
Datatype | ENUM('Asia','Europe','North America','Africa','Oceania','Antarctica','South America') |
Is User Type | No |
Schema Name | world2 |
Table Name | country |
Key Part | |
Nullable | No |
Default Value | '' |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | CHAR(26) |
Is User Type | No |
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 |
Datatype | FLOAT(10,2) |
Is User Type | No |
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 |
Datatype | SMALLINT(6) |
Is User Type | No |
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 |
Datatype | INT(11) |
Is User Type | No |
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 |
Datatype | FLOAT(3,1) |
Is User Type | No |
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 |
Datatype | FLOAT(10,2) |
Is User Type | No |
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 |
Datatype | FLOAT(10,2) |
Is User Type | No |
Schema Name | world2 |
Table Name | country |
Key Part | |
Nullable | No |
Default Value | '' |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | CHAR(45) |
Is User Type | No |
Schema Name | world2 |
Table Name | country |
Key Part | |
Nullable | No |
Default Value | '' |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | CHAR(45) |
Is User Type | No |
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 |
Datatype | CHAR(60) |
Is User Type | No |
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 |
Datatype | INT(11) |
Is User Type | No |
Schema Name | world2 |
Table Name | country |
Key Part | |
Nullable | No |
Default Value | '' |
Auto Increment | No |
Character Set | Schema Default |
Collation Name | Schema Default |
Comment |
Datatype | CHAR(2) |
Is User Type | No |
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 |
Datatype | CHAR(3) |
Is User Type | No |
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 |
Datatype | CHAR(30) |
Is User Type | No |
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 |
Datatype | ENUM('T','F') |
Is User Type | No |
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 |
Datatype | FLOAT(4,1) |
Is User Type | No |
Schema Name | world2 |
Table Name | city |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
ID | Ascending | no comment |
Schema Name | world2 |
Table Name | city |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
CountryCode | Ascending | no comment |
Schema Name | world2 |
Table Name | country |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
Code | Ascending | no comment |
Schema Name | world2 |
Table Name | countrylanguage |
Is Primary Key | Yes |
Is Unique | No |
Type | PRIMARY |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
CountryCode | Ascending | no comment |
Language | Ascending | no comment |
Schema Name | world2 |
Table Name | countrylanguage |
Is Primary Key | No |
Is Unique | No |
Type | INDEX |
Kind | |
Key Block Size | 0 |
Comment |
Column Name | Column Order | Comment |
CountryCode | Ascending | no comment |
Parent Table | country |
Child Table | city |
Cardinality | 1:n |
Delete Rule | |
Update Rule | |
Is Mandatory | Yes |
Parent Table | country |
Child Table | countrylanguage |
Cardinality | 1:n |
Delete Rule | |
Update Rule | |
Is Mandatory | Yes |