amu_kursustyper


Columns

Column Type Size Nulls Auto Default Children Parents Comments
amuku_id int8 19 null
amu_bevislinjer.amuku_id ambeli_amuku_fk R
amu_forlobsstruktur.amuku_elem_id amuforl_amuku_elem_fk R
amu_forlobsstruktur.amuku_sup_id amuforl_amuku_sup_fk R
amu_konteringer.amuku_id amkon_amuku_fk R
aufgruppe_amu_kursustyper.amuku_id aufgrpak_amuku_fk R
kursustyper_pa_kurser.amuku_id kkt_amuku_fk R
skolegodkendelser.amuku_id sko_amuku_fk R
amre_id int8 19 √ null
amu_rekvirenter.amre_id amuku_amre_fk R
kursusart varchar 2 √ null
kursustype varchar 5 √ null
version varchar 2 √ null
central_lokal varchar 1 √ null
certifikatprove varchar 1 √ null
forsog varchar 1 √ null
supertype varchar 1 √ null
elementtype varchar 1 √ null
titel varchar 70 √ null
kursusmal varchar 2000 √ null
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
normeret_varighed int2 5 √ null
min_varighed int2 5 √ null
max_varighed int2 5 √ null
max_deltagere int2 5 √ null
erhvervsgruppe varchar 3 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
split varchar 1 √ null
deltid varchar 1 √ null
abent_verksted varchar 1 √ null
weekend varchar 1 √ null
aften varchar 1 √ null
fjern varchar 1 √ null
ramme varchar 1 √ null
nedsat_godtgorelse varchar 1 √ null
reduceret_takst varchar 1 √ null
restfinansiering numeric 6,2 √ null
variable_virksomhedsprocent numeric 5,2 √ null
undtaget_for_hovedmodellen varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
amuku_pk Primary key Asc amuku_id
amuku_amre_fk_i Performance Asc amre_id
amuku_amuku1_uk Must be unique Asc/Asc/Asc/Asc kursusart + kursustype + version + amre_id

Check Constraints

Constraint Name Constraint
amu_kursustyper_check7 (('ELEMENTTYPE' IS NOT NULL))
amu_kursustyper_forsog_check (((forsog)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
amu_kursustyper_certifikatprove_check (((certifikatprove)::text = ANY ((ARRAY['J'::character varying, 'U'::character varying, 'N'::character varying])::text[])))
amu_kursustyper_check (('ABENT_VERKSTED' IS NOT NULL))
amu_kursustyper_check10 (('KURSUSART' IS NOT NULL))
amu_kursustyper_supertype_check (((supertype)::text = ANY ((ARRAY['0'::character varying, '1'::character varying, '2'::character varying, '3'::character varying, '4'::character varying, '5'::character varying, '6'::character varying, '7'::character varying, '-'::character varying])::text[])))
amu_kursustyper_check14 (('OPDMOD' IS NOT NULL))
amu_kursustyper_undtaget_for_hovedmodellen_check (((undtaget_for_hovedmodellen)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
amu_kursustyper_split_check (((split)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
amu_kursustyper_check11 (('KURSUSTYPE' IS NOT NULL))
amu_kursustyper_check13 (('OPDINIT' IS NOT NULL))
amu_kursustyper_check8 (('FJERN' IS NOT NULL))
amu_kursustyper_check3 (('AMUKU_ID' IS NOT NULL))
amu_kursustyper_check17 (('SPLIT' IS NOT NULL))
amu_kursustyper_reduceret_takst_check (((reduceret_takst)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
amu_kursustyper_abent_verksted_check (((abent_verksted)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
amu_kursustyper_check1 (('AFTEN' IS NOT NULL))
amu_kursustyper_check21 (('WEEKEND' IS NOT NULL))
amu_kursustyper_deltid_check (((deltid)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
amu_kursustyper_check2 (('AMRE_ID' IS NOT NULL))
amu_kursustyper_check4 (('CENTRAL_LOKAL' IS NOT NULL))
amu_kursustyper_check12 (('NEDSAT_GODTGORELSE' IS NOT NULL))
amu_kursustyper_check16 (('REDUCERET_TAKST' IS NOT NULL))
amu_kursustyper_check15 (('OPDTID' IS NOT NULL))
amu_kursustyper_check9 (('FORSOG' IS NOT NULL))
amu_kursustyper_elementtype_check (((elementtype)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '3'::character varying, '4'::character varying, '5'::character varying, '6'::character varying, '7'::character varying, '8'::character varying, '9'::character varying, '-'::character varying])::text[])))
amu_kursustyper_fjern_check (((fjern)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
amu_kursustyper_check20 (('VERSION' IS NOT NULL))
amu_kursustyper_weekend_check (((weekend)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
amu_kursustyper_check6 (('DELTID' IS NOT NULL))
amu_kursustyper_check19 (('UNDTAGET_FOR_HOVEDMODELLEN' IS NOT NULL))
amu_kursustyper_central_lokal_check (((central_lokal)::text = ANY ((ARRAY['C'::character varying, 'L'::character varying])::text[])))
amu_kursustyper_nedsat_godtgorelse_check (((nedsat_godtgorelse)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
amu_kursustyper_aften_check (((aften)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
amu_kursustyper_check5 (('CERTIFIKATPROVE' IS NOT NULL))
amu_kursustyper_check18 (('SUPERTYPE' IS NOT NULL))

Relationships

Close relationships within degrees of separation