virtualshelves


Columns

Column Type Size Nulls Auto Default Children Parents Comments
shelfnumber INT 10 √ null
virtualshelfcontents.shelfnumber virtualshelfcontents_ibfk_1 C
virtualshelfshares.shelfnumber virtualshelfshares_ibfk_1 C

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?

Table contained 0 rows

Indexes

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

Relationships

Close relationships within degrees of separation