| exi_id | int(11) | NO | | PRI | auto_increment | |
| exi_org_id | int(11) | NO | 0 | MUL | | Organization ID i.e. Dr First, Labcrop, PDS |
| exi_mdl_id | int(11) | NO | 0 | | | Mapped concept i.e. See models table |
| exi_internal_id | varchar(50) | NO | | | | |
| exi_external_id | varchar(128) | NO | | | | |
| exi_public_id | varchar(50) | NO | | | | User Facing ID |
| exi_cli_id | int(11) | YES | | | | Client ID# |
| exi_last_received_dt | datetime | YES | | | | the last time this entity has received an update from the given external source |
| exi_last_sent_dt | datetime | YES | | | | the last time this entity has sent an update to the given external source |
| exi_version_id | int(11) | NO | 0 | | | Version ID of the given record |
| exi_internal_attr | varchar(100) | YES | | | | Internal Azalea attribute. i.e. espv_height maps to a single result record |
| exi_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| exi_created | timestamp | YES | CURRENT_TIMESTAMP | | | |