Table transmart.biomart.ctd2_trial_details 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
ctd_td_seq int8 19  √  null
ctd_study_id int8 19  √  null
control varchar 2000  √  null
blinding_procedure varchar 2000  √  null
no_of_arms varchar 2000  √  null
sponsor varchar 2000  √  null
patient_studied varchar 2000  √  null
source_type varchar 2000  √  null
trial_description varchar 4000  √  null
arm_name varchar 250  √  null
patient_study varchar 250  √  null
class_type varchar 250  √  null
class_value varchar 250  √  null
asthma_duration varchar 250  √  null
region varchar 250  √  null
age varchar 100  √  null
gender varchar 100  √  null
minor_participation varchar 100  √  null
symptom_score varchar 100  √  null
rescue_medication varchar 2000  √  null
therapeutic_intervention varchar 255  √  null
smokers varchar 255  √  null
former_smokers varchar 255  √  null
never_smokers varchar 255  √  null
smoking_pack_years varchar 255  √  null
pulm_path_name varchar 255  √  null
pulm_path_pct varchar 50  √  null
pulm_path_value varchar 50  √  null
pulm_path_method varchar 255  √  null
allow_med_therapy_ocs varchar 1000  √  null
allow_med_therapy_ics varchar 1000  √  null
allow_med_therapy_laba varchar 1000  √  null
allow_med_therapy_ltra varchar 1000  √  null
allow_med_therapy_desc varchar 4000  √  null
allow_med_therapy_cortster varchar 1000  √  null
allow_med_therapy_immuno varchar 1000  √  null
allow_med_therapy_cyto varchar 1000  √  null
allow_med_treat_ocs varchar 1000  √  null
allow_med_treat_ics varchar 1000  √  null
allow_med_treat_laba varchar 1000  √  null
allow_med_treat_ltra varchar 1000  √  null
allow_med_treat_desc varchar 4000  √  null
allow_med_treat_cortster varchar 1000  √  null
allow_med_treat_immuno varchar 1000  √  null
allow_med_treat_cyto varchar 1000  √  null
pat_char_base_clin_var varchar 500  √  null
pat_char_base_clin_var_pct varchar 250  √  null
pat_char_base_clin_var_value varchar 250  √  null
biomarker_name_name varchar 250  √  null
pat_char_biomarker_pct varchar 250  √  null
pat_char_biomarker_value varchar 250  √  null
pat_char_cellinfo_name varchar 250  √  null
pat_char_cellinfo_type varchar 250  √  null
pat_char_cellinfo_count varchar 250  √  null
pat_char_priormed_name varchar 250  √  null
pat_char_priormed_pct varchar 500  √  null
pat_char_priormed_dose varchar 250  √  null
disease_phenotype_name varchar 1000  √  null
disease_severity_name varchar 500  √  null
incl_age varchar 2000  √  null
incl_difficult_to_treat varchar 2000  √  null
incl_disease_diagnosis varchar 2000  √  null
incl_steroid_dose varchar 2000  √  null
incl_laba varchar 2000  √  null
incl_ocs varchar 2000  √  null
incl_xolair varchar 2000  √  null
incl_ltra_inhibitor varchar 2000  √  null
incl_fev1 varchar 2000  √  null
incl_fev1_reversibility varchar 2000  √  null
incl_smoking varchar 2000  √  null
incl_tlc varchar 2000  √  null
incl_fvc varchar 2000  √  null
incl_dlco varchar 2000  √  null
incl_sgrq varchar 2000  √  null
incl_hrct varchar 2000  √  null
incl_biopsy varchar 2000  √  null
incl_dypsnea_on_exertion varchar 2000  √  null
incl_concomitant_med varchar 2000  √  null
incl_former_smokers varchar 2000  √  null
incl_never_smokers varchar 2000  √  null
incl_smoking_pack_years varchar 2000  √  null
incl_fev_fvc varchar 2000  √  null
trial_des_minimal_symptom varchar 2000  √  null
trial_des_rescue_med varchar 4000  √  null
trial_des_exclusion_criteria varchar 4000  √  null
trial_des_open_label_status varchar 250  √  null
trial_des_random_status varchar 250  √  null
trial_des_nature_of_trial varchar 250  √  null
trial_des_blinded_status varchar 250  √  null
trial_des_run_in_period varchar 2000  √  null
trial_des_treatment varchar 2000  √  null
trial_des_washout_period varchar 2000  √  null
trial_status_name varchar 2000  √  null
trial_phase_name varchar 2000  √  null

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