Table testsql_comments.borrower_sync Generated by
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
borrowersyncid int 10  √  Primary key, unique identifier
borrowernumber int 10
borrowers.borrowernumber borrower_sync_ibfk_1 C
Connects data about synchronisations to a borrower
synctype varchar 32 There could potentially be more than one kind of syncing going on, a text string here can be used to tell them apart. E.g.: The Norwegian national patron database uses 'norwegianpatrondb' in this column
sync bit 0 0 A boolean (1/0) for turning syncing off and on for individual borrowers
syncstatus varchar 10  √  null The sync status for any given borrower. Could be text strings like 'new', 'edited', 'synced' etc. The values used here will depend on the actual syncing being done.
lastsync varchar 50  √  null Date of the last successfull sync. The date format might be different depending on the service that is being used, so no special date format is being enforced here.
hashed_pin varchar 64  √  null Perhaps specific to The Norwegian national patron database, this column holds a hashed PIN code

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

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

Close relationships  within of separation: