elevtyper


Columns

Column Type Size Nulls Auto Default Children Parents Comments
elty_id int8 19 null
elevtyper_elevtyp_byggeklodser.elty_id eeb_elr_fk R
elevtyper_skolerperioder.elty_id esr_elr_fk R
elevtyper_uddannelser.elty_id eur_elr_fk R
ftu_elever_grf.elty_id ftu_eletyper_fk R
fuldtidsuddannelser_uvm_fag.elty_id eltyinst_fk R
specialer_uvm_fag.elty_id elinst_fk R
elevtype varchar 10 √ null
kort_betegnelse varchar 15 √ null
betegnelse varchar 50 √ null
grundforlob_del_1 varchar 1 √ null
grundforlob_del_2 varchar 1 √ null
hovedforlob varchar 1 √ null
skolepraktik varchar 1 √ null
opdmod varchar 4 √ null
opdtid timestamp 22 √ null
opdinit varchar 30 √ null

Indexes

Constraint Name Type Sort Column(s)
elty_pk Primary key Asc elty_id
elty_uk Must be unique Asc elevtype

Check Constraints

Constraint Name Constraint
elevtyper_grundforlob_del_1_check (((grundforlob_del_1)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elevtyper_check1 (('ELEVTYPE' IS NOT NULL))
elevtyper_skolepraktik_check (((skolepraktik)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elevtyper_check2 (('ELTY_ID' IS NOT NULL))
elevtyper_check7 (('OPDINIT' IS NOT NULL))
elevtyper_check4 (('GRUNDFORLOB_DEL_2' IS NOT NULL))
elevtyper_check8 (('OPDMOD' IS NOT NULL))
elevtyper_check5 (('HOVEDFORLOB' IS NOT NULL))
elevtyper_check9 (('OPDTID' IS NOT NULL))
elevtyper_check (('BETEGNELSE' IS NOT NULL))
elevtyper_check10 (('SKOLEPRAKTIK' IS NOT NULL))
elevtyper_grundforlob_del_2_check (((grundforlob_del_2)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elevtyper_check3 (('GRUNDFORLOB_DEL_1' IS NOT NULL))
elevtyper_hovedforlob_check (((hovedforlob)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elevtyper_check6 (('KORT_BETEGNELSE' IS NOT NULL))

Relationships

Close relationships within degrees of separation