fraversprotokollinier


Columns

Column Type Size Nulls Auto Default Children Parents Comments
frvpl_id int8 19 null
fvproto_id int8 19 √ null
fraversprotokoller.fvproto_id frvpl_fvproto_fk R
pers_id int8 19 √ null
personer.pers_id frvpl_pers_fk R
linie_nummer int2 5 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
akpl_id int8 19 √ null
aktivitetsplaceringer.akpl_id frvpl_akpl_fk R
hele_ugen varchar 100 √ null
mandag varchar 100 √ null
tirsdag varchar 100 √ null
onsdag varchar 100 √ null
torsdag varchar 100 √ null
fredag varchar 100 √ null
lordag varchar 100 √ null
sondag varchar 100 √ null
registrering_findes varchar 1 √ null
overskriv varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
frvpl_pk Primary key Asc frvpl_id
frvpl_akpl_fk_i Performance Asc akpl_id
frvpl_frvpl1_uk Must be unique Asc/Asc fvproto_id + linie_nummer
frvpl_fvproto_fk_i Performance Asc fvproto_id
frvpl_pers_fk_i Performance Asc pers_id

Check Constraints

Constraint Name Constraint
fraversprotokollinier_check4 (('OPDMOD' IS NOT NULL))
fraversprotokollinier_check (('FRVPL_ID' IS NOT NULL))
fraversprotokollinier_check1 (('FVPROTO_ID' IS NOT NULL))
fraversprotokollinier_registrering_findes_check (((registrering_findes)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
fraversprotokollinier_check2 (('LINIE_NUMMER' IS NOT NULL))
fraversprotokollinier_check3 (('OPDINIT' IS NOT NULL))
fraversprotokollinier_check5 (('OPDTID' IS NOT NULL))
fraversprotokollinier_overskriv_check (((overskriv)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))

Relationships

Close relationships within degrees of separation