Constraints

27 Foreign Key Constraints

Constraint Name

Child Column

Parent Column

Delete Rule

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_code

group_permission.code

permission.code

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

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_property_group_id

property.prop_group_id

property_group.id

Null on delete

fk_user_permission_code

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_configs_prop_id

configs.prop_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_user_language

users.language_id

Null on delete

fk_users_group

users.user_group_id

Restrict delete

fk_batch_report_prop_id

batch_report.prop_id

Cascade on delete

Check Constraints

Table	Constraint Name	Constraint
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]))