View transmart.biomart.ctd_full_search_view 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
fact_id int8 19  √  null
ref_article_protocol_id varchar 4000  √  null
mesh varchar 4000  √  null
common_name varchar 4000  √  null
drug_inhibitor_standard_name varchar 4000  √  null
primary_endpoint_type varchar 4000  √  null
secondary_type varchar 4000  √  null
biomarker_name varchar 4000  √  null
disease_severity varchar 4000  √  null
inhaled_steroid_dose varchar 4000  √  null
fev1 varchar 4000  √  null
primary_endpoint_time_period varchar 4000  √  null
primary_endpoint_change varchar 4000  √  null
primary_endpoint_p_value varchar 4000  √  null

Analyzed at Wed Jun 26 00:10 CEST 2019