Table transmart.searchapp.search_secure_object
Holds the secure tokens that control access.

 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
search_secure_object_id int8 19
search_auth_sec_object_access.secure_object_id sch_sec_s_o_fk R
search_auth_user_sec_access.search_secure_object_id search_sec_s_o_fk R
search_auth_user_sec_access_v.search_secure_object_id Implied Constraint R
search_secure_object_path.search_secure_object_id Implied Constraint R
Primary key. Id of the token.
bio_data_id int8 19  √  null Id of the data restricted by this token.
display_name varchar 100  √  null The name used to display this token. E.g., Private Studies - SHARED_HD_CONCEPTS_STUDY_C_PR.
data_type varchar 200  √  null Data type. E.g., BIO_CLINICAL_TRIAL.
bio_data_unique_id varchar 200  √  null The unique id used to refer to the token. E.g., EXP:SHDCSCP.

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

Indexes:
Column(s) Type Sort Constraint Name
search_secure_object_id Primary key Asc search_sec_obj_pk

Close relationships  within of separation: