meta_postalcodes

Module: meta

Postal code lookup data by country.

Name	Type	Nullable	Default Value	Notes
ID	integer
country meta_countries.ID	smallint
state meta_states.ID	smallint
code	character varying(20)
place	text
latitude	double precision
longitude	double precision

Name	Unique	Nulls Distinct	Primary	Partial	Method	Keys
fk_meta_postalcodes_country					gin	country
fk_meta_postalcodes_state					gin	state
i_meta_postalcodes_code					btree	code
pk_meta_postalcodes					btree	ID
s_meta_postalcodes_place					gin	place

Name	Type
fk_meta_postalcodes_country	foreign_key
fk_meta_postalcodes_state	foreign_key
pk_meta_postalcodes	primary_key

Loading...