CREATE TABLE acs_sc_operations ( contract_id integer, operation_id integer PRIMARY KEY NOT NULL, contract_name varchar(1000), operation_name varchar(100), operation_desc text(-5) NOT NULL, operation_iscachable_p bool, operation_nargs integer, operation_inputtype_id integer, operation_outputtype_id integer, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_sc_operations_intype_fk REFERENCES acs_sc_contracts (), CONSTRAINT acs_sc_operations_opid_fk REFERENCES acs_sc_contracts (), CONSTRAINT acs_sc_operations_pk REFERENCES acs_sc_contracts (), CONSTRAINT acs_sc_operations_cid_fk REFERENCES acs_sc_contracts (), CONSTRAINT acs_sc_operations_outtype_fk REFERENCES acs_sc_contracts (), CONSTRAINT acs_sc_operations_opid_fk REFERENCES acs_sc_msg_types (), CONSTRAINT acs_sc_operations_cid_fk REFERENCES acs_sc_msg_types (), CONSTRAINT acs_sc_operations_intype_fk REFERENCES acs_sc_msg_types (), CONSTRAINT acs_sc_operations_outtype_fk REFERENCES acs_sc_msg_types (), CONSTRAINT acs_sc_operations_pk REFERENCES acs_sc_msg_types () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_sc_operations_pk REFERENCES acs_objects (), CONSTRAINT acs_sc_operations_outtype_fk REFERENCES acs_objects (), CONSTRAINT acs_sc_operations_opid_fk REFERENCES acs_objects (), CONSTRAINT acs_sc_operations_intype_fk REFERENCES acs_objects (), CONSTRAINT acs_sc_operations_cid_fk REFERENCES acs_objects (), CONSTRAINT acs_sc_operations_pk REFERENCES acs_sc_msg_types (), CONSTRAINT acs_sc_operations_cid_fk REFERENCES acs_sc_msg_types (), CONSTRAINT acs_sc_operations_intype_fk REFERENCES acs_sc_msg_types (), CONSTRAINT acs_sc_operations_opid_fk REFERENCES acs_sc_msg_types (), CONSTRAINT acs_sc_operations_outtype_fk REFERENCES acs_sc_msg_types () ); CREATE TRIGGER RI_ConstraintTrigger_c_340584 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340585 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340589 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340590 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340594 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340595 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340599 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340600 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 16,384 bytes -- Table rows: 75
Begin main content
