Table transmart.biomart.ctd_full 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
clinical_trial_design_id int8 19  √  null
ref_article_protocol_id varchar 4000  √  null
ref_record_id varchar 4000  √  null
ref_back_reference varchar 4000  √  null
ref_article_pmid varchar 4000  √  null
ref_protocol_id varchar 4000  √  null
ref_title varchar 4000  √  null
study_type varchar 4000  √  null
common_name varchar 4000  √  null
icd10 varchar 4000  √  null
mesh varchar 4000  √  null
disease_type varchar 4000  √  null
physiology_name varchar 4000  √  null
trial_status varchar 4000  √  null
trial_phase varchar 4000  √  null
nature_of_trial varchar 4000  √  null
randomization varchar 4000  √  null
blinded_trial varchar 4000  √  null
trial_type varchar 4000  √  null
run_in_period varchar 4000  √  null
treatment_period varchar 4000  √  null
washout_period varchar 4000  √  null
open_label_extension varchar 4000  √  null
sponsor varchar 4000  √  null
trial_nbr_of_patients_studied varchar 4000  √  null
source_type varchar 4000  √  null
trial_age varchar 4000  √  null
disease_severity varchar 4000  √  null
difficult_to_treat varchar 4000  √  null
asthma_diagnosis varchar 4000  √  null
inhaled_steroid_dose varchar 4000  √  null
laba varchar 4000  √  null
ocs varchar 4000  √  null
xolair varchar 4000  √  null
ltra_inhibitors varchar 4000  √  null
asthma_phenotype varchar 4000  √  null
fev1 varchar 4000  √  null
fev1_reversibility varchar 4000  √  null
tlc varchar 4000  √  null
fev1_fvc varchar 4000  √  null
fvc varchar 4000  √  null
dlco varchar 4000  √  null
sgrq varchar 4000  √  null
hrct varchar 4000  √  null
biopsy varchar 4000  √  null
dyspnea_on_exertion varchar 4000  √  null
concomitant_med varchar 4000  √  null
trial_smokers_pct varchar 4000  √  null
trial_former_smokers_pct varchar 4000  √  null
trial_never_smokers_pct varchar 4000  √  null
trial_pack_years varchar 4000  √  null
exclusion_criteria text 2147483647  √  null
minimal_symptoms varchar 4000  √  null
rescue_medication_use varchar 4000  √  null
control_details varchar 4000  √  null
blinding_procedure varchar 4000  √  null
number_of_arms varchar 4000  √  null
description text 2147483647  √  null
arm varchar 4000  √  null
arm_nbr_of_patients_studied varchar 4000  √  null
arm_classification_type varchar 4000  √  null
arm_classification_value varchar 4000  √  null
arm_asthma_duration varchar 4000  √  null
arm_geographic_region varchar 4000  √  null
arm_age varchar 4000  √  null
arm_gender varchar 4000  √  null
arm_smokers_pct varchar 4000  √  null
arm_former_smokers_pct varchar 4000  √  null
arm_never_smokers_pct varchar 4000  √  null
arm_pack_years varchar 4000  √  null
minority_participation varchar 4000  √  null
baseline_symptom_score varchar 4000  √  null
baseline_rescue_medication_use varchar 4000  √  null
clinical_variable varchar 4000  √  null
clinical_variable_pct varchar 4000  √  null
clinical_variable_value varchar 4000  √  null
prior_med_drug_name varchar 4000  √  null
prior_med_pct varchar 4000  √  null
prior_med_value varchar 4000  √  null
biomarker_name varchar 4000  √  null
biomarker_pct varchar 4000  √  null
biomarker_value varchar 4000  √  null
cellinfo_type varchar 4000  √  null
cellinfo_count varchar 4000  √  null
cellinfo_source varchar 4000  √  null
pulmonary_pathology_name varchar 4000  √  null
pulmpath_patient_pct varchar 4000  √  null
pulmpath_value_unit varchar 4000  √  null
pulmpath_method varchar 4000  √  null
runin_ocs varchar 4000  √  null
runin_ics varchar 4000  √  null
runin_laba varchar 4000  √  null
runin_ltra varchar 4000  √  null
runin_corticosteroids varchar 4000  √  null
runin_anti_fibrotics varchar 4000  √  null
runin_immunosuppressive varchar 4000  √  null
runin_cytotoxic varchar 4000  √  null
runin_description varchar 4000  √  null
trtmt_ocs varchar 4000  √  null
trtmt_ics varchar 4000  √  null
trtmt_laba varchar 4000  √  null
trtmt_ltra varchar 4000  √  null
trtmt_corticosteroids varchar 4000  √  null
trtmt_anti_fibrotics varchar 4000  √  null
trtmt_immunosuppressive varchar 4000  √  null
trtmt_cytotoxic varchar 4000  √  null
trtmt_description varchar 4000  √  null
drug_inhibitor_common_name varchar 4000  √  null
drug_inhibitor_standard_name varchar 4000  √  null
drug_inhibitor_cas_id varchar 4000  √  null
drug_inhibitor_dose varchar 4000  √  null
drug_inhibitor_route_of_admin varchar 4000  √  null
drug_inhibitor_trtmt_regime varchar 4000  √  null
comparator_name varchar 4000  √  null
comparator_dose varchar 4000  √  null
comparator_time_period varchar 4000  √  null
comparator_route_of_admin varchar 4000  √  null
treatment_regime varchar 4000  √  null
placebo varchar 4000  √  null
experiment_description varchar 4000  √  null
primary_endpoint_type varchar 4000  √  null
primary_endpoint_definition varchar 4000  √  null
primary_endpoint_change varchar 4000  √  null
primary_endpoint_time_period varchar 4000  √  null
primary_endpoint_stat_test varchar 4000  √  null
primary_endpoint_p_value varchar 4000  √  null
secondary_type varchar 4000  √  null
secondary_type_definition varchar 4000  √  null
secondary_type_change varchar 4000  √  null
secondary_type_time_period varchar 4000  √  null
secondary_type_p_value varchar 4000  √  null
secondary_type_stat_test varchar 4000  √  null
clinical_variable_name varchar 4000  √  null
pct_change_from_baseline varchar 4000  √  null
abs_change_from_baseline varchar 4000  √  null
rate_of_change_from_baseline varchar 4000  √  null
average_over_treatment_period varchar 4000  √  null
within_group_changes varchar 4000  √  null
stat_measure_p_value varchar 4000  √  null
definition_of_the_event varchar 4000  √  null
number_of_events varchar 4000  √  null
event_rate varchar 4000  √  null
time_to_event varchar 4000  √  null
event_pct_reduction varchar 4000  √  null
event_p_value varchar 4000  √  null
event_description varchar 4000  √  null
discontinuation_rate varchar 4000  √  null
response_rate varchar 4000  √  null
downstream_signaling_effects varchar 4000  √  null
beneficial_effects varchar 4000  √  null
adverse_effects varchar 4000  √  null
pk_pd_parameter varchar 4000  √  null
pk_pd_value varchar 4000  √  null
effect_description varchar 4000  √  null
biomolecule_name varchar 4000  √  null
biomolecule_id varchar 4000  √  null
biomolecule_type varchar 4000  √  null
biomarker varchar 4000  √  null
biomarker_type varchar 4000  √  null
baseline_expr_pct varchar 4000  √  null
baseline_expr_number varchar 4000  √  null
baseline_expr_value_fold_mean varchar 4000  √  null
baseline_expr_sd varchar 4000  √  null
baseline_expr_sem varchar 4000  √  null
baseline_expr_unit varchar 4000  √  null
expr_after_trtmt_pct varchar 4000  √  null
expr_after_trtmt_number varchar 4000  √  null
expr_aftertrtmt_valuefold_mean varchar 4000  √  null
expr_after_trtmt_sd varchar 4000  √  null
expr_after_trtmt_sem varchar 4000  √  null
expr_after_trtmt_unit varchar 4000  √  null
expr_chg_source_type varchar 4000  √  null
expr_chg_technique varchar 4000  √  null
expr_chg_description varchar 4000  √  null
clinical_correlation varchar 4000  √  null
statistical_test varchar 4000  √  null
statistical_coefficient_value varchar 4000  √  null
statistical_test_p_value varchar 4000  √  null
statistical_test_description varchar 4000  √  null
drug_inhibitor_time_period varchar 4000  √  null

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