housebound_profile

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
borrowernumber INT 10 null
housebound_visit.borrowernumber houseboundvisit_bnfkC
borrowers.borrowernumber housebound_profile_bnfkC

Number of the borrower associated with this profile.

day MEDIUMTEXT 16777215 null

The preferred day of the week for delivery.

frequency MEDIUMTEXT 16777215 null

The Authorised_Value definining the pattern for delivery.

fav_itemtypes MEDIUMTEXT 16777215 null

Free text describing preferred itemtypes.

fav_subjects MEDIUMTEXT 16777215 null

Free text describing preferred subjects.

fav_authors MEDIUMTEXT 16777215 null

Free text describing preferred authors.

referral MEDIUMTEXT 16777215 null

Free text indicating how the borrower was added to the service.

notes MEDIUMTEXT 16777215 null

Free text for additional notes.

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc borrowernumber

Relationships