-- -- Instead of coercing everything into a big string, we could use -- a "union", i.e, a string column, a number column, a date column, -- and a discriminator. -- CREATE TABLE acs_attribute_values ( object_id integer NOT NULL, attribute_id integer NOT NULL, attr_value text(-5), PRIMARY KEY (object_id,attribute_id), CONSTRAINT acs_attr_values_attr_id_fk REFERENCES acs_attributes (), CONSTRAINT acs_attr_values_obj_id_fk REFERENCES acs_attributes (), CONSTRAINT acs_attribute_values_pk REFERENCES acs_attributes () ON DELETE CASCADE ON DELETE CASCADE ON DELETE CASCADE, CONSTRAINT acs_attribute_values_pk REFERENCES acs_objects (), CONSTRAINT acs_attr_values_attr_id_fk REFERENCES acs_objects (), CONSTRAINT acs_attr_values_obj_id_fk REFERENCES acs_objects () ); CREATE INDEX acs_attr_values_attr_id_idx ON acs_attribute_values (attribute_id); CREATE TRIGGER RI_ConstraintTrigger_c_340269 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340270 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340274 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_340275 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Table size: 0 bytes -- Table rows: 0
Begin main content
