| shelfnumber |
INT |
10 |
|
√ |
null |
|
|
unique identifier assigned by Koha |
| shelfname |
VARCHAR |
255 |
√ |
|
null |
|
|
name of the list |
| owner |
INT |
10 |
√ |
|
null |
|
|
borrowers.borrowernumber
|
virtualshelves_ibfk_1 N
|
|
foreign key linking to the borrowers table (using borrowernumber) for the creator of this list (changed from varchar(80) to int) |
| category |
VARCHAR |
1 |
√ |
|
null |
|
|
type of list (private 1, public 2) |
| sortfield |
VARCHAR |
16 |
√ |
|
title |
|
|
the field this list is sorted on |
| lastmodified |
TIMESTAMP |
19 |
|
|
current_timestamp() |
|
|
date and time the list was last modified |
| created_on |
DATETIME |
19 |
|
|
null |
|
|
creation time |
| allow_change_from_owner |
BIT |
0 |
√ |
|
1 |
|
|
can owner change contents? |
| allow_change_from_others |
BIT |
0 |
√ |
|
0 |
|
|
can others change contents? |
