DiversityAgents Model 2.1.24

Content

DiversityAgents Information Model (version 2.1.24, 12 October, 2024)
Authors M. Weiss, A. Grunz, G. Hagedorn, D. Triebel, S. Seifert
License CC BY-ND 3.0
Suggested citation M. Weiss, A. Grunz, G. Hagedorn, D. Triebel & S. Seifert (2024). DiversityAgents information model (version 2.1.24). http://www.diversityworkbench.net/Portal/DiversityAgentsModel_2.1.24
Notes The model is implemented on MS SQL Server and so the data types are also MS SQL Server specific

A short introduction:

DiversityAgents is the module for the administration of agents within the Diversity Workbench. DiversityAgents provides information for other modules like DiversityCollection and DiversityTaxonNames. DiversityAgents keeps only data directly connected with the handling of agents. Data of other realms like e.g. projects or references are handled in separate modules. DiversityAgents can also be used as a stand-alone application.

  • Agent is the central entity, containing the information directly related to the agent.
  • AgentProject keeps the relation to the projects. Each agent may be included in several projects.
  • AgentImage keeps the images for a agent.
  • AgentContactInformation is the central entity, containing the contact informations for the Agent.
  • AgentRelation keeps the relations between the agents.
  • AgentReference keeps the references containing informations about the agent.

ER-Diagram

Overview over all entities and relations used in the database model

ER-Diagram

TABLES

Table Agent

The main table with the data of the agent

Column Data type Description Nullable Relation
AgentID int Unique ID for the Agent (= Primary key) NO -
AgentParentID int The AgentID of the superior agent if agents are organized within a hierarchy YES Refers to table Agent
AgentName nvarchar (200) The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitleDefault value: '' NO -
Version smallint The version of a agent record (revision number, internally filled by system)Default value: (1) NO -
AgentTitle nvarchar (50) The title of the agent, e.g. Dr., Prof. YES Refers to table AgentTitle_Enum
GivenName nvarchar (255) The first names of the agent (if a person) or the name of e.g. an institution YES -
GivenNamePostfix nvarchar (50) Variable part of name, correctly placed at end of given names YES -
InheritedNamePrefix nvarchar (50) Variable part of name, correctly placed at the beginning of the inherited names YES -
InheritedName nvarchar (255) The last names of the agent (if a person) YES -
InheritedNamePostfix nvarchar (50) Additions after inherited name, like generation (Jr., III.) or names of religious orders YES -
Abbreviation nvarchar (50) Abbreviation of the agent YES -
AgentType nvarchar (50) The type of the agent, e.g. person, companyDefault value: N’person' YES Refers to table AgentType_Enum
AgentRole nvarchar (255) The role of an agent esp. a person within an organization. e.g. “Database Administrator” or “Curator” YES -
AgentGender nvarchar (50) The gender of the agent YES Refers to table AgentGender_Enum
Description nvarchar (1000) A description of the agent YES -
OriginalSpelling nvarchar (200) Name as originally written in e.g. chinese or cyrillic letters YES -
Notes nvarchar (MAX) Notes about the agent YES -
ValidFromDate datetime The date of the begin of the exsistence of the agent, e.g. the birthday of a person or the founding of an institution, calculated from ValidFromDay, - Month and -Year YES -
ValidFromDay tinyint The day of the begin of the exsistence of the agent YES -
ValidFromMonth tinyint The month of the begin of the exsistence of the agent YES -
ValidFromYear smallint The year of the begin of the exsistence of the agent YES -
ValidUntilDate datetime The date of the end of the exsistence of the agent, e.g. death of a person or closing of an institute, calculated from ValidUntilDay, - Month and -Year YES -
ValidUntilDay tinyint The day of the end of the exsistence of the agent YES -
ValidUntilMonth tinyint The month of the end of the exsistence of the agent YES -
ValidUntilYear smallint The year of the end of the exsistence of the agent YES -
ValidDateSupplement nvarchar (255) Verbal or additional date information, e.g. ’end of summer 1985’, ‘first quarter’. The time of the valid date if necessary. YES -
PlaceOfBirth nvarchar (500) The place (e.g. a city) where a person was born or an institution was founded YES -
PlaceOfDeath nvarchar (500) The place (e.g.a city) where the person died YES -
SynonymToAgentID int The AgentID of the agent which was selected as a replacement for the current agent, e.g. if to equal datasets were imported from different sources YES Refers to table Agent
SynonymisationType nvarchar (50) The type of the synonymisation like “replaced with”, “synonym to” YES Refers to table AgentSynonymisationType_Enum
RevisionLevel nvarchar (50) The level of the revision of the agent, e.g. ‘unchecked’, ‘final revision’Default value: N’unchecked’ YES Refers to table RevisionLevel_Enum
DataWithholdingReason nvarchar (255) If the dataset is withhold, the reason for withholding the data, otherwise null YES -
IgnoreButKeepForReference bit If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead.Default value: (0) YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: suser_sname() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -
ContentLanguage nvarchar (50) The language of the content YES Refers to table LanguageCode_Enum

