cities


Columns

Column Type Size Nulls Auto Default Children Parents Comments
cityid INT 10 null

unique identifier added by Koha

city_name VARCHAR 100

name of the city

city_state VARCHAR 100 null

name of the state/province

city_country VARCHAR 100 null

name of the country

city_zipcode VARCHAR 20 null

zip or postal code

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc cityid