Constraints

7 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
badge_circ_mod_filter_fkey
badge.circ_mod_filter
circ_modifier.code
Null on delete
badge_scope_fkey
badge.scope
org_unit.id
Cascade on delete
badge_loc_grp_filter_fkey
badge.loc_grp_filter
copy_location_group.id
Null on delete
badge_src_filter_fkey
badge.src_filter
bib_source.id
Null on delete
badge_popularity_parameter_fkey
badge.popularity_parameter
popularity_parameter.id
Cascade on delete
record_badge_score_badge_fkey
record_badge_score.badge
badge.id
Cascade on delete
record_badge_score_record_fkey
record_badge_score.record
record_entry.id
Cascade on delete

Check Constraints

Table Constraint Name Constraint
badge badge_fixed_rating_check (((fixed_rating IS NULL) OR ((fixed_rating >= '-5'::integer) AND (fixed_rating <= 5))))
badge badge_importance_scale_check (((importance_scale IS NULL) OR (importance_scale > 0.0)))
badge badge_percentile_check (((percentile IS NULL) OR ((percentile >= 50.0) AND (percentile < 100.0))))
record_badge_score record_badge_score_score_check (((score >= '-5'::integer) AND (score <= 5)))