fraversprotokoller


Columns

Column Type Size Nulls Auto Default Children Parents Comments
fvproto_id int8 19 null
fraversprotokollinier.fvproto_id frvpl_fvproto_fk R
akti_id int8 19 √ null
aktiviteter.akti_id fvproto_akti_fk R
vfu_uge varchar 11 √ null
kalenderuger.visningsformat_uge fvproto_kauge_fk R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
protokol_nr int2 5 √ null
status varchar 1 √ null
protokol_type varchar 1 √ null
meda_id int8 19 √ null
medarbejdere.meda_id fvproto_meda_fk R
registrering_findes varchar 1 √ null
overskriv varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
fvproto_pk Primary key Asc fvproto_id
fvproto_akti_fk_i Performance Asc akti_id
fvproto_fvproto1_uk Must be unique Asc/Asc vfu_uge + protokol_nr
fvproto_kauge_fk_i Performance Asc vfu_uge
fvproto_meda_fk_i Performance Asc meda_id

Check Constraints

Constraint Name Constraint
fraversprotokoller_overskriv_check (((overskriv)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
fraversprotokoller_check3 (('OPDMOD' IS NOT NULL))
fraversprotokoller_check6 (('PROTOKOL_TYPE' IS NOT NULL))
fraversprotokoller_status_check (((status)::text = ANY ((ARRAY['O'::character varying, 'I'::character varying, 'R'::character varying])::text[])))
fraversprotokoller_check1 (('FVPROTO_ID' IS NOT NULL))
fraversprotokoller_check2 (('OPDINIT' IS NOT NULL))
fraversprotokoller_check8 (('VFU_UGE' IS NOT NULL))
fraversprotokoller_check5 (('PROTOKOL_NR' IS NOT NULL))
fraversprotokoller_check4 (('OPDTID' IS NOT NULL))
fraversprotokoller_protokol_type_check (((protokol_type)::text = ANY ((ARRAY['S'::character varying, 'U'::character varying])::text[])))
fraversprotokoller_check7 (('STATUS' IS NOT NULL))
fraversprotokoller_registrering_findes_check (((registrering_findes)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
fraversprotokoller_check (('AKTI_ID' IS NOT NULL))

Relationships

Close relationships within degrees of separation