ae_rekvirenter


Columns

Column Type Size Nulls Auto Default Children Parents Comments
aere_id int8 19 null
amu_bidrag.aere_id ambi_aere_fk R
amu_holdidenter.aere_id amho_aere_fk R
elev_i_skoleforlob.aere_id elis_aere_fk R
elev_i_skolepraktik.aere_id eisp_aere_fk R
elever.aere_id elev_aere_fk R
generel_ansogning.aere_id aere_ftu_fk R
holdidenter.aere_id holdi_aere_fk R
holdplaceringer.aere_id hopl_aere_fk R
kursistlektionsbidrag.aere_id kubi_aere_fk R
kursusplaceringer.aere_id kupl_aere_fk R
skolefag_pa_holdplaceringer.aere_id skhp_aere_fk R
varighedsuafh_tilskud_au_amu.aere_id vaufaa_aere_fk R
varighedsuafhengige_tilskud_fu.aere_id vautft_aere_fk R
ponr_id int8 19 √ null
postnr.ponr_id aere_ponr_fk R
ae_rekvirent varchar 4 √ null
navn varchar 50 √ null
gade varchar 50 √ null
telefon varchar 16 √ null
telefax varchar 16 √ null
ae_rekvirent_type varchar 5 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
holdident_krevet varchar 1 √ null
aerety_id int8 19 √ null
ae_rekvirent_typer.aerety_id aere_aerety_fk R
gyldig_fra timestamp 22 √ null
gyldig_til timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
aere_pk Primary key Asc aere_id
aere_aere1_uk Must be unique Asc ae_rekvirent
aere_aerety_fk_i Performance Asc aerety_id
aere_ponr_fk_i Performance Asc ponr_id

Check Constraints

Constraint Name Constraint
ae_rekvirenter_check7 (('OPDINIT' IS NOT NULL))
ae_rekvirenter_check (('AERETY_ID' IS NOT NULL))
ae_rekvirenter_holdident_krevet_check (((holdident_krevet)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
ae_rekvirenter_check6 (('NAVN' IS NOT NULL))
ae_rekvirenter_check8 (('OPDMOD' IS NOT NULL))
ae_rekvirenter_check9 (('OPDTID' IS NOT NULL))
ae_rekvirenter_check3 (('GADE' IS NOT NULL))
ae_rekvirenter_check4 (('GYLDIG_FRA' IS NOT NULL))
ae_rekvirenter_check1 (('AERE_ID' IS NOT NULL))
ae_rekvirenter_check10 (('PONR_ID' IS NOT NULL))
ae_rekvirenter_check5 (('HOLDIDENT_KREVET' IS NOT NULL))
ae_rekvirenter_check2 (('AE_REKVIRENT' IS NOT NULL))

Relationships

Close relationships within degrees of separation