Table testsql_comments.housebound_profile Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
borrowernumber int 10
housebound_visit.borrowernumber houseboundvisit_bnfk C
borrowers.borrowernumber housebound_profile_bnfk C
Number of the borrower associated with this profile.
day mediumtext 16777215
frequency mediumtext 16777215 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.

Table contained 0 rows at Mon Jul 16 08:37 NZST 2018

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

Close relationships  within of separation: