 	"DELETED" DATE, 
 	"INCL_RESEARCH" NUMBER
    ) 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_LM_REPORT_TYPE
---------------------------------------------------------
-
-  CREATE UNIQUE INDEX "MART_USER"."PK_RM_LM_REPORT_TYPE" ON "MART_USER"."RM_LM_REPORT_TYPE" ("ENTERPRISE_ID", "RPT_TYPE_ID") 
-  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_LM_REPORT_TYPE
---------------------------------------------------------
-
-  ALTER TABLE "MART_USER"."RM_LM_REPORT_TYPE" ADD CONSTRAINT "PK_RM_LM_REPORT_TYPE" PRIMARY KEY ("ENTERPRISE_ID", "RPT_TYPE_ID")
-  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_LM_REPORT_TYPE" MODIFY ("ENTERPRISE_ID" NOT NULL ENABLE);
- 
-  ALTER TABLE "MART_USER"."RM_LM_REPORT_TYPE" MODIFY ("REPORT_TYPE" NOT NULL ENABLE);
- 
-  ALTER TABLE "MART_USER"."RM_LM_REPORT_TYPE" MODIFY ("INCL_RESEARCH" NOT NULL ENABLE);
---------------------------------------------------------
---  File created - Saturday-April-04-2015   
---------------------------------------------------------
---------------------------------------------------------
---  DDL for Table RM_MEDDRA_SMQ_CONTENT
---------------------------------------------------------
 
   create table "RM_MEDDRA_SMQ_CONTENT" 
    (	"GLOBAL_DICT_ID" NUMBER , 

	"DELETED_FLAG" NUMBER(1,0), 
	"EFFECTIVE_START_DATE" DATE, 
	"EFFECTIVE_END_DATE" DATE, 
	"NOTES" CLOB, 
	"NOTES_J" CLOB, 
	"INSTITUTION_ID" varchar(15 CHAR)
   ) 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" 
 LOB ("NOTES") STORE AS BASICFILE "RCR_NOTES_CLOB"(
  TABLESPACE "AM_MART_LOB_01" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION 
  NOCACHE 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)) 
 LOB ("NOTES_J") STORE AS BASICFILE "RCR_NOTES_J_CLOB"(
  TABLESPACE "AM_MART_LOB_01" ENABLE STORAGE IN ROW CHUNK 8192 RETENTION 
  NOCACHE 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)) ;
--------------------------------------------------------
--  DDL for Index PK_RM_CASE_REPORTERS
--------------------------------------------------------

  CREATE UNIQUE INDEX "MART_USER"."PK_RM_CASE_REPORTERS" ON "MART_USER"."RM_CASE_REPORTERS" ("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_REPORTERS
--------------------------------------------------------

  CREATE INDEX "MART_USER"."I_RM_CASE_REPORTERS" ON "MART_USER"."RM_CASE_REPORTERS" ("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_REPORTERS
--------------------------------------------------------

  ALTER TABLE "MART_USER"."RM_CASE_REPORTERS" ADD CONSTRAINT "PK_RM_CASE_REPORTERS" 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_REPORTERS" MODIFY ("ENTERPRISE_ID" NOT NULL ENABLE);
 
  ALTER TABLE "MART_USER"."RM_CASE_REPORTERS" MODIFY ("DELETED_FLAG" NOT NULL ENABLE);
 
  ALTER TABLE "MART_USER"."RM_CASE_REPORTERS" MODIFY ("EFFECTIVE_START_DATE" NOT NULL ENABLE);
 
  ALTER TABLE "MART_USER"."RM_CASE_REPORTERS" MODIFY ("EFFECTIVE_END_DATE" NOT NULL ENABLE);
--------------------------------------------------------
--  File created - Saturday-April-04-2015   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table RM_CASE_STUDY
--------------------------------------------------------

  create table "RM_CASE_STUDY" 
   (	"ENTERPRISE_ID" NUMBER , 

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

  create table "RM_CASE_EVENT_ASSESS" 
   (	"ENTERPRISE_ID" NUMBER , 
