# | Column Name | Nullable | Data Type | Max Length | Description |
---|---|---|---|---|---|
1 | state_sales_tax_id | integer | 0 | The primary key of the table. | |
2 | state_sales_tax_code | character varying | 12 | The code given to the state sales tax. | |
3 | state_sales_tax_name | character varying | 100 | The name of the sales tax, which is also a unique field. | |
4 | state_id | integer | 0 | Foreign key to the table core.states. | |
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 | Tax rate of the state. | |
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. |
# | Column Name | Key Name | References |
---|---|---|---|
4 | state_id | state_sales_taxes_state_id_fkey | core.states.state_id |
5 | entity_id | state_sales_taxes_entity_id_fkey | core.entities.entity_id |
6 | industry_id | state_sales_taxes_industry_id_fkey | core.industries.industry_id |
7 | item_group_id | state_sales_taxes_item_group_id_fkey | core.item_groups.item_group_id |
9 | audit_user_id | state_sales_taxes_audit_user_id_fkey | office.users.user_id |
Index Name | Owner | Access Method | Definition | Description |
---|---|---|---|---|
state_sales_taxes_pkey | postgres | btree | state_sales_tax_id | |
state_sales_taxes_state_id_item_group_id_uix | postgres | btree | state_id item_group_id | |
state_sales_taxes_state_id_industry_id_uix | postgres | btree | state_id industry_id | |
state_sales_taxes_state_id_entity_id_uix | postgres | btree | state_id entity_id | |
state_sales_taxes_state_sales_tax_name_uix | postgres | btree | upper(state_sales_tax_name::text) | |
state_sales_taxes_state_sales_tax_code_uix | postgres | btree | upper(state_sales_tax_code::text) |
Constraint Name | Description |
---|
# | Column Name | Default |
---|---|---|
1 | state_sales_tax_id | nextval('core.state_sales_taxes_state_sales_tax_id_seq'::regclass) |
8 | rate | 0 |
10 | audit_ts | now() |
Trigger Name | Targets | On Event | Timing | Condition | Order | Orientation | Description |
---|