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)