MIXERP-Table core.zip_codes

#	Column Name	Nullable	Data Type	Max Length	Description
1	zip_code_id		bigint	0	The primary key of this table, which is also a bigserial field.
2	state_id		integer	0	Foreign key to the table core.states
3	code		character varying	12	ZIP code of the area.
4	zip_code_type_id		integer	0	Foreign key to the table core.zip_code_types.
5	city		character varying	100	Name of the city,
6	lat		numeric	0	Latitude of the area.
7	lon		numeric	0	Longitude of the area.
8	x_axis		numeric	0	X-axis of the ZIP code.
9	y_axis		numeric	0	Y-axis of the ZIP code.
10	z_axis		numeric	0	Z-axis of the ZIP code.
11	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
12	audit_ts		timestamp with time zone	0	Contains the date and timestamp of the last insert or update action.

Foreign Keys

#	Column Name	Key Name	References
2	state_id	zip_codes_state_id_fkey	core.states.state_id
4	zip_code_type_id	zip_codes_zip_code_type_id_fkey	core.zip_code_types.zip_code_type_id
11	audit_user_id	zip_codes_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
zip_codes_pkey	postgres	btree	zip_code_id

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	zip_code_id	nextval('core.zip_codes_zip_code_id_seq'::regclass)
12	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description