entityData table and entity view

Information on entities is held in the entityData table in Network Manager versions 3.9 and later. This table replaces the entity table used in earlier versions. To ensure backward compatibility an entity view has been created to hold the same data as the entity table from earlier versions.

The difference between the entityData table and the earlier entity table is that entities in the entityData can be members of more than one domain. In versions 3.8 and earlier, an entity in the entity table could only be a member of a single domain.

In order to facilitate this, the domainMgrId field that was in the earlier entity tables does not appear in the entityData table. Instead, in versions 3.9 and later a new domainMembers table maps entityId values from the entityData table to the domainMgrId values from the domainMgr table. This enables a single entity to be a member of multiple domains.

In versions 3.9 and later the entity view is created by joining the two tables, entityData and domainMembers.