revisionsspor_hold


Columns

Column Type Size Nulls Auto Default Children Parents Comments
revihold_id int8 19 null
aktivitet varchar 12 √ null
opropdtid timestamp 22 √ null
opropdinit varchar 30 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
akti_id int8 19 √ null
trekningstype varchar 1 √ null
opropdmod varchar 4 √ null
operation varchar 1 √ null
lobende_optag varchar 1 √ null
udlobsdato timestamp 22 √ null
tilmeldingsblanket varchar 26 √ null
tilmeldingshjemmeside varchar 200 √ null
postnr varchar 15 √ null
arsverk numeric 4,1 √ null
forventet_antal_telledatoer int2 5 √ null
faktisk_antal_telledatoer int2 5 √ null
elevplan_startdato timestamp 22 √ null
elevplan_betegnelse varchar 100 √ null
kombination varchar 5 √ null
starttidspunkt varchar 5 √ null
sluttidspunkt varchar 5 √ null
ugedag varchar 3 √ null
kontaktperson varchar 50 √ null
kontakt_telefonnr varchar 20 √ null
deltagerpris numeric 10,2 √ null
tilmeldingsfrist timestamp 22 √ null
undervisningsform varchar 20 √ null
undervisningstid varchar 50 √ null
undervisningssted varchar 50 √ null
beskrivelse varchar 1000 √ null
vidar_indberet varchar 1 √ null
vidar_navn varchar 100 √ null
akti_type varchar 4 √ null
frafaldsprocent int2 5 √ null
aflyst varchar 1 √ null
elevlektioner int2 5 √ null
kvotient int2 5 √ null
startdato timestamp 22 √ null
afregningsform varchar 1 √ null
slutdato timestamp 22 √ null
kort_betegnelse varchar 15 √ null
akkord varchar 1 √ null
uddannelsesgruppe varchar 3 √ null
betegnelse varchar 50 √ null
ringesystem varchar 4 √ null
ansvarsomrade varchar 10 √ null
projektomrade varchar 10 √ null
skoledagskalender varchar 8 √ null
akt_gruppe varchar 4 √ null
ac_sats_kode varchar 2 √ null
indberetningsprincip varchar 3 √ null
godkendt_skole varchar 4 √ null
gennemforende_skole varchar 4 √ null
indkaldelsesdato timestamp 22 √ null
aflyst_pr_dato timestamp 22 √ null
tmer_pr_dag numeric 6,2 √ null
lms varchar 1 √ null
individuel_fagvalg varchar 1 √ null
parameterlistenavn varchar 15 √ null
undervisningsforlob_bundet varchar 1 √ null
undervisningsforlob varchar 100 √ null
webservice_tilladt varchar 1 √ null
overfores_til_fagligt_udvalg varchar 1 √ null
sidste_skoleophold varchar 1 √ null
skoleophold varchar 2 √ null
akti_guid varchar 32 √ null
email varchar 100 √ null
hjemmeside varchar 200 √ null
tilmeld_via_efteruddannelse_dk varchar 240 √ null

Indexes

Constraint Name Type Sort Column(s)
revihold_pk Primary key Asc revihold_id
revihold_akti_fk_i Performance Asc akti_id

Check Constraints

Constraint Name Constraint
revisionsspor_hold_sidste_skoleophold_check (((sidste_skoleophold)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
revisionsspor_hold_check8 (('REVIHOLD_ID' IS NOT NULL))
revisionsspor_hold_skoleophold_check (((skoleophold)::text = ANY ((ARRAY['GF'::character varying, 'H1'::character varying, 'H2'::character varying, 'H3'::character varying, 'H4'::character varying, 'H5'::character varying, 'H6'::character varying])::text[])))
revisionsspor_hold_check6 (('OPROPDTID' IS NOT NULL))
revisionsspor_hold_tilmeldingsblanket_check (((tilmeldingsblanket)::text = ANY ((ARRAY['Bestil mere info'::character varying, 'Ingen tilmeldingsblanket'::character varying, 'Skolens tilmeldingsblanket'::character varying, 'Tilmelding'::character varying])::text[])))
revisionsspor_hold_check5 (('OPROPDINIT' IS NOT NULL))
revisionsspor_hold_trekningstype_check (((trekningstype)::text = ANY ((ARRAY['A'::character varying, 'B'::character varying, 'C'::character varying, 'D'::character varying, 'E'::character varying, 'F'::character varying, 'G'::character varying, 'H'::character varying, 'I'::character varying, 'J'::character varying, 'K'::character varying, 'L'::character varying, 'M'::character varying])::text[])))
revisionsspor_hold_check2 (('OPDMOD' IS NOT NULL))
revisionsspor_hold_overfores_til_fagligt_udvalg_check (((overfores_til_fagligt_udvalg)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
revisionsspor_hold_indberetningsprincip_check (((indberetningsprincip)::text = ANY ((ARRAY['-'::character varying, 'P'::character varying, 'S'::character varying, 'SFI'::character varying, 'ÅV'::character varying])::text[])))
revisionsspor_hold_check7 (('OVERFORES_TIL_FAGLIGT_UDVALG' IS NOT NULL))
revisionsspor_hold_ugedag_check (((ugedag)::text = ANY ((ARRAY['FRE'::character varying, 'LØR'::character varying, 'MAN'::character varying, 'ONS'::character varying, 'SØN'::character varying, 'TIR'::character varying, 'TOR'::character varying])::text[])))
revisionsspor_hold_vidar_indberet_check (((vidar_indberet)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
revisionsspor_hold_check3 (('OPDTID' IS NOT NULL))
revisionsspor_hold_check10 (('WEBSERVICE_TILLADT' IS NOT NULL))
revisionsspor_hold_individuel_fagvalg_check (((individuel_fagvalg)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
revisionsspor_hold_lms_check (((lms)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
revisionsspor_hold_check4 (('OPERATION' IS NOT NULL))
revisionsspor_hold_operation_check (((operation)::text = ANY ((ARRAY['-'::character varying, 'D'::character varying, 'I'::character varying, 'U'::character varying])::text[])))
revisionsspor_hold_check (('AKTIVITET' IS NOT NULL))
revisionsspor_hold_undervisningsforlob_bundet_check (((undervisningsforlob_bundet)::text = ANY ((ARRAY['B'::character varying, 'V'::character varying])::text[])))
revisionsspor_hold_afregningsform_check (((afregningsform)::text = ANY ((ARRAY['A'::character varying, 'L'::character varying])::text[])))
revisionsspor_hold_check9 (('SIDSTE_SKOLEOPHOLD' IS NOT NULL))
revisionsspor_hold_lobende_optag_check (((lobende_optag)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
revisionsspor_hold_check1 (('OPDINIT' IS NOT NULL))
revisionsspor_hold_akkord_check (((akkord)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
revisionsspor_hold_webservice_tilladt_check (((webservice_tilladt)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
revisionsspor_hold_aflyst_check (((aflyst)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))

Relationships

Close relationships within degrees of separation