Table transmart.biomart.bio_sample 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
bio_assay_data.bio_sample_id bio_exp_data_fact_samp_fk R
bio_assay_data_stats.bio_sample_id bio_asy_dt_stats_smp_s_fk R
bio_assay_sample.bio_sample_id bio_assay_sample_bio_sample_fk R
bio_asy_data_stats_all.bio_sample_id bio_asy_dt_stats_smp_fk R
bio_sample_type varchar 200
characteristics varchar 1000  √  null
source_code varchar 200  √  null
experiment_id int8 19  √  null
bio_subject_id int8 19  √  null
bio_subject.bio_subject_id bio_sample_bio_subject_fk R
source varchar 200  √  null
bio_bank_id int8 19  √  null
bio_patient_event_id int8 19  √  null
bio_patient_event.bio_patient_event_id bio_sample_pt_evt_fk R
bio_cell_line_id int8 19  √  null
bio_cell_line.bio_cell_line_id bio_sample_cl_fk R
bio_sample_name varchar 100  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
bio_sample_id Primary key Asc biosample_pk
bio_sample_id Must be unique Asc bio_sample_pk

Close relationships  within of separation: