refactions3.out

derby database source code.good for you.

                              C1 CHAR(3) NOT NULL,
                              C2 CHAR(3),
                              PRIMARY KEY (C0, C1));
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E120_T2 (C0 CHAR(3),
                              C1 CHAR(3),
                              C0b CHAR(3),
                              C2 CHAR(3),
                              CONSTRAINT E120_T1_T2  FOREIGN KEY (C0b, C2)
                              REFERENCES refint.E120_T1 ON DELETE RESTRICT);
0 rows inserted/updated/deleted
ij> CREATE VIEW refint.E120_V1 AS SELECT * FROM refint.E120_T1;
0 rows inserted/updated/deleted
ij> CREATE VIEW refint.E120_V2 AS SELECT * FROM refint.E120_V1;
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.RJCE120_T1 (C0 INTEGER NOT NULL,
                                 C1 INTEGER NOT NULL,
                                 C2 INTEGER,
                                 PRIMARY KEY (C0, C1));
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.RJCE120_T2 (C0 INTEGER NOT NULL,
                                 C1 INTEGER NOT NULL,
                                 C0b   INTEGER,
                                 C2   INTEGER,
                                 PRIMARY KEY (C0, C1),
                                 CONSTRAINT RJCE120_T1_T2 FOREIGN KEY (C0b, C2)
                                 REFERENCES refint.RJCE120_T1 ON DELETE RESTRICT);
0 rows inserted/updated/deleted
ij> CREATE VIEW refint.RJCE120_V1 AS SELECT * FROM refint.RJCE120_T1;
0 rows inserted/updated/deleted
ij> CREATE VIEW refint.RJCE120_V2 AS SELECT * FROM refint.RJCE120_V1;
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E130_T1 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0, C1));
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E130_T2 (C0 CHAR(3),
                              C1 CHAR(3),
                              C0b  CHAR(3),
                              C2   CHAR(3),
                              CONSTRAINT E130_T1_T2 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E130_T1 ON DELETE SET NULL);
0 rows inserted/updated/deleted
ij> CREATE VIEW refint.E130_V1 AS SELECT * FROM refint.E130_T1;
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E140_T1 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E140_T2 (C0 CHAR(3),
                              C1 CHAR(3),
                              C0b CHAR(3),
                              C2  CHAR(3),
                              CONSTRAINT E140_T1_T2  FOREIGN KEY (C0b, C2)
                              REFERENCES refint.E140_T1 ON UPDATE RESTRICT);
0 rows inserted/updated/deleted
ij> CREATE VIEW refint.E140_V1 AS SELECT * FROM refint.E140_T1;
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E220_T1 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0, C1));
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E220_T2 (C0 CHAR(3),
                              C1 CHAR(3),
                              C0b  CHAR(3),
                              C2  CHAR(3),
                              CONSTRAINT FK13 FOREIGN KEY (C0b, C2)
                              REFERENCES refint.E220_T1 ON DELETE RESTRICT);
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E220_T3 (C0 CHAR(3),
                              C1 CHAR(3),
                              C0b  CHAR(3),
                              C2  CHAR(3),
                              CONSTRAINT FK32 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E220_T1 ON DELETE CASCADE);
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E230_T1 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E230_T2 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              C0b  CHAR(3)  ,
                              C2  CHAR(3)  ,
                              PRIMARY KEY (C0,C1),
                              CONSTRAINT FK14 FOREIGN KEY (C0b,C2)
                              REFERENCES refint.E230_T1 ON DELETE SET NULL);
0 rows inserted/updated/deleted
ij> 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);
0 rows inserted/updated/deleted
ij> CREATE VIEW refint.E230_V1 AS SELECT * FROM refint.E230_T1;
0 rows inserted/updated/deleted
ij> CREATE VIEW refint.E230_V2 (C1, C2) AS
    SELECT refint.E230_T2.C1, refint.E230_T3.C2
    FROM refint.E230_T2, refint.E230_T3;
0 rows inserted/updated/deleted
ij> 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));
0 rows inserted/updated/deleted
ij> 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);
0 rows inserted/updated/deleted
ij> 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);
0 rows inserted/updated/deleted
ij> CREATE VIEW refint.E240_V1 AS SELECT * FROM refint.E240_T1;
0 rows inserted/updated/deleted
ij> 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;
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E250_T1 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));
0 rows inserted/updated/deleted
ij> 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);
0 rows inserted/updated/deleted
ij> 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);
0 rows inserted/updated/deleted
ij> CREATE VIEW refint.E250_V1 AS SELECT * FROM refint.E250_T1;
0 rows inserted/updated/deleted
ij> 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;
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E260_T1 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));
0 rows inserted/updated/deleted
ij> 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);
0 rows inserted/updated/deleted
ij> 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);
0 rows inserted/updated/deleted
ij> CREATE VIEW refint.E260_V1 AS SELECT * FROM refint.E260_T1;
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E310_T1 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));
0 rows inserted/updated/deleted
ij> 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);
0 rows inserted/updated/deleted
ij> 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);
0 rows inserted/updated/deleted
ij> CREATE VIEW refint.E310_V1 AS SELECT * FROM refint.E310_T1;
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E360_T1 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));
0 rows inserted/updated/deleted
ij> 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);
0 rows inserted/updated/deleted
ij> 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);
0 rows inserted/updated/deleted
ij> CREATE VIEW refint.E360_V1 AS SELECT * FROM refint.E360_T1;
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E370_T1 (C1 CHAR(3) NOT NULL,
                              C0 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));
0 rows inserted/updated/deleted
ij> 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);
0 rows inserted/updated/deleted
ij> 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);
0 rows inserted/updated/deleted
ij> CREATE VIEW refint.E370_V1 AS SELECT * FROM refint.E370_T1;
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E340_T1 (C0 CHAR(3) NOT NULL,
                              C1 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));
0 rows inserted/updated/deleted
ij> 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);
0 rows inserted/updated/deleted
ij> 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);
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E410_T1 (C1 CHAR(3) NOT NULL,
                              C0 CHAR(3) NOT NULL,
                              PRIMARY KEY (C0,C1));
0 rows inserted/updated/deleted
ij> 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);
0 rows inserted/updated/deleted
ij> 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);
0 rows inserted/updated/deleted
ij> CREATE TABLE refint.E410_T4 (C0a CHAR(3),
                              C1 CHAR(3),
                              C0 CHAR(3),
                              C0b CHAR(3),
                              C2  CHAR(3),