amu_rekvirenter


Columns

Column Type Size Nulls Auto Default Children Parents Comments
amre_id int8 19 null
aktiviteter.amre_id akti_amre_fk R
amu_kursustyper.amre_id amuku_amre_fk R
amu_rekvirentkonti.amre_id amukonto_amre_fk R
kursistlektionsbidrag.amre_id kubi_amre_fk R
kursusplaceringer.amre_id kupl_amre_fk R
financieringskilde varchar 2 √ null
malgruppe varchar 2 √ null
rekvirent varchar 50 √ null
rekvirentgruppe varchar 1 √ null
central_lokal varchar 1 √ null
ds_kategori varchar 2 √ null
cofo_id int8 19 √ null
cosa_formal.cofo_id amre_cofo_fk R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
bevisformat varchar 2 √ null
tilskud varchar 1 √ null
ams_rekvirent varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
amre_pk Primary key Asc amre_id
amre_amre1_uk Must be unique Asc/Asc financieringskilde + malgruppe
amre_cofo_fk_i Performance Asc cofo_id

Check Constraints

Constraint Name Constraint
amu_rekvirenter_check7 (('MALGRUPPE' IS NOT NULL))
amu_rekvirenter_tilskud_check (((tilskud)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
amu_rekvirenter_check (('AMRE_ID' IS NOT NULL))
amu_rekvirenter_check8 (('OPDINIT' IS NOT NULL))
amu_rekvirenter_check2 (('BEVISFORMAT' IS NOT NULL))
amu_rekvirenter_bevisformat_check (((bevisformat)::text = ANY ((ARRAY['A4'::character varying, 'A6'::character varying])::text[])))
amu_rekvirenter_central_lokal_check (((central_lokal)::text = ANY ((ARRAY['C'::character varying, 'L'::character varying])::text[])))
amu_rekvirenter_check3 (('CENTRAL_LOKAL' IS NOT NULL))
amu_rekvirenter_ams_rekvirent_check (((ams_rekvirent)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
amu_rekvirenter_check9 (('OPDMOD' IS NOT NULL))
amu_rekvirenter_ds_kategori_check (((ds_kategori)::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, '10'::character varying, '12'::character varying, '13'::character varying, '14'::character varying, '15'::character varying, '0'::character varying])::text[])))
amu_rekvirenter_rekvirentgruppe_check (((rekvirentgruppe)::text = ANY ((ARRAY['1'::character varying, '2'::character varying, '3'::character varying, '4'::character varying, '5'::character varying, '6'::character varying])::text[])))
amu_rekvirenter_check5 (('DS_KATEGORI' IS NOT NULL))
amu_rekvirenter_check1 (('AMS_REKVIRENT' IS NOT NULL))
amu_rekvirenter_check12 (('TILSKUD' IS NOT NULL))
amu_rekvirenter_check10 (('OPDTID' IS NOT NULL))
amu_rekvirenter_check6 (('FINANCIERINGSKILDE' IS NOT NULL))
amu_rekvirenter_check4 (('COFO_ID' IS NOT NULL))
amu_rekvirenter_check11 (('REKVIRENT' IS NOT NULL))

Relationships

Close relationships within degrees of separation