Table testsql_comments.cities
authorized values for cities/states/countries to choose when adding/editing a patron/borrower

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
cityid int 10  √  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 at Mon Jul 16 09:22 NZST 2018

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