regelgrundlag


Columns

Column Type Size Nulls Auto Default Children Parents Comments
regr_id int8 19 null
elever.b_regr_id bregr_elev_fk R
elever.u_regr_id uregr_elev_fk R
fuldtidsuddannelser_uvm_fag.regr_id eltyinst1_fk R
regelgrundlag.regr_id_rel regr_regr_fk R
regelgrundlag_fag.regr_id regfa_regr_fk R
regelgrundlag_for_uddannelser.regr_id refu_regr_fk R
specialer_uvm_fag.regr_id elinst_fk1 R
regelnr varchar 5 √ null
regeltype varchar 5 √ null
titel varchar 2000 √ null
regeldato timestamp 22 √ null
ikrafttredelsesdato timestamp 22 √ null
slut_dato timestamp 22 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
regr_id_rel int8 19 √ null
regelgrundlag.regr_id regr_regr_fk R
url varchar 300 √ null

Indexes

Constraint Name Type Sort Column(s)
regr_pk Primary key Asc regr_id
regr_regr1_uk Must be unique Asc/Asc/Asc regelnr + regeldato + regeltype
regr_regr_fk_i Performance Asc regr_id_rel

Check Constraints

Constraint Name Constraint
regelgrundlag_check6 (('REGELTYPE' IS NOT NULL))
regelgrundlag_check7 (('REGR_ID' IS NOT NULL))
regelgrundlag_check3 (('OPDTID' IS NOT NULL))
regelgrundlag_check1 (('OPDINIT' IS NOT NULL))
regelgrundlag_regeltype_check (((regeltype)::text = ANY ((ARRAY['A'::character varying, 'B'::character varying, 'C'::character varying, 'E'::character varying, 'F'::character varying, 'H'::character varying, 'L'::character varying, 'U'::character varying, 'V'::character varying, 'Ø'::character varying])::text[])))
regelgrundlag_check2 (('OPDMOD' IS NOT NULL))
regelgrundlag_check5 (('REGELNR' IS NOT NULL))
regelgrundlag_check4 (('REGELDATO' IS NOT NULL))
regelgrundlag_check (('IKRAFTTREDELSESDATO' IS NOT NULL))
regelgrundlag_check8 (('TITEL' IS NOT NULL))

Relationships

Close relationships within degrees of separation