country
| Documentation | Sakila |
| Name | country |
| Module | Customer Data |
The country table contains a list of countries.
The country table is referred to by a foreign key in the city table.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | country_id | unsigned smallint(5, 0) | Identity / Auto increment column | A surrogate primary key used to uniquely identify each country in the table. | ||||
| A surrogate primary key used to uniquely identify each country in the table. Identity / Auto increment column |
||||||||
| 2 | country | varchar(50) | The name of the country. | |||||
| The name of the country. |
||||||||
| 3 | last_update | timestamp | Default: CURRENT_TIMESTAMP | The time that the row was created or most recently updated. | ||||
| The time that the row was created or most recently updated. Default: CURRENT_TIMESTAMP |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| city | country | city.country_id = country.country_id | fk_city_country Foreign key constraint referencing country.country_id |
|
|
city.country_id = country.country_id Name: fk_city_countryForeign key constraint referencing country.country_id |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PRIMARY | country_id | Primary key. | |
| Primary key. | |||
Used by
| Name |
|---|
|
country
|
Exported: 2018-10-12 17:43, Last imported: 2018-08-06 10:44