Table Details - Person Role

Person Role Details

Business Name

Person Role

Table Name

person_role

Definition

The association of a Person to a Position for a given Association year. One Person may have multiple roles, either across years or within a single year. In addition, two (or more) Persons may share a role though this is undesirable since they would share an IRMAC email address if one has been allocated.

Note

Entity Id

2375651

Container Name

IRMAC Database.erwin

Status

Active

Relationships


person	occupies
position	occupied by

Keys


XPKPerson Role	PK	Person Role Id
XIF1Person Role	IF1	Person Id
XIF2Person Role	IF2	Position Id

Entity Attribute List

Attribute Name	Datatype	Null Option	Definition
Association Year	INTEGER	NotNull	The current year of the Association. E.g. 2012 indicates the year 2012-2013.
Person Id	INTEGER	NotNull	A generated number to identify a person.
Person Role Id	INTEGER	NotNull	A generated number to identify the role that a person plays on the IRMAC Board.
Position Id	INTEGER	NotNull	A generated number to identify an IRMAC position.

1 - 4 of 4