RP REPORTRESULT
Материал из GedeminWiki
CREATE TABLE rp_reportresult
( functionkey dintkey, crcparam dinteger NOT NULL, paramorder dinteger DEFAULT 0 NOT NULL, paramdata dblob, resultdata dblob, createdate dtimestamp, executetime dtime, lastusedate dtimestamp, reserved dinteger );
ALTER TABLE rp_reportresult ADD CONSTRAINT rp_pk_reportresult PRIMARY KEY (functionkey, crcparam, paramorder);
COMMIT;
ALTER TABLE rp_reportresult ADD CONSTRAINT rp_fk_reportresult_functionkey FOREIGN KEY (functionkey) REFERENCES gd_function(id) ON UPDATE CASCADE ON DELETE CASCADE;