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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |