Table transmart.biomart.bio_assay_dataset 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_assay_dataset_id int8 19
bio_assay_data.bio_assay_dataset_id bio_asy_dt_ds_fk R
bio_assay_data_stats.bio_assay_dataset_id bio_asy_dt_stats_ds_s_fk R
bio_asy_analysis_dataset.bio_assay_dataset_id bio_data_anl_ds_fk R
bio_asy_data_stats_all.bio_assay_dataset_id Implied Constraint R
dataset_name varchar 400  √  null
dataset_description varchar 1000  √  null
dataset_criteria varchar 1000  √  null
create_date timestamp 29,6  √  null
bio_experiment_id int8 19
bio_experiment.bio_experiment_id bio_dataset_experiment_fk R
bio_assay_id int8 19  √  null
bio_assay.bio_assay_id Implied Constraint R
etl_id varchar 100  √  null
accession varchar 50  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
bio_assay_dataset_id Primary key Asc bio_dataset_pk
bio_assay_dataset_id Must be unique Asc bio_assay_dataset_pk

Close relationships  within of separation: