#	Column Name	Nullable	Data Type	Max Length	Description
1	item_group_id		integer	0	The primary key of this table, which is also a serial field.
2	item_group_code		character varying	12
3	item_group_name		character varying	50
4	exclude_from_purchase		boolean	0
5	exclude_from_sales		boolean	0
6	sales_tax_id		integer	0
7	sales_account_id		bigint	0
8	sales_discount_account_id		bigint	0
9	sales_return_account_id		bigint	0
10	purchase_account_id		bigint	0
11	purchase_discount_account_id		bigint	0
12	inventory_account_id		bigint	0
13	cost_of_goods_sold_account_id		bigint	0
14	parent_item_group_id		integer	0
15	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
16	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
6	sales_tax_id	item_groups_sales_tax_id_fkey	core.sales_taxes.sales_tax_id
7	sales_account_id	item_groups_sales_account_id_fkey	core.accounts.account_id
8	sales_discount_account_id	item_groups_sales_discount_account_id_fkey	core.accounts.account_id
9	sales_return_account_id	item_groups_sales_return_account_id_fkey	core.accounts.account_id
10	purchase_account_id	item_groups_purchase_account_id_fkey	core.accounts.account_id
11	purchase_discount_account_id	item_groups_purchase_discount_account_id_fkey	core.accounts.account_id
12	inventory_account_id	item_groups_inventory_account_id_fkey	core.accounts.account_id
13	cost_of_goods_sold_account_id	item_groups_cost_of_goods_sold_account_id_fkey	core.accounts.account_id
14	parent_item_group_id	item_groups_parent_item_group_id_fkey	core.item_groups.item_group_id
15	audit_user_id	item_groups_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
item_groups_pkey	postgres	btree	item_group_id
item_groups_item_group_name_uix	postgres	btree	upper(item_group_name::text)
item_groups_item_group_code_uix	postgres	btree	upper(item_group_code::text)

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	item_group_id	nextval('core.item_groups_item_group_id_seq'::regclass)
4	exclude_from_purchase	false
5	exclude_from_sales	false
16	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description