Relationship Parent to Child Rule | Relationship Parent to Child Phrase | Relationship Child to Parent Phrase | Relationship Type | Relationship Child to Parent Rule | Relationship Parent Entity Name | Relationship Parent Entity Primary Key Attribute Name | Relationship Child Entity Primary Key Attribute Name | Relationship Parent Table Name | Relationship Child Table Name | Relationship Child Table Primary Key Column Name |
---|---|---|---|---|---|---|---|---|---|---|
A CERTIFICATION STATUS TYPE may be the description for many CERTIFICATION STATUSs. | may be the description for | must be described by | Identifying | A CERTIFICATION STATUS must be described by exactly one CERTIFICATION STATUS TYPE. | CERTIFICATION STATUS TYPE | STATUS TYPE ID | STATUS TYPE ID | CERTIFICATION_STATUS_TYPE | CERTIFICATION_STATUS | STATUS_TYPE_ID |
  |   |   |   |   | HEALTH CARE DELIVERY ID |   | HEALTH_CARE_DELIVERY_ID | |||
  |   |   |   |   | STATUS DATE |   | STATUS_DATE | |||
A CERTIFICATION TYPE may be the description for many CERTIFICATION REQUIREMENTs. |   |   |   | A CERTIFICATION REQUIREMENT must be described by exactly one CERTIFICATION TYPE. | CERTIFICATION TYPE | CERTIFICATION TYPE ID | HEALTH CARE OFFERING ID | CERTIFICATION_TYPE | CERTIFICATION_REQUIREMENT | HEALTH_CARE_OFFERING_ID |
  |   |   |   |   | CERTIFICATION TYPE ID |   | CERTIFICATION_TYPE_ID | |||
A DIAGNOSIS may be from many PRACTITIONER DIAGNOSISs. | may be from | must be of |   | A PRACTITIONER DIAGNOSIS must be of exactly one DIAGNOSIS. | DIAGNOSIS | DIAGNOSIS ID | DIAGNOSIS ID | DIAGNOSIS | PRACTITIONER_DIAGNOSIS | DIAGNOSIS_ID |
  |   |   |   |   | PARTY ID |   | PARTY_ID | |||
  |   |   |   |   | ROLE TYPE ID |   | ROLE_TYPE_ID | |||
A DIAGNOSIS may be treated with many DIAGNOSIS TREATMENTs. | may be treated with | must be for |   | A DIAGNOSIS TREATMENT must be for exactly one DIAGNOSIS. | DIAGNOSIS | DIAGNOSIS ID | DIAGNOSIS ID | DIAGNOSIS | DIAGNOSIS_TREATMENT | DIAGNOSIS_ID |
  |   |   |   |   | HEALTH CARE DELIVERY ID |   | HEALTH_CARE_DELIVERY_ID | |||
A DIAGNOSIS TYPE may be the description for many DIAGNOSISs. | may be the description for | must be described by | Non-identifying | A DIAGNOSIS must be described by exactly one DIAGNOSIS TYPE. | DIAGNOSIS TYPE | DIAGNOSIS TYPE ID | DIAGNOSIS ID | DIAGNOSIS_TYPE | DIAGNOSIS | DIAGNOSIS_ID |
A HEALTH CARE DELIVERY may be to many HEALTH CARE DELIVERY ASSOCIATIONs. | may be to | must be related to | Identifying | A HEALTH CARE DELIVERY ASSOCIATION must be related to exactly one HEALTH CARE DELIVERY. | HEALTH CARE DELIVERY | HEALTH CARE DELIVERY ID | HEALTH CARE DELIVERY ID FROM | HEALTH_CARE_DELIVERY | HEALTH_CARE_DELIVERY_ASSOCIATI | HEALTH_CARE_DELIVERY_ID_FROM |
  |   |   |   |   | HEALTH CARE DELIVERY ID TO |   | HEALTH_CARE_DELIVERY_ID_TO | |||
A HEALTH CARE DELIVERY may be from many HEALTH CARE DELIVERY ASSOCIATIONs. | may be from | must be related from |   | A HEALTH CARE DELIVERY ASSOCIATION must be related from exactly one HEALTH CARE DELIVERY. | HEALTH CARE DELIVERY | HEALTH CARE DELIVERY ID | HEALTH CARE DELIVERY ID FROM | HEALTH_CARE_DELIVERY |   | HEALTH_CARE_DELIVERY_ID_FROM |
  |   |   |   |   | HEALTH CARE DELIVERY ID TO |   | HEALTH_CARE_DELIVERY_ID_TO | |||
