badge

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('rating.badge_id_seq'::regclass)
record_badge_score.badge record_badge_score_badge_fkey C
name text 2147483647 null
description text 2147483647 √ null
scope int4 10 null
org_unit.id badge_scope_fkey C
weight int4 10 1
horizon_age interval 49,6 √ null
importance_age interval 49,6 √ null
importance_interval interval 49,6 '1 day'::interval
importance_scale numeric 0 √ null
recalc_interval interval 49,6 '1 mon'::interval
attr_filter text 2147483647 √ null
src_filter int4 10 √ null
bib_source.id badge_src_filter_fkey N
circ_mod_filter text 2147483647 √ null
circ_modifier.code badge_circ_mod_filter_fkey N
loc_grp_filter int4 10 √ null
copy_location_group.id badge_loc_grp_filter_fkey N
popularity_parameter int4 10 null
popularity_parameter.id badge_popularity_parameter_fkey C
fixed_rating int4 10 √ null
percentile numeric 0 √ null
discard int4 10 0
last_calc timestamptz 35,6 √ null

Indexes

Constraint Name Type Sort Column(s)
badge_pkey Primary key Asc id
unique_name_scope Must be unique Asc/Asc name + scope

Check Constraints

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

Relationships

Close relationships within degrees of separation