Просмотр исходного текста страницы RP REPORTRESULT


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;

[[Category:База данных]]