Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null
shelfnumber INT 10 null
virtualshelves.shelfnumber virtualshelfshares_ibfk_1 C
borrowernumber INT 10 null
borrowers.borrowernumber virtualshelfshares_ibfk_2 N
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

Table contained 0 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
virtualshelfshares_ibfk_1 Performance Asc shelfnumber
virtualshelfshares_ibfk_2 Performance Asc borrowernumber