#	Column Name	Nullable	Data Type	Max Length	Description
1	policy_id		integer	0
2	user_id		integer	0	The primary key of this table, which is also a serial field.
3	can_verify_sales_transactions		boolean	0
4	sales_verification_limit		money_strict2	0
5	can_verify_purchase_transactions		boolean	0
6	purchase_verification_limit		money_strict2	0
7	can_verify_gl_transactions		boolean	0
8	gl_verification_limit		money_strict2	0
9	can_self_verify		boolean	0
10	self_verification_limit		money_strict2	0
11	effective_from		date	0
12	ends_on		date	0
13	is_active		boolean	0
14	audit_user_id		integer	0	Contains the id of the user who last inserted or updated the corresponding row.
15	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	user_id	voucher_verification_policy_user_id_fkey	office.users.user_id
14	audit_user_id	voucher_verification_policy_audit_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
voucher_verification_policy_pkey	postgres	btree	policy_id

Check Constraints

Constraint Name	Description

Default Values

#	Column Name	Default
1	policy_id	nextval('policy.voucher_verification_policy_policy_id_seq'::regclass)
3	can_verify_sales_transactions	false
4	sales_verification_limit	0
5	can_verify_purchase_transactions	false
6	purchase_verification_limit	0
7	can_verify_gl_transactions	false
8	gl_verification_limit	0
9	can_self_verify	false
10	self_verification_limit	0
15	audit_ts	now()

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description