Team_Member Attributes

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

Team_Member Keys

Key Name	Key Type	Keys
PK_Team_Member	PrimaryKey	Team_Member_ID
AK_Team_Member	Alternate Key	Team_ID, Person_Role_ID
FK_TEAM_MEMBER_TEAM	Inversion Entry	Team_ID
FK_TEAM_MEMBER_PERSON_ROLE	Inversion Entry	Person_Role_ID

Team_Member Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
Person_Role	Non-Identifying	One To Zero or More				Person_Role_ID	NO
Team	Non-Identifying	One To Zero or More				Team_ID	NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Team_Member Check Constraints

Check Constraint Name

CheckConstraint

Team_Member Security Types

Name	Current Value

Team_Member Where Used - Model Usage

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

Team_Member 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