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 text 65535
frequency text 65535 The Authorised_Value definining the pattern for delivery.
fav_itemtypes text 65535  √  null Free text describing preferred itemtypes.
fav_subjects text 65535  √  null Free text describing preferred subjects.
fav_authors text 65535  √  null Free text describing preferred authors.
referral text 65535  √  null Free text indicating how the borrower was added to the service.
notes text 65535  √  null Free text for additional notes.

Table contained 0 rows at Mon Jul 16 09:22 NZST 2018

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

Close relationships  within of separation: