refactions3.sql

derby database source code.good for you.

                              REFERENCES refint.E230_T1 ON DELETE SET NULL);

CREATE TABLE refint.E230_T3 (C0 CHAR(3),
                              C1 CHAR(3),
                              C0b  CHAR(3),
                              C2  CHAR(3),
                              CONSTRAINT FK33 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E230_T1 ON DELETE CASCADE);

CREATE VIEW refint.E230_V1 AS SELECT * FROM refint.E230_T1;
CREATE VIEW refint.E230_V2 (C1, C2) AS
    SELECT refint.E230_T2.C1, refint.E230_T3.C2
    FROM refint.E230_T2, refint.E230_T3;

CREATE TABLE refint.E240_T1 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3),
                              C2  CHAR(3)   NOT NULL,
                              C3  SMALLINT NOT NULL,
                              C4  INTEGER,
                              C5  DECIMAL(9,3) NOT NULL,
                              C6  VARCHAR(20) NOT NULL,
                              C7  DATE NOT NULL,
                              PRIMARY KEY (C0, C2, C6, C7));

CREATE TABLE refint.E240_T2 (C0 CHAR(3) NOT NULL,
                              C0a CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              C2  CHAR(3)  ,
                              C3  SMALLINT NOT NULL,
                              C4  DECIMAL(9,3) NOT NULL,
                              C5  VARCHAR(20),
                              C6  TIME,
                              C7  DATE NOT NULL,
                              PRIMARY KEY (C0,C1,C3),
                              CONSTRAINT E240_T1_T2_A FOREIGN KEY (C0a,C1,C5,C7)
                              REFERENCES refint.E240_T1 ON DELETE SET NULL);

CREATE TABLE refint.E240_T3 (C0 CHAR(3),
                              C0a CHAR(3),
                              C1 CHAR(3),
                              C2  CHAR(3)  ,
                              C3  SMALLINT NOT NULL,
                              C4  DECIMAL(9,3) NOT NULL,
                              C5  VARCHAR(20),
                              C6  TIME,
                              C7  DATE NOT NULL,
                              CONSTRAINT E240_T1_T2_B
                              FOREIGN KEY (C0a, C1, C5, C7)
                              REFERENCES refint.E240_T1 ON DELETE SET NULL);

CREATE VIEW refint.E240_V1 AS SELECT * FROM refint.E240_T1;
CREATE VIEW refint.E240_V2 (C1,C2,C3,C4,C5,C6,C7) AS
    SELECT refint.E240_T2.C1, refint.E240_T2.C2, refint.E240_T3.C3,
    refint.E240_T3.C4, refint.E240_T3.C5, refint.E240_T2.C6,
    refint.E240_T2.C7
    FROM refint.E240_T2,refint.E240_T3;

CREATE TABLE refint.E250_T1 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));

CREATE TABLE refint.E250_T2 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              C0b  CHAR(3),
                              C2  CHAR(3),
                              PRIMARY KEY (C0,C1),
                              CONSTRAINT E250_T1_T2 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E250_T1 ON DELETE RESTRICT);

CREATE TABLE refint.E250_T3 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              C2  CHAR(3),
                              C0b  CHAR(3),
                              PRIMARY KEY (C0,C1),
                              CONSTRAINT  E250_T1_T3 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E250_T1 ON DELETE RESTRICT);

CREATE VIEW refint.E250_V1 AS SELECT * FROM refint.E250_T1;
CREATE VIEW refint.E250_V2 (C1 ,C2) AS
    SELECT refint.E250_T2.C1, refint.E250_T3.C2
    FROM refint.E250_T2, refint.E250_T3
    WHERE refint.E250_T2.C1 = refint.E250_T3.C1;

CREATE TABLE refint.E260_T1 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));

CREATE TABLE refint.E260_T2 (C0 CHAR(3),
                              C1 CHAR(3),
                              C0b  CHAR(3),
                              C2  CHAR(3),
                              CONSTRAINT E260_T1_T2 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E260_T1);

CREATE TABLE refint.E260_T3 (C0 CHAR(3),
                              C1 CHAR(3),
                              C0b  CHAR(3),
                              C2  CHAR(3),
                              CONSTRAINT E260_T1_T3  FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E260_T1);

CREATE VIEW refint.E260_V1 AS SELECT * FROM refint.E260_T1;

CREATE TABLE refint.E310_T1 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));

CREATE TABLE refint.E310_T2 (C0 INTEGER NOT NULL,
                              C1 INTEGER NOT NULL,
                              C2  CHAR(3)  ,
                              C0b  CHAR(3)  ,
                              PRIMARY KEY (C0,C1),
                              CONSTRAINT FK15 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E310_T1 ON DELETE CASCADE);