Depending on:

  • AgentGender_Enum
  • AgentSynonymisationType_Enum
  • AgentTitle_Enum
  • AgentType_Enum
  • LanguageCode_Enum
  • RevisionLevel_Enum

trgInsAgent

Setting the value of column AgentName according to standard derived from content of given values in columns InheritedNamePrefix, Inheritedname, GivenName, GivenNamePostfix, InheritedNamePostfix and AgentTitle

Table AgentContactInformation

The contact information resp. addresses of the agents

Column Data type Description Nullable Relation
AgentID int Refers to the ID of Agent (= Foreign key and part of primary key) NO Refers to table Agent
DisplayOrder tinyint Display order of records in user interface. DisplayOrder 1 corresponds to the preferred address (= part of primary key) NO -
AddressType nvarchar (50) Type of the adress, e.g. private YES Refers to table AddressType_Enum
Country nvarchar (255) Country of the address YES -
City nvarchar (255) City of the address YES -
PostalCode nvarchar (50) ZIP or postcode of the address (usually output before or after the city) YES -
Streetaddress nvarchar (255) Usually street name and number, but may also contain post office box YES -
Address nvarchar (255) Free text postal address of the agent YES -
Telephone nvarchar (50) Phone number, including area code YES -
CellularPhone nvarchar (50) The number of a mobile telephone device of the agent YES -
Telefax nvarchar (50) Fax number, including area code YES -
Email nvarchar (255) E-mail address of the agent YES -
URI nvarchar (255) URI pointing to a homepage containing further information YES -
Notes nvarchar (MAX) Notes about this address YES -
ValidFrom datetime The date when this address became valid as date according to ISO 8601 YES -
ValidUntil datetime The date of the expiration of the validity of this address as date according to ISO 8601 YES -
DataWithholdingReason nvarchar (255) If the dataset is withhold, the reason for withholding the data, otherwise nullDefault value: N’Withhold by default’ YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: suser_sname() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -

Depending on:

  • AddressType_Enum
  • Agent

trgInsAgentContactInformation

Table AgentDescriptor

The Descriptors for the agents

Column Data type Description Nullable Relation
AgentID int Unique ID for the Agent (foreign key + part of primary key) NO Refers to table Agent
DescriptorID int Unique ID for the descriptor, Part of PK NO -
Descriptor nvarchar (200) The DescriptorDefault value: '’ NO -
URL varchar (500) URL of the Descriptor. In case of a module related Descriptor, the link to the module entry resp. the related webserviceDefault value: '' YES -
DescriptorType nvarchar (50) Type of the Descriptor as described in table AgentDescriptorType_EnumDefault value: N’Descriptor' YES Refers to table AgentDescriptorType_Enum
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: suser_sname() YES -
LogInsertedWhen smalldatetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: suser_sname() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() NO -

Depending on:

  • Agent
  • AgentDescriptorType_Enum

Table AgentExternalDatabase

The external databases from which data in the database may have been imported from

Column Data type Description Nullable Relation
ExternalDatabaseID int An ID to identify an external data collection of plant names (primary key, the ID has no meaning outside of the DiversityWorkbench system) NO -
ExternalDatabaseName nvarchar (100) The name of the data collection that has been integrated or can be linked to for further analysis YES -
ExternalDatabaseVersion nvarchar (255) The version of this data collection (either official version number, or dates when the collection was integrated) YES -
Rights nvarchar (500) A description of copyright agreements or permission to use data from the external database YES -
ExternalDatabaseAuthors nvarchar (200) The persons or institutions responsible for the external database YES -
ExternalDatabaseURI nvarchar (300) The link to the database provider resp. the external database YES -
ExternalDatabaseInstitution nvarchar (300) The institution responsible for the external database YES -
InternalNotes nvarchar (1500) Additional notes concerning this data collection YES -
ExternalAttribute_AgentID nvarchar (255) The table and field name in the external data collection to which PlantNameAnalysis.ExternalNameID refers YES -
PreferredSequence tinyint For selection in e.g. picklists: of several equal names only the name from the source with the lowest preferred sequence will be provided. YES -
Disabled bit If this source should be disabled for selection of names e.g. in picklists YES -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data. YES -
LogInsertedWhen smalldatetime Date and time when the data were first entered (typed or imported) into this database. YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data. YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated. YES -

