Information concerning the entities are stored in the tables shown in the diagram below.
| 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() |
| 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() |
| 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() |