Entity Appointment Resource

DescriptionAn association between an appointment and a resource which identifies the type of resource required for an appointment.

For example:
Equipment
Room
Practitioner

Relationship
Appointment Resource Group_Appointment_FKAppointment Resource Group_Appointment_FK
Appointment Resource_Point Of Care Location_FKAppointment Resource_Point Of Care Location_FK
Appointment Resource_Practitioner_FKAppointment Resource_Practitioner_FK
Appointment Resource_Equipment_FKAppointment Resource_Equipment_FK
Appointment Resource_Appointment Personnel_FKAppointment Resource_Appointment Personnel_FK
Appointment Resource_Appointment Location_FKAppointment Resource_Appointment Location_FK

Dependencies
 NONE

Reverse Dependencies
 

Relationship Details

 Appointment Resource Group_Appointment_FK
Is Identifying Relationshipfalse
Child TableAppointment Resource
Child MultiplicityONE_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableAppointment
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Appointment Resource_Point Of Care Location_FK
Is Identifying Relationshipfalse
Child TableAppointment Resource
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePoint Of Care Location
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Appointment Resource_Practitioner_FK
Is Identifying Relationshipfalse
Child TableAppointment Resource
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePractitioner
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Appointment Resource_Equipment_FK
Is Identifying Relationshipfalse
Child TableAppointment Resource
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableAppointment Resource Equipment
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Appointment Resource_Appointment Personnel_FK
Is Identifying Relationshipfalse
Child TableAppointment Resource
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableAppointment Resource Personnel
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE



 Appointment Resource_Appointment Location_FK
Is Identifying Relationshipfalse
Child TableAppointment Resource
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TableAppointment Resource Location
Parent MultiplicityZERO_TO_ONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE