Table transmart.searchapp.saved_faceted_search Generated by
SchemaSpy
Legend: SourceForge.net
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
saved_faceted_search_id int8 19
user_id int8 19
search_auth_user.id saved_faceted_search_user_id R
name varchar 100
keywords varchar 4000
create_dt date 13  √  now()
modified_dt date 13  √  null
search_type varchar 50 'FACETED_SEARCH'::character varying
analysis_ids varchar 4000  √  null

Table contained 0 rows at Wed Jun 26 00:11 CEST 2019

Indexes:
Column(s) Type Sort Constraint Name
saved_faceted_search_id Primary key Asc saved_faceted_search_pkey
user_id + name Must be unique Asc/Asc u_saved_search__user_id_name

Close relationships  within of separation: