EntityCounts table - SuperOffice

EntityCounts Table (547)

Number of different entities an associate has created for usage statistics

Fields

Name	Description	Type	Nullable
entitycounts_id	Primary key	PK	No
associate_id	Associate who created the entity	FK associate	Yes
entity_name	The entity measured by this tile	String(255)	Yes
records	Number of related entities an associate has created	Int	Yes
registered	Registered when	UtcDateTime	Yes

Indexes

Fields	Types	Description
associate_id, entity_name	FK, String(255)	Unique

Relationships

Table	Description
associate	Employees, resources and other users - except for External persons

Replication Flags

None

Security Flags

No access control via user’s Role.