--
-- Type: TABLE; Owner: BIOMART; Name: HEAT_MAP_RESULTS
--
 CREATE TABLE "BIOMART"."HEAT_MAP_RESULTS" 
  (	"SUBJECT_ID" VARCHAR2(50 BYTE), 
"LOG_INTENSITY" FLOAT(126), 
"COHORT_ID" VARCHAR2(255 BYTE), 
"PROBE_ID" VARCHAR2(100 BYTE), 
"BIO_ASSAY_FEATURE_GROUP_ID" NUMBER, 
"FOLD_CHANGE_RATIO" FLOAT(126), 
"TEA_NORMALIZED_PVALUE" FLOAT(126), 
"BIO_MARKER_NAME" VARCHAR2(400 BYTE), 
"BIO_MARKER_ID" NUMBER, 
"SEARCH_KEYWORD_ID" NUMBER, 
"BIO_ASSAY_ANALYSIS_ID" NUMBER, 
"TRIAL_NAME" VARCHAR2(50 BYTE), 
"SIGNIFICANT" NUMBER(*,0), 
"GENE_ID" VARCHAR2(200 BYTE), 
"ASSAY_ID" NUMBER, 
"PREFERRED_PVALUE" FLOAT(126)
  ) SEGMENT CREATION DEFERRED
 TABLESPACE "TRANSMART" ;

