|
|
| Line 37: |
Line 37: |
| | ---- | | ---- |
| | | | |
| − | ===Table: Project=== | + | ===Table: SamplingPlot=== |
| − | Informations about the projects | + | Informations about the sampling plots |
| | {|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;" | | {|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;" |
| | |-style="text-align:left; background:#D3D3D3;" | | |-style="text-align:left; background:#D3D3D3;" |
| Line 47: |
Line 47: |
| | !Ind. | | !Ind. |
| | |- | | |- |
| − | |<u>ProjectID</u> | + | |<u>todo...</u> |
| − | |int | + | | |
| − | |PK, ID of the Project | + | | |
| − | |R | + | | |
| − | |U | + | | |
| | |-style="background:WhiteSmoke;" | | |-style="background:WhiteSmoke;" |
| − | |ProjectParentID | + | |todo... |
| − | |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
| |
| − | |R
| |
| − | | -
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |ProjectTitle
| |
| − | |nvarchar (200)
| |
| − | |An explicit title for the project
| |
| − | | -
| |
| − | | -
| |
| − | |-
| |
| − | |ProjectDescription
| |
| − | |nvarchar (2000)
| |
| − | |A short text, describing the purpose and scope of the project
| |
| − | | -
| |
| − | | -
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |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
| |
| − | | -
| |
| − | | -
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |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
| |
| − | | -
| |
| − | | -
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |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
| |
| − | | -
| |
| − | | -
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |ProjectSettings
| |
| − | |xml (MAX)
| |
| − | |The settings used within the project
| |
| − | | -
| |
| − | | -
| |
| − | |-
| |
| − | |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.<br />''DefaultValue: user_name()''
| |
| − | | -
| |
| − | | -
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |LogInsertedWhen
| |
| − | |smalldatetime
| |
| − | |Date and time when record was first entered (typed or imported) into this system.<br />''DefaultValue: getdate()''
| |
| − | | -
| |
| − | | -
| |
| − | |-
| |
| − | |LogUpdatedBy
| |
| − | |nvarchar (50)
| |
| − | |Name of user who last updated the data.<br />''DefaultValue: user_name()''
| |
| − | | -
| |
| − | | -
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |LogUpdatedWhen
| |
| − | |smalldatetime
| |
| − | |Date and time when the data were last updated.<br />''DefaultValue: getdate()''
| |
| − | | -
| |
| − | | -
| |
| − | |-
| |
| − | |RowGUID
| |
| − | |uniqueidentifier
| |
| − | |<br />''DefaultValue: newsequentialid()''
| |
| − | |R
| |
| − | | -
| |
| − | |}
| |
| − |
| |
| − |
| |
| − | ===Table: ProjectAgent===
| |
| − | The persons or institutions involved in the project
| |
| − | {|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
| |
| − | |-style="text-align:left; background:#D3D3D3;"
| |
| − | !Column
| |
| − | !Data type
| |
| − | !Description
| |
| − | !Requ.
| |
| − | !Ind.
| |
| − | |-
| |
| − | |<u>ProjectID</u>
| |
| − | |int
| |
| − | |Part of PK, ID of the Project
| |
| − | |R
| |
| − | |U
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |<u>AgentName</u>
| |
| − | |nvarchar (255)
| |
| − | |The name of the agent. Only cached value where AgentURI is given
| |
| − | |R
| |
| − | |U
| |
| − | |-
| |
| − | |<u>AgentURI</u>
| |
| − | |varchar (255)
| |
| − | |An URL linked to e.g. the module DiversityAgents within the Diversity Workbench
| |
| − | |R
| |
| − | |U
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |AgentRole
| |
| − | |nvarchar (50)
| |
| − | |The role of the agent within the project as defined in ProjectAgentRole_Enum
| |
| − | | -
| |
| − | | -
| |
| − | |-
| |
| − | |Notes
| |
| − | |nvarchar (MAX)
| |
| − | |Notes about the agent
| |
| − | | -
| |
| − | | -
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |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.<br />''DefaultValue: user_name()''
| |
| − | | -
| |
| − | | -
| |
| − | |-
| |
| − | |LogInsertedWhen
| |
| − | |smalldatetime
| |
| − | |Date and time when record was first entered (typed or imported) into this system.<br />''DefaultValue: getdate()''
| |
| − | | -
| |
| − | | -
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |LogUpdatedBy
| |
| − | |nvarchar (50)
| |
| − | |Name of user who last updated the data.<br />''DefaultValue: user_name()''
| |
| − | | -
| |
| − | | -
| |
| − | |-
| |
| − | |LogUpdatedWhen
| |
| − | |smalldatetime
| |
| − | |Date and time when the data were last updated.<br />''DefaultValue: getdate()''
| |
| − | | -
| |
| − | | -
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |RowGUID
| |
| − | |uniqueidentifier
| |
| − | |<br />''DefaultValue: newsequentialid()''
| |
| − | |R
| |
| − | | -
| |
| − | |}
| |
| − |
| |
| − |
| |
| − | ===Table: ProjectResource===
| |
| − | Resources of the project
| |
| − | {|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
| |
| − | |-style="text-align:left; background:#D3D3D3;"
| |
| − | !Column
| |
| − | !Data type
| |
| − | !Description
| |
| − | !Requ.
| |
| − | !Ind.
| |
| − | |-
| |
| − | |<u>ProjectID</u>
| |
| − | |int
| |
| − | |Refers to the ID of the project (= Foreign key and part of primary key)
| |
| − | |R
| |
| − | |U
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |<u>URI</u>
| |
| − | |varchar (255)
| |
| − | |The complete URI address of the resource.
| |
| − | |R
| |
| − | |U
| |
| − | |-
| |
| − | |SpecificRights
| |
| − | |nvarchar (500)
| |
| − | |The rights, e.g. the copyright of the resource
| |
| − | | -
| |
| − | | -
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |SpecificLicenseURI
| |
| − | |nvarchar (500)
| |
| − | |The license under which the resource is re-used or may be re-used
| |
| − | | -
| |
| − | | -
| |
| − | |-
| |
| − | |ResourceURI
| |
| − | |varchar (255)
| |
| − | |The URI of the image, e.g. as stored in the module DiversityResources.
| |
| − | | -
| |
| − | | -
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |Notes
| |
| − | |nvarchar (MAX)
| |
| − | |Notes about the resource
| |
| − | | -
| |
| − | | -
| |
| − | |-
| |
| − | |LogInsertedWhen
| |
| − | |datetime
| |
| − | |The time when this dataset was created<br />''DefaultValue: getdate()''
| |
| − | | -
| |
| − | | -
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |LogInsertedBy
| |
| − | |nvarchar (50)
| |
| − | |Who created this dataset<br />''DefaultValue: user_name()''
| |
| − | | -
| |
| − | | -
| |
| − | |-
| |
| − | |LogUpdatedWhen
| |
| − | |datetime
| |
| − | |The last time when this dataset was updated<br />''DefaultValue: getdate()''
| |
| − | | -
| |
| − | | -
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |LogUpdatedBy
| |
| − | |nvarchar (50)
| |
| − | |Who was the last to update this dataset<br />''DefaultValue: user_name()''
| |
| − | | -
| |
| − | | -
| |
| − | |-
| |
| − | |RowGUID
| |
| − | |uniqueidentifier
| |
| − | |<br />''DefaultValue: newsequentialid()''
| |
| − | |R
| |
| − | | -
| |
| − | |}
| |
| − |
| |
| − |
| |
| − | ===Table: ProjectUser===
| |
| − | The projects available for a user
| |
| − | {|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
| |
| − | |-style="text-align:left; background:#D3D3D3;"
| |
| − | !Column
| |
| − | !Data type
| |
| − | !Description
| |
| − | !Requ.
| |
| − | !Ind.
| |
| − | |-
| |
| − | |<u>LoginName</u>
| |
| − | |nvarchar (50)
| |
| − | |A login name which the user uses for access the DivesityWorkbench, Microsoft domains, etc..
| |
| − | |R
| |
| − | |U
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |<u>ProjectID</u>
| |
| − | |int
| |
| − | |ID of the project to which the specimen belongs (Projects are defined in DiversityProjects)
| |
| − | |R
| |
| − | |U
| |
| − | |-
| |
| − | |RowGUID
| |
| − | |uniqueidentifier
| |
| − | |<br />''DefaultValue: newsequentialid()''
| |
| − | |R
| |
| − | | -
| |
| − | |}
| |
| − |
| |
| − |
| |
| − | ===Table: UserProxy===
| |
| − | The users with access to the database
| |
| − | {|border=1 cellpadding="5" style="margin:1em 1em 1em 0; background:#FFFFFF;border:1px #AAA solid; border-collapse:collapse; empty-cells:show;"
| |
| − | |-style="text-align:left; background:#D3D3D3;"
| |
| − | !Column
| |
| − | !Data type
| |
| − | !Description
| |
| − | !Requ.
| |
| − | !Ind.
| |
| − | |-
| |
| − | |<u>LoginName</u>
| |
| − | |nvarchar (50)
| |
| − | |A login name of the user for access to the database server
| |
| − | |R
| |
| − | |U
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |CombinedNameCache
| |
| − | |nvarchar (255)
| |
| − | |The short name of the user, e.g. P. Smith. A cached value derived from an entry in the module DiversityAgents if AgentURI is filled.
| |
| − | |R
| |
| − | | -
| |
| − | |-
| |
| − | |AgentURI
| |
| − | |varchar (255)
| |
| − | |URI of a user in the remote module DiversityAgents
| |
| − | | -
| |
| − | | -
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |Queries
| |
| − | |xml (MAX)
| |
| − | |Queries defined by the user to access the data in the database
| |
| − | | -
| |
| − | | -
| |
| − | |-
| |
| − | |Settings
| |
| − | |xml (MAX)
| |
| − | |The settings for the user
| |
| − | | -
| |
| − | | -
| |
| − | |-style="background:WhiteSmoke;"
| |
| − | |RowGUID
| |
| − | |uniqueidentifier
| |
| − | |<br />''DefaultValue: newsequentialid()''
| |
| − | |R
| |
| − | | -
| |
| − | |}
| |
| − |
| |
| | | | |
| | | | |
| | | | |
| | '''Footnotes''': The following conventions and abbreviations have been used in the tables: Columns of primary key:<u>underlined</u> '''R''': It is required to enter data in this field. '''I''': The field is indexed to enable faster searching. '''U''': unique index | | '''Footnotes''': The following conventions and abbreviations have been used in the tables: Columns of primary key:<u>underlined</u> '''R''': It is required to enter data in this field. '''I''': The field is indexed to enable faster searching. '''U''': unique index |
Some “housekeeping” fields and tables for the documentation when and by whom the data were inserted or changed are not shown in the overview or the detail diagrams.
