virtualshelves

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
shelfnumber INT 10 null
virtualshelfcontents.shelfnumber virtualshelfcontents_ibfk_1C
virtualshelfshares.shelfnumber virtualshelfshares_ibfk_1C

unique identifier assigned by Koha

shelfname VARCHAR 255 null

name of the list

owner INT 10 null
borrowers.borrowernumber virtualshelves_ibfk_1N

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?

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc shelfnumber
virtualshelves_ibfk_1 Performance Asc owner

Relationships