MIXERP-Table core.counties

#	Column Name	Nullable	Data Type	Max Length	Description
1	county_id		integer	0	The primary key of this table, which is also a serial field.
2	county_code		character varying	12	The code given to the county,which is a unique field.
3	county_name		character varying	100	The name of the county, which is a unique field.
4	state_id		integer	0	State code of the county.
5	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
6	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
4	state_id	counties_state_id_fkey	core.states.state_id
5	audit_user_id	counties_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
counties_pkey	postgres	btree	county_id

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	county_id	nextval('core.counties_county_id_seq'::regclass)
6	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description