Diversity Descriptions Workshop

Index

Table BaseEntity

The BaseEntity is used within the database to provide unique keys

Column Data type Description Nullable
id int Database-internal object ID, unique across all tables in database (primary key) NO
table_id int References the table name of table entries associated with the BaseEntity; NULL indicates orphaned entries and may be used for garbage collection of otherwise deleted object ids
Default value: NULL		 YES
specific_rights_text nvarchar (255) To be used where the licence for an object differs from the default project licence
Default value: NULL		 YES
specific_licence_uri nvarchar (255) URI of licence, where different from project licence
Default value: NULL		 YES

Table BaseEntityTable_Enum

The BaseEntityTable_Enum contains the names of tables that reference the BaseEntity table

Column Data type Description Nullable
id int Database-internal object ID of this record (primary key) NO
table nvarchar (255) Name of table that references the BaseEntity table NO

Table CacheDatabase

Table holding the cache databases connected to the database

Column Data type Description Nullable
Server varchar (50) The name or IP of the server where the cache database is located NO
DatabaseName varchar (50) The name of the cache database NO
Port smallint The port of the server where the cache database is located NO
Version varchar (50) The version of the cache database YES

Table CacheMappingDescription

Table holding the description key mappings for the cache database

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
project_id int Reference to the description project (foreign key) NO
description_id int Reference to the description to which these data belong (foreign key) NO
target_key int Mapped key value for the target of the cache database. NO

Table CacheMappingDescriptor

Table holding the descriptor key mappings for the cache database

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
project_id int Reference to the descriptor project (foreign key) NO
descriptor_id int Reference to the descriptor to which these data belong (foreign key) NO
target_key int Mapped key value for the target of the cache database. NO
last_state_key int Highest value of state key. Relevant for key_mapping_level > 0
Default value: (0)		 YES

Table CacheMappingState

Table holding the categorical state key mappings for the cache database

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
project_id int Reference to the state project (foreign key) NO
state_id int Reference to the categorical state to which these data belong (foreign key) NO
target_key int Mapped key value for the target of the cache database. NO

Table CacheProject

Table holding the project settings for the cache database

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
project_id int Reference to the description project (foreign key) NO
withheld_data_level tinyint Flag for handling of withheld descriptor data. 0=withhold description; 1=withhold descriptor; 2=do not withhold data
Default value: (0)		 YES
key_mapping_level tinyint Flag for handling of key mapping. 0=re-build mapping for each update; 1=keep first mapping; 2=additionally take numeric values of alternate ID for items; >2 as 2 but re-initialize table
Default value: (1)		 YES
last_char_key int Highest value of character key. Relevant for key_mapping_level > 0
Default value: (0)		 YES
last_item_key int Highest value of item key. Relevant for key_mapping_level > 0
Default value: (0)		 YES
last_changes datetime The recent date when data within the project had been changed
Default value: getdate()		 YES

Table CategoricalSamplingData

The categorical data recorded for a sampling event

Column Data type Description Nullable
id int Database-internal ID of this record, references BaseEntity (primary key) NO
sampling_unit_id int Reference to the sampling unit (foreign key) NO
state_id int Reference to the state (descriptor is implicit in state_id) (foreign key) NO
notes nvarchar (MAX) Free-form text detailing special cases or additional data beyond the values YES
modifier_id int Optional reference to a modifier definition (e.g. "strongly", "at the base", "in autumn") (foreign key)
Default value: NULL		 YES
frequency_value int Number of times this category was observed within a single sampling unit
Default value: NULL		 YES

Table CategoricalState

The categorical states available for categorical descriptors

Column Data type Description Nullable
id int Database-internal ID of this record, references BaseEntity (primary key) NO
descriptor_id int Reference to the descriptor to which the state belongs (foreign key) NO
label nvarchar (255) Short label (or name) of descriptor state NO
abbreviation nvarchar (255) Abbreviated label of descriptor state
Default value: NULL		 YES
detail nvarchar (MAX) Additional detail text explaining or commenting on the descriptor state definition YES
wording nvarchar (255) Optional separate wording for natural language generation (label will be used if this is missing)
Default value: NULL		 YES
display_order int A positive number defining the sequence in which descriptor states are displayed
Default value: '0'		 NO

Table CategoricalSummaryData

The categorical data of a description

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
description_id int Reference to the description to which these data belong (foreign key) NO
state_id int Reference to the state (the descriptor is implicit in state_id) (foreign key) NO
notes nvarchar (MAX) Free-form text detailing special cases or additional data beyond the values YES
modifier_id int Optional reference to a modifier definition (e.g. "strongly", "at the base", "in autumn") (foreign key)
Default value: NULL		 YES
frequency_id int Optional reference to a frequency modifier definition (e.g. "rarely", "usually", "mostly") (foreign key)
Default value: NULL		 YES

Table DataStatus_Enum

Values of data status used for descriptions according to SDD 1.1 rev 5

Column Data type Description Nullable
id int Database-internal ID of this record, references BaseEntity (primary key) NO
label nvarchar (255) Short label (or name) of data status NO
code nvarchar (255) Code of data status NO
abbreviation char (1) Single (intuitive) character NO
detail nvarchar (MAX) Additional detail text explaining or commenting on the data status definition YES

Table Description

The description in the database

Column Data type Description Nullable
id int Database-internal ID of this record, references BaseEntity (primary key) NO
label nvarchar (255) Short label (or name) of description
Default value: NULL		 YES
detail nvarchar (MAX) Additional detail text explaining or commenting on the description definition YES
project_id int Each description belongs to exactly one project that determines its terminology (required, foreign key) NO
alternate_id nvarchar (30) Optional alternate id of a description item - should be unique within one project, but not checked by database
Default value: NULL		 YES
wording nvarchar (255) Optional separate wording for natural language generation (label will be used if this is missing)
Default value: NULL		 YES

Table DescriptionProject

The projects where descriptions are accessible

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
description_id int ID of the description that belongs to the project (required, foreign key) NO
project_id int ID of the project to which the description belongs (required, foreign key) NO

Table DescriptionScope

The scope of the description

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
description_id int Reference to the description to which these data belong (foreign key) NO
label nvarchar (255) Short label (or name) of scope
Default value: NULL		 YES
dwbURI nvarchar (500) Reference to DiversityWorkbench component
Default value: NULL		 YES
type nvarchar (255) Scope type ("GeographicArea", "SamplingPlot", "Citation", "Observation", "Specimen", "TaxonName", "OtherConcept", "Stage", "Part" or "Sex")
Default value: NULL		 YES
other_scope_id int Reference to further scopes, e.g. stage, sex etc. (foreign key)
Default value: NULL		 YES

Table Descriptor

Descriptor (= characters, features) define variables