Table AgentExternalID

The ID’s of data that were imported from foreign souces

Column Data type Description Nullable Relation
AgentID int Unique ID for the Agent (foreign key + part of primary key) NO Refers to table Agent
ExternalDatabaseID int The ID of an external taxonomic data collection as defined in AgentExternalDatabase (foreign key + part of primary key)Default value: '' NO Refers to table AgentExternalDatabase
ExternalAgentURI varchar (255) The URI (e.g. LSID) of the external agent YES -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: suser_sname() YES -
LogInsertedWhen smalldatetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: suser_sname() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -

Depending on:

  • Agent
  • AgentExternalDatabase

Table AgentHierarchyOther

Other hierarchies of the agent

Column Data type Description Nullable Relation
AgentID int Refers to the ID of Agent (= Foreign key and part of primary key) NO Refers to table Agent
HierarchyID int Identifier of the hierarchy, part of PK NO -
AgentParentID int The AgentID of the superior agent if agents are organized within a hierarchy NO Refers to table Agent
ValidFrom datetime The start time of the hierarchy, e.g. when a person was employed in an institution YES -
ValidUntil datetime The end of a hierarchy, e.g. when an employment ended YES -
Notes nvarchar (MAX) Notes about the other hierarchy YES -
LogCreatedWhen datetime Point in time when this data set was createdDefault value: getdate() YES -
LogCreatedBy nvarchar (50) Name of the creator of this data setDefault value: suser_sname() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: suser_sname() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() NO -

Depending on:

  • Agent

Table AgentIdentifier

Identifier for the agent

Column Data type Description Nullable Relation
AgentID int Refers to the ID of Agent (= Foreign key and part of primary key) NO Refers to table Agent
Identifier nvarchar (400) Identifier for the agent, part of PK NO -
IdentifierURI varchar (500) URI of Identifier YES -
Type nvarchar (50) Type of the identifier as defined in table AgentIdentifierType_Enum YES Refers to table AgentIdentifierType_Enum
Notes nvarchar (MAX) Notes about the identifier YES -
LogCreatedWhen datetime Point in time when this data set was createdDefault value: getdate() YES -
LogCreatedBy nvarchar (50) Name of the creator of this data setDefault value: suser_sname() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: suser_sname() YES -
RowGUID uniqueidentifier -Default value: newsequentialid() NO -

Depending on:

  • Agent
  • AgentIdentifierType_Enum

Table AgentImage

The images of the agents

Column Data type Description Nullable Relation
AgentID int Unique ID for the Agent (foreign key + part of primary key) NO Refers to table Agent
URI varchar (255) The complete URI address of the image. This is only a cached value if ResourceID is available referring to the module DiversityResources NO -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: suser_sname() YES -
LogInsertedWhen smalldatetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: suser_sname() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -
Description nvarchar (MAX) Description of the resource YES -
Type nvarchar (50) The type of the image YES Refers to table AgentImageType_Enum
Sequence int The sequence of the imageDefault value: (1) YES -
DataWithholdingReason nvarchar (255) If the dataset is withhold, the reason for withholding the data, otherwise nullDefault value: N’Withhold by default' YES -

Depending on:

  • Agent
  • AgentImageType_Enum

trgInsAgentImage

Table AgentKeyword

The keywords for the agents

Column Data type Description Nullable Relation
AgentID int Unique ID for the Agent (foreign key + part of primary key) NO Refers to table Agent
Keyword nvarchar (200) The keyword NO -
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: suser_sname() YES -
LogInsertedWhen smalldatetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: suser_sname() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -

Depending on:

  • Agent

trgInsAgentKeyword

Table AgentProject

The projects of the agents

Column Data type Description Nullable Relation
AgentID int Unique ID for the Agent (= Foreign key) NO Refers to table Agent
ProjectID int The ID of the projectDefault value: (0) NO Refers to table ProjectProxy
LogInsertedBy nvarchar (50) Name of user who first entered (typed or imported) the data.Default value: suser_sname() YES -
LogInsertedWhen smalldatetime Date and time when the data were first entered (typed or imported) into this database.Default value: getdate() YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data.Default value: suser_sname() YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated.Default value: getdate() YES -

Depending on:

  • Agent
  • ProjectProxy

