#	Column Name	Nullable	Data Type	Max Length	Description
1	transaction_master_id		bigint	0
2	transaction_counter		integer	0
3	transaction_code		character varying	50
4	book		character varying	50
5	value_date		date	0
6	transaction_ts		timestamp with time zone	0
7	login_id		bigint	0
8	user_id		integer	0
9	sys_user_id		integer	0
10	office_id		integer	0
11	cost_center_id		integer	0
12	reference_number		character varying	24
13	statement_reference		text	0
14	last_verified_on		timestamp with time zone	0
15	verified_by_user_id		integer	0
16	verification_status_id		smallint	0
17	verification_reason		character varying	128
18	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
19	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
7	login_id	transaction_master_login_id_fkey	audit.logins.login_id
8	user_id	transaction_master_user_id_fkey	office.users.user_id
9	sys_user_id	transaction_master_sys_user_id_fkey	office.users.user_id
10	office_id	transaction_master_office_id_fkey	office.offices.office_id
11	cost_center_id	transaction_master_cost_center_id_fkey	office.cost_centers.cost_center_id
15	verified_by_user_id	transaction_master_verified_by_user_id_fkey	office.users.user_id
16	verification_status_id	transaction_master_verification_status_id_fkey	core.verification_statuses.verification_status_id
18	audit_user_id	transaction_master_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
transaction_master_pkey	postgres	btree	transaction_master_id
transaction_master_transaction_code_uix	postgres	btree	upper(transaction_code::text)

Check Constraints

Constraint Name	Description
transaction_master_sys_user_id_chk CHECK (sys_user_id IS NULL OR office.is_sys_user(sys_user_id) = true)
transaction_master_office_id_chk CHECK (NOT policy.is_transaction_restricted(office_id))
transaction_master_login_id_sys_user_id_chk CHECK (login_id IS NULL AND sys_user_id IS NOT NULL OR login_id IS NOT NULL AND sys_user_id IS NULL)

Default Values

#	Column Name	Default
1	transaction_master_id	nextval('transactions.transaction_master_transaction_master_id_seq'::regclass)
6	transaction_ts	now()
16	verification_status_id	0
17	verification_reason	''::character varying
19	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description
transactions.verification_delete_trigger	transactions.verification_trigger	DELETE	BEFORE		0	ROW
transactions.verification_update_trigger	transactions.verification_trigger	UPDATE	AFTER		0	ROW