MIXERP-Table core.bank_accounts

#	Column Name	Nullable	Data Type	Max Length	Description
1	account_id		bigint	0	The primary key of this table, which is also a serial field.
2	maintained_by_user_id		integer	0	Foreign key to the table office.users.
3	office_id		integer	0
4	bank_name		character varying	128	The name of the bank.
5	bank_branch		character varying	128	The name of the branch.
6	bank_contact_number		character varying	128	The contact number of the bank.
7	bank_address		text	0	The address of the bank.
8	bank_account_number		character varying	128	The bank account number.
9	bank_account_type		character varying	128	The type of bank account.
10	relationship_officer_name		character varying	128	The name of the relationship officer.
11	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
12	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
1	account_id	bank_accounts_account_id_fkey	core.accounts.account_id
2	maintained_by_user_id	bank_accounts_maintained_by_user_id_fkey	office.users.user_id
3	office_id	bank_accounts_office_id_fkey	office.offices.office_id
11	audit_user_id	bank_accounts_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
bank_accounts_pkey	postgres	btree	account_id

Check Constraints

Constraint Name	Description
bank_accounts_account_id_chk CHECK (core.get_account_master_id_by_account_id(account_id) = 10102)

Default Values

#	Column Name	Default
12	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description