      
      /*
      ACTION is CREATE Table WEBSERVICETRANSACTION
      */

CREATE TABLE WEBSERVICETRANSACTION (
       WEBSERVICETRANSACTION_ID NUMBER NOT NULL,
       TIMESTAMP            DATE NOT NULL,
       TABLENAME            VARCHAR2(30) NOT NULL,
       WEBSERVICETYPE       VARCHAR2(1) NULL
                                   CONSTRAINT WebServiceType_valid
                                          CHECK (WEBSERVICETYPE IN ('A', 'U', 'D')),
       RECORD_ID            NUMBER NULL
);

COMMENT ON COLUMN WEBSERVICETRANSACTION.WEBSERVICETYPE IS 'A = Add
U = Update
D = Delete';

ALTER TABLE WEBSERVICETRANSACTION
       ADD  ( CONSTRAINT XPKWEBSERVICETRANSACTION PRIMARY KEY (
              WEBSERVICETRANSACTION_ID) ) ;