A HEALTH CARE DELIVERY R/2754 many CERTIFICATION STATUSs. | R/2754 |   | A CERTIFICATION STATUS is associated with exactly one HEALTH CARE DELIVERY. | HEALTH CARE DELIVERY | HEALTH CARE DELIVERY ID | STATUS TYPE ID | HEALTH_CARE_DELIVERY | CERTIFICATION_STATUS | STATUS_TYPE_ID | |
  |   |   |   | HEALTH CARE DELIVERY ID |   | HEALTH_CARE_DELIVERY_ID | ||||
  |   |   |   | STATUS DATE |   | STATUS_DATE | ||||
A HEALTH CARE DELIVERY may be lead to many DELIVERY OUTCOMEs. | may be lead to | must be from |   | A DELIVERY OUTCOME must be from exactly one HEALTH CARE DELIVERY. | HEALTH CARE DELIVERY | HEALTH CARE DELIVERY ID | HEALTH CARE DELIVERY ID | HEALTH_CARE_DELIVERY | DELIVERY_OUTCOME | HEALTH_CARE_DELIVERY_ID |
  |   |   |   |   | DELIVERY OUTCOME ID |   | DELIVERY_OUTCOME_ID | |||
A HEALTH CARE DELIVERY may be recommended from many DIAGNOSIS TREATMENTs. | may be recommended from | must be for |   | A DIAGNOSIS TREATMENT must be for exactly one HEALTH CARE DELIVERY. | HEALTH CARE DELIVERY | HEALTH CARE DELIVERY ID | DIAGNOSIS ID | HEALTH_CARE_DELIVERY | DIAGNOSIS_TREATMENT | DIAGNOSIS_ID |
  |   |   |   |   | HEALTH CARE DELIVERY ID |   | HEALTH_CARE_DELIVERY_ID | |||
A HEALTH CARE DELIVERY may be involving many HEALTH CARE DELIVERY ROLEs. | may be involving |   |   | A HEALTH CARE DELIVERY ROLE must be for exactly one HEALTH CARE DELIVERY. | HEALTH CARE DELIVERY | HEALTH CARE DELIVERY ID | ROLE TYPE ID | HEALTH_CARE_DELIVERY | HEALTH_CARE_DELIVERY_ROLE | ROLE_TYPE_ID |
  |   |   |   |   | FROM DATE |   | FROM_DATE | |||
  |   |   |   |   | PARTY ID |   | PARTY_ID | |||
  |   |   |   |   | HEALTH CARE DELIVERY ID |   | HEALTH_CARE_DELIVERY_ID | |||
A HEALTH CARE DELIVERY ROLE TYPE may be the description for many HEALTH CARE DELIVERY ROLEs. | may be the description for | must be described by |   | A HEALTH CARE DELIVERY ROLE must be described by exactly one HEALTH CARE DELIVERY ROLE TYPE. | HEALTH CARE DELIVERY ROLE TYPE | ROLE TYPE ID | ROLE TYPE ID | HEALTH_CARE_DELIVERY_ROLE_TYPE |   | ROLE_TYPE_ID |
  |   |   |   |   | FROM DATE |   | FROM_DATE | |||
  |   |   |   |   | PARTY ID |   | PARTY_ID | |||
  |   |   |   |   | HEALTH CARE DELIVERY ID |   | HEALTH_CARE_DELIVERY_ID | |||
A HEALTH CARE EPISODE may be resulting in many EPISODE OUTCOMEs. | may be resulting in | must be from |   | A EPISODE OUTCOME must be from exactly one HEALTH CARE EPISODE. | HEALTH CARE EPISODE | HEALTH CARE EPISODE ID | HEALTH CARE EPISODE ID | HEALTH_CARE_EPISODE | EPISODE_OUTCOME | HEALTH_CARE_EPISODE_ID |
  |   |   |   |   | EPISODE OUTCOME ID |   | EPISODE_OUTCOME_ID | |||
