Relationship Phrases for Volume 2 Demo

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