CREATE TABLE Contract (
    ID AUTOINCREMENT PRIMARY KEY,
    CONTRACT_NO TEXT(20),
    PRICE CURRENCY,
    WORK_TYPE TEXT(100),
    CONTRACT_DATE DATETIME,
    STATUS TEXT(20),
    ORG1_ID LONG,
    ORG2_ID LONG,
    CONSTRAINT fk_org1 FOREIGN KEY (ORG1_ID) REFERENCES Organization(ID),
    CONSTRAINT fk_org2 FOREIGN KEY (ORG2_ID) REFERENCES Organization(ID)
);