Table transmart.biomart.bio_assay 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_id int8 19
bio_assay_data.bio_assay_id Implied Constraint R
bio_assay_dataset.bio_assay_id Implied Constraint R
bio_assay_sample.bio_assay_id bio_assay_sample_bio_assay_fk R
etl_id varchar 100
study varchar 200  √  null
protocol varchar 200  √  null
description text 2147483647  √  null
sample_type varchar 200  √  null
experiment_id int8 19
bio_experiment.bio_experiment_id dataset_experiment_fk R
test_date timestamp 29,6  √  null
sample_receive_date timestamp 29,6  √  null
requestor varchar 200  √  null
bio_assay_type varchar 200
bio_assay_platform_id int8 19  √  null
bio_assay_platform.bio_assay_platform_id bio_asy_asy_pfm_fk R
biosource varchar 200  √  null
measurement_type varchar 200  √  null
technology varchar 200  √  null
vendor varchar 200  √  null
platform_design varchar 200  √  null
biomarkers_studied varchar 200  √  null
biomarkers_type varchar 200  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
bio_assay_id Primary key Asc rbmorderdim_pk
bio_assay_id Must be unique Asc bio_assay_pk

Close relationships  within of separation: