item_lists

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
item_list_contents.item_list_id ilc_list C
item_list_shares.item_list_id ils_list C

unique id for the item list
name VARCHAR 255 null
items_search_fields.name Implied Constraint R

name of the item list
owner INT 10 √ NULL
borrowers.borrowernumber il_owner N

borrowernumber of the item list owner
branchcode VARCHAR 10 null

branchcode of the item list owner
visibility enum('private', 'group', 'public') 7 'private'

visibility determining ability to read the item list
created_on TIMESTAMP 19 current_timestamp()

when the item list was created
updated_on TIMESTAMP 19 current_timestamp()

when the item list was last updated

Indexes

Constraint Name Type Sort Column(s)
item_lists_s_pk Primary key Asc id
il_owner Performance Asc owner
name Must be unique Asc name
PRIMARY Must be unique Asc id

Relationships

Close relationships within degrees of separation