The The list for taxa are stored in the tables documented below.
For details of the enumeration tables see ..._Enum.
| Column | Data type | Description |
|---|---|---|
| NameID | int | ID of the name. Refers to the NameID of TaxonName (= foreign key). |
| ProjectID | int | Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module. |
| Notes | nvarchar (MAX) | An note concerning this entry. |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. Default value: user_name() |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database. Default value: getdate() |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data. Default value: user_name() |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated. Default value: getdate() |
| RowGUID | uniqueidentifier | - Default value: newsequentialid() |
| Column | Data type | Description |
|---|---|---|
| NameID | int | ID of the name. Refers to the NameID of TaxonName (= foreign key). |
| ProjectID | int | Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module. |
| TaxonNameListRefID | int | Unique ID of the reference within the list, refers to table TaxonNameListReference, part of primary key Default value: (-1) |
| AnalysisID | int | ID of the analysis (= foreign key) |
| AnalysisValue | nvarchar (255) | The result of the analysis |
| ReferenceTitle | nvarchar (190) | Source publication where distribution is published (not publication of name!) Default value: '' |
| ReferenceURI | varchar (255) | Source publication where the distribution is published (not publication of name!) as stored e.g. in DiversityReferences |
| Notes | nvarchar (MAX) | Notes concerning this analysis |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. Default value: user_name() |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database. Default value: getdate() |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data. Default value: user_name() |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated. Default value: getdate() |
| RowGUID | uniqueidentifier | - Default value: newsequentialid() |
| Column | Data type | Description |
|---|---|---|
| AnalysisID | int | ID of the analysis (Primary key) |
| AnalysisParentID | int | Analysis ID of the parent analysis if it belongs to a certain type documented in this table |
| DisplayText | nvarchar (50) | Name of the analysis as e.g. shown in user interface |
| Description | nvarchar (MAX) | Description of the analysis |
| AnalysisURI | varchar (255) | URI referring to an external documentation of the analysis |
| Notes | nvarchar (MAX) | Notes concerning this analysis |
| LogCreatedWhen | datetime | The time when this dataset was created Default value: getdate() |
| LogCreatedBy | nvarchar (50) | Who created this dataset Default value: user_name() |
| LogUpdatedWhen | datetime | The last time when this dataset was updated Default value: getdate() |
| LogUpdatedBy | nvarchar (50) | Who was the last to update this dataset Default value: user_name() |
| Column | Data type | Description |
|---|---|---|
| AnalysisID | int | ID of the analysis (Primary key) |
| AnalysisValue | nvarchar (255) | The categorized value of the analysis |
| 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. |
| Notes | nvarchar (500) | Internal development notes about usage, definition, etc. of an enumerated object |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. Default value: user_name() |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database. Default value: getdate() |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data. Default value: user_name() |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated. Default value: getdate() |
| Column | Data type | Description |
|---|---|---|
| ProjectID | int | Each project can have a different opinion regarding the parameters defined for a list. Refers to the common project definition in the DiversityProjects module. |
| PlaceURI | varchar (255) | URI or identifier for a place (which may have several names) derived from e.g. TDWG |
| PlaceNameCache | nvarchar (255) | The name of the place |
| Notes | nvarchar (MAX) | An note concerning this entry. |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. Default value: user_name() |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database. Default value: getdate() |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data. Default value: user_name() |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated. Default value: getdate() |
| Column | Data type | Description |
|---|---|---|
| NameID | int | ID of the name. Refers to the NameID of TaxonName (= foreign key). |
| ProjectID | int | ProjectID of the taxon list. Foreign key and part of primary key. |
| DisplayText | varchar (255) | The name of the collection specimen as shown e.g. in a user interface. Part of the primary key |
| CollectionSpecimenURI | varchar (255) | URI of the collection specimen. May refer to the module CollectionSpecimen |
| Role | nvarchar (50) | The role of the specimen in relation to the taxon list (= foreign key, see table TaxonNameListSpecimenRole_Enum) |
| Description | nvarchar (MAX) | Description of the collection specimen |
| PlaceURI | varchar (255) | URI or identifier for a place (which may have several names) derived from e.g. TDWG |
| PlaceNameCache | nvarchar (255) | The name of the place |
| Notes | nvarchar (MAX) | Notes about the collection specimen |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. Default value: user_name() |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database. Default value: getdate() |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data. Default value: user_name() |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated. Default value: getdate() |
| Column | Data type | Description |
|---|---|---|
| NameID | int | ID of the name. Refers to the NameID of TaxonName (= foreign key). |
| ProjectID | int | Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module. |
| TaxonNameListRefID | int | Unique ID of the reference within the list, refers to table TaxonNameListReference, part of primary key Default value: (-1) |
| PlaceURI | varchar (255) | URI or identifier for a place (which may have several names) derived from e.g. TDWG Default value: '' |
| PlaceNameCache | nvarchar (255) | The name of the place Default value: '' |
| ReferenceTitle | nvarchar (190) | Source publication where distribution is published (not publication of name!) Default value: '' |
| ReferenceURI | varchar (255) | Source publication where the distribution is published (not publication of name!) as stored e.g. in DiversityReferences |
| Notes | nvarchar (MAX) | Notes concerning this analysis |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. Default value: user_name() |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database. Default value: getdate() |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data. Default value: user_name() |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated. Default value: getdate() |
| RowGUID | uniqueidentifier | - Default value: newsequentialid() |
| Column | Data type | Description |
|---|---|---|
| NameID | int | ID of the accepted name. Refers to the NameID of TaxonName (= foreign key). |
| ProjectID | int | Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module. |
| URI | varchar (255) | The complete URI address of the image. |
| Description | xml (MAX) | Description of the image |
| Notes | nvarchar (MAX) | Notes concerning this analysis |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. Default value: user_name() |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database. Default value: getdate() |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data. Default value: user_name() |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated. Default value: getdate() |
| RowGUID | uniqueidentifier | - Default value: newsequentialid() |
| Column | Data type | Description |
|---|---|---|
| ProjectID | int | ID of the Project, Primary key. May be related to module DiversityProjects |
| Project | nvarchar (50) | The name of the project. May be related to module DiversityProjets |
| ProjectURI | varchar (255) | The URI of the project, e.g. as provided by the module DiversityProjects. |
| Column | Data type | Description |
|---|---|---|
| NameID | int | ID of the name. Refers to the NameID of TaxonName (= foreign key). |
| ProjectID | int | Each project can may contain one taxon list. Refers to the common project definition in the DiversityProjects module. |
| TaxonNameListRefID | int | Unique ID of the reference within the list, part of primary key |
| TaxonNameListRefText | nvarchar (255) | Free text, esp. where a TaxonNameListRefURI is missing. Source publication where distribution is published (not publication of name!) |
| TaxonNameListRefURI | varchar (255) | Reference URI: Source publication where the distribution is published (not publication of name!) as stored e.g. in DiversityReferences |
| TaxonNameListRefDetail | nvarchar (255) | Esp. page number on which the distribution is published |
| ReferenceType | nvarchar (50) | The type of the reference, e.g. a webpage |
| TaxonUsageContext | nvarchar (50) | The context of the usage of the taxonomic name within the reference, e.g. ecology |
| Notes | nvarchar (MAX) | An note concerning this entry. |
| LogInsertedBy | nvarchar (50) | Name of user who first entered (typed or imported) the data. Default value: user_name() |
| LogInsertedWhen | smalldatetime | Date and time when the data were first entered (typed or imported) into this database. Default value: getdate() |
| LogUpdatedBy | nvarchar (50) | Name of user who last updated the data. Default value: user_name() |
| LogUpdatedWhen | smalldatetime | Date and time when the data were last updated. Default value: getdate() |
| RowGUID | uniqueidentifier | - Default value: newsequentialid() |
| Column | Data type | Description |
|---|---|---|
| LoginName | nvarchar (50) | Login of a user. |
| ProjectID | int | Project accessible for a user. Refers to ProjectID in table TaxonNameList (= foreign key). |