Table transmart.biomart.bio_assay_analysis 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
analysis_name varchar 500  √  null
short_description varchar 510  √  null
analysis_create_date timestamp 29,6  √  null
analyst_id varchar 510  √  null
bio_assay_analysis_id int8 19
bio_assay_analysis_data.bio_assay_analysis_id bio_assay_analysis_data_n_fk1 R
bio_assay_analysis_data_tea.bio_assay_analysis_id bio_assay_analysis_data_t_fk1 R
bio_assay_analysis_ext.bio_assay_analysis_id fk_asy_analysis_ext_analy R
bio_assay_analysis_gwas.bio_assay_analysis_id fk_gwas_bio_aa R
bio_asy_analysis_dataset.bio_assay_analysis_id bio_data_anl_ds_anl_fk R
bio_asy_analysis_gwas_top50.bio_assay_analysis_id fk_gwas_top50_asy_anal R
bio_analysis_cohort_xref.bio_assay_analysis_id Implied Constraint R
analysis_version varchar 200  √  null
fold_change_cutoff float8 17,17  √  null
pvalue_cutoff float8 17,17  √  null
rvalue_cutoff float8 17,17  √  null
bio_asy_analysis_pltfm_id int8 19  √  null
bio_asy_analysis_pltfm.bio_asy_analysis_pltfm_id bio_assay_ans_pltfm_fk R
bio_source_import_id int8 19  √  null
analysis_type varchar 200  √  null
analyst_name varchar 250  √  null
analysis_method_cd varchar 50  √  null
bio_assay_data_type varchar 50  √  null
etl_id varchar 100  √  null
long_description varchar 4000  √  null
qa_criteria varchar 4000  √  null
data_count int8 19  √  null
tea_data_count int8 19  √  null
analysis_update_date date 13  √  null
lsmean_cutoff float8 17,17  √  null
etl_id_source int8 19  √  null
update_of numeric 18  √  null
created_by varchar 30  √  null
modified_by varchar 30  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
bio_assay_analysis_id Primary key Asc bio_data_anl_pk
bio_assay_analysis_id Must be unique Asc bio_assay_analysis_pk

Close relationships  within of separation: