-- -- Stores static values for the object attributes. One row per object -- type. -- CREATE TABLE acs_static_attr_values ( object_type varchar(1000) NOT NULL, attribute_id integer NOT NULL, attr_value text(-5), PRIMARY KEY (object_type,attribute_id), CONSTRAINT acs_static_a_v_attr_id_fk REFERENCES acs_attributes (), CONSTRAINT acs_static_a_v_obj_id_fk REFERENCES acs_attributes (), CONSTRAINT acs_static_a_v_pk REFERENCES acs_attributes () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_static_a_v_pk REFERENCES acs_object_types (), CONSTRAINT acs_static_a_v_attr_id_fk REFERENCES acs_object_types (), CONSTRAINT acs_static_a_v_obj_id_fk REFERENCES acs_object_types () ); CREATE INDEX acs_stat_attrs_attr_id_idx ON acs_static_attr_values (attribute_id); CREATE TRIGGER RI_ConstraintTrigger_c_340604 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340605 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610586 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610587 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
