Entities and attributes for logical data models

Entity Name Entity Type Entity Attribute Name Entity Attribute Required Entity Attribute Is PK Entity Attribute Is FK Entity Attribute Domain Name
CERTIFICATION REQUIREMENT Dependent HEALTH CARE OFFERING ID Yes Yes Yes ID
CERTIFICATION REQUIREMENT Dependent CERTIFICATION TYPE ID Yes Yes Yes ID
CERTIFICATION STATUS Dependent STATUS TYPE ID Yes Yes Yes ID
CERTIFICATION STATUS Dependent HEALTH CARE DELIVERY ID Yes Yes Yes ID
CERTIFICATION STATUS Dependent STATUS DATE Yes Yes No Datetime
CERTIFICATION STATUS TYPE Dependent STATUS TYPE ID Yes Yes Yes ID
CERTIFICATION TYPE Independent CERTIFICATION TYPE ID Yes Yes No ID
CERTIFICATION TYPE Independent DESCRIPTION Yes No No Description
DELIVERY OUTCOME Dependent HEALTH CARE DELIVERY ID Yes Yes Yes ID
DELIVERY OUTCOME Dependent DELIVERY OUTCOME ID Yes Yes No ID
DELIVERY OUTCOME Dependent OUTCOME TYPE ID No No Yes ID
DELIVERY OUTCOME Dependent OUTCOME EXPLANATION Yes No No Long varchar
DIAGNOSIS Independent DIAGNOSIS ID Yes Yes No ID
DIAGNOSIS Independent HEALTH CARE EPISODE ID No No Yes ID
DIAGNOSIS Independent DIAGNOSIS TYPE ID Yes No Yes ID
DIAGNOSIS Independent DIAGNOSIS DATE Yes No No Datetime
DIAGNOSIS TREATMENT Dependent DIAGNOSIS ID Yes Yes Yes ID
DIAGNOSIS TREATMENT Dependent HEALTH CARE DELIVERY ID Yes Yes Yes ID
DIAGNOSIS TYPE Independent DIAGNOSIS TYPE ID Yes Yes No ID
DIAGNOSIS TYPE Independent DESCRIPTION Yes No No Description
DIAGNOSIS TYPE Independent ABBREVIATION Yes No No Short varchar
DME DELIVERY Dependent HEALTH CARE DELIVERY ID Yes Yes Yes ID
DRUG ADMINISTRATION Dependent HEALTH CARE DELIVERY ID Yes Yes Yes ID
EPISODE OUTCOME Dependent HEALTH CARE EPISODE ID Yes Yes Yes ID
EPISODE OUTCOME Dependent EPISODE OUTCOME ID Yes Yes No ID
EPISODE OUTCOME Dependent OUTCOME TYPE ID No No Yes ID
EPISODE OUTCOME Dependent OUTCOME EXPLANATION Yes No No Long varchar
EXAMINATION Dependent HEALTH CARE DELIVERY ID Yes Yes Yes ID
HEALTH CARE DELIVERY Independent HEALTH CARE DELIVERY ID Yes Yes No ID
HEALTH CARE DELIVERY Independent HEALTH CARE VISIT ID Yes No Yes ID
HEALTH CARE DELIVERY Independent HEALTH CARE EPISODE ID Yes No Yes ID
HEALTH CARE DELIVERY Independent HEALTH CARE OFFERING ID Yes No Yes ID
HEALTH CARE DELIVERY Independent FROM DATE No No No Datetime
HEALTH CARE DELIVERY Independent THRU DATE No No No Datetime
HEALTH CARE DELIVERY Independent DELIVERY NOTES Yes No No Long varchar
HEALTH CARE DELIVERY ASSOCIATION Dependent HEALTH CARE DELIVERY ID FROM Yes Yes Yes ID
HEALTH CARE DELIVERY ASSOCIATION Dependent HEALTH CARE DELIVERY ID TO Yes Yes Yes ID
HEALTH CARE DELIVERY ROLE Dependent ROLE TYPE ID Yes Yes Yes ID
HEALTH CARE DELIVERY ROLE Dependent FROM DATE Yes Yes No Datetime
HEALTH CARE DELIVERY ROLE Dependent PARTY ID Yes Yes Yes ID
HEALTH CARE DELIVERY ROLE Dependent HEALTH CARE DELIVERY ID Yes Yes Yes ID
HEALTH CARE DELIVERY ROLE Dependent THRU DATE No No No Datetime
HEALTH CARE DELIVERY ROLE TYPE Dependent ROLE TYPE ID Yes Yes Yes ID
HEALTH CARE EPISODE Independent HEALTH CARE EPISODE ID Yes Yes No ID
HEALTH CARE EPISODE Independent INCIDENT ID Yes No No ID
HEALTH CARE EPISODE Independent PARTY ID Yes No No ID
HEALTH CARE EPISODE Independent ROLE TYPE ID Yes No No ID
HEALTH CARE EPISODE Independent PATIENT TYPE ID Yes No No ID
HEALTH CARE EPISODE Independent HOUR ID Yes No No Datetime
HEALTH CARE EPISODE Independent EPISODE CREATE DATE Yes No No Datetime
HEALTH CARE EPISODE Independent DESCRIPTION Yes No No Description
HEALTH CARE EPISODE Independent EPISODE TYPE ID Yes No No ID
HEALTH CARE GOOD OFFERING Dependent HEALTH CARE OFFERING ID Yes Yes Yes ID
HEALTH CARE OFFERING Independent HEALTH CARE OFFERING ID Yes Yes No ID
HEALTH CARE OFFERING Independent NAME No No No Name
HEALTH CARE SERVICE OFFERING Dependent HEALTH CARE OFFERING ID Yes Yes Yes ID
HEALTH CARE VISIT Independent HEALTH CARE VISIT ID Yes Yes No ID
HEALTH CARE VISIT Independent CONTACT MECHANISM ID No No No ID
HEALTH CARE VISIT Independent PARTY ID No No No ID
HEALTH CARE VISIT Independent ROLE TYPE ID No No No ID
HEALTH CARE VISIT Independent FACILITY ID No No No ID
HEALTH CARE VISIT Independent FROM DATE Yes No No Datetime
HEALTH CARE VISIT Independent THRU DATE No No No Datetime
INDIVIDUAL HEALTH CARE PRACTITIONER Independent PARTY ID Yes Yes No ID
INDIVIDUAL HEALTH CARE PRACTITIONER Independent ROLE TYPE ID Yes Yes No ID
OUTCOME TYPE Independent OUTCOME TYPE ID Yes Yes No ID
OUTCOME TYPE Independent DESCRIPTION Yes No No Description
PARTY Independent PARTY ID Yes Yes No ID
PRACTITIONER DIAGNOSIS Dependent DIAGNOSIS ID Yes Yes Yes ID
PRACTITIONER DIAGNOSIS Dependent PARTY ID Yes Yes Yes ID
PRACTITIONER DIAGNOSIS Dependent ROLE TYPE ID Yes Yes Yes ID
PROCEDURE Dependent HEALTH CARE DELIVERY ID Yes Yes Yes ID
ROLE TYPE Independent ROLE TYPE ID Yes Yes No ID
ROLE TYPE Independent DESCRIPTION Yes No No Description
STATUS TYPE Independent STATUS TYPE ID Yes Yes No ID
STATUS TYPE Independent DESCRIPTION Yes No No Description
SUPPLY ADMINISTRATION Dependent HEALTH CARE DELIVERY ID Yes Yes Yes ID