Table AgentReference

References containing informations about the agent

Column Data type Description Nullable Relation
AgentID int Refers to the ID of Agent (= Foreign key and part of primary key) NO Refers to table Agent
ReferenceTitle nvarchar (255) The title of the publication where information about the agent was published. Note this is only a cached value where ReferenceURI is present NO -
ReferenceURI varchar (255) URI of reference where information about the agent, e.g. referring to the module DiversityReferences YES -
ReferenceDetails nvarchar (50) Details within the reference, e.g. pages YES -
ContainsImage tinyint If the reference contains an image of the agent YES -
ContainsReferencelist tinyint If the reference contains a publication list of the agent YES -
Notes nvarchar (255) Notes about the reference YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data. YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated. YES -

Depending on:

  • Agent

trgInsAgentReference

Table AgentRelation

Relations of the agent to other agents

Column Data type Description Nullable Relation
AgentID int Refers to the ID of Agent (= Foreign key and part of primary key) NO Refers to table Agent
RelatedAgentID int The AgentID of the related agent NO -
RelationType nvarchar (50) The type of the relation between the agents, e.g. “parent of”, “child of”, “married to” YES Refers to table AgentRelationType_Enum
Notes nvarchar (255) Notes about the relation YES -
DataWithholdingReason nvarchar (255) If the dataset is withhold, the reason for withholding the data, otherwise null YES -
LogUpdatedBy nvarchar (50) Name of user who last updated the data. YES -
LogUpdatedWhen smalldatetime Date and time when the data were last updated. YES -

Depending on:

  • Agent
  • AgentRelationType_Enum

trgInsAgentRelation

Enumeration tables

Tabledesign

Column Data type Description
Code nvarchar (50) A text code that uniquely identifies each object in the enumeration (primary key). This value may not be changed, because the application may depend upon it.
ParentCode nvarchar (50) The code of the superior entry, if a hierarchy within the entries is necessary
ParentRelation nvarchar (50) Relation to parent entry, e.g. part of
Description nvarchar (500) Description of enumerated object, displayed in the user interface
DisplayText nvarchar (50) Short abbreviated description of the object, displayed in the user interface
DisplayOrder smallint The order in which the entries are displayed. The order may be changed at any time, but all values must be unique.
DisplayEnable bit Enumerated objects can be hidden from the user interface if this attribute is set to false (= unchecked check box)
URL varchar (500) A link to further information about the enumerated object
InternalNotes nvarchar (500) Internal development notes about usage, definition, etc. of an enumerated object
Icon image A symbol representing this entry in the user interface
ModuleName varchar (50) If the enumerated entry is related to a DiversityWorkbench module or a related webservice, the name of the DiversityWorkbench module, e.g. DiversityAgents
RowGUID uniqueidentifier -Default value: newsequentialid()

Table AddressType_Enum

Lookup table for the types of the addresses

Dependent tables:

  • AgentContactInformation

Content

Code Description
office office address
private private address

Table AgentDescriptorType_Enum

The type of the Descriptors

Dependent tables:

  • AgentDescriptor

Table AgentGender_Enum

Gender of the agent: female or male

Dependent tables:

  • Agent

Content

Code Description
female
male

Table AgentIdentifierType_Enum

Types of the agent identifier, e.g. ISNI

Dependent tables:

  • AgentIdentifier

Content

Code Description
ISNI International Standard Name Identifier (ISO 27729)
ORCID Open Researcher Contributor Identification
ROR Research Organization Registry

Table AgentImageType_Enum

Types of images in table AgentImage, e.g. Logo

Dependent tables:

  • AgentImage

Content

Code Description
Logo Logo
Portrait Portrait

Table AgentNameDisplayType_Enum

Display types of the names of the agents, defining e.g. the position of title, given and inherited part of the name and their abbreviation

Dependent tables:

  • ProjectProxy

Content

Code Description
Abbr The international defined standard arbbreviation; e.g. L. for Linne
G. Ii Given name. Inherited name; e.g. H. Hertel
Gg Ii Given name InheritedName; e.g. Hannes Hertel
Ii, G. Inherited name, GivenName; e.g. Hertel, H.
Ii, Gg Inherited name, GivenName; e.g. Hertel, Hannes
Tt. G. Ii Titel Given name. Inherited name; e.g. Prof. H. Hertel
Tt. Gg Ii Titel Given name Inherited name; e.g. Prof. Hannes Hertel

Table AgentRelationType_Enum

Relation types of agents, e.g. Child of

Dependent tables:

  • AgentRelation

Content

Code Description
Child of
Married to
Parent of

Table AgentSynonymisationType_Enum

Synonymisation types of agents, e.g. synonym to

Dependent tables:

  • Agent

Content

Code Description
replaced with if the agent was replaced by another entry
synonym to if the agent is synonym to another agent

Table AgentTitle_Enum

Lookup table for the titles of the agents

Dependent tables:

  • Agent

Content

Code Description
Dr.
Frater
Pater
Prof.
Prof. Dr.

Table AgentType_Enum

Lookup table for the types of the agents

Dependent tables:

  • Agent

Content

Code Description
Collection
Company
Department
Group
Institution
Person
University

Table LanguageCode_Enum

The codes for the languages

Dependent tables:

  • Agent

Content

Code Description
af Afrikaans
ar Arabisch
az Aserbaidschanisch
be Belarussisch
bg Bulgarisch
ca Katalanisch
cs Tschechisch
da DĂ€nisch
de Deutsch
el Griechisch
en Englisch
es Spanisch
et Estnisch
eu Baskisch
fa Farsi
fi Finnisch
fo FĂ€ringisch
fr Französisch
gl Galizisch
gu Gujarati
he HebrÀisch
hi Hindi
hr Kroatisch
hu Ungarisch
hy Armenisch
id Indonesisch
is IslÀndisch
it Italienisch
ja Japanisch
ka Georgisch
kk Kasachisch
kn Kannada
ko Koreanisch
ky Kirgisisch
lt Litauisch
lv Lettisch
mk Mazedonisch
mn Mongolisch
mr Marathi
ms Malaiisch
nl NiederlÀndisch
no Norwegisch
pa Punjabi
pl Polnisch
pt Portugiesisch
ro RumÀnisch
ru Russisch
sa Sanskrit
sk Slowakisch
sl Slowenisch
sq Albanisch
sv Schwedisch
sw Swahili
ta Tamil
te Telugu
th Thai
tr TĂŒrkisch
tt Tatarisch
uk Ukrainisch
ur Urdu
uz Usbekisch
vi Vietnamesisch
zh Chinesisch

Table RevisionLevel_Enum

Lookup table for the revision level

Dependent tables:

  • Agent

Content

Code Description
checked checked
final revision final revision
review required review required
to be deleted to be deleted
unchecked unchecked

VIEWS

View Agent_Core

Agents that are available for a user and are not ignored

Column Data type Description Nullable
AgentID int Unique ID for the Agent (= Primary key) NO
AgentParentID int The AgentID of the superior agent if agents are organized within a hierarchy YES
AgentName nvarchar (200) The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitle NO
DisplayText nvarchar (204) The name of the agent including indentation for synonyms NO
Version smallint The version of a agent record (revision number, internally filled by system) NO
AgentTitle nvarchar (50) The title of the agent, e.g. Dr., Prof. YES
GivenName nvarchar (255) The first names of the agent (if a person) or the name of e.g. an institution YES
GivenNamePostfix nvarchar (50) Variable part of name, correctly placed at end of given names YES
InheritedNamePrefix nvarchar (50) Variable part of name, correctly placed at the beginning of the inherited names YES
InheritedName nvarchar (255) The last names of the agent (if a person) YES
InheritedNamePostfix nvarchar (50) Additions after inherited name, like generation (Jr., III.) or names of religious orders YES
Abbreviation nvarchar (50) Abbreviation of the agent YES
AgentType nvarchar (50) The type of the agent, e.g. person, company YES
AgentRole nvarchar (255) The role of an agent esp. a person within an organization. e.g. “Database Administrator” or “Curator” YES
AgentGender nvarchar (50) The gender of the agent YES
Description nvarchar (1000) A description of the agent YES
OriginalSpelling nvarchar (200) Name as originally written in e.g. chinese or cyrillic letters YES
Notes nvarchar (MAX) Notes about the agent YES
ValidFromDate datetime The date of the begin of the exsistence of the agent, e.g. the birthday of a person or the founding of an institution, calculated from ValidFromDay, - Month and -Year YES
ValidFromDay tinyint The day of the begin of the exsistence of the agent YES
ValidFromMonth tinyint The month of the begin of the exsistence of the agent YES
ValidFromYear smallint The year of the begin of the exsistence of the agent YES
ValidUntilDate datetime The date of the end of the exsistence of the agent, e.g. death of a person or closing of an institute, calculated from ValidUntilDay, - Month and -Year YES
ValidUntilDay tinyint The day of the end of the exsistence of the agent YES
ValidUntilMonth tinyint The month of the end of the exsistence of the agent YES
ValidUntilYear smallint The year of the end of the exsistence of the agent YES
ValidDateSupplement nvarchar (255) Verbal or additional date information, e.g. ’end of summer 1985’, ‘first quarter’. The time of the valid date if necessary. YES
PlaceOfBirth nvarchar (500) The place (e.g. a city) where a person was born or an institution was founded YES
PlaceOfDeath nvarchar (500) The place (e.g.a city) where the person died YES
SynonymToAgentID int The AgentID of the agent which was selected as a replacement for the current agent, e.g. if to equal datasets were imported from different sources YES
SynonymisationType nvarchar (50) The type of the synonymisation like “replaced with”, “synonym to” YES
RevisionLevel nvarchar (50) The level of the revision of the agent, e.g. ‘unchecked’, ‘final revision’ YES
DataWithholdingReason nvarchar (255) If the dataset is withhold, the reason for withholding the data, otherwise null YES
IgnoreButKeepForReference bit If true, the record is ignored for all purposes of evaluation (because contradicted). It is kept only to maintain the cited reference. If no reference is given, it may be deleted instead. YES
ValidFrom varchar (92) The date of the begin of the exsistence of the agent, e.g. the birthday of a person or the founding of an institution YES
ValidUntil varchar (92) The date of the end of the exsistence of the agent, e.g. death of a person or closing of an institute YES