Column Data type Description Nullable
id int Database-internal ID of this record, references BaseEntity (primary key) NO
label nvarchar (255) Short label (or name) of descriptor NO
abbreviation nvarchar (255) Abbreviated label of descriptor
Default value: NULL		 YES
detail nvarchar (MAX) Additional detail text explaining or commenting on the descriptor definition YES
display_order int A positive number defining the sequence in which descriptors are displayed
Default value: '0'		 NO
subclass nvarchar (255) The four character subclasses of SDD are all combined here in one entity and distinguished by this attribute ("categorical", "quantitative", "text" or "sequence")
Default value: 'categorical'		 NO
statistical_measurement_scale nvarchar (255) Scale of descriptor: Categorical may be nominal (unordered, “red/green/blue”) or ordinal (ordered, “bad/medium/good”); Quantitative may be interval (°C) or ratio (mass, length, time, K)
Default value: 'nominal'		 NO
usually_exclusive tinyint Applicable to categorical (nominal/ordinal) descriptors only. If usually exclusive = 1, then by default the user interface allows only entering one state. Nevertheless, multiple states in the data are valid.
Default value: '0'		 NO
state_collection_model nvarchar (255) Handling of multiple values: OrSet/AndSet: unordered set combined with or/and, OrSeq/AndSeq: ordered sequence combined with or/and, WithSeq: example is “green with brown”, Between: an example is “oval to elliptic”
Default value: 'OrSet'		 NO
mandatory tinyint Is the scoring of this descriptor mandatory (required) in each item?
Default value: '0'		 NO
repeatability nvarchar (255) How reliable and consistent are repeated measurements or scorings of the descriptor by different observers and on different objects? ("ignore", "very low", "low", "below average", "slightly below average", "standard", "slightly above average", "above average", "high" or "very high")
Default value: 'standard'		 NO
availability nvarchar (255) How available is the descriptor or concept for identification? ("ignore", "very low", "low", "below average", "slightly below average", "standard", "slightly above average", "above average", "high" or "very high")
Default value: 'standard'		 NO
measurement_unit nvarchar (255) A measurement unit (mm, inch, kg, °C, m/s etc.) or dimensionless scaling factor
Default value: NULL		 YES
measurement_unit_precedes_value tinyint Set to 1 if the measurement unit precedes the value
Default value: '0'		 NO
values_are_integer tinyint Set to 1 if the values are integer
Default value: '0'		 NO
min_plausible_value float Applicable to quantitative descriptors only; in support of a plausibility check for values. Example: for tree height this could be 0, i.e. only positive values allowed
Default value: '-1.79e308'		 NO
max_plausible_value float Applicable to quantitative descriptors only; in support of a plausibility check for values. Example: for tree height this could be 99
Default value: '1.79e308'		 NO
sequence_type nvarchar (255) Type of molecular sequence, "Nucleotide" or "Protein". The value "Nucleotide" covers RNA and DNA sequences
Default value: 'Nucleotide'		 NO
symbol_length tinyint The number of letters in each symbol. Nucleotides are always codes with 1-letter symbols, but proteins may use 1 or 3-letter codes (e.g. A or Ala for alanine)
Default value: '1'		 NO
enable_ambiguity_symbols tinyint Set to 1 if ambiguity symbols are supported in the sequence string, e.g. R, Y, S, W for nucleotides or B, Z for proteins
Default value: '1'		 NO
gap_symbol nvarchar (3) A string identifying the "gap" symbol used in aligned sequences. The gap symbol must always be symbol_length long
Default value: NULL		 YES
wording_before nvarchar (255) Representation for natural language output, inserted before the states/value
Default value: NULL		 YES
wording_after nvarchar (255) Representation for natural language output, inserted after the states/value
Default value: NULL		 YES
data_entry_note nvarchar (MAX) A note or prompt when entering or dealing with data YES
wording nvarchar (255) Optional separate wording for natural language generation (label will be used if this is missing)
Default value: NULL		 YES

Table DescriptorInapplicability

The descriptor dependency rules

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
controlled_descriptor_id int Reference to the descriptor to which the rule will apply, e.g. which will be inapplicable if controlling state applies to the same description (foreign key) NO
controlling_state_id int Reference to the controlling categorical state; if present in a description, controlled descriptor is affected according to rule NO
rule nvarchar (255) The kind of rule creating a descriptor inapplicability ("inapplicable-if", "applicable-if", "inapplicable-computed-from-applicable")
Default value: 'inapplicable-if'		 NO

Table DescriptorStatusData

The status data of a descriptor for a certain description

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
description_id int Reference to the description to which these data belong (foreign key) NO
descriptor_id int Reference to the descriptor to which the status value belongs (foreign key) NO
datastatus_id int Reference to a status definition. Status is like a marker why data is missing or in need of revision (examples: “unknown”, “not applicable”, “to be checked”, “data withheld” etc.) (foreign key) NO
notes nvarchar (MAX) Free-form text detailing additional information (rarely used, not multilingual) YES

Table DescriptorTree

The root and definition of a descriptor tree

Column Data type Description Nullable
id int Database-internal ID of this record, references BaseEntity (primary key) NO
is_complete tinyint Set to 1 if this tree includes the largest possible set of descriptors for the taxon set associated with a project (i.e. the "master-descriptor tree", other trees being subsets)
Default value: '0'		 NO
label nvarchar (255) Short label (or name) of descriptor tree NO
type nvarchar (255) "mixed", "part-of", "property" or "generalization" NO
project_id int Each tree belongs to exactly one project (required, foreign key) NO

