-- -- This table is used for objects that want to vertically partition -- their data storage, for example user_demographics stores a set of -- optional columns that belong to a user object. -- CREATE TABLE acs_object_type_tables ( object_type varchar(1000) NOT NULL, table_name varchar(30) NOT NULL, -- -- If this is null then the id column is assumed to have the same name -- as the primary table. -- id_column varchar(30), PRIMARY KEY (object_type,table_name), CONSTRAINT acs_obj_type_tbls_obj_type_fk REFERENCES acs_object_types (), CONSTRAINT acs_object_type_tables_pk REFERENCES acs_object_types () ); CREATE INDEX acs_objtype_tbls_objtype_idx ON acs_object_type_tables (object_type); CREATE TRIGGER RI_ConstraintTrigger_a_340287 AFTER DELETE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_del (disabled) CREATE TRIGGER RI_ConstraintTrigger_a_340288 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_noaction_upd (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610561 AFTER INSERT FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_ins (disabled) CREATE TRIGGER RI_ConstraintTrigger_c_1610562 AFTER UPDATE FOR EACH ROW EXECUTE PROCEDURE RI_FKey_check_upd (disabled) -- Tables with foreign keys that refer to acs_object_type_tables: --acs_attributes(acs_obj_type_tbls_obj_type_fk) --acs_attributes(acs_object_type_tables_pk) -- Table size: 8,192 bytes -- Table rows: 1
Begin main content
