MIXERP-Table core.accounts

#	Column Name	Nullable	Data Type	Max Length	Description
1	account_id		bigint	0	The primary key of this table, which is also a bigserial field.
2	account_master_id		smallint	0	The foreign key to table core.account_masters.
3	account_number		character varying	12	The unique numeric value assigned to the account name which is similar to account id.
4	external_code		character varying	12
5	currency_code		character varying	12	Foreign key to the table core.currencies.
6	account_name		character varying	100	The name of account master, which is also a unique field.
7	description		character varying	200	Description about the account.
8	confidential		boolean	0	Limits the access to the particular account among various uesers.
9	is_transaction_node		boolean	0
10	sys_type		boolean	0
11	parent_account_id		bigint	0	Foreign key to the table core.accounts.
12	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
13	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	account_master_id	accounts_account_master_id_fkey	core.account_masters.account_master_id
5	currency_code	accounts_currency_code_fkey	core.currencies.currency_code
11	parent_account_id	accounts_parent_account_id_fkey	core.accounts.account_id
12	audit_user_id	accounts_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
accounts_pkey	postgres	btree	account_id
accounts_name_uix	postgres	btree	upper(account_name::text)
accounts_account_number_uix	postgres	btree	upper(account_number::text)

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	account_id	nextval('core.accounts_account_id_seq'::regclass)
4	external_code	''::character varying
8	confidential	false
9	is_transaction_node	true
10	sys_type	false
13	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description