Diversity Projects
TABLES, VIEWS, FUNCTIONS, PROCEDURES, ROLES
The following objects are not included:
- Logging tables
- Enumeration tables
- System objects
- Objects marked as obsolete
- Previous versions of objects
TABLES
Table Project
Information on the project
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| ProjectID | int | PK, ID of the Project | NO | - |
| ProjectParentID | int | ID of the superior project | YES | Refers to table Project |
| Project | nvarchar (255) | A short title for the project as displayed e.g. for selection from a list in an user interface | NO | - |
| ProjectTitle | nvarchar (200) | An explicit title for the project | YES | - |
| ProjectType | nvarchar (50) | Type of the project | YES | Refers to table ProjectType_Enum |
| ProjectDescription | nvarchar (MAX) | A text, describing characteristic features, e. g. the purpose and scope, of the project | YES | - |
| ProjectDescriptionType | nvarchar (50) | classification of the public description, e. g. abstract | YES | - |
| PublicDescription | nvarchar (MAX) | Public description of the project if different from the description | YES | - |
| InternalDescription | nvarchar (MAX) | Internal description of the project, not to be published | YES | - |
| ProjectNotes | nvarchar (1000) | Internal notes regarding the project, not published on the web | YES | - |
| ProjectVersion | nvarchar (255) | Version number (refers to the database content of this project, not to application development) | YES | - |
| ProjectURL | varchar (255) | An URL where e.g. the project is described | YES | - |
| ProjectRights | nvarchar (255) | The rights, e.g. the copyright of the project | YES | - |
| ProjectEditors | nvarchar (255) | The editors of the project | YES | - |
| ProjectInstitution | nvarchar (500) | The institution responsible for the Project | YES | - |
| ProjectSettings | xml (MAX) | The settings used within the project | YES | - |
| ProjectCopyright | nvarchar (255) | Copyright statement for the data collected for and revised by this project | YES | - |
| ProjectLicenseURI | nvarchar (255) | The license under which the project is re-used or may be re-used | YES | - |
| EmbargoDate | date | The date until which the data should not be published, made available to the public | YES | - |
| CreateArchive | bit | If an archive e.g. by a task schedule should be created | YES | - |
| ArchiveProtocol | nvarchar (MAX) | The protocol created during the last archive | YES | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: suser_sname() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when record was first entered (typed or imported) into this system.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() | YES | - |
Depending on:
- ProjectType_Enum
Table ProjectAgent
The persons or institutions involved in the project
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| ProjectAgentID | int | Unique ID for the Agent, Primary key | NO | - |
| ProjectID | int | Refers to the ID of the project (= Foreign key and part of primary key) | NO | Refers to table Project |
| AgentName | nvarchar (255) | The name of the agent. Only cached value where AgentURI is given, Part of PK | NO | - |
| AgentURI | varchar (255) | An URL linked to e.g. the module DiversityAgents within the Diversity Workbench, Part of PKDefault value: '' | NO | - |
| AgentType | nvarchar (50) | The type of the agent, e.g. person or institution as defined in ProjectAgentType_Enum | YES | Refers to table ProjectAgentType_Enum |
| AgentRole | nvarchar (50) | The role of the agent within the project as defined in ProjectAgentRole_Enum | YES | - |
| AgentSequence | int | The sequence of an agent within a project | YES | - |
| Notes | nvarchar (MAX) | Notes about the agent | YES | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: suser_sname() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when record was first entered (typed or imported) into this system.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:
- Project
- ProjectAgentType_Enum
Table ProjectAgentRole
The role of the person or institution involved in the project
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| ProjectAgentID | int | Unique ID for the Agent, Part of primary key | NO | Refers to table ProjectAgent |
| AgentRole | nvarchar (50) | The role of the agent within the project as defined in ProjectAgentRole_Enum | NO | Refers to table ProjectAgentRole_Enum |
| ProjectID | int | Part of PK, ID of the Project | NO | - |
| AgentName | nvarchar (255) | The name of the agent. Only cached value where AgentURI is given | NO | - |
| AgentURI | varchar (255) | An URL linked to e.g. the module DiversityAgents within the Diversity Workbench | NO | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: suser_sname() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when record was first entered (typed or imported) into this system.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:
- ProjectAgent
- ProjectAgentRole_Enum
Table ProjectArchive
Archives of the project
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| ProjectID | int | Part of PK, ID of the Project | NO | Refers to table Project and table ProjectArchive |
| ArchiveID | int | Part of PK, ID of the Archive | NO | - |
| ParentArchiveID | int | The ID of the parent archive | YES | Refers to table ProjectArchive |
| Format | nvarchar (50) | The format of the archive,e.g. SDD, EML, ABCD etc. | YES | Refers to table ProjectArchiveFormat_Enum |
| MimeType | nvarchar (50) | The mime type of the archive, e.g. zip | YES | Refers to table ProjectArchiveMimeType_Enum |
| StorageLocation | nvarchar (500) | The path or URI of the archive file | YES | - |
| ExternalStorageLocation | nvarchar (500) | The path or URI of the archive file as stored on an external server | YES | - |
| FileSHA512Hash | nvarchar (529) | The hash value generated from the file | YES | - |
| FileSize | int | Size of the file in bytes | YES | - |
| TransferDate | datetime | The date and time when the data were transferred from the productive database (Last date and time when changes may have happend)Default value: getdate() | YES | - |
| PublicationDate | date | The date when the archive is published | YES | - |
| DataWithholdingReason | nvarchar (50) | The reason for locking the data from publication. If empty data may be published | YES | - |
| Notes | nvarchar (MAX) | Notes about the archive | YES | - |
| Published | bit | If the dataset is published and no further changes are allowedDefault value: (0) | YES | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: suser_sname() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when record was first entered (typed or imported) into this system.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:
- Project
- ProjectArchiveFormat_Enum
- ProjectArchiveMimeType_Enum
Table ProjectArchiveIdentifier
Identifier of archives of the project
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| ProjectID | int | Part of PK, ID of the Project | NO | Refers to table ProjectArchive and table ProjectIdentifier |
| ArchiveID | int | Part of PK, ID of the Archive | NO | Refers to table ProjectArchive |
| Identifier | nvarchar (255) | The identifier if archive is linked to an identifier | NO | Refers to table ProjectIdentifier |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: suser_sname() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when record was first entered (typed or imported) into this system.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:
- ProjectArchive
- ProjectIdentifier
Table ProjectDescriptor
Object names, event names, keywords, etc., providing indexing information for a resource.
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| ID | int | Internal system generated primary key. Note that multiple values for a descriptor concept may be added (e.g. keywords) | NO | - |
| ProjectID | int | ID of the project, foreign key | NO | Refers to table Project |
| Language | varchar (5) | Language in which element content is expressed. Necessary even for numeric or date content (because expressed through string using language-specific conventions)Default value: ’en' | NO | - |
| ElementID | int | ID of a descriptor element concept (foreign key)Default value: (0) | NO | Refers to table ProjectDescriptorElement |
| Content | nvarchar (255) | A name, state, or value text for the descriptor element.Default value: '' | NO | - |
| ContentURI | varchar (500) | The URI of a conceptual ontological resource considered equivalent with the content, especially URIs for taxon names or keywords from ontologies.Default value: '' | NO | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: suser_sname() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when record was first entered (typed or imported) into this system.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:
- Project
- ProjectDescriptorElement
Table ProjectDescriptorElement
Examples of descriptor elements (= concepts for variables) are keyword, taxon name, pathogen name, host name, or host feature. Association with ResourceCollections is defined in ProjectDescriptorAssociation, relations in Res.DescriptorElementRelation.
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| ElementID | int | Numeric identifier (primary key). | NO | - |
| ParentElementID | int | The ID of the parent element | YES | - |
| Abbreviation | nvarchar (25) | Short abbreviated name for descriptor element.Default value: '' | NO | - |
| DisplayText | nvarchar (80) | Concise English label of a descriptor element definition.Default value: '' | NO | - |
| DisplayOrder | int | Order in which elements are displayed independently of a resource collection (for order within a collection see ProjectDescriptorAssociation.DisplayOrder).Default value: (0) | NO | - |
| Description | nvarchar (1000) | A free-form text that may be displayed in user interfaces as explanatory text.Default value: '' | NO | - |
| URL | varchar (500) | The URI of a conceptual ontological resource considered equivalent with this descriptor element.Default value: '' | NO | - |
| InternalNotes | nvarchar (1000) | Internal notes and remarks. Although normally not published in public reports, this should not be used for truly confidential information.Default value: '' | NO | - |
| DisplayEnabled | bit | Whether this DescriptorElement is to be displayed in the user interface. | NO | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: suser_sname() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when record was first entered (typed or imported) into this system.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 | - |
Table ProjectIdentifier
External identifiers for the project, e.g. a DOI
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| ProjectID | int | Part of PK, ID of the Project | NO | Refers to table Project |
| Identifier | nvarchar (255) | The name of the agent. Only cached value where AgentURI is given | NO | - |
| Type | nvarchar (50) | The type of the identifier as defined in table ExternalIdentifierType | YES | Refers to table ProjectIdentifierType |
| URL | varchar (500) | A URL with further informations about the identifier | YES | - |
| Notes | nvarchar (MAX) | Notes about the identifier | YES | - |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible.Default value: suser_sname() | YES | - |
| LogInsertedWhen | smalldatetime | Date and time when record was first entered (typed or imported) into this system.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:
- Project
- ProjectIdentifierType
Table ProjectIdentifierType
The type of an external identier, e.g. DOI
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| Type | nvarchar (50) | The type of project identifiers (primary key) | NO | - |
| ParentType | nvarchar (50) | The superior type of this type | YES | - |
| URL | varchar (500) | A URL providing with further informations about this type | YES | - |
| Description | nvarchar (MAX) | The description of this type | YES | - |
| InternalNotes | nvarchar (MAX) | Internal notes about the type | 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 | datetime | Point in time when this data set was updated lastDefault value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of the person to update this data set lastDefault value: suser_sname() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newid() | NO | - |
Table ProjectLicense
The Licenses within a project
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| LicenseID | int | ID of the License, part of primary key | NO | - |
| ProjectID | int | Refers to the ID of the project (= Foreign key and part of primary key) | NO | Refers to table Project |
| DisplayText | nvarchar (200) | A display text as shown in the interface generated by the system or edited by the user | YES | - |
| LicenseURI | varchar (500) | The URL of the license under which the project is re-used or may be re-used | YES | - |
| LicenseType | nvarchar (500) | Type of an official or legal permission to do or own a specified thing, e. g. Creative Common Licenses, Copyright Licenses | YES | - |
| LicenseHolder | nvarchar (500) | The person or institution holding the license | YES | - |
| LicenseHolderAgentURI | varchar (500) | The link to a module containing futher information on the person or institution holding the license | YES | - |
| LicenseYear | nvarchar (50) | The year of the license declaration | YES | - |
| Context | nvarchar (500) | The context of the license, e.g. for publication | YES | - |
| LicenseDetails | nvarchar (500) | Details of the license | YES | - |
| IPR | nvarchar (500) | Intellectual Property Rights; the rights given to persons for their intellectual property | YES | - |
| IPRHolder | nvarchar (500) | The person or institution holding the Intellectual Property Rights | YES | - |
| IPRHolderAgentURI | varchar (500) | The link to a module containing futher information on the person or institution holding the | YES | - |
| CopyrightStatement | nvarchar (500) | Notice on rights held in and for the resource | YES | - |
| CopyrightHolder | nvarchar (500) | The person or institution holding the copyright | YES | - |
| CopyrightHolderAgentURI | varchar (500) | The link to a module containing futher information on the person or institution holding the copyright | YES | - |
| Notes | nvarchar (MAX) | Notes about the license | 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 | datetime | Point in time when this data set was updated lastDefault value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of the person to update this data set lastDefault value: suser_sname() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newid() | NO | - |
Depending on:
- Project
Table ProjectReference
The references related to the project
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| ProjectID | int | Refers to the ID of table Project (= Foreign key and part of primary key) | NO | Refers to table Project |
| ReferenceTitle | nvarchar (500) | The title of the data publication of the project data package or literature reference publication where information on the project and/ or on project dataset(s) was published. Note this is only a cached value where ReferenceURI is present | NO | - |
| ReferenceURI | varchar (255) | URI of project data citation/ data package citation or URI of literature reference where information on the project and/ or on project dataset(s) was published, e.g. referring to the module DiversityReferences | YES | - |
| ReferenceDetails | nvarchar (50) | Details within the project data citation/ data package citation, e.g. versioning, or details within the literature reference, e.g. pages | YES | - |
| ReferenceType | nvarchar (255) | The type of the data citation or literature reference | YES | - |
| IsCitation | bit | If a reference is the citation for the project data, i.e. the way the project data should be citedDefault value: (0) | NO | - |
| ReferenceCitation | nvarchar (500) | The way the reference should be cited; suggested citation style | YES | - |
| URI | nvarchar (500) | The URI of a reference | YES | - |
| Notes | nvarchar (MAX) | Notes on the project data citation or literature reference | YES | - |
| LogInsertedWhen | datetime | The time when this dataset was createdDefault value: getdate() | YES | - |
| LogInsertedBy | nvarchar (50) | Who created this datasetDefault 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:
- Project
Table ProjectResource
Resources of the project
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| ProjectID | int | Refers to the ID of the project (= Foreign key and part of primary key) | NO | Refers to table Project |
| URI | varchar (255) | The complete URI address of the resource. | NO | - |
| SpecificRights | nvarchar (500) | The rights, e.g. the copyright of the resource | YES | - |
| SpecificLicenseURI | nvarchar (500) | The license under which the resource is re-used or may be re-used | YES | - |
| ResourceURI | varchar (255) | The URI of the image, e.g. as stored in the module DiversityResources. | YES | - |
| Notes | nvarchar (MAX) | Notes about the resource | YES | - |
| LogInsertedWhen | datetime | The time when this dataset was createdDefault value: getdate() | YES | - |
| LogInsertedBy | nvarchar (50) | Who created this datasetDefault value: suser_sname() | YES | - |
| LogUpdatedWhen | datetime | The last time when this dataset was updatedDefault value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Who was the last to update this datasetDefault value: suser_sname() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | NO | - |
Depending on:
- Project
Table ProjectSetting
Settings of a project
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| ProjectID | int | Refers to the ID of the project (= Foreign key and part of primary key) | NO | Refers to table Project |
| SettingID | int | Refers to ID of Settings, foreign key and part of primary key | NO | Refers to table Setting |
| Value | nvarchar (MAX) | The value of the settingDefault value: '' | 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 | - |
| RowGUID | uniqueidentifier | -Default value: newid() | NO | - |
Depending on:
- Project
- Setting
Table ProjectUser
The projects available for a user
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| LoginName | nvarchar (50) | A login name which the user uses for access the DivesityWorkbench, Microsoft domains, etc.. | NO | Refers to table UserProxy |
| ProjectID | int | ID of the project to which the specimen belongs (Projects are defined in DiversityProjects) | NO | Refers to table Project |
| RowGUID | uniqueidentifier | -Default value: newsequentialid() | NO | - |
Depending on:
- Project
- UserProxy
Table Setting
The settings used within the projects
| Column | Data type | Description | Nullable | Relation |
|---|---|---|---|---|
| SettingID | int | ID of the setting, primary key | NO | - |
| ParentSettingID | int | The ID of the superior setting | YES | Refers to table Setting |
| DisplayText | nvarchar (50) | Short abbreviated description of the setting, displayed in the user interface | YES | - |
| Description | nvarchar (MAX) | Description of the setting | YES | - |
| DisplayOrder | int | The sequence in which the items should be shown in an interface | 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 | datetime | Point in time when this data set was updated lastDefault value: getdate() | YES | - |
| LogUpdatedBy | nvarchar (50) | Name of the person to update this data set lastDefault value: suser_sname() | YES | - |
| RowGUID | uniqueidentifier | -Default value: newid() | NO | - |
VIEWS
View Project_Core
Provides all columus of table Project restricted to the projects accessible for a user as set in table ProjectUser with the exception of the dbo
| Column | Data type | Description | Nullable |
|---|---|---|---|
| ProjectID | int | PK, ID of the Project | NO |
| ProjectParentID | int | ID of the superior project | YES |
| Project | nvarchar (255) | A short title for the project as displayed e.g. for selection from a list in an user interface | NO |
| ProjectTitle | nvarchar (200) | An explicit title for the project | YES |
| ProjectType | nvarchar (50) | Type of the project | YES |
| ProjectDescription | nvarchar (2000) | A text, describing characteristic features, e. g. the purpose and scope, of the project | YES |
| ProjectNotes | nvarchar (1000) | Internal notes regarding the project, not published on the web | YES |
| ProjectCopyright | nvarchar (255) | Copyright statement for the data collected for and revised by this project | YES |
| ProjectRights | nvarchar (255) | The rights, e.g. the copyright of the project | YES |
| ProjectLicenseURI | nvarchar (255) | The license under which the project is re-used or may be re-used | YES |
| ProjectVersion | nvarchar (255) | Version number (refers to the database content of this project, not to application development) | YES |
| ProjectURL | varchar (255) | An URL where e.g. the project is described | YES |
| ProjectSettings | nvarchar (MAX) | The settings used within the project | YES |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible. | YES |
| LogInsertedWhen | smalldatetime | Date and time when record was first entered (typed or imported) into this system. | 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 |
| RowGUID | uniqueidentifier | - | YES |
Depending on:
- Project
- ProjectList
View ProjectAgent_Core
Content of table ProjectAgent restricted to user accessible datasets
| Column | Data type | Description | Nullable |
|---|---|---|---|
| ProjectID | int | Refers to the ID of the project (= Foreign key and part of primary key) | NO |
| AgentName | nvarchar (255) | The name of the agent. Only cached value where AgentURI is given, Part of PK | NO |
| AgentURI | varchar (255) | An URL linked to e.g. the module DiversityAgents within the Diversity Workbench, Part of PK | NO |
| AgentRole | nvarchar (50) | The role of the agent within the project as defined in ProjectAgentRole_Enum | YES |
| Notes | nvarchar (MAX) | Notes about the agent | YES |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible. | YES |
| LogInsertedWhen | smalldatetime | Date and time when record was first entered (typed or imported) into this system. | 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 |
| RowGUID | uniqueidentifier | - | NO |
Depending on:
- ProjectAgent
- ProjectList
View ProjectResource_Core
Content of table ProjectResource restricted to those accessible for a user
| Column | Data type | Description | Nullable |
|---|---|---|---|
| ProjectID | int | Refers to the ID of the project (= Foreign key and part of primary key) | NO |
| URI | varchar (255) | The complete URI address of the resource. | NO |
| SpecificRights | nvarchar (500) | The rights, e.g. the copyright of the resource | YES |
| SpecificLicenseURI | nvarchar (500) | The license under which the resource is re-used or may be re-used | YES |
| ResourceURI | varchar (255) | The URI of the image, e.g. as stored in the module DiversityResources. | YES |
| Notes | nvarchar (MAX) | Notes about the resource | YES |
| LogInsertedWhen | datetime | The time when this dataset was created | YES |
| LogInsertedBy | nvarchar (50) | Who created this dataset | YES |
| LogUpdatedWhen | datetime | The last time when this dataset was updated | YES |
| LogUpdatedBy | nvarchar (50) | Who was the last to update this dataset | YES |
| RowGUID | uniqueidentifier | - | NO |
Depending on:
- ProjectList
- ProjectResource
View View_ProjectDescriptor
Project descriptors for query
| Column | Data type | Description | Nullable |
|---|---|---|---|
| ProjectID | int | ID of the project, foreign key | NO |
| Descriptor | nvarchar (337) | Descriptor of the project (Type + Value) | NO |
Depending on:
- ProjectDescriptor
- ProjectDescriptorElement
View View_ProjectSetting
Project settings for query
| Column | Data type | Description | Nullable |
|---|---|---|---|
| ProjectID | int | Refers to the ID of the project (= Foreign key and part of primary key) | NO |
| Setting | nvarchar (MAX) | Setting of the project (Type + Value) | YES |
Depending on:
- ProjectSetting
- Setting
View ViewBaseURL
Value of the function BaseURL provided via a view for usage e.g. by linked servers
| Column | Data type | Description | Nullable |
|---|---|---|---|
| BaseURL | varchar (255) | Value of the function BaseURL | YES |
Depending on:
- BaseURL
View ViewDataCitation
The citation of published data from the project; references of the data publication of the project data package
| Column | Data type | Description | Nullable |
|---|---|---|---|
| ProjectID | int | Refers to the ID of table Project (= Foreign key and part of primary key) | NO |
| ReferenceTitle | nvarchar (255) | The title of the data publication of the project data package. Note this is only a cached value where ReferenceURI is present. | NO |
| ReferenceURI | varchar (255) | URI of project data citation/ data package citation of the project data package, e.g. referring to the module DiversityReferences. | YES |
| ReferenceDetails | nvarchar (50) | Details within the project data citation/ data package citation, e.g. versioning | YES |
| ReferenceType | nvarchar (255) | The type of the project data citation/ data package citation | YES |
| Notes | nvarchar (MAX) | Notes on the project data citation/ data package citation | YES |
| URI | nvarchar (500) | URI of project data citation/ data package citation with information on the project dataset(s) | YES |
| ReferenceCitation | nvarchar (500) | The way the project data/ data package should be cited; suggested citation style | YES |
Depending on:
- ProjectReference
View ViewDiversityWorkbenchModule
Value of the function DiversityWorkbenchModule provided via a view for usage e.g. by linked servers
| Column | Data type | Description | Nullable |
|---|---|---|---|
| DiversityWorkbenchModule | nvarchar (50) | Value of the function DiversityWorkbenchModule | YES |
Depending on:
- DiversityWorkbenchModule
View ViewLiteratureReference
The references related to the project; references of literature publications where information on the project and/ or on project dataset(s) is given
| Column | Data type | Description | Nullable |
|---|---|---|---|
| ProjectID | int | Refers to the ID of table Project (= Foreign key and part of primary key) | NO |
| ReferenceTitle | nvarchar (255) | The title of the literature reference publication where information on the project and/ or on project dataset(s) was published. Note this is only a cached value where ReferenceURI is present. | NO |
| ReferenceURI | varchar (255) | URI of literature reference with information on the project and/ or on the project dataset(s), e.g. referring to the module DiversityReferences. | YES |
| ReferenceDetails | nvarchar (50) | Details within the literature reference, e.g. pages | YES |
| ReferenceType | nvarchar (255) | The type of the literature reference | YES |
| Notes | nvarchar (MAX) | Notes on the literature reference | YES |
| URI | nvarchar (500) | URI of the literature reference with information on the project dataset(s) | YES |
| ReferenceCitation | nvarchar (500) | The way the literature reference should be cited; suggested citation style | YES |
Depending on:
- ProjectReference
View ViewProject
Content of table Project including the StableIdentifier
| Column | Data type | Description | Nullable |
|---|---|---|---|
| ProjectID | int | PK, ID of the Project | NO |
| ProjectParentID | int | ID of the superior project | YES |
| Project | nvarchar (255) | A short title for the project as displayed e.g. for selection from a list in an user interface | NO |
| ProjectTitle | nvarchar (200) | An explicit title for the project | YES |
| ProjectDescription | nvarchar (2000) | A text, describing characteristic features, e. g. the purpose and scope, of the project | YES |
| ProjectNotes | nvarchar (1000) | Internal notes regarding the project, not published on the web | YES |
| ProjectVersion | nvarchar (255) | Version number (refers to the database content of this project, not to application development) | YES |
| ProjectURL | varchar (255) | An URL where e.g. the project is described | YES |
| StableIdentifier | varchar (500) | The StableIdentifier for the project | YES |
| ProjectType | nvarchar (50) | Type of the project | YES |
| InternalDescription | nvarchar (MAX) | Internal description of the project, not to be published | YES |
| PublicDescription | nvarchar (MAX) | Public description of the project if different from the description | YES |
| ProjectDescriptionType | nvarchar (50) | classification of the public description, e. g. abstract | YES |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. This is the operator (or typist) name, which may be different from the person responsible. | YES |
| LogInsertedWhen | smalldatetime | Date and time when record was first entered (typed or imported) into this system. | 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 |
| RowGUID | uniqueidentifier | - | YES |
Depending on:
- Project
- StableIdentifier
FUNCTIONS
Function BaseURL
Provides the basic address for accessing the database
DataType: varchar (255)
Function DiversityWorkbenchModule
Provides the name of the DiversityWorkbench module
DataType: nvarchar (50)
Function PrivacyConsentInfo
Providing common information about the storage and processing of personal data within the DiversityWorkbench
DataType: varchar (900)
Function ProjectChildNodes
Returns a result set that lists all the items within a hierarchy starting at the topmost item related to the given item.
| Parameter | DataType | Description |
|---|---|---|
| @ID | int | ID of the project |
| Column | DataType | Description |
|---|---|---|
| ProjectID | int | PK, ID of the Project |
| ProjectParentID | int | ID of the superior project |
| Project | nvarchar (50) | A short title for the project as displayed e.g. for selection from a list in an user interface |
| ProjectTitle | nvarchar (200) | An explicit title for the project |
| ProjectDescription | nvarchar (MAX) | A text, describing characteristic features, e. g. the purpose and scope, of the project |
| ProjectNotes | nvarchar (1000) | Internal notes regarding the project, not published on the web |
| ProjectVersion | nvarchar (255) | Version number (refers to the database content of this project, not to application development) |
| ProjectURL | varchar (255) | An URL where e.g. the project is described |
| ProjectType | nvarchar (50) | Type of the project |
| InternalDescription | nvarchar (MAX) | Internal description of the project, not to be published |
| PublicDescription | nvarchar (MAX) | Public description of the project if different from the description |
| ProjectDescriptionType | nvarchar (50) | classification of the public description, e. g. abstract |
| EmbargoDate | date | The date until which the data should not be published, made available to the public |
| CreateArchive | bit | If an archive e.g. by a task schedule should be created |
| ArchiveProtocol | nvarchar (MAX) | The protocol created during the last archive |
Depending on:
- Project
- ProjectChildNodes
Function ProjectDataLastChanges
DataType: datetime
| Parameter | DataType | Description |
|---|---|---|
| @ProjectID | int | PK, ID of the Project |
Depending on:
- Project
Function ProjectHierarchy
Returns a table that lists all the items related to the given item
| Parameter | DataType | Description |
|---|---|---|
| @ProjectID | int | ID of the project |
| Column | DataType | Description |
|---|---|---|
| ProjectID | int | PK, ID of the Project |
| ProjectParentID | int | ID of the superior project |
| Project | nvarchar (50) | A short title for the project as displayed e.g. for selection from a list in an user interface |
| ProjectTitle | nvarchar (200) | An explicit title for the project |
| ProjectDescription | nvarchar (MAX) | A text, describing characteristic features, e. g. the purpose and scope, of the project |
| ProjectNotes | nvarchar (1000) | Internal notes regarding the project, not published on the web |
| ProjectVersion | nvarchar (255) | Version number (refers to the database content of this project, not to application development) |
| ProjectURL | varchar (255) | An URL where e.g. the project is described |
| ProjectType | nvarchar (50) | Type of the project |
| InternalDescription | nvarchar (MAX) | Internal description of the project, not to be published |
| PublicDescription | nvarchar (MAX) | Public description of the project if different from the description |
| ProjectDescriptionType | nvarchar (50) | classification of the public description, e. g. abstract |
| EmbargoDate | date | The date until which the data should not be published, made available to the public |
| CreateArchive | bit | If an archive e.g. by a task schedule should be created |
| ArchiveProtocol | nvarchar (MAX) | The protocol created during the last archive |
Depending on:
- Project
- ProjectChildNodes
Function ProjectList
The list of Projects accessible for the current user
| Column | DataType | Description |
|---|---|---|
| ProjectID | int | ID of the project |
Depending on:
- Project
- ProjectUser
Function ProjectParents
Returns a table that lists all the parents of the given project
| Parameter | DataType | Description |
|---|---|---|
| @ProjectID | int | ID of the project as stored in table Project |
| Column | DataType | Description |
|---|---|---|
| ProjectID | int | PK, ID of the Project |
| ProjectParentID | int | ID of the superior project |
| Project | nvarchar (50) | A short title for the project as displayed e.g. for selection from a list in an user interface |
| ProjectTitle | nvarchar (200) | An explicit title for the project |
| ProjectDescription | nvarchar (MAX) | A text, describing characteristic features, e. g. the purpose and scope, of the project |
| ProjectNotes | nvarchar (1000) | Internal notes regarding the project, not published on the web |
| ProjectCopyright | nvarchar (255) | Copyright statement for the data collected for and revised by this project |
| ProjectRights | nvarchar (255) | The rights, e.g. the copyright of the project |
| ProjectLicenseURI | varchar (255) | The license under which the project is re-used or may be re-used |
| ProjectVersion | nvarchar (255) | Version number (refers to the database content of this project, not to application development) |
| ProjectURL | varchar (255) | An URL where e.g. the project is described |
| HierarchyLevel | int | The level of the hierarchy: 1 = level of selected project; increasing with parents in hierarchy |
Depending on:
- Project
Function SettingHierarchyAll
Returns a table that lists all the settings including a display text with the whole hierarchy
| Column | DataType | Description |
|---|---|---|
| SettingID | int | ID of the setting as defined in table Setting |
| ParentSettingID | int | ID of the superior setting |
| DisplayText | nvarchar (50) | Short abbreviated description of the object, displayed in the user interface |
| DisplayOrder | int | The sequence in which the items should be shown in an interface |
| Description | nvarchar (MAX) | Description of enumerated object, displayed in the user interface |
| Hierarchy | nvarchar (4000) | The hierarchy composed of the display texts of the superior settings |
Depending on:
- Setting
Function SettingHierarchyChildren
Returns a table that lists all the settings depending on a setting
| Parameter | DataType | Description |
|---|---|---|
| @SettingID | int | ID of the setting |
| Column | DataType | Description |
|---|---|---|
| SettingID | int | ID of the setting as defined in table Setting |
| ParentSettingID | int | The ID of the superior setting |
| DisplayText | nvarchar (50) | Short abbreviated description of the setting, displayed in the user interface |
| DisplayOrder | int | The sequence in which the items should be shown in an interface |
| Description | nvarchar (MAX) | Description of the setting |
Depending on:
- Setting
Function SettingHierarchyNonProject
Returns a table that lists all the settings including a display text with the whole hierarchy that are not included in a project so far
| Parameter | DataType | Description |
|---|---|---|
| @ProjectID | int | The ID of the project |
| Column | DataType | Description |
|---|---|---|
| SettingID | int | ID of the setting as defined in table Setting |
| ParentSettingID | int | ID of the superior setting |
| DisplayText | nvarchar (50) | Short abbreviated description of the object, displayed in the user interface |
| DisplayOrder | int | The sequence in which the items should be shown in an interface |
| Description | nvarchar (MAX) | Description of enumerated object, displayed in the user interface |
| Hierarchy | nvarchar (4000) | The hierarchy composed of the display texts of the superior settings |
Depending on:
- ProjectSetting
- SettingHierarchyAll
Function SettingHierarchyProjectAll
Returns a table that lists all the settings for a project including those inherited from superior projects.
| Parameter | DataType | Description |
|---|---|---|
| @ProjectID | int | Input parameter. Enter a valid ProjectID. |
| Column | DataType | Description |
|---|---|---|
| SettingID | int | The ID of the setting as defined in table Setting |
| ParentSettingID | int | The ID of the superior setting |
| DisplayText | nvarchar (50) | Short abbreviated description of the object, displayed in the user interface |
| DisplayOrder | int | The sequence in which the items should be shown in an interface |
| Description | nvarchar (MAX) | Description of enumerated object, displayed in the user interface |
| Hierarchy | nvarchar (4000) | The hierarchy composed of the display texts of the superior settings |
| Value | nvarchar (4000) | The value of the setting |
| ProjectID | int | ID of the superior project from which this setting has been inherited |
| Project | nvarchar (200) | The name of the project from which this setting has been inherited |
Depending on:
- ProjectParents
- ProjectSetting
- SettingHierarchyAll
Function SettingsForProject
Returns a table that lists all the settings for a project including those inherited from parent projects including formatting options. Used for Metadata retrieval by DiversityCollection cache databases
| Parameter | DataType | Description |
|---|---|---|
| @ProjectID | int | The ID of the project |
| @SettingFilter | nvarchar (255) | A optional filter for the settings |
| @Spacer | nvarchar (20) | Optional. A spacer placed between the |
| @DisplayType | int | Formatting mode of the column ProjectSetting: 1= Whole hierarchy; 2= Remove leading value of @SettingFilter from hierarchy |
| Column | DataType | Description |
|---|---|---|
| SettingID | int | ID of the Setting |
| ParentSettingID | int | ID of the superior setting |
| DisplayText | nvarchar (50) | Short abbreviated description of the object, displayed in the user interface |
| Description | nvarchar (MAX) | Description of enumerated object, displayed in the user interface |
| ProjectSetting | nvarchar (4000) | The hierarchy composed of the display texts of the superior settings formatting depending from parameter |
| Value | nvarchar (4000) | The value of the setting |
Depending on:
- SettingHierarchyProjectAll
Function StableIdentifier
The stable identifier published for a project
DataType: varchar (500)
| Parameter | DataType | Description |
|---|---|---|
| @ProjectID | int | ID of the project |
Depending on:
- Project
Function UserID
ID of the User as stored in table UserProxy
DataType: int
Depending on:
- UserProxy
Function Version
Version of the database
DataType: nvarchar (8)
Function VersionClient
Version of the client software compatible with the version of the database
DataType: nvarchar (11)
PROCEDURES
Procedure procInsertProjectCopy
Copy project including all depending data
| Parameter | DataType | Description |
|---|---|---|
| @ProjectID | int | Output parameter, ID of the new project |
| @CopyID | int | ID of the project that should be copied |
| @ProjectTitle | nvarchar (200) | Title of the new project |
Depending on:
- Project
- ProjectAgent
- ProjectLicense
- ProjectReference
- ProjectResource
- ProjectSetting
- ProjectUser
Procedure SetUserProjects
| Parameter | DataType | Description |
|---|---|---|
| @User | varchar (50) | - |
Depending on:
- UserProxy
ROLES
Role DiversityWorkbenchAdministrator
Database Role for administrative actions within the database.
| Permissions | SELECT | INSERT | UPDATE | DELETE | EXECUTE | Type |
|---|---|---|---|---|---|---|
| Language_Enum | Diversity Workbench User | TABLE | ||||
| Project | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | • | TABLE | |
| Project_log | Diversity Workbench User | Diversity Workbench Editor | TABLE | |||
| ProjectAgent | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| ProjectAgent_log | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |||
| ProjectAgentRole | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| ProjectAgentRole_Enum | Diversity Workbench User | TABLE | ||||
| ProjectAgentRole_log | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |||
| ProjectAgentType_Enum | Diversity Workbench User | TABLE | ||||
| ProjectArchive | TABLE | |||||
| ProjectArchive_log | TABLE | |||||
| ProjectArchiveFormat_Enum | TABLE | |||||
| ProjectArchiveIdentifier | TABLE | |||||
| ProjectArchiveIdentifier_log | TABLE | |||||
| ProjectArchiveMimeType_Enum | TABLE | |||||
| ProjectDescriptor | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| ProjectDescriptor_log | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |||
| ProjectDescriptorElement | Diversity Workbench User | • | • | • | TABLE | |
| ProjectDescriptorElement_log | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |||
| ProjectIdentifier | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | • | TABLE | |
| ProjectIdentifier_log | Diversity Workbench User | Diversity Workbench Editor | TABLE | |||
| ProjectIdentifierType | Diversity Workbench User | TABLE | ||||
| ProjectIdentifierType_log | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |||
| ProjectKeyword | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| ProjectKeyword_log | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |||
| ProjectLabel | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| ProjectLabel_log | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |||
| ProjectLicense | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | • | TABLE | |
| ProjectLicense_log | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |||
| ProjectReference | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| ProjectReference_log | Diversity Workbench User | Diversity Workbench Editor | TABLE | |||
| ProjectResource | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| ProjectResource_log | Diversity Workbench User | Diversity Workbench Editor | TABLE | |||
| ProjectSetting | Diversity Workbench User | Diversity Workbench Editor | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |
| ProjectSetting_log | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |||
| ProjectType_Enum | Diversity Workbench User | TABLE | ||||
| ProjectUser | Diversity Workbench User | Diversity Workbench Editor | • | • | TABLE | |
| Setting | Diversity Workbench Editor | • | • | • | TABLE | |
| Setting_log | Diversity Workbench Editor | Diversity Workbench Editor | TABLE | |||
| Project_Core | Diversity Workbench User | VIEW | ||||
| ProjectAgent_Core | Diversity Workbench User | VIEW | ||||
| ProjectResource_Core | Diversity Workbench User | VIEW | ||||
| View_ProjectDescriptor | Diversity Workbench User | VIEW | ||||
| View_ProjectSetting | Diversity Workbench User | VIEW | ||||
| ViewBaseURL | Diversity Workbench User | VIEW | ||||
| ViewDataCitation | Diversity Workbench User | VIEW | ||||
| ViewDiversityWorkbenchModule | Diversity Workbench User | VIEW | ||||
| ViewLiteratureReference | Diversity Workbench User | VIEW | ||||
| ViewProject | Diversity Workbench User | VIEW | ||||
| BaseURL | Diversity Workbench User | FUNCTION | ||||
| DiversityWorkbenchModule | Diversity Workbench User | FUNCTION | ||||
| PrivacyConsentInfo | Diversity Workbench User | FUNCTION | ||||
| ProjectChildNodes | Diversity Workbench User | FUNCTION | ||||
| ProjectDataLastChanges | Diversity Workbench User | FUNCTION | ||||
| ProjectHierarchy | Diversity Workbench User | FUNCTION | ||||
| ProjectList | Diversity Workbench User | FUNCTION | ||||
| ProjectParents | Diversity Workbench User | FUNCTION | ||||
| SettingHierarchyAll | Diversity Workbench User | FUNCTION | ||||
| SettingHierarchyChildren | Diversity Workbench User | FUNCTION | ||||
| SettingHierarchyNonProject | Diversity Workbench User | FUNCTION | ||||
| SettingHierarchyProjectAll | Diversity Workbench User | FUNCTION | ||||
| SettingsForProject | Diversity Workbench User | FUNCTION | ||||
| StableIdentifier | Diversity Workbench User | FUNCTION | ||||
| UserID | Diversity Workbench User | FUNCTION | ||||
| Version | Diversity Workbench User | FUNCTION | ||||
| VersionClient | Diversity Workbench User | FUNCTION | ||||
| procInsertProjectCopy | Diversity Workbench Editor | PROCEDURE | ||||
| SetUserProjects | PROCEDURE | |||||
| Inheriting from roles: |
- DiversityWorkbenchEditor
Role DiversityWorkbenchEditor
Database Role with read/write accesss to the database.
| Permissions | SELECT | INSERT | UPDATE | DELETE | EXECUTE | Type |
|---|---|---|---|---|---|---|
| Language_Enum | Diversity Workbench User | TABLE | ||||
| Project | Diversity Workbench User | • | • | TABLE | ||
| Project_log | Diversity Workbench User | • | TABLE | |||
| ProjectAgent | Diversity Workbench User | • | • | • | TABLE | |
| ProjectAgent_log | • | • | TABLE | |||
| ProjectAgentRole | Diversity Workbench User | • | • | • | TABLE | |
| ProjectAgentRole_Enum | Diversity Workbench User | TABLE | ||||
| ProjectAgentRole_log | • | • | TABLE | |||
| ProjectAgentType_Enum | Diversity Workbench User | TABLE | ||||
| ProjectArchive | TABLE | |||||
| ProjectArchive_log | TABLE | |||||
| ProjectArchiveFormat_Enum | TABLE | |||||
| ProjectArchiveIdentifier | TABLE | |||||
| ProjectArchiveIdentifier_log | TABLE | |||||
| ProjectArchiveMimeType_Enum | TABLE | |||||
| ProjectDescriptor | Diversity Workbench User | • | • | • | TABLE | |
| ProjectDescriptor_log | • | • | TABLE | |||
| ProjectDescriptorElement | Diversity Workbench User | TABLE | ||||
| ProjectDescriptorElement_log | • | • | TABLE | |||
| ProjectIdentifier | Diversity Workbench User | • | • | TABLE | ||
| ProjectIdentifier_log | Diversity Workbench User | • | TABLE | |||
| ProjectIdentifierType | Diversity Workbench User | TABLE | ||||
| ProjectIdentifierType_log | • | • | TABLE | |||
| ProjectKeyword | Diversity Workbench User | • | • | • | TABLE | |
| ProjectKeyword_log | • | • | TABLE | |||
| ProjectLabel | Diversity Workbench User | • | • | • | TABLE | |
| ProjectLabel_log | • | • | TABLE | |||
| ProjectLicense | Diversity Workbench User | • | • | • | TABLE | |
| ProjectLicense_log | • | • | TABLE | |||
| ProjectReference | Diversity Workbench User | • | • | • | TABLE | |
| ProjectReference_log | Diversity Workbench User | • | TABLE | |||
| ProjectResource | Diversity Workbench User | • | • | • | TABLE | |
| ProjectResource_log | Diversity Workbench User | • | TABLE | |||
| ProjectSetting | Diversity Workbench User | • | • | • | TABLE | |
| ProjectSetting_log | • | • | TABLE | |||
| ProjectType_Enum | Diversity Workbench User | TABLE | ||||
| ProjectUser | Diversity Workbench User | • | TABLE | |||
| Setting | • | • | TABLE | |||
| Setting_log | • | • | TABLE | |||
| Project_Core | Diversity Workbench User | VIEW | ||||
| ProjectAgent_Core | Diversity Workbench User | VIEW | ||||
| ProjectResource_Core | Diversity Workbench User | VIEW | ||||
| View_ProjectDescriptor | Diversity Workbench User | VIEW | ||||
| View_ProjectSetting | Diversity Workbench User | VIEW | ||||
| ViewBaseURL | Diversity Workbench User | VIEW | ||||
| ViewDataCitation | Diversity Workbench User | VIEW | ||||
| ViewDiversityWorkbenchModule | Diversity Workbench User | VIEW | ||||
| ViewLiteratureReference | Diversity Workbench User | VIEW | ||||
| ViewProject | Diversity Workbench User | VIEW | ||||
| BaseURL | Diversity Workbench User | FUNCTION | ||||
| DiversityWorkbenchModule | Diversity Workbench User | FUNCTION | ||||
| PrivacyConsentInfo | Diversity Workbench User | FUNCTION | ||||
| ProjectChildNodes | Diversity Workbench User | FUNCTION | ||||
| ProjectDataLastChanges | Diversity Workbench User | FUNCTION | ||||
| ProjectHierarchy | Diversity Workbench User | FUNCTION | ||||
| ProjectList | Diversity Workbench User | FUNCTION | ||||
| ProjectParents | Diversity Workbench User | FUNCTION | ||||
| SettingHierarchyAll | Diversity Workbench User | FUNCTION | ||||
| SettingHierarchyChildren | Diversity Workbench User | FUNCTION | ||||
| SettingHierarchyNonProject | Diversity Workbench User | FUNCTION | ||||
| SettingHierarchyProjectAll | Diversity Workbench User | FUNCTION | ||||
| SettingsForProject | Diversity Workbench User | FUNCTION | ||||
| StableIdentifier | Diversity Workbench User | FUNCTION | ||||
| UserID | Diversity Workbench User | FUNCTION | ||||
| Version | Diversity Workbench User | FUNCTION | ||||
| VersionClient | Diversity Workbench User | FUNCTION | ||||
| procInsertProjectCopy | • | PROCEDURE | ||||
| SetUserProjects | PROCEDURE | |||||
| Inheriting from roles: |
- DiversityWorkbenchUser
Role DiversityWorkbenchUser
Database Role with reading accesss to the database.
| Permissions | SELECT | INSERT | UPDATE | DELETE | EXECUTE | Type |
|---|---|---|---|---|---|---|
| Language_Enum | • | TABLE | ||||
| Project | • | TABLE | ||||
| Project_log | • | TABLE | ||||
| ProjectAgent | • | TABLE | ||||
| ProjectAgent_log | TABLE | |||||
| ProjectAgentRole | • | TABLE | ||||
| ProjectAgentRole_Enum | • | TABLE | ||||
| ProjectAgentRole_log | TABLE | |||||
| ProjectAgentType_Enum | • | TABLE | ||||
| ProjectArchive | TABLE | |||||
| ProjectArchive_log | TABLE | |||||
| ProjectArchiveFormat_Enum | TABLE | |||||
| ProjectArchiveIdentifier | TABLE | |||||
| ProjectArchiveIdentifier_log | TABLE | |||||
| ProjectArchiveMimeType_Enum | TABLE | |||||
| ProjectDescriptor | • | TABLE | ||||
| ProjectDescriptor_log | TABLE | |||||
| ProjectDescriptorElement | • | TABLE | ||||
| ProjectDescriptorElement_log | TABLE | |||||
| ProjectIdentifier | • | TABLE | ||||
| ProjectIdentifier_log | • | TABLE | ||||
| ProjectIdentifierType | • | TABLE | ||||
| ProjectIdentifierType_log | TABLE | |||||
| ProjectKeyword | • | TABLE | ||||
| ProjectKeyword_log | TABLE | |||||
| ProjectLabel | • | TABLE | ||||
| ProjectLabel_log | TABLE | |||||
| ProjectLicense | • | TABLE | ||||
| ProjectLicense_log | TABLE | |||||
| ProjectReference | • | TABLE | ||||
| ProjectReference_log | • | TABLE | ||||
| ProjectResource | • | TABLE | ||||
| ProjectResource_log | • | TABLE | ||||
| ProjectSetting | • | TABLE | ||||
| ProjectSetting_log | TABLE | |||||
| ProjectType_Enum | • | TABLE | ||||
| ProjectUser | • | TABLE | ||||
| Setting | • | TABLE | ||||
| Setting_log | TABLE | |||||
| Project_Core | • | VIEW | ||||
| ProjectAgent_Core | • | VIEW | ||||
| ProjectResource_Core | • | VIEW | ||||
| View_ProjectDescriptor | • | VIEW | ||||
| View_ProjectSetting | • | VIEW | ||||
| ViewBaseURL | • | VIEW | ||||
| ViewDataCitation | • | VIEW | ||||
| ViewDiversityWorkbenchModule | • | VIEW | ||||
| ViewLiteratureReference | • | VIEW | ||||
| ViewProject | • | VIEW | ||||
| BaseURL | • | FUNCTION | ||||
| DiversityWorkbenchModule | • | FUNCTION | ||||
| PrivacyConsentInfo | • | FUNCTION | ||||
| ProjectChildNodes | • | FUNCTION | ||||
| ProjectDataLastChanges | • | FUNCTION | ||||
| ProjectHierarchy | • | FUNCTION | ||||
| ProjectList | • | FUNCTION | ||||
| ProjectParents | • | FUNCTION | ||||
| SettingHierarchyAll | • | FUNCTION | ||||
| SettingHierarchyChildren | • | FUNCTION | ||||
| SettingHierarchyNonProject | • | FUNCTION | ||||
| SettingHierarchyProjectAll | • | FUNCTION | ||||
| SettingsForProject | • | FUNCTION | ||||
| StableIdentifier | • | FUNCTION | ||||
| UserID | • | FUNCTION | ||||
| Version | • | FUNCTION | ||||
| VersionClient | • | FUNCTION | ||||
| procInsertProjectCopy | PROCEDURE | |||||
| SetUserProjects | PROCEDURE |