CREATE TABLE "PULSEUI"."MESSAGES"
   (	"TO_USER_ID" NUMBER NOT NULL ENABLE,
	"FROM_USER_ID" NUMBER NOT NULL ENABLE,
	"MESSAGE_TYPE_CODE" VARCHAR2(3) NOT NULL ENABLE,
	"MESSAGE_SUBJECT" VARCHAR2(50),
	"MESSAGE_BODY" VARCHAR2(4000),
	"READ_STATUS" CHAR(1),
	"DELETED_FLAG" CHAR(1),
	"STARRED_FLAG" CHAR(1),
	"CREATED_DT" DATE DEFAULT CURRENT_TIMESTAMP NOT NULL ENABLE,
	"DELETED_DT" DATE,
	"MESSAGE_ID" NUMBER(10,0) NOT NULL ENABLE,
	"EXPIRATION_DT" DATE DEFAULT (sysdate +30) NOT NULL ENABLE,
	"MESSAGE_SUBJECT_FR" VARCHAR2(55),
	"MESSAGE_BODY_FR" VARCHAR2(4000),
	 CONSTRAINT "MESSAGES_FROMUSER_FK" FOREIGN KEY ("FROM_USER_ID")
	  REFERENCES "PULSEUI"."PULSE_USER" ("USER_ID") ENABLE,
	 CONSTRAINT "MESSAGES_TOUSER_FK" FOREIGN KEY ("TO_USER_ID")
	  REFERENCES "PULSEUI"."PULSE_USER" ("USER_ID") ENABLE,
	 CONSTRAINT "MESSAGES_TYPE_FK" FOREIGN KEY ("MESSAGE_TYPE_CODE")
	  REFERENCES "PULSEUI"."MESSAGE_TYPE" ("MESSAGE_TYPE_CODE") ENABLE
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  TABLESPACE "PULSEUI_DATA"


GRANT SELECT ON MESSAGES TO INFA_RO
/

GRANT DELETE, INSERT, SELECT, UPDATE ON MESSAGES TO INFORMATICA_USER
/

GRANT SELECT ON MESSAGES TO PULSEUI_RO
/

GRANT SELECT ON MESSAGES TO PULSE_AUDIT
/

GRANT SELECT ON MESSAGES TO PULSE_RO
/

GRANT DELETE, INSERT, UPDATE ON MESSAGES TO PULSE_RW
/

GRANT SELECT ON MESSAGES TO X122750
/

GRANT DELETE, INSERT, SELECT, UPDATE ON MESSAGES TO X393528
/

GRANT SELECT ON MESSAGES TO XPCTR287243
/