Order Appointment_Order_FKOrder Appointment_Encounter_FKOrder Appointment_Appointment_FKOrder Appointment_Order_FK1
| Business Data Model Data Model |
| Description | An association between an appointment and an order. This may identify the order requesting the appointment or it could identify the order generated as a result of the requested appointment. For example: A full blood count is ordered for a surgical review appointment |
| Relationship | |
| Order Appointment_Order_FK |
|
| Order Appointment_Encounter_FK |
|
| Order Appointment_Appointment_FK |
|
| Order Appointment_Order_FK1 |
|
| Dependencies | |
 NONE |
|
| Reverse Dependencies | |
| |
|
| Relationship Details |
Order Appointment_Order_FK
| Is Identifying Relationship | false |
| Child Table | Order Appointment |
| 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 | Order |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Order Appointment_Encounter_FK
| Is Identifying Relationship | false |
| Child Table | Order Appointment |
| 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 | Encounter |
| Parent Multiplicity | ZERO_TO_ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
Order Appointment_Appointment_FK
| Is Identifying Relationship | false |
| Child Table | Order Appointment |
| 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 |
Order Appointment_Order_FK1
| Is Identifying Relationship | true |
| Child Table | Order Appointment |
| 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 | Order |
| Parent Multiplicity | ONE |
| Parent Referential Integrity: On Delete | NONE |
| Parent Referential Integrity: On Insert | NONE |
| Parent Referential Integrity: On Update | NONE |
| Business Data Model Data Model |