id |
INT |
10 |
|
√ |
null |
|
|
unique key |
shelfnumber |
INT |
10 |
|
|
null |
|
|
foreign key for virtualshelves |
borrowernumber |
INT |
10 |
√ |
|
null |
|
borrowers.borrowernumber |
virtualshelfshares_ibfk_2N |
|
borrower that accepted access to this list |
invitekey |
VARCHAR |
10 |
√ |
|
null |
|
|
temporary string used in accepting the invitation to access thist list; not-empty means that the invitation has not been accepted yet |
sharedate |
DATETIME |
19 |
√ |
|
null |
|
|
date of invitation or acceptance of invitation |