elevbookinger


Columns

Column Type Size Nulls Auto Default Children Parents Comments
elbo_id int8 19 null
pladsbookinger.elbo_id plbo_elbo_fk R
shj_bidrag.elbo_id shjb_elbo_fk R
shje_id int8 19 √ null
skolehjemselever.shje_id elbo_shje_fk R
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
forsorger varchar 1 √ null
skolehjemsforsog varchar 1 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
bemerkning varchar 200 √ null
diet_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
elbo_pk Primary key Asc elbo_id
elbo_diet_fk_i Performance Asc diet_id
elbo_elbo1_uk Must be unique Asc/Asc shje_id + startdato
elbo_shje_fk_i Performance Asc shje_id

Check Constraints

Constraint Name Constraint
elevbookinger_check5 (('SHJE_ID' IS NOT NULL))
elevbookinger_check6 (('SKOLEHJEMSFORSOG' IS NOT NULL))
elevbookinger_check8 (('STARTDATO' IS NOT NULL))
elevbookinger_forsorger_check (((forsorger)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elevbookinger_check7 (('SLUTDATO' IS NOT NULL))
elevbookinger_check (('ELBO_ID' IS NOT NULL))
elevbookinger_check2 (('OPDINIT' IS NOT NULL))
elevbookinger_skolehjemsforsog_check (((skolehjemsforsog)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
elevbookinger_check1 (('FORSORGER' IS NOT NULL))
elevbookinger_check3 (('OPDMOD' IS NOT NULL))
elevbookinger_check4 (('OPDTID' IS NOT NULL))

Relationships

Close relationships within degrees of separation