Person_Role Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
Person_Role_ID		NUMERIC(19, 0)	NO
Role_ID		NUMERIC(19, 0)	NO
Person_ID		NUMERIC(19, 0)	NO
Version		NUMERIC(5, 0)	NO
Date_Created		DATE	YES
Last_Updated		DATE	YES
Modified_By		VARCHAR(40)	YES

Person_Role Keys

Key Name	Key Type	Keys
PK_Person_Role	PrimaryKey	Person_Role_ID
AK_Person_Role	Alternate Key	Role_ID, Person_ID
FK_PERSON_ROLE_PERSON	Inversion Entry	Person_ID
FK_PERSON_ROLE_ROLE	Inversion Entry	Role_ID

Person_Role Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Person	Non-Identifying	One To Zero or More				Person_ID	NO
Role	Non-Identifying	One To Zero or More				Role_ID	NO

Child Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Subtype
Team_Member	Non-Identifying	One To Zero or More					NO

Person_Role Check Constraints

Check Constraint Name

CheckConstraint

Person_Role Security Types

Name	Current Value

Person_Role Where Used - Model Usage

Mapped Object	Is User Defined?	Denormalization Mappings	Description	Bound Attachments
Logical Person_Role	NO
BARD - MySQL (MySQL) Does Not Exist	NO
BARD_Dev (Oracle) PERSON_ROLE	NO
Current Production (Oracle) Does Not Exist	NO

Person_Role Where Used - Submodel Usage

Model	Submodel Usage
Logical	Main Model
Logical	RI hierarchy
Logical	Security
BARD_Dev (Oracle)	Main Model
BARD_Dev (Oracle)	RI hierarchy
BARD_Dev (Oracle)	Security