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 BOOLEAN 3 √ 0

Indexes

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

Relationships

Close relationships within degrees of separation