Diversity Descriptions Workshop

Index

Table BaseEntity

The BaseEntity is used within the database to provide unique keys

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

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

Table CategoricalSamplingData

The categorical data recorded for a sampling event

Table CategoricalState

The categorical states available for categorical descriptors

Table CategoricalSummaryData

The categorical data of a description

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

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

Table Descriptor

Descriptor (= characters, features) define variables

Table DescriptorInapplicability

The descriptor dependency rules

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

Table DescriptorTreeNode

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

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

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

Table Modifier

Definition of modifier values

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”

Table Project

Projects define separated workareas in a single database

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

Table QuantitativeSummaryData

The quantitative data of a description

Table Resource

Hyperlinks to separate rich text/media objects

Table ResourceVariant

Different resource variants/instances/service access points

Table ResourceVariant_Enum

Classes for resource variants, values are predefined in the database

Table SamplingEvent

A sampling event may contain many sampling units

Table SamplingUnit

Sampling unit data

Table SexStatus_Enum

Values of sex status predefined according to SDD 1.1 rev 5

Table StatisticalMeasure_Enum

The statistical measures predefined according SDD 1.1 rev 5

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