Table DescriptorTreeNode

The descriptor tree nodes representing either nodes of the tree or descriptors (“leafes” of the tree)

Column Data type Description Nullable
id int Database-internal ID of this record, references BaseEntity (primary key) NO
parent_node_id int Reference to a parent node, creating a true tree; NULL for a root node (foreign key)
Default value: NULL		 YES
label nvarchar (255) Short label (or name) of internal node associated with a concept; NULL for a descriptor node
Default value: NULL		 YES
abbreviation nvarchar (255) Abbreviated label of node
Default value: NULL		 YES
display_order int A positive number defining the sequence in which child nodes are displayed
Default value: '0'		 NO
descriptortree_id int Reference to a descriptor tree; all nodes must have a direct link to the tree definition (foreign key) NO
descriptor_id int Reference to a descriptor; NULL if the present node is an inner concept node defining a hierarchy of nodes or descriptors (foreign key)
Default value: NULL		 YES
detail nvarchar (MAX) Additional detail text explaining or commenting on the node definition YES

Table DescriptorTreeNodeRecFrequency

Selection of recommended frequency values for descriptor tree parts or single descriptors

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
node_id int Reference to the descriptor tree node (foreign key) NO
frequency_id int Reference to the recommended frequency modifier (foreign key) NO

Table DescriptorTreeNodeRecModifier

Selection of recommended modifier values for descriptor tree parts or single descriptors

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
node_id int Reference to the descriptor tree node (foreign key) NO
modifier_id int Reference to the recommended modifier (foreign key) NO

Table DescriptorTreeNodeRecStatMeasure

Selection of recommended statistical measures for descriptor tree parts or single descriptors

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
node_id int Reference to the descriptor tree node (foreign key) NO
measure_id int Reference to the recommended measure (foreign key) NO

Table Frequency

Definition of frequency modifier values

Column Data type Description Nullable
id int Database-internal ID of this record, references BaseEntity (primary key) NO
label nvarchar (255) Short label (or name) of frequency modifier (e.g. "very rare", "rare", "usually" etc.) NO
lower_estimate float Each frequency modifier defines a frequency range, this is the estimated lowest frequency
Default value: '0'		 NO
upper_estimate float As above, estimate of upper range for the border; note: ranges may overlap!
Default value: '1'		 NO
display_order int A positive number defining the sequence in which frequency modifiers are to be displayed
Default value: '0'		 NO

Table ImportMapping

The import mappings to support mapping of external file keys to database keys

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
object_id int Reference to the object to which the mapping belongs, references BaseEntity (foreign key) NO
session_id int Reference to the import session to which the mapping belongs, references ImportMapping (foreign key) NO
table_name varchar (50) Name of the import table NO
parent_key varchar (255) Symbolic key of the parent table NO
external_key nvarchar (255) External key in the import file NO

Table ImportSession

The import sessions to support import of data spread over several files

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
project_id int Each import session belongs to exactly one project (required, foreign key) NO
detail nvarchar (MAX) Detail text explaining the import session definition YES
create_timestamp datetime Date and time when the import session was created
Default value: getdate()		 NO
update_timestamp datetime Date and time when the import session was updated
Default value: getdate()		 NO

Table Modifier

Definition of modifier values

Column Data type Description Nullable
id int Database-internal ID of this record, references BaseEntity (primary key) NO
class nvarchar (255) Grouping of modifiers into classes ("Certainty", "Seasonal", "Diurnal", "TreatAsMisinterpretation" or "OtherModifierClass") NO
label nvarchar (255) Short label (or name) of modifier (e.g. "strong", "probably" etc.) NO
display_order int A positive number defining the sequence in which modifiers are to be displayed
Default value: '0'		 NO

Table MolecularSequenceData

The molecular sequence data of a description

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
description_id int Reference to description to which these data belong (foreign key) NO
descriptor_id int Reference to a molecular sequence descriptor to which the sequence text belongs (foreign key) NO
sequence nvarchar (MAX) Molecular sequence text referring to information on one descriptor NO
notes nvarchar (MAX) Free-form text detailing special cases or additional data beyond the values YES

Table MolecularSequenceSamplingData

