Table transmart.biomart.bio_lit_ref_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_lit_ref_data_id int8 19
bio_data_literature.bio_lit_ref_data_id Implied Constraint R
bio_lit_alt_data.bio_lit_ref_data_id bio_lit_alt_ref_fk R
bio_lit_inh_data.bio_lit_ref_data_id bio_lit_inh_ref_fk R
bio_lit_int_data.bio_lit_ref_data_id bio_lit_int_ref_fk R
bio_lit_pe_data.bio_lit_ref_data_id bio_lit_pe_ref_fk R
etl_id varchar 50  √  null
component varchar 100  √  null
component_class varchar 250  √  null
gene_id varchar 50  √  null
molecule_type varchar 50  √  null
variant varchar 250  √  null
reference_type varchar 50  √  null
reference_id varchar 250  √  null
reference_title varchar 2000  √  null
back_references varchar 1000  √  null
study_type varchar 250  √  null
disease varchar 250  √  null
disease_icd10 varchar 250  √  null
disease_mesh varchar 250  √  null
disease_site varchar 250  √  null
disease_stage varchar 250  √  null
disease_grade varchar 250  √  null
disease_types varchar 250  √  null
disease_description varchar 1000  √  null
physiology varchar 250  √  null
stat_clinical varchar 500  √  null
stat_clinical_correlation varchar 250  √  null
stat_tests varchar 500  √  null
stat_coefficient varchar 500  √  null
stat_p_value varchar 100  √  null
stat_description varchar 1000  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
bio_lit_ref_data_id Primary key Asc bio_lit_ref_data_pk

Close relationships  within of separation: