Database - Entity tables

Information concerning the entities are stored in the tables shown in the diagram below.

Table Entity

The entities in an application e.g. the tables and columns in a database

Column Data type Description
Entity varchar (500) Name of the entity, e.g. Table.Column.Content within the database or a unique string for e.g. a message within the DiversityWorkbench (e.g. "DiversityWorkbench.Message.Connection.NoAccess"), primary key
DisplayGroup nvarchar (50) Name of the group, if DiversityWorkbench entities should be displayed in a group.
Notes nvarchar (MAX) Notes about the entity
Obsolete bit True if an entity is obsolete. Obsolete entities may be kept to ensure compatibility with older modules
LogCreatedWhen datetime Point in time when this data set was created
Default value: getdate()
LogCreatedBy nvarchar (50) Name of the creator of this data set
Default value: user_name()
LogUpdatedWhen datetime Point in time when this data set was updated last
Default value: getdate()
LogUpdatedBy nvarchar (50) Name of the person to update this data set last
Default value: user_name()
RowGUID uniqueidentifier -
Default value: newsequentialid()


Table EntityRepresentation

The description of the entity in a certain context in different languages

Column Data type Description
Entity varchar (500) Name of the entity. Foreign key, relates to table Entity
LanguageCode nvarchar (50) ISO 639: 2-letter codes for the language of the content
EntityContext nvarchar (50) Context for the representation, e.g. "Exchange with ABCD", "collection management" or "observation" as defined in table EntityContext_Enum
DisplayText nvarchar (50) Text for the entity as shown e.g. in a user interface
Abbreviation nvarchar (20) Abbreviation for the entity as shown e.g. in a user interface
Description nvarchar (MAX) Description of the entity
Notes nvarchar (MAX) Notes about the representation of the entity
LogCreatedWhen datetime Point in time when this data set was created
Default value: getdate()
LogCreatedBy nvarchar (50) Name of the creator of this data set
Default value: user_name()
LogUpdatedWhen datetime Point in time when this data set was updated last
Default value: getdate()
LogUpdatedBy nvarchar (50) Name of the person to update this data set last
Default value: user_name()
RowGUID uniqueidentifier -
Default value: newsequentialid()


Table EntityUsage

The usage of an entity in a certain context, e.g. hidden, read only

Column Data type Description
Entity varchar (500) Name of the entity. Foreign key, relates to table Entity
EntityContext nvarchar (50) Context for the representation, e.g. "Exchange with ABCD", "collection management" or "observation" as defined in table EntityContext_Enum
Accessibility nvarchar (50) Whether the access to an entity is resticted to e.g. read only or can be edited without restrictions
Determination nvarchar (50) Whether a value is determined e.g. by the system or the user
Visibility nvarchar (50) Whether the entity is visible or hidden from e.g. a user interface
PresetValue nvarchar (500) Whether a value resp. SQL statement for the value is preset, e.g. 'determination' for identifications when using a mobile device during an expedition
Notes nvarchar (MAX) Notes about the usage of the entity
LogCreatedWhen datetime Point in time when this data set was created
Default value: getdate()
LogCreatedBy nvarchar (50) Name of the creator of this data set
Default value: user_name()
LogUpdatedWhen datetime Point in time when this data set was updated last
Default value: getdate()
LogUpdatedBy nvarchar (50) Name of the person to update this data set last
Default value: user_name()
RowGUID uniqueidentifier -
Default value: newsequentialid()