


DROP TABLE OMALERT.OM_ALERT_SENDER CASCADE CONSTRAINTS ;
/
CREATE TABLE OMALERT.OM_ALERT_SENDER (
  SENDER_ID            NUMBER (5)    NOT NULL,
  SENDER_NAME          VARCHAR2 (50)  NOT NULL,
  SENDER_ADDRESS_TYPE  VARCHAR2 (10)  NOT NULL,
  SENDER_ADDRESS       VARCHAR2 (100)  NOT NULL,
  SENDER_DESCRIPTION   VARCHAR2 (100),
  CONSTRAINT PK_OMALERT_SENDER
  PRIMARY KEY ( SENDER_ID ) ) ;
/

ALTER TABLE OMALERT.OM_ALERT_SENDER ADD  CONSTRAINT UK_OMALERT_SENDER
 UNIQUE (SENDER_NAME, SENDER_ADDRESS_TYPE, SENDER_ADDRESS) ;
/



GRANT ALTER ON OMALERT.OM_ALERT_SENDER TO PUBLIC;
/

GRANT DELETE ON OMALERT.OM_ALERT_SENDER TO PUBLIC;
/

GRANT INDEX ON OMALERT.OM_ALERT_SENDER TO PUBLIC;
/

GRANT INSERT ON OMALERT.OM_ALERT_SENDER TO PUBLIC;
/

GRANT SELECT ON OMALERT.OM_ALERT_SENDER TO PUBLIC;
/

GRANT UPDATE ON OMALERT.OM_ALERT_SENDER TO PUBLIC;
/

GRANT REFERENCES ON OMALERT.OM_ALERT_SENDER TO PUBLIC;
/




CREATE PUBLIC SYNONYM OM_ALERT_SENDER FOR OMALERT.OM_ALERT_SENDER;
/
