pladsbookinger


Columns

Column Type Size Nulls Auto Default Children Parents Comments
plbo_id int8 19 null
plad_id int8 19 √ null
pladser.plad_id plbo_plad_fk R
kaldag_id int8 19 √ null
kalenderdage.kaldag_id plbo_kaldag_fk R
verelsesblokering varchar 1 √ null
fravers_markering varchar 1 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
vere_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
book_id int8 19 √ null
bookinger.book_id plbo_book_fk R
elbo_id int8 19 √ null
elevbookinger.elbo_id plbo_elbo_fk R
manuel_fraversendring varchar 1 √ null

Indexes

Constraint Name Type Sort Column(s)
plbo_pk Primary key Asc plbo_id
plbo_book_fk_i Performance Asc book_id
plbo_elbo_fk_i Performance Asc elbo_id
plbo_kaldag_fk_i Performance Asc kaldag_id
plbo_plad_fk_i Performance Asc plad_id
plbo_plbo1_uk Must be unique Asc/Asc/Asc/Asc plad_id + kaldag_id + book_id + elbo_id
plbo_vere_fk_i Performance Asc vere_id

Check Constraints

Constraint Name Constraint
pladsbookinger_check1 (('KALDAG_ID' IS NOT NULL))
pladsbookinger_check6 (('PLAD_ID' IS NOT NULL))
pladsbookinger_check7 (('PLBO_ID' IS NOT NULL))
pladsbookinger_check8 (('VERELSESBLOKERING' IS NOT NULL))
pladsbookinger_manuel_fraversendring_check (((manuel_fraversendring)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
pladsbookinger_verelsesblokering_check (((verelsesblokering)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
pladsbookinger_check2 (('MANUEL_FRAVERSENDRING' IS NOT NULL))
pladsbookinger_fravers_markering_check (((fravers_markering)::text = ANY ((ARRAY['T'::character varying, 'F'::character varying])::text[])))
pladsbookinger_check (('FRAVERS_MARKERING' IS NOT NULL))
pladsbookinger_check3 (('OPDINIT' IS NOT NULL))
pladsbookinger_check4 (('OPDMOD' IS NOT NULL))
pladsbookinger_check5 (('OPDTID' IS NOT NULL))

Relationships

Close relationships within degrees of separation