Table transmart.searchapp.search_gene_signature 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_gene_signature_id int8 19
search_gene_signature.parent_gene_signature_id gene_sig_parent_fk1 R
search_gene_signature_item.search_gene_signature_id Implied Constraint R
name varchar 100
description varchar 1000  √  null
unique_id varchar 50  √  null
create_date timestamp 29,6
created_by_auth_user_id int8 19
search_auth_user.id gene_sig_create_auth_user_fk1 R
last_modified_date timestamp 29,6  √  null
modified_by_auth_user_id int8 19  √  null
search_auth_user.id gene_sig_mod_auth_user_fk1 R
version_number varchar 50  √  null
public_flag bool 1  √  false
deleted_flag bool 1  √  false
parent_gene_signature_id int8 19  √  null
search_gene_signature.search_gene_signature_id gene_sig_parent_fk1 R
source_concept_id int8 19  √  null
source_other varchar 255  √  null
owner_concept_id int8 19  √  null
stimulus_description varchar 1000  √  null
stimulus_dosing varchar 255  √  null
treatment_description varchar 1000  √  null
treatment_dosing varchar 255  √  null
treatment_bio_compound_id int8 19  √  null
treatment_protocol_number varchar 50  √  null
pmid_list varchar 255  √  null
species_concept_id int8 19
species_mouse_src_concept_id int8 19  √  null
species_mouse_detail varchar 255  √  null
tissue_type_concept_id int8 19  √  null
experiment_type_concept_id int8 19  √  null
experiment_type_in_vivo_descr varchar 255  √  null
experiment_type_atcc_ref varchar 255  √  null
analytic_cat_concept_id int8 19  √  null
analytic_cat_other varchar 255  √  null
bio_assay_platform_id int8 19
analyst_name varchar 100  √  null
norm_method_concept_id int8 19  √  null
norm_method_other varchar 255  √  null
analysis_method_concept_id int8 19  √  null
analysis_method_other varchar 255  √  null
multiple_testing_correction bool 1  √  null
p_value_cutoff_concept_id int8 19
upload_file varchar 255
search_gene_sig_file_schema_id int8 19 1
search_gene_sig_file_schema.search_gene_sig_file_schema_id gene_sig_file_schema_fk1 R
fold_chg_metric_concept_id int8 19
experiment_type_cell_line_id int8 19  √  null
qc_performed numeric 1  √  null
qc_date date 13  √  null
qc_info varchar 255  √  null
data_source varchar 255  √  null
custom_value1 varchar 255  √  null
custom_name1 varchar 255  √  null
custom_value2 varchar 255  √  null
custom_name2 varchar 255  √  null
custom_value3 varchar 255  √  null
custom_name3 varchar 255  √  null
custom_value4 varchar 255  √  null
custom_name4 varchar 255  √  null
custom_value5 varchar 255  √  null
custom_name5 varchar 255  √  null
version varchar 255  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
search_gene_signature_id Primary key Asc search_gene_sig_descr_pk

Close relationships  within of separation: