CREATE TABLE acs_sc_contracts ( contract_id integer PRIMARY KEY NOT NULL, contract_name varchar(1000) NOT NULL, contract_desc text(-5) NOT NULL, ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_sc_contracts_id_fk REFERENCES acs_objects (), CONSTRAINT acs_sc_contracts_pk REFERENCES acs_objects () ); CREATE UNIQUE INDEX acs_sc_contracts_name_un ON acs_sc_contracts (contract_name); CREATE TRIGGER RI_ConstraintTrigger_a_340542 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340543 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340554 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340555 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340582 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_cascade_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340583 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) -- Tables with foreign keys that refer to acs_sc_contracts: --acs_sc_bindings(acs_sc_contracts_id_fk) --acs_sc_bindings(acs_sc_contracts_pk) --acs_sc_operations(acs_sc_contracts_id_fk) --acs_sc_operations(acs_sc_contracts_pk) -- Table size: 8,192 bytes -- Table rows: 23
Begin main content
