bookinger


Columns

Column Type Size Nulls Auto Default Children Parents Comments
book_id int8 19 null
pladsbookinger.book_id plbo_book_fk R
startdato timestamp 22 √ null
slutdato timestamp 22 √ null
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
akpl_id int8 19 √ null
aktivitetsplaceringer.akpl_id book_akpl_fk R
pers_id int8 19 √ null
personer.pers_id book_pers_fk R
arra_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
sidste_betalingsdato timestamp 22 √ null
bemerkning varchar 200 √ null
fakturatekst varchar 28 √ null
fakturatekst_logi varchar 28 √ null
grbo_id int8 19 √ null
grundlag_for_booking.grbo_id book_grbo_fk R
diet_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R

Indexes

Constraint Name Type Sort Column(s)
book_pk Primary key Asc book_id
book_akpl_fk_i Performance Asc akpl_id
book_arra_fk_i Performance Asc arra_id
book_book1_uk Must be unique Asc/Asc/Asc startdato + akpl_id + pers_id
book_diet_fk_i Performance Asc diet_id
book_grbo_fk_i Performance Asc grbo_id
book_pers_fk_i Performance Asc pers_id

Check Constraints

Constraint Name Constraint
bookinger_check2 (('OPDMOD' IS NOT NULL))
bookinger_check4 (('SLUTDATO' IS NOT NULL))
bookinger_check1 (('OPDINIT' IS NOT NULL))
bookinger_check3 (('OPDTID' IS NOT NULL))
bookinger_check (('BOOK_ID' IS NOT NULL))
bookinger_check5 (('STARTDATO' IS NOT NULL))

Relationships

Close relationships within degrees of separation