Entities Attributes

This table contains the attributes of our entities. Each entity can have several attributes, which can either be used as entities themselves or only as attributes.

For example, age, gender, and admission are attributes of the Patient entity, as each patient has an age, gender, and admission sequence. Additionally, multimorbidity, treated multimorbidity, untreated multimorbidity, and new multimorbidity are attributes of the Admission entity. Similarly, each disorder is an attribute of multimorbidity, treated multimorbidity, untreated multimorbidity, and new multimorbidity. This table contains 7,243,702 records and includes several columns:

  • Origin: This column shows the type of attribute.
  • ID: This column shows the ID of the attribute.
  • Name: This column contains a mix of synonyms for origins and IDs.
  • Value: This column contains the value of the attribute, if it exists.
  • Category: This column has the value absolute for all attributes that are only used for data analysis.
  • temp_patient_id and temp_encounter_id: These serve the same purpose as in the B_EventLog table.