The molecular sequence data recorded for a sampling event

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
sampling_unit_id int Reference to a sampling unit (foreign key) NO
descriptor_id int Reference to a molecular sequence descriptor to which the sequence text belongs (foreign key) NO
sequence nvarchar (MAX) Molecular sequence text referring to information on one descriptor NO
notes nvarchar (MAX) Free-form text detailing special cases or additional data beyond the values YES

Table OtherScope

Scope values for description scope values for scope types “Other scope”, “Part”, “Stage” and “Sex”

Column Data type Description Nullable
id int Database-internal ID of this record, references BaseEntity (primary key) NO
label nvarchar (255) Short label (or name) of scope (e.g. "male", "female", "adult", "juvenile" etc.) NO
detail nvarchar (MAX) Additional detail text explaining or commenting on the scope and delimitation of the present description YES
type nvarchar (255) Describes the scope type ("sex", "stage", "part" or "other") NO
sex_status_id int Reference to sex status value according SDD V5.1 (foreign key)
Default value: NULL		 YES

Table Project

Projects define separated workareas in a single database

Column Data type Description Nullable
id int Database-internal ID of this record, references BaseEntity (primary key) NO
parent_project_id int Reference to a parent project, creating a subproject; NULL for a root project (foreign key)
Default value: NULL		 YES
label nvarchar (255) Short label (or name) of project (or subproject); each project defines a separate work environment within a shared database by means of defining sets of descriptors (through DescriptorTree) NO
rights_text nvarchar (255) The default rights and licence statement for the entire project; BaseEntity provides means to override this for individual objects
Default value: NULL		 YES
licence_uri nvarchar (255) URI of licence for the project; BaseEntity provides means to override this for individual objects
Default value: NULL		 YES
detail nvarchar (MAX) Additional detail text explaining or commenting on the project (or subproject) YES
primary_language_code nvarchar (3) Language of primary text version (fields directly in tables, may be translated in table Translation); Examples: "de", "en" etc. (ISO 639 language code) NO
ProjectProxyID int Reference to a project definition of DiversityProjects that allows control of access rights
Default value: (0)		 NO
wording nvarchar (255) Optional separate wording for natural language generation and cache database (label will be used if this is missing)
Default value: NULL		 YES

Table Project_AvailableScope

Scope values available for a certain project

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
project_id int Reference to the project for which a shall be available (foreign key) NO
scope_id int Reference to a scope definition in OtherScope (foreign key) NO

Table QuantitativeSamplingData

The quantitative data recorded for a sampling event

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
measure_id int Optional statistical measure (minimum, mean, maximum, ranges, sample size, variance etc.) recorded in value; if NULL, value is a direct measurement (foreign key)
Default value: NULL		 YES
sampling_unit_id int Reference to a sampling unit (foreign key) NO
descriptor_id int Reference to descriptor which the values record (foreign key) NO
value float The value for the statistical measure or single measurement/recording NO
notes nvarchar (MAX) Free-form text detailing special cases or additional data beyond the values YES
modifier_id int Optional reference to a modifier definition (e.g. "strongly", "at the base", "in autumn") (foreign key)
Default value: NULL		 YES

Table QuantitativeSummaryData

The quantitative data of a description

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
measure_id int Reference to the statistical measure (minimum, mean, maximum, ranges, sample size, variance etc.) recorded in value (foreign key) NO
description_id int Reference to the description to which these data belong (foreign key) NO
descriptor_id int Reference to the descriptor which the values record (foreign key) NO
value float The value of the statistical measure NO
notes nvarchar (MAX) Free-form text detailing special cases or additional data beyond the values YES
modifier_id int Optional reference to a modifier definition (e.g. "strongly", "at the base", "in autumn") (foreign key)
Default value: NULL		 YES

Table Resource

Hyperlinks to separate rich text/media objects

Column Data type Description Nullable
id int Database-internal ID of this record, references BaseEntity (primary key) NO
terminology_role nvarchar (255) Role in relation to descriptors or states ("unknown"=role not known or not specified; "diagnostic"=optimized for identification; "iconic"=icon/thumbnail, needs text; "normative"=defines a resource object; "primary"=display always, informative without text; "secondary"=display only on request)
Default value: 'unknown'		 NO
ranking_for_terminology tinyint Ranking of the resource with respect to terminology; range: 0 to 10
Default value: NULL		 YES
descriptor_id int Optional reference to a descriptor (at least 1 of description_id, node_id, descriptor_id, state_id or taxon_id must be present) (foreign key)
Default value: NULL		 YES
state_id int Optional reference to a categorical state (at least 1 of description_id, node_id, descriptor_id, state_id or taxon_id must be present) (foreign key)
Default value: NULL		 YES
taxon_role nvarchar (255) Role in relation to taxa or descriptions ("unknown"=role not known or not specified; "diagnostic"=optimized for identification; "iconic"=icon/thumbnail, needs text; "normative"=defines a resource object; "primary"=display always, informative without text; "secondary"=display only on request)
Default value: 'unknown'		 NO
ranking_for_taxon_use tinyint Ranking of the resource with respect to taxa or descriptions; range: 0 to 10
Default value: NULL		 YES
taxon_id int Optional reference to a taxon (at least 1 of description_id, node_id, descriptor_id, state_id or taxon_id must be present) (foreign key)
Default value: NULL		 YES
description_id int Optional reference to a description (at least 1 of description_id, node_id, descriptor_id, state_id or taxon_id must be present) (foreign key)
Default value: NULL		 YES
scope_id int Reference to the scope of the resource (e.g. "sex", "stage", "season" etc.)
Default value: NULL		 YES
display_embedded tinyint false/0: display as link, true/1: display as embedded media object
Default value: '0'		 NO
label nvarchar (255) Short label of (or caption for) the resource, e.g. a text displayed below an image or instead of the link NO
detail nvarchar (MAX) Additional detail text explaining or commenting on the resource definition YES
language_code nvarchar (3) Language of the resource itself, use zxx for language neutral/no linguistic content (ISO 639-1)
Default value: NULL		 YES
rights_text nvarchar (255) The rights and licence statement for the resource
Default value: NULL		 YES
licence_uri nvarchar (255) URI of licence for the resource
Default value: NULL		 YES
display_order int A positive number defining the sequence in which multiple resources are displayed
Default value: '0'		 NO
node_id int Optional reference to a descriptor tree node (at least 1 of description_id, node_id, descriptor_id, state_id or taxon_id must be present) (foreign key)
Default value: NULL		 YES

Table ResourceVariant

Different resource variants/instances/service access points

Column Data type Description Nullable
id int Database-internal ID of this record, references BaseEntity (primary key) NO
resource_id int Reference to the resource to which these variants provide access points (foreign key) NO
variant_id int Reference to the definition of a variant class e.g. "tiny sample", "small sample", "lower quality", "medium quality", "good quality" or "best quality" (foreign key) NO
url nvarchar (255) URL of the resource variant NO
pixel_width int Where applicable (still- or moving image): the width in pixel
Default value: NULL		 YES
pixel_height int Where applicable (still- or moving image): the height in pixel
Default value: NULL		 YES
duration int Where applicable (sound or moving image): the duration in seconds
Default value: NULL		 YES
size int The size of the resource in bytes
Default value: NULL		 YES
mime_type nvarchar (255) Type of the resource as MIME type like image/jpeg; color as color/hexrgb
Default value: NULL		 YES

Table ResourceVariant_Enum

Classes for resource variants, values are predefined in the database

Column Data type Description Nullable
id int Database-internal ID of this record, references BaseEntity (primary key) NO
label nvarchar (255) Short label (or name) of resource variant class ("tiny sample", "small sample", "lower quality", "medium quality", "good quality" or "best quality") NO
code nvarchar (255) Brief code equivalent to the (longer) label NO
detail nvarchar (MAX) Additional detail text explaining the resource variant class YES
quality_order int A positive number providing a filter mechanism for "tiny sample" to "best quality"; the smaller the number, the less quality a resource has
Default value: '0'		 NO

Table SamplingEvent

A sampling event may contain many sampling units

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
description_id int Reference to the description to which these sampling data belong (foreign key) NO
label nvarchar (255) Free-form text identifying a sampling event to humans. Sampling events have time, location, perhaps purpose and act as a container for multiple sampling units.
Default value: NULL		 YES
detail nvarchar (MAX) Free-form text giving detail or description of sampling event YES
date_time datetime Date and time when the event occurred; single point or start of duration
Default value: NULL		 YES
datetimespan_end datetime Optional end of a time span or duration within which or during which the event occurred
Default value: NULL		 YES
geographic_area nvarchar (255) A geographic area at which the event occurred
Default value: NULL		 YES
geographic_area_uri nvarchar (255) Reference to a geographic area in DiversityGazetteers
Default value: NULL		 YES
coord_dec_latitude float Latitude of geographical coordinates in signed decimal degrees
Default value: NULL		 YES
coord_dec_longitude float Longitude of geographical coordinates in decimal degrees
Default value: NULL		 YES
coord_literal nvarchar (255) Free-form string, either in addition to or instead of code (a mapping to the controlled vocabulary may be unavailable or considered ambiguous)
Default value: NULL		 YES
coord_geodeticdatum nvarchar (50) Optional, only where knowledge of the geodetic datum is readily available; defaults to WGS84 used in GPS
Default value: NULL		 YES

Table SamplingUnit

Sampling unit data

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
sampling_event_id int Reference to a sampling event; keeps paired measurements together (several categorical or quantitative observations at the same time on the same object or object part) (foreign key) NO
collection_specimen nvarchar (255) A collection specimen that is represented by the sampling unit
Default value: NULL		 YES
collection_specimen_uri nvarchar (500) Reference to a collection specimen in DiversityCollection
Default value: NULL		 YES

Table SexStatus_Enum

Values of sex status predefined according to SDD 1.1 rev 5

Column Data type Description Nullable
id int Database-internal ID of this record, references BaseEntity (primary key) NO
label nvarchar (255) Short label (or name) of sex status NO
code nvarchar (255) Code of sex status NO
abbreviation nvarchar (255) One or two (intuitive) characters NO
detail nvarchar (MAX) Additional detail text explaining or commenting on the sex status definition YES
display_order int A positive number defining the sequence in which sex status values are displayed
Default value: '0'		 NO

Table StatisticalMeasure_Enum

The statistical measures predefined according SDD 1.1 rev 5

Column Data type Description Nullable
id int Database-internal ID of this record, references BaseEntity (primary key) NO
label nvarchar (255) Short label (or name) of statistical measure NO
code nvarchar (255) Code of statistical measure according SDD 1.1 rev 5 NO
abbreviation nvarchar (255) Abbreviation of statistical measure NO
display_order int A positive number defining the sequence in which statistical measures are displayed
Default value: '0'		 NO

Table TextDescriptorData

The text data of a description

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
description_id int Reference to description to which these data belong (foreign key) NO
descriptor_id int Reference to a text descriptor to which the free-form text belongs (foreign key) NO
content nvarchar (MAX) Free-form text referring to information on one descriptor NO
notes nvarchar (MAX) Free-form text detailing special cases or additional data beyond the values YES

Table TextSamplingData

Free-form text data recorded for a sampling event

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
sampling_unit_id int Reference to a sampling unit (foreign key) NO
descriptor_id int Reference to descriptor to which the free-form text belongs (foreign key) NO
content nvarchar (MAX) Free-form text referring to information on one descriptor NO
notes nvarchar (MAX) Free-form text detailing special cases or additional data beyond the data YES

Table Translation

The translations of entries related to BaseEntity

Column Data type Description Nullable
id int Database-internal ID of this record (primary key) NO
object_id int Reference to the object to which the translation belongs, references BaseEntity (foreign key) NO
language_code nvarchar (3) Language of representation translation (ISO 639 language code) NO
column_id int References the translated column name NO
contents nvarchar (MAX) Translated contents YES

Table TranslationColumn_Enum

The TranslationColumn_Enum contains the column names that are translated in the Translation table

Column Data type Description Nullable
id int Database-internal object ID of this record (primary key) NO
column nvarchar (255) Name of column that is translated in the Translation table NO