Table transmart.biomart.bio_assay_data 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
bio_sample_id int8 19  √  null
bio_sample.bio_sample_id bio_exp_data_fact_samp_fk R
bio_assay_data_id int8 19
log2_value float8 17,17  √  null
log10_value float8 17,17  √  null
numeric_value int8 19  √  null
text_value varchar 200  √  null
float_value float8 17,17  √  null
feature_group_name varchar 100
bio_experiment_id int8 19  √  null
bio_experiment.bio_experiment_id bio_asy_exp_fk R
bio_assay_dataset_id int8 19  √  null
bio_assay_dataset.bio_assay_dataset_id bio_asy_dt_ds_fk R
bio_assay_id int8 19  √  null
bio_assay.bio_assay_id Implied Constraint R
etl_id int8 19  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
bio_assay_data_id Primary key Asc bio_experiment_data_fact_pk
bio_assay_data_id Must be unique Asc bio_assay_data_pk

Close relationships  within of separation: