MIXERP-Table office.cash_repositories

#	Column Name	Nullable	Data Type	Max Length	Description
1	cash_repository_id		integer	0	The primary key of this table, which is also a bigserial field.
2	office_id		integer	0	Foreign key to the table office.offices.
3	cash_repository_code		character varying	12	The code given to cash repository.
4	cash_repository_name		character varying	50	The name given to cash repository,which is also a unique field.
5	parent_cash_repository_id		integer	0	Foreign key to the table office.cash_repositories.
6	description		character varying	100	Description on cash repository.
7	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
8	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	office_id	cash_repositories_office_id_fkey	office.offices.office_id
5	parent_cash_repository_id	cash_repositories_parent_cash_repository_id_fkey	office.cash_repositories.cash_repository_id
7	audit_user_id	cash_repositories_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
cash_repositories_pkey	postgres	btree	cash_repository_id
cash_repositories_cash_repository_name_uix	postgres	btree	office_id upper(cash_repository_name::text)
cash_repositories_cash_repository_code_uix	postgres	btree	office_id upper(cash_repository_code::text)

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	cash_repository_id	nextval('office.cash_repositories_cash_repository_id_seq'::regclass)
8	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description