MIXERP-Table core.county_sales_taxes

#	Column Name	Nullable	Data Type	Max Length	Description
1	county_sales_tax_id		integer	0	The primary key of this table, which is also a serial field.
2	county_sales_tax_code		character varying	12	The code given to county sale tax.
3	county_sales_tax_name		character varying	100	The name given to county sales tax, which is a unique field
4	county_id		integer	0	Foreign key to the table core.counties.
5	entity_id		integer	0	Foreign key to the table core.entities.
6	industry_id		integer	0	Foreign key to the table core.industries.
7	item_group_id		integer	0	Foreign key to the table core.item_groups.
8	rate		decimal_strict2	0	Rate of sales tax of the county.
9	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
10	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	county_id	county_sales_taxes_county_id_fkey	core.counties.county_id
5	entity_id	county_sales_taxes_entity_id_fkey	core.entities.entity_id
6	industry_id	county_sales_taxes_industry_id_fkey	core.industries.industry_id
7	item_group_id	county_sales_taxes_item_group_id_fkey	core.item_groups.item_group_id
9	audit_user_id	county_sales_taxes_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
county_sales_taxes_pkey	postgres	btree	county_sales_tax_id
county_sales_taxes_county_id_item_group_id_uix	postgres	btree	county_id item_group_id
county_sales_taxes_county_id_industry_id_uix	postgres	btree	county_id industry_id
county_sales_taxes_county_id_entity_id_uix	postgres	btree	county_id entity_id
county_sales_taxes_county_sales_tax_name_uix	postgres	btree	upper(county_sales_tax_name::text)
county_sales_taxes_county_sales_tax_code_uix	postgres	btree	upper(county_sales_tax_code::text)

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	county_sales_tax_id	nextval('core.county_sales_taxes_county_sales_tax_id_seq'::regclass)
8	rate	0
10	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description