CREATE TABLE Q (
    C          INTEGER NOT NULL,
    PEOPLE_ID  INTEGER,
    FLAG       INTEGER,
    FROM_DATE  DATE
);


ALTER TABLE Q ADD CONSTRAINT PK_Q PRIMARY KEY (C);

INSERT INTO Q (C, PEOPLE_ID, FLAG, FROM_DATE)  VALUES (1, 1, 10, '2010-01-01 00:00:00');
INSERT INTO Q (C, PEOPLE_ID, FLAG, FROM_DATE) VALUES (2, 1, 20, '2011-01-01 00:00:00');

COMMIT WORK;


COMMIT WORK;

CREATE TABLE Q1 (
    C         INTEGER NOT NULL,
    DOC_DATE  DATE,
    FLAG      SMALLINT
);


ALTER TABLE Q1 ADD CONSTRAINT PK_Q1 PRIMARY KEY (C);

INSERT INTO Q1 (C, DOC_DATE, FLAG)  VALUES (1, '2010-10-10 00:00:00', 1);

COMMIT WORK;

CREATE TABLE Q2 (
    C      INTEGER,
    Q1_ID  INTEGER,
    Q_ID   INTEGER
);


ALTER TABLE Q2 ADD CONSTRAINT FK_Q2_1 FOREIGN KEY (Q1_ID) REFERENCES Q1 (C);
ALTER TABLE Q2 ADD CONSTRAINT FK_Q2_2 FOREIGN KEY (Q_ID) REFERENCES Q (C);

INSERT INTO Q2 (C, Q1_ID, Q_ID)  VALUES (1, 1, 1);

COMMIT WORK;