Depending on:

  • Agent
  • AgentID_UserAvailable

View AgentID_AvailableReadOnly

Available AgentIDs that are ReadOnly or Locked

Column Data type Description Nullable
AgentID int Unique ID for the Agent (= Foreign key) NO

Depending on:

  • AgentID_Locked
  • AgentProject
  • ProjectUser

View AgentID_FullAccess

ID of agents with full access (neither read only or locked)

Column Data type Description Nullable
AgentID int Unique ID for the Agent (= Foreign key) NO

Depending on:

  • AgentProject
  • ProjectProxy
  • ProjectUser

View AgentID_Locked

AgentIDs that are locked due to locking of the project

Column Data type Description Nullable
AgentID int Unique ID for the Agent (= Foreign key) NO

Depending on:

  • AgentProject
  • ProjectProxy

View AgentID_ReadOnly

AgentIDs that are ReadOnly for a User or are locked due to locking of the project

Column Data type Description Nullable
AgentID int Unique ID for the Agent (= Foreign key) NO

Depending on:

  • AgentID_Locked
  • AgentProject
  • ProjectUser

View AgentID_UserAvailable

IDs of the agent available for a user

Column Data type Description Nullable
AgentID int Unique ID for the Agent (= Primary key) NO

Depending on:

  • Agent
  • AgentProject
  • ProjectUser

View ProjectList

Projects available for a user

Column Data type Description Nullable
ProjectID int The ID of the project, Primary key NO
Project nvarchar (50) The name of the project as stored in the module DiversityProjects NO
ReadOnly int If the user has only read access to data of this project YES
IsLocked bit If the data within the project should not be changeed and the access for all users is restricted to read only YES

Depending on:

  • ProjectProxy
  • ProjectUser

View PublicAgent

Content of table Agent available for the public

