Ext_DSKR_CTI
Tables (5)
CTI_ClinicalTrials
- nctid — varchar(100) — NOT NULL
- trial_type — varchar(50) — NOT NULL
- recruitment_status — varchar(max)
- phase_result — varchar(max)
- inclusion_criteria_in_indication — varchar(max)
- primary_outcome_measures — varchar(max)
- salts_matching — varchar(max)
- roa — varchar(max)
- dosage — varchar(max)
- off_label — varchar(max)
- reason_for_off_label — varchar(max)
- validation_result — varchar(max)
- openyn — char(1) — NOT NULL
clinical_trial_gov
- nctid — varchar(20) — Primary key — NOT NULL
- orgstudyid — varchar(max)
- orgfullname — varchar(max)
- orgclass — varchar(max)
- brieftitle — varchar(max)
- officialtitle — varchar(max)
- statusverifieddate — varchar(max)
- overallstatus — varchar(max)
- hasexpandedaccess — varchar(max)
- startdate — varchar(max)
- startdatetype — varchar(max)
- primarycompletiondate — varchar(max)
- primarycompletiondatetype — varchar(max)
- completiondate — varchar(max)
- completiondatetype — varchar(max)
- studyfirstsubmitdate — varchar(max)
- studyfirstsubmitqcdate — varchar(max)
- studyfirstpostdate — varchar(max)
- studyfirstpostdatetype — varchar(max)
- resultsfirstsubmitdate — varchar(max)
- resultsfirstsubmitqcdate — varchar(max)
- resultsfirstpostdate — varchar(max)
- resultsfirstpostdatetype — varchar(max)
- lastupdatesubmitdate — varchar(max)
- lastupdatepostdate — varchar(max)
- lastupdatepostdatetype — varchar(max)
- responsiblepartytype — varchar(max)
- responsiblepartyinvestigatorfullname — varchar(max)
- responsiblepartyinvestigatortitle — varchar(max)
- responsiblepartyinvestigatoraffiliation — varchar(max)
- leadsponsorname — varchar(max)
- leadsponsorclass — varchar(max)
- oversighthasdmc — varchar(max)
- isfdaregulateddrug — varchar(max)
- isfdaregulateddevice — varchar(max)
- briefsummary — varchar(max)
- detaileddescription — varchar(max)
- condition — varchar(max)
- keyword — varchar(max)
- studytype — varchar(max)
- phase — varchar(max)
- designallocation — varchar(max)
- designinterventionmodel — varchar(max)
- designinterventionmodeldescription — varchar(max)
- designprimarypurpose — varchar(max)
- designmasking — varchar(max)
- designmaskingdescription — varchar(max)
- designwhomasked — varchar(max)
- enrollmentcount — varchar(max)
- enrollmenttype — varchar(max)
- armgrouplabel — varchar(max)
- armgrouptype — varchar(max)
- armgroupdescription — varchar(max)
- armgroupinterventionname — varchar(max)
- interventiontype — varchar(max)
- interventionname — varchar(max)
- interventiondescription — varchar(max)
- interventionarmgrouplabel — varchar(max)
- interventionothername — varchar(max)
- primaryoutcomemeasure — varchar(max)
- … +184
kdca
- trial_id — varchar(50)
- public_title_kr — varchar(max)
- public_title_en — varchar(max)
- scientific_title_kr — varchar(max)
- scientific_title_en — varchar(max)
- date_registration — varchar(max)
- date_updated — varchar(max)
- scientific_name_kr — varchar(max)
- scientific_name_en — varchar(max)
- affiliation_kr — varchar(max)
- affiliation_en — varchar(max)
- public_name_kr — varchar(max)
- public_name_en — varchar(max)
- telephone — varchar(max)
- public_affiliation_kr — varchar(max)
- public_affiliation_en — varchar(max)
- recruitment_status_kr — varchar(max)
- recruitment_status_en — varchar(max)
- date_enrolment — varchar(max)
- type_enrolment_kr — varchar(max)
- type_enrolment_en — varchar(max)
- target_size — varchar(max)
- results_date_completed — varchar(max)
- results_type_date_completed_kr — varchar(max)
- results_type_date_completed_en — varchar(max)
- study_summary_kr — varchar(max)
- study_summary_en — varchar(max)
- study_type_kr — varchar(max)
- study_type_en — varchar(max)
- primary_purpose_kr — varchar(max)
- primary_purpose_en — varchar(max)
- phase_kr — varchar(max)
- phase_en — varchar(max)
- intervention_model_kr — varchar(max)
- intervention_model_en — varchar(max)
- blinding_masking_kr — varchar(max)
- blinding_masking_en — varchar(max)
- blinding_masking_target_kr — varchar(max)
- blinding_masking_target_en — varchar(max)
- allocation_kr — varchar(max)
- allocation_en — varchar(max)
- i_freetext_type_kr — varchar(max)
- i_freetext_type_en — varchar(max)
- i_freetext_kr — varchar(max)
- i_freetext_en — varchar(max)
- time_perspective_kr — varchar(max)
- time_perspective_en — varchar(max)
- group_number — varchar(max)
- biospecimen_retention_kr — varchar(max)
- biospecimen_retention_en — varchar(max)
- hc_code_kr — varchar(max)
- hc_code_en — varchar(max)
- target_gender_kr — varchar(max)
- target_gender_en — varchar(max)
- target_age_range_kr — varchar(max)
- target_age_range_en — varchar(max)
- primary_outcome_type_kr — varchar(max)
- primary_outcome_type_en — varchar(max)
- source_name_kr — varchar(max)
- source_name_en — varchar(max)
- … +17
pubmed
- pmid — varchar(50)
- articletitle — varchar(max)
- isoabbreviation — varchar(50)
test
- id — int
- nctid — varchar(20)
- product — varchar(max)
- keyword — varchar(max)
- primaryoutcomemeasure — varchar(max)