kalenderdage


Columns

Column Type Size Nulls Auto Default Children Parents Comments
kaldag_id int8 19 null
pladsbookinger.kaldag_id plbo_kaldag_fk R
sdfe_kaldag.kaldag_id sdka_kaldag_fk R
skoledage.kaldag_id skodag_kaldag_fk R
vfm_visningsformat_mdr varchar 8 √ null
kalendermaneder.visningsformat_mdr kaldag_kamd_fk R
vfk_visningsformat_kvt varchar 12 √ null
kalenderkvartaler.visningsformat_kvt kaldag_kakvt_fk R
vfu_visningsformat_uge varchar 11 √ null
kalenderuger.visningsformat_uge kaldag_kauge_fk R
dato timestamp 22 √ null
ugedag varchar 3 √ null
ugedagsnummer int2 5 √ null
helligdag varchar 1 √ null
dagsnummer int2 5 √ null
ar varchar 4 √ null
bemerkning varchar 15 √ null

Indexes

Constraint Name Type Sort Column(s)
kaldag_pk Primary key Asc kaldag_id
kaldag_kakvt_fk_i Performance Asc vfk_visningsformat_kvt
kaldag_kaldag1_uk Must be unique Asc dato
kaldag_kamd_fk_i Performance Asc vfm_visningsformat_mdr
kaldag_kauge_fk_i Performance Asc vfu_visningsformat_uge
kalenderdate_i01 Performance Asc/Asc helligdag + dato

Check Constraints

Constraint Name Constraint
kalenderdage_check6 (('UGEDAGSNUMMER' IS NOT NULL))
kalenderdage_ugedag_check (((ugedag)::text = ANY ((ARRAY['MAN'::character varying, 'TIR'::character varying, 'ONS'::character varying, 'TOR'::character varying, 'FRE'::character varying, 'LØR'::character varying, 'SØN'::character varying])::text[])))
kalenderdage_check5 (('UGEDAG' IS NOT NULL))
kalenderdage_check4 (('KALDAG_ID' IS NOT NULL))
kalenderdage_helligdag_check (((helligdag)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
kalenderdage_check9 (('VFU_VISNINGSFORMAT_UGE' IS NOT NULL))
kalenderdage_check1 (('DAGSNUMMER' IS NOT NULL))
kalenderdage_check3 (('HELLIGDAG' IS NOT NULL))
kalenderdage_check (('AR' IS NOT NULL))
kalenderdage_check2 (('DATO' IS NOT NULL))
kalenderdage_ugedagsnummer_check ((ugedagsnummer = ANY (ARRAY[1, 2, 3, 4, 5, 6, 7])))
kalenderdage_check8 (('VFM_VISNINGSFORMAT_MDR' IS NOT NULL))
kalenderdage_check7 (('VFK_VISNINGSFORMAT_KVT' IS NOT NULL))

Relationships

Close relationships within degrees of separation