Data Project
Project related tables
Information concerning the project access and related tables are stored in the tables shown in the diagram below. The table “Project” relates the table “ProjectProxy”, which holds an optional link to DiversityProjects, with attribute “ProjectProxyID”. The tables “UserProxy”, “ProjectUser” and “ProjectProxy” allow a independent administration of the access functions related to projects and users and are required for the centralized DiversityWorkbench components.
Index
Table ProjectProxy
The projects as stored in the module DiversityProjects
| Column | Data type | Description |
|---|---|---|
| ProjectID | int | ID of the project to which the specimen belongs (Projects are defined in DiversityProjects) |
| Project | nvarchar (255) | The name or title of the project as shown in a user interface (Projects are defined in DiversityProjects) |
| ProjectURI | nvarchar (255) | URI of a project in a remote module, e.g. refering to database DiversityProjects |
Table ProjectUser
The projects that a user can access
| Column | Data type | Description |
|---|---|---|
| LoginName | nvarchar (50) | A login name which the user uses for access the DivesityWorkbench, Microsoft domains, etc.. |
| ProjectID | int | ID of the project to which the specimen belongs (Projects are defined in DiversityProjects) |
| ReadOnly | bit | If the user has only read access to data of
this project Default value: (0) |
Table UserProxy
The user as stored in the module DiversityAgents
| Column | Data type | Description |
|---|---|---|
| LoginName | nvarchar (50) | A login name which the user uses for access the DivesityWorkbench, Microsoft domains, etc.. |
| CombinedNameCache | nvarchar (255) | The short name of the user, e.g. P. Smith |
| AgentURI | nvarchar (255) | URI of a user in a remote module, e.g. refering to database DiversityAgents |
| Queries | xml (MAX) | Queries created by the user |
| ID | int | ID of the user |
| PrivacyConsent | bit | If the user consents the storage of his user name in the database |
| PrivacyConsentDate | datetime | The time and date when the user consented or refused the storage of his user name in the database |