Table pvsadmin.public.ctystate 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
ctystate_id serial 10  √  nextval('ctystate_ctystate_id_seq'::regclass)
zip5 int4 10
city_state_key varchar 2147483647
city_name varchar 2147483647
city_abbr varchar 2147483647  √  null
preferred_key varchar 2147483647  √  null
preferred_name varchar 2147483647  √  null
state_id varchar 2147483647
county_no int4 10  √  null
county_name varchar 2147483647  √  null

Table contained 80,156 rows at Tue Jan 03 04:46 MST 2017

Indexes:
Column(s) Type Sort Constraint Name
ctystate_id Primary key Asc ctystate_pkey
city_name Performance Asc ctystate__city_name
county_name Performance Asc ctystate__county_name
state_id Performance Asc ctystate__state_id
zip5 Performance Asc ctystate__zip5