patron_lists

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
patron_list_id INT 10 null
patron_list_patrons.patron_list_id patron_list_patrons_ibfk_1 C

unique identifier

name VARCHAR 255 null
items_search_fields.name Implied Constraint R

the list’s name

owner INT 10 null
borrowers.borrowernumber patron_lists_ibfk_1 C

borrowernumber of the list creator

shared BIT 0 0

Indexes

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

Relationships