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() |