CREATE TABLE refint.E310_T3 (C0 CHAR(3),
                              C1 CHAR(3),
                              C0b  INTEGER,
                              C2  INTEGER,
                              CONSTRAINT FK34 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E310_T2 ON DELETE CASCADE);

CREATE VIEW refint.E310_V1 AS SELECT * FROM refint.E310_T1;

CREATE TABLE refint.E360_T1 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));

CREATE TABLE refint.E360_T2 (C0 INT NOT NULL,
                              C1 DECIMAL(9,3) NOT NULL,
                              C0b  CHAR(3)  ,
                              C2  CHAR(3)  ,
                              PRIMARY KEY (C0,C1),
                              CONSTRAINT E360_T1_T2 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E360_T1 ON DELETE CASCADE);

CREATE TABLE refint.E360_T3 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              C0b INT,
                              C2  DECIMAL(9,3),
                              CONSTRAINT E360_T2_T3 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E360_T2 ON DELETE RESTRICT);

CREATE VIEW refint.E360_V1 AS SELECT * FROM refint.E360_T1;

CREATE TABLE refint.E370_T1 (C1 CHAR(3) NOT NULL,
                              C0 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));

CREATE TABLE refint.E370_T2 (C1 CHAR(3) NOT NULL,
                              C0 CHAR(3) NOT NULL,
                              C2  CHAR(3),
                              C0b  CHAR(3),
                              PRIMARY KEY (C0,C1),
                              CONSTRAINT FK16 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E370_T1 ON DELETE CASCADE);

CREATE TABLE refint.E370_T3 (C1 CHAR(3),
                              C0 CHAR(3),
                              C2  CHAR(3),
                              C0b  CHAR(3),
                              CONSTRAINT FK35 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E370_T2 ON DELETE SET NULL);

CREATE VIEW refint.E370_V1 AS SELECT * FROM refint.E370_T1;

CREATE TABLE refint.E340_T1 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));

CREATE TABLE refint.E340_T2 (C1 CHAR(3) NOT NULL,
                              C0 CHAR(3) NOT NULL,
                              C2  CHAR(3),
                              C0b  CHAR(3),
                              PRIMARY KEY (C0,C1),
                              CONSTRAINT FK17 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E340_T1 ON DELETE SET NULL);

CREATE TABLE refint.E340_T3 (C1 CHAR(3),
                              C0 CHAR(3),
                              C2  CHAR(3),
                              C0b  CHAR(3),
                              CONSTRAINT FK36 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E340_T2 ON DELETE RESTRICT);


CREATE TABLE refint.E410_T1 (C1 CHAR(3) NOT NULL,
                              C0 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));

CREATE TABLE refint.E410_T2 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              C2  CHAR(3) NOT NULL,
                              C0b  CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1,C2),
                              CONSTRAINT FK18 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E410_T1 ON DELETE CASCADE);

CREATE TABLE refint.E410_T3 (C1 CHAR(3) NOT NULL,
                              C0 CHAR(3) NOT NULL,
                              C0a CHAR(3),
                              C2  CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1,C2),
                              CONSTRAINT FK37 FOREIGN KEY (C0a,C1)
                              REFERENCES refint.E410_T1 ON DELETE CASCADE);

CREATE TABLE refint.E410_T4 (C0a CHAR(3),
                              C1 CHAR(3),
                              C0 CHAR(3),
                              C0b CHAR(3),
                              C2  CHAR(3),
                              C3  CHAR(3),
                              CONSTRAINT FK7 FOREIGN KEY (C0b,C2,C3)
                              REFERENCES refint.E410_T2 ON DELETE CASCADE,
                              CONSTRAINT FK8 FOREIGN KEY (C0a,C1,C2)
                              REFERENCES refint.E410_T3 ON DELETE CASCADE);


CREATE TABLE refint.E450_T1 (C1 CHAR(3) NOT NULL,
                              C0 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));

CREATE TABLE refint.E450_T2 (C1 CHAR(3) NOT NULL,
                              C0 CHAR(3) NOT NULL,
                              C2  CHAR(3) NOT NULL,
                              C0c  CHAR(3),
                              C3  CHAR(3),
                              PRIMARY KEY (C0,C1,C2),
                              CONSTRAINT FK20 FOREIGN KEY (C0c,C3)
                              REFERENCES refint.E450_T1 ON DELETE SET NULL);

CREATE TABLE refint.E450_T3 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              C2  CHAR(3) NOT NULL,
                              C0c  CHAR(3),
                              C3  CHAR(3),
                              PRIMARY KEY (C0,C1,C2),
                              CONSTRAINT FK38 FOREIGN KEY (C0c,C3)
                              REFERENCES refint.E450_T1 ON DELETE CASCADE);

