tilskudsmerkekombinationer


Columns

Column Type Size Nulls Auto Default Children Parents Comments
tmk_id int8 19 null
aktiviteter.tmk_id akti_tmk_fk R
amu_bidrag.tmk_id ambi_tmk_fk R
elev_i_skoleforlob.tmk_id elis_tmk_fk R
elev_i_skolepraktik.tmk_id eisp_tmk_fk R
gyldige_tmk_pa_au.tmk_id gtma_tmk_fk R
gyldige_tmk_pa_skoleperiode.tmk_id gtms_tmk_fk R
shj_bidrag.tmk_id shjb_tmk_fk R
skolefag_pa_hold_perioder.tmk_id sphp_tmk_fk R
skolefag_pa_holdplaceringer.tmk_id skph_tmk_fk R
tilskudsmerker_tilskudsmerkeko.tmk_id tima_tmk_tmk_fk R
varighedsuafh_tilskud_au_amu.tmk_id vaufaa_tmk_fk R
varighedsuafhengige_tilskud_fu.tmk_id vautft_tmk_fk R
kombination varchar 5 √ null
betegnelse varchar 50 √ null
kort_betegnelse varchar 15 √ null
bidrag varchar 1 √ null
tmk_type varchar 5 √ null
primer varchar 1 √ null
skolehjemsforslag varchar 2 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
opgorelsesmetode varchar 10 √ null

Indexes

Constraint Name Type Sort Column(s)
tmk_pk Primary key Asc tmk_id
tmk_tmk1_uk Must be unique Asc kombination

Check Constraints

Constraint Name Constraint
tilskudsmerkekombinationer_check4 (('OPDINIT' IS NOT NULL))
tilskudsmerkekombinationer_check5 (('OPDMOD' IS NOT NULL))
tilskudsmerkekombinationer_check6 (('OPDTID' IS NOT NULL))
tilskudsmerkekombinationer_check7 (('PRIMER' IS NOT NULL))
tilskudsmerkekombinationer_primer_check (((primer)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
tilskudsmerkekombinationer_tmk_type_check (((tmk_type)::text = ANY ((ARRAY['AABEN'::character varying, 'ALM'::character varying, 'AMU'::character varying, 'BRO'::character varying, 'PRAK'::character varying, 'SKHJ'::character varying])::text[])))
tilskudsmerkekombinationer_opgorelsesmetode_check (((opgorelsesmetode)::text = ANY ((ARRAY['Antal'::character varying, 'Kroner'::character varying, 'Årselev'::character varying])::text[])))
tilskudsmerkekombinationer_check8 (('TMK_ID' IS NOT NULL))
tilskudsmerkekombinationer_skolehjemsforslag_check (((skolehjemsforslag)::text = ANY ((ARRAY['A'::character varying, 'U'::character varying, 'F'::character varying, 'FA'::character varying, 'FU'::character varying, 'FF'::character varying])::text[])))
tilskudsmerkekombinationer_check1 (('BIDRAG' IS NOT NULL))
tilskudsmerkekombinationer_check2 (('KOMBINATION' IS NOT NULL))
tilskudsmerkekombinationer_check3 (('KORT_BETEGNELSE' IS NOT NULL))
tilskudsmerkekombinationer_check9 (('TMK_TYPE' IS NOT NULL))
tilskudsmerkekombinationer_bidrag_check (((bidrag)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
tilskudsmerkekombinationer_check (('BETEGNELSE' IS NOT NULL))

Relationships

Close relationships within degrees of separation