--
-- Type: TABLE; Owner: TM_LZ; Name: CLINICAL_TRIAL_METADATA_EXT
--
 CREATE TABLE "TM_LZ"."CLINICAL_TRIAL_METADATA_EXT" 
  (	"TRIAL" VARCHAR2(4000 BYTE), 
"TITLE" VARCHAR2(4000 BYTE), 
"DESCRIPTION" VARCHAR2(4000 BYTE), 
"CONDITION" VARCHAR2(4000 BYTE), 
"DISEASE_SUBTYPE" VARCHAR2(4000 BYTE), 
"DRUG_CNTO" VARCHAR2(4000 BYTE), 
"DRUG_NAME" VARCHAR2(4000 BYTE), 
"DESCRIPTIVE_TRIAL_NAME" VARCHAR2(4000 BYTE), 
"STUDY_OWNER" VARCHAR2(4000 BYTE), 
"BIOMARKER_DATA_OWNER" VARCHAR2(4000 BYTE), 
"STUDY_PHASE" VARCHAR2(4000 BYTE), 
"BLINDING_PROCEDURE" VARCHAR2(4000 BYTE), 
"STUDY_TYPE" VARCHAR2(4000 BYTE), 
"DURATION_OF_STUDY" VARCHAR2(4000 BYTE), 
"NUMBER_OF_PATIENTS" VARCHAR2(4000 BYTE), 
"NUMBER_OF_SITES" VARCHAR2(4000 BYTE), 
"ROUTE_OF_ADMIN" VARCHAR2(4000 BYTE), 
"DOSING_REGIMEN" VARCHAR2(4000 BYTE), 
"GROUP_ASSIGNMENT" VARCHAR2(4000 BYTE), 
"TYPE_OF_CONTROL" VARCHAR2(4000 BYTE), 
"STUDY_DESIGN" VARCHAR2(4000 BYTE), 
"COMPLETION_DATE" VARCHAR2(4000 BYTE), 
"PRIMARY_ENDPOINTS" VARCHAR2(4000 BYTE), 
"SECONDARY_ENDPOINTS" VARCHAR2(4000 BYTE), 
"INCLUSION_CRITERIA" VARCHAR2(4000 BYTE), 
"EXCLUSION_CRITERIA" VARCHAR2(4000 BYTE), 
"SUBJECTS" VARCHAR2(4000 BYTE), 
"GENDER_RESTRICTION" VARCHAR2(4000 BYTE), 
"MIN_AGE" VARCHAR2(4000 BYTE), 
"MAX_AGE" VARCHAR2(4000 BYTE), 
"SECONDARY_IDS" VARCHAR2(4000 BYTE), 
"PI" VARCHAR2(4000 BYTE), 
"DEVELOPMENT_PARTNER" VARCHAR2(4000 BYTE), 
"GEO_PLATFORM" VARCHAR2(4000 BYTE), 
"MAIN_FINDINGS" VARCHAR2(4000 BYTE), 
"PLATFORM_NAME" VARCHAR2(4000 BYTE), 
"STUDY_ID" VARCHAR2(50 BYTE), 
"SEARCH_AREA" VARCHAR2(100 BYTE), 
"EXPERIMENTAL_DESIGN" VARCHAR2(100 BYTE), 
"DATA_SOURCE" VARCHAR2(100 BYTE)
  ) SEGMENT CREATION DEFERRED
 TABLESPACE "TRANSMART" ;

