Table bookmark
Legacy name, actually references favourites

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int8 19
bookmark_keywords.bookmark_id fk1253a8933b9a12bc R
always_latest bool 1
date_modified timestamp 29,6  √  null
owner varchar 255
institution_id int8 19
institution.id fk7787a536bc711081 R
item_id int8 19
item.id fk7787a5366f7f1a9c R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc bookmark_pkey
institution_id Performance Asc bmkinstitutionindex
item_id Performance Asc bookmarkitem

Close relationships  within of separation: