Table favourite_search
Saved searches

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
criteria text 2147483647  √  null
date_modified timestamp 29,6
name varchar 255
owner varchar 255
query varchar 512  √  null
url text 2147483647
within varchar 512  √  null
institution_id int8 19
institution.id fkdb761febc711081 R
Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc favourite_search_pkey
institution_id Performance Asc favsearchinstitutionindex
name Performance Asc favsearchnameindex
owner Performance Asc favsearchownerindex

Close relationships  within of separation: