| id |
INT |
10 |
|
√ |
null |
|
|
ID of the visit. |
| borrowernumber |
INT |
10 |
|
|
null |
|
|
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_1 |
C |
|
Number of the borrower to choose items for delivery. |
| deliverer_brwnumber |
INT |
10 |
√ |
|
null |
|
| borrowers.borrowernumber |
houseboundvisit_bnfk_2 |
C |
|
Number of the borrower to deliver items. |