A HEALTH CARE EPISODE may be diagnosised as many DIAGNOSISs. | may be diagnosised as | must be for | Non-identifying | A DIAGNOSIS must be for zero or one HEALTH CARE EPISODEs. | HEALTH CARE EPISODE | HEALTH CARE EPISODE ID | DIAGNOSIS ID | HEALTH_CARE_EPISODE | DIAGNOSIS | DIAGNOSIS_ID |
A HEALTH CARE EPISODE may be treated with many HEALTH CARE DELIVERYs. | may be treated with | may be treatment for |   | A HEALTH CARE DELIVERY may be treatment for zero or one HEALTH CARE EPISODEs. |   |   | HEALTH CARE DELIVERY ID |   | HEALTH_CARE_DELIVERY | HEALTH_CARE_DELIVERY_ID |
A HEALTH CARE OFFERING may be in need of approval by many CERTIFICATION REQUIREMENTs. | may be in need of approval by | must be for | Identifying | A CERTIFICATION REQUIREMENT must be for exactly one HEALTH CARE OFFERING. | HEALTH CARE OFFERING | HEALTH CARE OFFERING ID | HEALTH CARE OFFERING ID | HEALTH_CARE_OFFERING | CERTIFICATION_REQUIREMENT | HEALTH_CARE_OFFERING_ID |
  |   |   |   |   | CERTIFICATION TYPE ID |   | CERTIFICATION_TYPE_ID | |||
A HEALTH CARE OFFERING may be the description for many HEALTH CARE DELIVERYs. | may be the description for | must be of | Non-identifying | A HEALTH CARE DELIVERY must be of exactly one HEALTH CARE OFFERING. | HEALTH CARE OFFERING | HEALTH CARE OFFERING ID | HEALTH CARE DELIVERY ID | HEALTH_CARE_OFFERING | HEALTH_CARE_DELIVERY | HEALTH_CARE_DELIVERY_ID |
A HEALTH CARE VISIT may be consisting of many HEALTH CARE DELIVERYs. | may be consisting of | may be part of |   | A HEALTH CARE DELIVERY may be part of zero or one HEALTH CARE VISITs. | HEALTH CARE VISIT | HEALTH CARE VISIT ID |   | HEALTH_CARE_VISIT |   |   |
A INDIVIDUAL HEALTH CARE PRACTITIONER may be involved in many PRACTITIONER DIAGNOSISs. | may be involved in | must be from | Identifying | A PRACTITIONER DIAGNOSIS must be from exactly one INDIVIDUAL HEALTH CARE PRACTITIONER. | INDIVIDUAL HEALTH CARE PRACTITIONER | PARTY ID | DIAGNOSIS ID | INDIVIDUAL_HEALTH_CARE_PRACTIT | PRACTITIONER_DIAGNOSIS | DIAGNOSIS_ID |
  |   |   |   |   |   | ROLE TYPE ID | PARTY ID |   | PARTY_ID | |
  |   |   |   |   | ROLE TYPE ID |   | ROLE_TYPE_ID | |||
A OUTCOME TYPE may be the description for many EPISODE OUTCOMEs. | may be the description for | must be described by | Non-identifying | A EPISODE OUTCOME must be described by zero or one OUTCOME TYPEs. | OUTCOME TYPE | OUTCOME TYPE ID | HEALTH CARE EPISODE ID | OUTCOME_TYPE | EPISODE_OUTCOME | HEALTH_CARE_EPISODE_ID |
  |   |   |   |   | EPISODE OUTCOME ID |   | EPISODE_OUTCOME_ID | |||
A OUTCOME TYPE may be the description for many DELIVERY OUTCOMEs. |   |   |   | A DELIVERY OUTCOME must be described by zero or one OUTCOME TYPEs. | OUTCOME TYPE | OUTCOME TYPE ID | HEALTH CARE DELIVERY ID | OUTCOME_TYPE | DELIVERY_OUTCOME | HEALTH_CARE_DELIVERY_ID |
  |   |   |   |   | DELIVERY OUTCOME ID |   | DELIVERY_OUTCOME_ID | |||
A PARTY may be involve in many HEALTH CARE DELIVERY ROLEs. | may be involve in | must be involving | Identifying | A HEALTH CARE DELIVERY ROLE must be involving exactly one PARTY. | PARTY | PARTY ID | ROLE TYPE ID | PARTY | HEALTH_CARE_DELIVERY_ROLE | ROLE_TYPE_ID |
  |   |   |   |   | FROM DATE |   | FROM_DATE | |||
  |   |   |   |   | PARTY ID |   | PARTY_ID | |||
  |   |   |   |   | HEALTH CARE DELIVERY ID |   | HEALTH_CARE_DELIVERY_ID |