Table transmart.biomart.annotation 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
platform varchar 50  √  null
probeset varchar 50  √  null
gene_descr varchar 4000  √  null
gene_symbol varchar 4000  √  null
gene_id varchar 50  √  null
organism varchar 200  √  null
id int8 19
bio_species_organism.id Implied Constraint R
ctd_arm_view.id Implied Constraint R
ctd_biomarker_view.id Implied Constraint R
ctd_cell_info_view.id Implied Constraint R
ctd_clinical_chars_view.id Implied Constraint R
ctd_drug_effects_view.id Implied Constraint R
ctd_drug_inhibitor_view.id Implied Constraint R
ctd_events_view.id Implied Constraint R
ctd_experiments_view.id Implied Constraint R
ctd_expr_after_view.id Implied Constraint R
ctd_expr_baseline_view.id Implied Constraint R
ctd_expr_bio_view.id Implied Constraint R
ctd_expr_source_view.id Implied Constraint R
ctd_full_clinical_endpts_view.id Implied Constraint R
ctd_primary_endpts.id Implied Constraint R
ctd_primary_endpts_view.id Implied Constraint R
ctd_prior_med_use_view.id Implied Constraint R
ctd_pulmonary_path_view.id Implied Constraint R
ctd_quant_params_view.id Implied Constraint R
ctd_reference_view.id Implied Constraint R
ctd_runin_therapies_view.id Implied Constraint R
ctd_sec_endpts.id Implied Constraint R
ctd_secondary_endpts_view.id Implied Constraint R
ctd_stats_view.id Implied Constraint R
ctd_study_details_view.id Implied Constraint R
ctd_td_design_view.id Implied Constraint R
ctd_td_excl_view.id Implied Constraint R
ctd_td_inclusion_view.id Implied Constraint R
ctd_td_smoker_view.id Implied Constraint R
ctd_td_sponsor_view.id Implied Constraint R
ctd_td_status_view.id Implied Constraint R
ctd_treatment_phases_view.id Implied Constraint R
tests.id Implied Constraint R
tmp_bio_marker.id Implied Constraint R

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc annotation_pk

Close relationships: