virtualshelfshares

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 null

unique key

shelfnumber INT 10 null
virtualshelves.shelfnumber virtualshelfshares_ibfk_1C

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

Indexes

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

Relationships