| 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 |
