--
--   Constrains the allowable object types to which a content type may
--   relate (see above).
-- 
CREATE TABLE cr_type_relations (
	content_type	 varchar(100) NOT NULL,
	target_type	 varchar(100) NOT NULL,
	relation_tag	 varchar(100) NOT NULL,
	min_n	 integer,
	max_n	 integer,
	PRIMARY KEY (content_type, target_type, relation_tag),
	CONSTRAINT cr_type_relations_child_fk REFERENCES acs_object_types (),
	CONSTRAINT cr_type_relations_parent_fk REFERENCES acs_object_types ()
);

CREATE INDEX cr_type_relations_tgt_typ_idx ON cr_type_relations (target_type);

-- Table size: 8,192 bytes
-- Table rows: 2

Tables: