#	Column Name	Nullable	Data Type	Max Length	Description
1	policy_id		integer	0	The primary key of this table, which is also a bigserial field.
2	menu_id		integer	0	Foreign key to the table core.menus.
3	office_id		integer	0	Foreign key to the table office.offices.
4	inherit_in_child_offices		boolean	0
5	role_id		integer	0
6	user_id		integer	0
7	scope		character varying	12

Foreign Keys

#	Column Name	Key Name	References
2	menu_id	menu_policy_menu_id_fkey	core.menus.menu_id
3	office_id	menu_policy_office_id_fkey	office.offices.office_id
5	role_id	menu_policy_role_id_fkey	office.roles.role_id
6	user_id	menu_policy_user_id_fkey	office.users.user_id

Indices

Index Name	Owner	Access Method	Definition	Description
menu_policy_pkey	postgres	btree	policy_id

Check Constraints

Constraint Name	Description
menu_policy_scope_chk CHECK (scope::text = ANY (ARRAY['Allow'::character varying, 'Deny'::character varying]::text[]))

Default Values

#	Column Name	Default
1	policy_id	nextval('policy.menu_policy_policy_id_seq'::regclass)
4	inherit_in_child_offices	false

Triggers

Trigger Name	Targets	On Event	Timing	Condition	Order	Orientation	Description
policy.check_menu_policy_trigger	policy.check_menu_policy_trigger	INSERT	BEFORE		0	ROW