CREATE TABLE refint.E450_T4 (C1 CHAR(3),
                              C0 CHAR(3),
                              C0a CHAR(3),
                              C0b  CHAR(3),
                              C2  CHAR(3),
                              C3  CHAR(3),
                              CONSTRAINT FK3 FOREIGN KEY (C0b,C2,C3)
                              REFERENCES refint.E450_T2 ON DELETE SET NULL,
                              CONSTRAINT FK4 FOREIGN KEY (C0a,C1,C2)
                              REFERENCES refint.E450_T3 ON DELETE CASCADE);


CREATE TABLE refint.E510_T1 (C1 CHAR(3) NOT NULL,
                              C0 CHAR(3) NOT NULL,
                              C0a CHAR(3),
                              C2 CHAR(3),
                              PRIMARY KEY (C0,C1));

CREATE TABLE refint.E510_T2 (C1 CHAR(3) NOT NULL,
                              C0 CHAR(3) NOT NULL,
                              C0b  CHAR(3),
                              C2  CHAR(3),
                              PRIMARY KEY (C0,C1),
                              CONSTRAINT FK21 FOREIGN KEY (c0b,C2)
                              REFERENCES refint.E510_T1 ON DELETE SET NULL);

CREATE TABLE refint.E510_T3 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              C2  CHAR(3),
                              C0b  CHAR(3),
                              PRIMARY KEY(C0,C1),
                              CONSTRAINT FK39 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E510_T2 ON DELETE SET NULL);

alter table refint.E510_T1 add CONSTRAINT CYC FOREIGN KEY (C0a,C1)
                REFERENCES refint.E510_T3 ON DELETE CASCADE;


CREATE VIEW refint.E510_V1 AS SELECT * FROM refint.E510_T3;

CREATE TABLE refint.E540_T1 (C0 CHAR(3) NOT NULL,
                              C0a CHAR(3),
                              C1 CHAR(3) NOT NULL,
                              C2 CHAR(3),
                              PRIMARY KEY (C0,C1));


CREATE TABLE refint.E540_T2 (C1 CHAR(3) NOT NULL,
                              C0 CHAR(3) NOT NULL,
                              C2  CHAR(3),
                              C0b  CHAR(3),
                              PRIMARY KEY (C0,C1),
                              CONSTRAINT E540_T1_T2  FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E540_T1 ON DELETE RESTRICT);

CREATE TABLE refint.E540_T3 (C1 CHAR(3) NOT NULL,
                              C0 CHAR(3) NOT NULL,
                              C2  CHAR(3),
                              C0b  CHAR(3),
                              PRIMARY KEY (C0,C1),
                              CONSTRAINT E540_T2_T3 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E540_T2 ON DELETE RESTRICT);


alter table refint.E540_T1 add CONSTRAINT E540_T3_T1 FOREIGN KEY (C0a,C1)
                              REFERENCES refint.E540_T3 ON DELETE RESTRICT;



CREATE TABLE refint.E560_T1 (C1 CHAR(3) NOT NULL,
                              C0a CHAR(3),
                              C0 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));


CREATE TABLE refint.E560_T2 (C1 CHAR(3) NOT NULL,
                              C0 CHAR(3) NOT NULL,
                              C2  CHAR(3),
                              C0b  CHAR(3),
                              PRIMARY KEY (C0,C1),
                              CONSTRAINT E560_T2_T1 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E560_T1 ON DELETE RESTRICT);

CREATE TABLE refint.E560_T3 (C1 CHAR(3) NOT NULL,
                              C0 CHAR(3) NOT NULL,
                              C2  CHAR(3),
                              C0b  CHAR(3),
                              PRIMARY KEY (C0,C1),
                              CONSTRAINT E560_T3_T2 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E560_T2 ON DELETE RESTRICT);


alter table refint.E560_T1  add CONSTRAINT E560_T1_T3  FOREIGN KEY (C0a,C1)
               REFERENCES refint.E560_T3 ON DELETE CASCADE;


CREATE TABLE refint.E550_T1 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              C0b CHAR(3),
                              C2 CHAR(3),
                              PRIMARY KEY (C0,C1));

CREATE TABLE refint.E550_T2 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              C0b  CHAR(3),
                              C2  CHAR(3),
                              PRIMARY KEY (C0,C1),
                              FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E550_T1 ON DELETE SET NULL);

CREATE TABLE refint.E550_T3 (C1 CHAR(3) NOT NULL,
                              C0 CHAR(3) NOT NULL,
                              C2  CHAR(3),
                              C0b  CHAR(3),