CREATE TABLE acs_named_objects ( object_id integer PRIMARY KEY NOT NULL, object_name varchar(200), package_id integer, ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_named_objs_object_id_fk REFERENCES acs_objects (), CONSTRAINT acs_named_objs_package_id_fk REFERENCES acs_objects (), CONSTRAINT acs_named_objs_pk REFERENCES acs_objects () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_named_objs_pk REFERENCES apm_packages (), CONSTRAINT acs_named_objs_object_id_fk REFERENCES apm_packages (), CONSTRAINT acs_named_objs_package_id_fk REFERENCES apm_packages () ); CREATE INDEX acs_named_objs_name_ix ON acs_named_objects (object_name); CREATE INDEX acs_named_objs_package_ix ON acs_named_objects (package_id); CREATE TRIGGER RI_ConstraintTrigger_c_340429 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340430 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340434 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340435 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 40,960 bytes -- Table rows: 673
Begin main content
