Table transmart.biomart_user.query
Storage for patients and observations queries to support front end functionality. DEPRECATED! This table has been moved to a gb-backend application database.

 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 serial 10  √  nextval('biomart_user.query_id_seq'::regclass)
query_set.query_id query_set_query_id_fk R
name varchar 1000 The query name.
username varchar 50 The username of the user that created the query.
patients_query text 2147483647  √  null The patient selection part of the query.
observations_query text 2147483647  √  null The observation selection part of the query.
api_version varchar 25  √  null The version of the API the query was intended for.
bookmarked bool 1  √  null Flag to indicate if the user has bookmarked the query.
deleted bool 1  √  null Flag to indicate if the query has been deleted.
subscribed bool 1  √  null Flag to indicate if the user has subscribed to the query.
subscription_freq varchar 25  √  null Frequency of query notifications: "DAILY" or "WEEKLY".
create_date timestamp 29,6  √  null
update_date timestamp 29,6  √  null
query_blob text 2147483647  √  null Additional user preferences e.g. data table state

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc query_pkey
username + deleted Performance Asc/Asc query_username_deleted
username + subscribed Performance Asc/Asc query_username_subscribed

Close relationships  within of separation: