Table transmart.searchapp.search_user_settings 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
id int8 19
search_gene_signature_item.id Implied Constraint R
setting_name varchar 255
user_id int8 19
setting_value varchar 1024

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc search_user_settings_pkey
user_id + setting_name + setting_value Must be unique Asc/Asc/Asc search_user_settings_uk

Close relationships: