CREATE TABLE CHILD
(
TRX_CTRYCODE CHAR(3),
TRX_TRANSACTIONID INTEGER,
TRX_VERSION SMALLINT,
TRX_COMPONENTID SMALLINT
);

DROP TABLE PARENT;

CREATE TABLE PARENT
(
CTRYCODE CHAR(3) NOT NULL,
TRANSACTIONID INTEGER NOT NULL,
VERSION SMALLINT NOT NULL,
COMPONENTID SMALLINT NOT NULL
);

ALTER TABLE "PARENT" ADD CONSTRAINT "PK_PARENT" PRIMARY KEY
(CTRYCODE,TRANSACTIONID,VERSION,COMPONENTID);


ALTER TABLE CHILD ADD CONSTRAINT FK_CHILD_PARENT FOREIGN KEY
(TRX_CTRYCODE,TRX_TRANSACTIONID,TRX_VERSION,TRX_COMPONENTID)
REFERENCES PARENT
(CTRYCODE,TRANSACTIONID,VERSION,COMPONENTID)
ON DELETE CASCADE;