Constraints

47 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

fk_permission_parent_id

permission.parent_id

Restrict delete

fk_batch_report_items_report_id

batch_report_items.report_id

Cascade on delete

fk_batch_report_items_batch_id

batch_report_items.batch_id

batch_report.id

Cascade on delete

fk_service_token_service_id

service_token.service_id

Cascade on delete

fk_service_token_prop_id

service_token.prop_id

Cascade on delete

fk_user_group_prop_id

user_group.prop_id

Cascade on delete

fk_user_group_prop_group

user_group.prop_group_id

property_group.id

Cascade on delete

fk_group_permission_group_id

group_permission.group_id

Cascade on delete

fk_group_permission_permission

group_permission.perm_id

group_permission.code

permission.code

Cascade on delete

oauth_client_redirect_uri_client_id_fkey

oauth_client_redirect_uri.client_id

oauth_client.client_id

Cascade on delete

fk_user_property_prop_id

user_property.prop_id

Cascade on delete

fk_user_property_user_id

user_property.user_id

Cascade on delete

property_reports_prop_id_fk

property_reports.prop_id

Cascade on delete

property_reports_report_id_fk

property_reports.report_id

Cascade on delete

fk_dashboard_prop_id

dashboard.prop_id

Cascade on delete

fk_dashboard_user_id

dashboard.user_id

Cascade on delete

fk_dashboard_user_group_id

dashboard.user_id

Cascade on delete

oauth_client_allowed_resource_client_id_fkey

oauth_client_allowed_resource.client_id

oauth_client.client_id

Cascade on delete

fk_print_form_prop_id

print_form.prop_id

Cascade on delete

fk_print_form_report_id

print_form.report_id

Null on delete

fk_group_permission_override_group_id

group_permission_override.group_id

Cascade on delete

fk_group_permission_override_prop_id

group_permission_override.prop_id

Cascade on delete

fk_group_permission_override_permission

group_permission_override.perm_id

group_permission_override.code

permission.code

Cascade on delete

fk_rpc_permission_code

rpc_permission.permission_code

permission.code

Restrict delete

fk_property_group_id

property.prop_group_id

property_group.id

Null on delete

fk_user_permission_permission

user_permission.perm_id

user_permission.code

permission.code

Cascade on delete

fk_user_permission_prop_id

user_permission.prop_id

Cascade on delete

fk_user_permission_user_id

user_permission.user_id

Cascade on delete

fk_apps_anchor_prop_id

apps.anchor_prop_id

Null on delete

fk_apps_access_from

apps.access_from

apps.code

Null on delete

fk_configs_prop_id

configs.prop_id

Cascade on delete

oauth_authorization_code_client_id_fkey

oauth_authorization_code.client_id

oauth_client.client_id

Cascade on delete

fk_user_roles_prop_id

user_roles.prop_id

Cascade on delete

fk_user_roles_user_id

user_roles.user_id

Cascade on delete

fk_user_roles_group_id

user_roles.group_id

Cascade on delete

fk_user_permission_override_permission

user_permission_override.perm_id

user_permission_override.code

permission.code

Cascade on delete

fk_user_permission_override_prop_id

user_permission_override.prop_id

Cascade on delete

fk_user_permission_override_user_id

user_permission_override.user_id

Cascade on delete

fk_work_log_prop_id

work_log.prop_id

Cascade on delete

fk_work_log_user_id

work_log.user_id

Null on delete

fk_property_app_prop_id

property_app.prop_id

Cascade on delete

fk_property_app_app_code

property_app.app_code

apps.code

Restrict delete

fk_users_group

users.user_group_id

Restrict delete

fk_batch_report_prop_id

batch_report.prop_id

Cascade on delete

fk_user_app_access_app_code

user_app_access.app_code

apps.code

Restrict delete

fk_user_app_access_prop_id

user_app_access.prop_id

Cascade on delete

fk_user_app_access_user_id

user_app_access.user_id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
user_group	chk_user_group_global_system_role	((app_code IS NOT NULL) OR ((group_type = 'S'::bpchar) AND (prop_id IS NULL) AND (prop_group_id IS NULL) AND (name = ANY (ARRAY['System Administrator'::text, 'System Support'::text, 'Developer'::text]))))
group_permission_override	group_permission_override_action_type_check	(action_type = ANY (ARRAY['allow'::text, 'deny'::text]))
property	property_prop_type_check	(prop_type = ANY (ARRAY['live'::text, 'demo'::text, 'training'::text, 'sample'::text, 'blank'::text, 'test'::text]))
apps	chk_apps_access_ttl_sec	((access_ttl_sec >= 60) AND (access_ttl_sec <= 86400))
apps	chk_apps_code_lower	(code = lower(code))
apps	chk_apps_refresh_ttl_sec	((refresh_ttl_sec >= 300) AND (refresh_ttl_sec <= 31536000))
user_permission_override	user_permission_override_action_type_check	(action_type = ANY (ARRAY['allow'::text, 'deny'::text]))
work_log	chk_work_log_app_code_lower	(app_code = lower(app_code))
property_app	chk_property_app_app_lower	(app_code = lower(app_code))
users	chk_users_email_canonical	((email IS NULL) OR (email = NULLIF(lower(btrim(email)), ''::text)))
batch_report	batch_report_batch_type_check	(batch_type = ANY (ARRAY['endday'::text, 'closeshift'::text, 'manual'::text]))
batch_report	batch_report_check	(output_type = ANY (ARRAY['email'::text, 'file'::text, 'printer'::text]))
user_app_access	chk_user_app_access_app_lower	(app_code = lower(app_code))