Column Data type Description Nullable
DisplayText nvarchar (200) Corresponds to content of column AgentName NO
URI varchar (285) Combines BaseURL of the database and AgentID to provide unique identifier of the dataset YES
AgentID int Unique ID for the Agent (= Primary key) NO
AgentParentID int The AgentID of the superior agent if agents are organized within a hierarchy YES
AgentName nvarchar (200) The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitle NO
Version smallint The version of a agent record (revision number, internally filled by system) NO
AgentTitle nvarchar (50) The title of the agent, e.g. Dr., Prof. YES
GivenName nvarchar (255) The first names of the agent (if a person) or the name of e.g. an institution YES
GivenNamePostfix nvarchar (50) Variable part of name, correctly placed at end of given names YES
InheritedNamePrefix nvarchar (50) Variable part of name, correctly placed at the beginning of the inherited names YES
InheritedName nvarchar (255) The last names of the agent (if a person) YES
InheritedNamePostfix nvarchar (50) Additions after inherited name, like generation (Jr., III.) or names of religious orders YES
Abbreviation nvarchar (50) Abbreviation of the agent YES
AgentType nvarchar (50) The type of the agent, e.g. person, company YES
AgentRole nvarchar (255) The role of an agent esp. a person within an organization. e.g. “Database Administrator” or “Curator” YES
AgentGender nvarchar (50) The gender of the agent YES
Description nvarchar (1000) A description of the agent YES
OriginalSpelling nvarchar (200) Name as originally written in e.g. chinese or cyrillic letters YES
Notes nvarchar (MAX) Notes about the agent YES
ValidFromDate datetime The date of the begin of the exsistence of the agent, e.g. the birthday of a person or the founding of an institution, calculated from ValidFromDay, - Month and -Year YES
ValidFromDay tinyint The day of the begin of the exsistence of the agent YES
ValidFromMonth tinyint The month of the begin of the exsistence of the agent YES
ValidFromYear smallint The year of the begin of the exsistence of the agent YES
ValidUntilDate datetime The date of the end of the exsistence of the agent, e.g. death of a person or closing of an institute, calculated from ValidUntilDay, - Month and -Year YES
ValidUntilDay tinyint The day of the end of the exsistence of the agent YES
ValidUntilMonth tinyint The month of the end of the exsistence of the agent YES
ValidUntilYear smallint The year of the end of the exsistence of the agent YES
ValidDateSupplement nvarchar (255) Verbal or additional date information, e.g. ’end of summer 1985’, ‘first quarter’. The time of the valid date if necessary. YES
PlaceOfBirth nvarchar (500) The place (e.g. a city) where a person was born or an institution was founded YES
PlaceOfDeath nvarchar (500) The place (e.g.a city) where the person died YES
SynonymToAgentID int The AgentID of the agent which was selected as a replacement for the current agent, e.g. if to equal datasets were imported from different sources YES
SynonymisationType nvarchar (50) The type of the synonymisation like “replaced with”, “synonym to” YES
RevisionLevel nvarchar (50) The level of the revision of the agent, e.g. ‘unchecked’, ‘final revision’ YES
LogUpdatedWhen smalldatetime Date and time when the data were last updated. YES

Depending on:

  • Agent
  • AgentNames
  • BaseURL
  • DefaultAgentNameDisplayType

View PublicContactInformation

Accumulated public address of an agent within a hierarchy of up to 4 levels

Column Data type Description Nullable
AgentID int Unique ID for the Agent (= Primary key) NO
DisplayOrder tinyint Display order of records in user interface. DisplayOrder 1 corresponds to the preferred address (= part of primary key) NO
ParentName nvarchar (200) Name of the superior agent within the hierarchy YES
AddressType nvarchar (50) Type of the adress, e.g. private YES
Country nvarchar (255) Country of the address YES
City nvarchar (255) City of the address YES
PostalCode nvarchar (50) ZIP or postcode of the address (usually output before or after the city) YES
Streetaddress nvarchar (255) Usually street name and number, but may also contain post office box YES
Address nvarchar (255) Free text postal address of the agent YES
Telephone nvarchar (50) Phone number, including area code YES
CellularPhone nvarchar (50) The number of a mobile telephone device of the agent YES
Telefax nvarchar (50) Fax number, including area code YES
Email nvarchar (255) E-mail address of the agent YES
URI nvarchar (255) URI pointing to a homepage containing further information YES
Notes nvarchar (MAX) Notes about the agent YES
ValidFrom datetime The date when this address became valid as date according to ISO 8601 YES
ValidUntil datetime The date of the expiration of the validity of this address as date according to ISO 8601 YES
LogUpdatedWhen smalldatetime Date and time when the data were last updated. YES

Depending on:

  • AgentContactInformation_Public

View PublicIdentifier

Content of table AgentIdentifier available for the public

Column Data type Description Nullable
AgentID int Unique ID for the Agent (= Primary key) NO
Identifier nvarchar (400) Identifier for the agent, part of PK NO
IdentifierURI varchar (500) URI of Identifier YES
Type nvarchar (50) Type of the identifier as defined in table AgentIdentifierType_Enum YES
Notes nvarchar (MAX) Notes about the agent YES
LogUpdatedWhen smalldatetime Date and time when the data were last updated. YES

Depending on:

  • Agent
  • AgentIdentifier

View PublicImage

Content of table AgentImage available for the public

Column Data type Description Nullable
AgentID int Unique ID for the Agent (= Primary key) NO
URI varchar (255) The complete URI address of the image. This is only a cached value if ResourceID is available referring to the module DiversityResources NO
Description nvarchar (MAX) A description of the agent YES
Type nvarchar (50) The type of the image YES
Sequence int The sequence of the image YES
LogUpdatedWhen smalldatetime Date and time when the data were last updated. YES

Depending on:

  • Agent
  • AgentImage

