Entity Performer

DescriptionA person, organization or device that participates in an activity.

For example:
Surgeon
Performing laboratory
Monitoring device

Attributes
Identification NumIdentification Num
Performer TypePerformer Type

Relationship
performedPerformerperformedPerformer
performingPerformerperformingPerformer
Performer_Person_FKPerformer_Person_FK
Performer_Organization_FKPerformer_Organization_FK

Dependencies
 NONE

Reverse Dependencies
 

Attribute Details

 Identification Num
DescriptionA unique symbol that establishes identity of the performer.
Data TypeStandards - Data Domains.ddm/Data Domains/Alphanumeric [VARCHAR(80)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse



 Performer Type
DescriptionSpecifies the kind of performer.

For example:
Surgeon
Monitoring device
Performing laboratory
Data TypeStandards - Data Domains.ddm/Data Domains/Enumeration [VARCHAR(20)]
Is Part Of PrimaryKeyfalse
Is Requiredfalse
Is Derivedfalse
Is Surrogate Keyfalse

Relationship Details

 performedPerformer
Description
Is Identifying Relationshipfalse
Child TablePerformer
Child Role NameperformingDevice
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteSET_NULL
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateSET_NULL
Parent TableDevice
Parent Role NameperformedPerformer
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertSET_NULL
Parent Referential Integrity: On UpdateSET_NULL



 performingPerformer
Description

Is Identifying Relationshipfalse
Child TablePerformer
Child Role NameperformedActivity
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableActivity
Parent Role NameperformingPerformer
Parent MultiplicityZERO_TO_MANY
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Performer_Person_FK
Is Identifying Relationshipfalse
Child TablePerformer
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePerson
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Performer_Organization_FK
Is Identifying Relationshipfalse
Child TablePerformer
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableOrganization
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE