projectmember table - SuperOffice

projectmember Table (12)

Project members. Link-table between person and project

Fields

Name	Description	Type	Nullable
projectmember_id	Primary key	PK	No
project_id	Parent project	FK project	Yes
contact_id	Contact ID of person who is the project member (slight denormalization)	FK contact	Yes
person_id	Person ID of person who is the project member	FK person	Yes
rank	Rank in list	UShort	Yes
mtype_idx	Member type link	FK PMembType	Yes
text_id	Optional comment	FK text	Yes
registered	Registered when	UtcDateTime	No
registered_associate_id	Registered by whom	FK associate	No
updated	Last updated when	UtcDateTime	No
updated_associate_id	Last updated by whom	FK associate	No
updatedCount	Number of updates made to this record	UShort	No
event_participant_status	Reserved field for Lyyti event participants.	Enum ProjectMemberEventParticipantStatus	No

projectmember table relationship diagram

Indexes

Fields	Types	Description
contact_id	FK	Index
person_id	FK	Index
project_id, rank	FK, UShort	Index
project_id, event_participant_status	FK, Enum	Index

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons
contact	Companies and Organizations.
person	Persons
PMembType	PMembType list table. List text of titles (member types) for project members.
project	Projects
text	Long text fields from all over the system

Replication Flags

Area Management controlled table. Contents replicated to satellites and traveller databases.
Replicate changes UP from satellites and travellers back to central.
Copy to satellite and travel prototypes.
Cache table during filtering.

Security Flags

Sentry controls access to items in this table using user’s Role and data rights matrix on the table’s parent.

Related topics

ProjectMember Enum values for ProjectMemberEventParticipantStatus Update Project Members Add Project Members Update Project Member Receiving notifications

⌘I