Description

Defines a many-to-many relationship between roles. By allowing roles to inherit from other roles, system administrators can create a hierarchy of roles to make privilege assignment more efficient and manageable. For example, a low-level role like Provider may refer to only privileges; however, a role like Physician might inherit the Provider privileges (by making a Physician–Provider row in this table) as well as including some additional privileges specific to physicians.

Attributes

	Column Name	Type	Default	Description
	parent_role	varchar(50)		Role containing another role. This role will inherit all privilege assigned to the child_role.
	child_role	varchar(255)		Role contained by the parent_role.
primary key, required