Entity Patient Appointment

DescriptionAn association between a patient and an appointment which identifies the appointment requested for the patient.

Relationship
Patient Appointment_Appointment_FKPatient Appointment_Appointment_FK
Patient Appointment_Patient_FKPatient Appointment_Patient_FK

Dependencies
 NONE

Reverse Dependencies
 

Relationship Details

 Patient Appointment_Appointment_FK
Is Identifying Relationshiptrue
Child TablePatient Appointment
Child MultiplicityZERO_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



 Patient Appointment_Patient_FK
Is Identifying Relationshiptrue
Child TablePatient Appointment
Child MultiplicityZERO_TO_MANY
Child Referential Integrity: On DeleteNONE
Child Referential Integrity: On InsertNONE
Child Referential Integrity: On UpdateNONE
Parent TablePatient
Parent MultiplicityONE
Parent Referential Integrity: On DeleteNONE
Parent Referential Integrity: On InsertNONE
Parent Referential Integrity: On UpdateNONE