 	"EFFECTIVE_START_DATE" DATE, 
 	"EFFECTIVE_END_DATE" DATE
    ) SEGMENT CREATION IMMEDIATE 
-  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
-  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-  TABLESPACE "AM_MART_DATA_01" ;
---------------------------------------------------------
---  DDL for Index PK_RM_CASE_FOLLOWUP
---------------------------------------------------------
-
-  CREATE UNIQUE INDEX "MART_USER"."PK_RM_CASE_FOLLOWUP" ON "MART_USER"."RM_CASE_FOLLOWUP" ("ENTERPRISE_ID", "CASE_ID", "SEQ_NUM", "DLP_REVISION_NUMBER") 
-  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
-  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-  TABLESPACE "AM_MART_INDEX_01" ;
---------------------------------------------------------
---  DDL for Index I_RM_CASE_FOLLOWUP
---------------------------------------------------------
-
-  CREATE INDEX "MART_USER"."I_RM_CASE_FOLLOWUP" ON "MART_USER"."RM_CASE_FOLLOWUP" ("ENTERPRISE_ID", "CASE_ID", "EFFECTIVE_END_DATE") 
-  PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
-  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-  TABLESPACE "AM_MART_INDEX_01" ;
---------------------------------------------------------
---  Constraints for Table RM_CASE_FOLLOWUP
---------------------------------------------------------
-
-  ALTER TABLE "MART_USER"."RM_CASE_FOLLOWUP" ADD CONSTRAINT "PK_RM_CASE_FOLLOWUP" PRIMARY KEY ("ENTERPRISE_ID", "CASE_ID", "SEQ_NUM", "DLP_REVISION_NUMBER")
-  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 
-  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
-  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
-  TABLESPACE "AM_MART_INDEX_01"  ENABLE;
- 
-  ALTER TABLE "MART_USER"."RM_CASE_FOLLOWUP" MODIFY ("ENTERPRISE_ID" NOT NULL ENABLE);
- 
-  ALTER TABLE "MART_USER"."RM_CASE_FOLLOWUP" MODIFY ("DELETED_FLAG" NOT NULL ENABLE);
- 
-  ALTER TABLE "MART_USER"."RM_CASE_FOLLOWUP" MODIFY ("EFFECTIVE_START_DATE" NOT NULL ENABLE);
- 
-  ALTER TABLE "MART_USER"."RM_CASE_FOLLOWUP" MODIFY ("EFFECTIVE_END_DATE" NOT NULL ENABLE);
---------------------------------------------------------
---  File created - Saturday-April-04-2015   
---------------------------------------------------------
---------------------------------------------------------
---  DDL for Table RM_CASE_MASTER
---------------------------------------------------------
 
   create table "RM_CASE_MASTER" 
    (	"ENTERPRISE_ID" NUMBER , 

	"WHO_DRUG_CODE" varchar(45), 
	"CO_DRUG_CODE" varchar(20), 
	"PRODUCT_NAME" varchar(70), 
	"GENERIC_NAME" CLOB, 
	"GENERIC_NAME_J" CLOB, 
	"UD_TEXT_1" varchar(100), 
	"UD_TEXT_2" varchar(100), 
	"UD_TEXT_3" varchar(100), 

	"EFFECTIVE_START_DATE" DATE, 
	"EFFECTIVE_END_DATE" DATE
   ) SEGMENT CREATION IMMEDIATE 

  create table "RM_CASE_CLASSIFICATIONS" 
   (	"ENTERPRISE_ID" NUMBER , 
