Appointment Service_Appointment_FKAppointment Service_Service _FK
| Business Data Model Data Model |
| Description | An association between an appointment and the service that is provided. There can be multiple services provided in one appointment. For example: Physiotherapy assessment for 30 minutes Speech and Language therapy for 30 minutes Dietitian assessment for 20 minutes. |
| Relationship | |
| Appointment Service_Appointment_FK |
|
| Appointment Service_Service _FK |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Relationship Details |
Appointment Service_Appointment_FK
| Is Identifying Relationship | false |
| Child Table | Appointment Service |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Appointment |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Appointment Service_Service _FK
| Is Identifying Relationship | false |
| Child Table | Appointment Service |
| Child Multiplicity | ZERO_TO_MANY |
| Child Referential Integrity: On Delete | NONE |
| Child Referential Integrity: On Insert | NONE |
| Child Referential Integrity: On Update | NONE |
| Parent Table | Schedule Service |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |