city

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
city_id SMALLINT UNSIGNED 5 √ null
address.city_id fk_address_cityR
city VARCHAR 50 null
country_id SMALLINT UNSIGNED 5 null
country.country_id fk_city_countryR
last_update TIMESTAMP 26 CURRENT_TIMESTAMP

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc city_id
idx_fk_country_id Performance Asc country_id

Relationships

Close relationships within degrees of separation