View PublicReference

Content of table AgentReference available for the public

Column Data type Description Nullable
AgentID int Unique ID for the Agent (= Primary key) NO
ReferenceTitle nvarchar (255) The title of the publication where information about the agent was published. Note this is only a cached value where ReferenceURI is present NO
ReferenceURI varchar (255) URI of reference where information about the agent, e.g. referring to the module DiversityReferences YES
ReferenceDetails nvarchar (50) Details within the reference, e.g. pages YES
ContainsImage tinyint If the reference contains an image of the agent YES
ContainsReferencelist tinyint If the reference contains a publication list of the agent YES
Notes nvarchar (255) Notes about the agent YES
LogUpdatedWhen smalldatetime Date and time when the data were last updated. YES

Depending on:

  • Agent
  • AgentReference

View PublicRelation

Content of table AgentRelation available for the public

Column Data type Description Nullable
AgentID int Unique ID for the Agent (= Primary key) NO
RelatedAgentID int The AgentID of the related agent NO
RelationType nvarchar (50) The type of the relation between the agents, e.g. “parent of”, “child of”, “married to” YES
Notes nvarchar (255) Notes about the agent YES
LogUpdatedWhen smalldatetime Date and time when the data were last updated. YES

Depending on:

  • Agent
  • AgentRelation

View UserInfo

Information about the user as stored in table UserProxy

Column Data type Description Nullable
LoginName nvarchar (50) The login name of the user, Primary key NO
CombinedNameCache nvarchar (50) A combined name of the user, created on the base of an entry in the module DiversityUsers YES
UserURI varchar (255) Refers to UserInfo.UserID in database DiversityUsers YES
ProjectID int The ID of the default project of the user as stored in table ProjectProxy YES

Depending on:

  • UserProxy

View ViewAgentAddress

Accumulated address of an agent within a hierarchy of up to 4 levels

Column Data type Description Nullable
AgentID int Refers to the ID of Agent (= Foreign key and part of primary key) YES
DisplayOrder tinyint Display order of records in user interface. DisplayOrder 1 corresponds to the preferred address (= part of primary key) YES
ParentName nvarchar (200) Name of the superior agent within the hierarchy YES
AddressType nvarchar (50) Type of the adress, e.g. private YES
Country nvarchar (255) Country of the address YES
City nvarchar (255) City of the address YES
PostalCode nvarchar (50) ZIP or postcode of the address (usually output before or after the city) YES
Streetaddress nvarchar (255) Usually street name and number, but may also contain post office box YES
Address nvarchar (255) Free text postal address of the agent YES
Telephone nvarchar (50) Phone number, including area code YES
CellularPhone nvarchar (50) The number of a mobile telephone device of the agent YES
Telefax nvarchar (50) Fax number, including area code YES
Email nvarchar (255) E-mail address of the agent YES
URI nvarchar (255) URI pointing to a homepage containing further information YES
Notes nvarchar (MAX) Notes about this address YES
ValidFrom datetime The date when this address became valid as date according to ISO 8601 YES
ValidUntil datetime The date of the expiration of the validity of this address as date according to ISO 8601 YES

Depending on:

  • ViewAgentAddress0
  • ViewAgentAddress1
  • ViewAgentAddress2
  • ViewAgentAddress3
  • ViewAgentAddress4

View ViewAgentNames

The names of the agents as retrieved for the default display type with function AgentNames

Column Data type Description Nullable
AgentID int Unique ID for the Agent (= Primary key) NO
AgentName nvarchar (200) The whole name of the agent as shown e.g. for selection in an user interface. For persons this entry will be generated as follows: LastName, FirstNames, AgentTitle NO

Depending on:

  • AgentNames
  • DefaultAgentNameDisplayType

View ViewBaseURL

Provides the basic address for accessing the database as defined in function BaseURL

Column Data type Description Nullable
BaseURL varchar (255) Basic address for accessing the database YES

Depending on:

  • BaseURL

View ViewDefaultAgentNameDisplayType

The default display type as set for the default project as defined in function DefaultAgentNameDisplayType

Column Data type Description Nullable
DefaultAgentNameDisplayType nvarchar (50) The default display type YES

Depending on:

  • DefaultAgentNameDisplayType

View ViewDiversityWorkbenchModule

Provides the name of the DiversityWorkbench module as defined in function DiversityWorkbenchModule

Column Data type Description Nullable
DiversityWorkbenchModule nvarchar (50) The name of the DiversityWorkbench module YES

Depending on:

  • DiversityWorkbenchModule