0 rows


Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null

ID of the visit.

borrowernumber INT 10 null
housebound_profile.borrowernumber houseboundvisit_bnfkC

Number of the borrower, & the profile, linked to this visit.

appointment_date DATE 10 null

Date of visit.

day_segment VARCHAR 10 null

Rough time frame: ‘morning’, ‘afternoon’ ‘evening’

chooser_brwnumber INT 10 null
borrowers.borrowernumber houseboundvisit_bnfk_1C

Number of the borrower to choose items for delivery.

deliverer_brwnumber INT 10 null
borrowers.borrowernumber houseboundvisit_bnfk_2C

Number of the borrower to deliver items.


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
houseboundvisit_bnfk Performance Asc borrowernumber
houseboundvisit_bnfk_1 Performance Asc chooser_brwnumber
houseboundvisit_bnfk_2 Performance Asc deliverer_brwnumber