DiversityDescriptions Quiz (Artenquiz)
From Diversity Workbench
Revision as of 12:43, 12 February 2021 by Andreas Plank (Talk | contribs) (+Database Scheme of DiversityDescriptions Quiz Artenquiz (20140717))
The ER diagram of DiversityDescriptions_Quiz (DD_Quiz) is a clone of DiversityDescriptions 3.00.10. July 17th, 2014 that is intended to work with the Web-Framework Django to have a quiz for species descriptions in German. This project is presently under development. Additional tables see below. For further information see under DiversityDescriptions Quiz implementations.
Suggested citation is that of DiversityDescriptions 3.00.10: G. Hagedorn, A. Plank, A. Link, G. Rambold & D. Triebel (2014). DiversityDescriptions information model (version 3.00.10). http://www.diversityworkbench.net/Portal/DescriptionsModel_v3.00.10.
Hover the mouse over a table to jump to the documentation (linked to DiversityDescriptions 3.00.10. July 17th, 2014).
Contents
Documentation
Database
Scheme of DiversityDescriptions Quiz:
Graph image creation requires permission to upload.
The following conventions and abbreviations have been used in the tables: Columns of primary key:underlined. Categorical data are presented to a user in the quiz therefore some tables (in gray) are not used for the quiz.
The data base scheme described in DOT language (click the expand on the right side to read the content)
<graphviz caption='Scheme of Diversity Descriptions Quiz' alt='Diversity Descriptions Quiz' format='png'>
digraph DD_Quiz_Scheme_20140717{
graph [rankdir = "LR" splines="line" outputorder="edgesfirst"];
node [fontsize = "10", shape = "plaintext"];
edge [color = "black" arrowhead="dot"];
Annotation [
URL="[[DescriptionsModel_v3.00.10#Table:_Annotation]]"
tooltip="One record per annotated object (Char, State, Descr. etc.)"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="lightblue" colspan="1">Annotation</td></tr>
<tr><td PORT="id">id</td></tr>
<tr><td PORT="object_id">object_id</td></tr>
<tr><td PORT="language_code">language_code</td></tr>
<tr><td PORT="contributor_id">contributor_id</td></tr>
<tr><td PORT="timestamp">timestamp</td></tr>
<tr><td PORT="content">content</td></tr>
<tr><td PORT="is_internal">is_internal</td></tr>
<tr><td PORT="is_latest_revision">is_latest_revision</td></tr>
<tr><td PORT="MEMO_WhichVersionsInheritIsNotSolved">MEMO_WhichVersionsInheritIsNotSolved</td></tr>
//CONSTRAINT [PK_Annotation] PRIMARY KEY ([id])
</table>>
];
BaseEntity [
URL="[[DescriptionsModel_v3.00.10#Table:_BaseEntity]]"
tooltip="The BaseEntity is used within the database to provide unique keys"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0">
<tr><td BGCOLOR="lightblue" >BaseEntity</td></tr>
<tr><td PORT="id">id</td></tr>
<tr><td PORT="table_id">table_id</td></tr>
<tr><td PORT="specific_rights_text">specific_rights_text</td></tr>
<tr><td PORT="specific_licence_uri">specific_licence_uri</td></tr>
//CONSTRAINT [PK_BaseEntity] PRIMARY KEY ([id])
</table>>
];
BaseEntityTable_Enum [
URL="[[DescriptionsModel_v3.00.10#Table:_BaseEntityTable_Enum]]"
tooltip="The BaseEntityTable_Enum contains the names of tables that reference the BaseEntity table"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="lightblue" colspan="2">BaseEntityTable_Enum</td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="table">table</td><td>u</td></tr>
//CONSTRAINT [PK_BaseEntityTable_Enum] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_BaseEntityTable_Enum_1] UNIQUE ([table])
</table>>
];
CategoricalSamplingData [
URL="[[DescriptionsModel_v3.00.10#Table:_CategoricalSamplingData]]"
tooltip="The categorical data recorded for a sampling event"
fontcolor="gray"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COLOR="gray">
<tr><td BGCOLOR="#cee12c" colspan="2"><font color="black">CategoricalSamplingData</font></td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="sampling_unit_id">sampling_unit_id</td><td>ut_1</td></tr>
<tr><td PORT="state_id">state_id</td><td>ut_1</td></tr>
<tr><td PORT="notes">notes</td><td></td></tr>
<tr><td PORT="modifier_id">modifier_id</td><td>ut_1</td></tr>
<tr><td PORT="frequency_value">frequency_value</td><td></td></tr>
//CONSTRAINT [PK_CategoricalSamplingData] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_CategoricalSamplingData_1] UNIQUE ([sampling_unit_id],[state_id],[modifier_id])
</table>>
];
CategoricalState [
URL="[[DescriptionsModel_v3.00.10#Table:_CategoricalState]]"
tooltip="The categorical states available for categorical descriptors"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#e5c96a" colspan="2">CategoricalState</td></tr>
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
<tr><td PORT="descriptor_id">descriptor_id</td><td>ut_1</td></tr>
<tr><td PORT="label">label</td><td>ut_1</td></tr>
<tr><td PORT="abbreviation">abbreviation</td><td></td></tr>
<tr><td PORT="detail">detail</td><td></td></tr>
<tr><td PORT="wording">wording</td><td></td></tr>
<tr><td PORT="display_order">display_order</td><td></td></tr>
//CONSTRAINT [PK_CategoricalState] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_CategoricalState_1] UNIQUE ([label],[descriptor_id])
</table>>
];
CategoricalSummaryData [
URL="[[DescriptionsModel_v3.00.10#Table:_CategoricalSummaryData]]"
tooltip="The categorical data of a description"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#00c900" colspan="2">CategoricalSummaryData</td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="description_id">description_id</td><td>ut_1</td></tr>
<tr><td PORT="state_id">state_id</td><td>ut_1</td></tr>
<tr><td PORT="notes">notes</td><td></td></tr>
<tr><td PORT="modifier_id">modifier_id</td><td>ut_1</td></tr>
<tr><td PORT="frequency_id">frequency_id</td><td>ut_1</td></tr>
//CONSTRAINT [PK_CategoricalSummaryData] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_CategoricalSummaryData_1] UNIQUE ([description_id],[state_id],[modifier_id],[frequency_id])
</table>>
];
Contribution [
URL="[[#Table:_Contribution]]"
tooltip="Multiple contributors may contribute in different roles"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="lightblue" colspan="1">Contribution</td></tr>
<tr><td PORT="id">id</td></tr>
<tr><td PORT="object_id">object_id</td></tr>
<tr><td PORT="contributor_id">contributor_id</td></tr>
<tr><td PORT="role">role</td></tr>
<tr><td PORT="timestamp">timestamp</td></tr>
//CONSTRAINT [PK_Contribution] PRIMARY KEY ([id])
</table>>
];
Contributor [
URL="[[#Table:_Contributor]]"
tooltip="People contibuting to a work. Roles are recorded in Contribution"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="lightblue" colspan="2">Contributor</td></tr>
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
<tr><td PORT="email">email</td><td>u</td></tr>
<tr><td PORT="web_pseudonym">web_pseudonym</td><td></td></tr>
<tr><td PORT="avatar_uri">avatar_uri</td><td></td></tr>
<tr><td PORT="real_name">real_name</td><td></td></tr>
<tr><td PORT="linked_agent_uri">linked_agent_uri</td><td></td></tr>
//CONSTRAINT [PK_Contributor] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_Contributor_1] UNIQUE ([email])
</table>>
];
DataStatus_Enum [
URL="[[DescriptionsModel_v3.00.10#Table:_DataStatus_Enum]]"
tooltip="Values of data status used for descriptions according to SDD 1.1 rev 5"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#e5c96a" colspan="2">DataStatus_Enum</td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="label">label</td><td>u</td></tr>
<tr><td PORT="code">code</td><td>u</td></tr>
<tr><td PORT="abbreviation">abbreviation</td><td>u</td></tr>
<tr><td PORT="detail">detail</td><td></td></tr>
//CONSTRAINT [PK_DataStatus_Enum] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_DataStatus_Enum_1] UNIQUE ([code]),
//CONSTRAINT [UQ_DataStatus_Enum_2] UNIQUE ([abbreviation]),
//CONSTRAINT [UQ_DataStatus_Enum_3] UNIQUE ([label])
</table>>
];
Description [
URL="[[DescriptionsModel_v3.00.10#Table:_Description]]"
tooltip="The description in the database"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#00c900" colspan="1">Description</td></tr>
<tr><td PORT="id">id</td></tr>
<tr><td PORT="label">label</td></tr>
<tr><td PORT="detail">detail</td></tr>
<tr><td PORT="project_id">project_id</td></tr>
//CONSTRAINT [PK_Description] PRIMARY KEY ([id])
</table>>
];
DescriptionScope [
URL="[[DescriptionsModel_v3.00.10#Table:_DescriptionScope]]"
tooltip="The scope of the description"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#00c900" colspan="1">DescriptionScope</td></tr>
<tr><td PORT="id">id</td></tr>
<tr><td PORT="description_id">description_id</td></tr>
<tr><td PORT="label">label</td></tr>
<tr><td PORT="dwbURI">dwbURI</td></tr>
<tr><td PORT="type">type</td></tr>
<tr><td PORT="taxon_id">taxon_id</td></tr>
<tr><td PORT="specimen_id">specimen_id</td></tr>
<tr><td PORT="observation_id">observation_id</td></tr>
<tr><td PORT="source_reference_id">source_reference_id</td></tr>
<tr><td PORT="geographicarea_id">geographicarea_id</td></tr>
<tr><td PORT="other_scope_id">other_scope_id</td></tr>
//CONSTRAINT [PK_DescriptionScope] PRIMARY KEY ([id])
</table>>
];
Descriptor [
URL="[[DescriptionsModel_v3.00.10#Table:_Descriptor]]"
tooltip="Descriptor (= characters, features) define variables"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#e5c96a">Descriptor</td></tr>
<tr><td PORT="id">id</td></tr>
<tr><td PORT="label">label</td></tr>
<tr><td PORT="abbreviation">abbreviation</td></tr>
<tr><td PORT="detail">detail</td></tr>
<tr><td PORT="display_order">display_order</td></tr>
<tr><td PORT="subclass">subclass</td></tr>
<tr><td PORT="statistical_measurement_scale">statistical_measurement_scale</td></tr>
<tr><td PORT="usually_exclusive">usually_exclusive</td></tr>
<tr><td PORT="state_collection_model">state_collection_model</td></tr>
<tr><td PORT="mandatory">mandatory</td></tr>
<tr><td PORT="repeatability">repeatability</td></tr>
<tr><td PORT="availability">availability</td></tr>
<tr><td PORT="measurement_unit">measurement_unit</td></tr>
<tr><td PORT="measurement_unit_precedes_value">measurement_unit_precedes_value</td></tr>
<tr><td PORT="min_plausible_value">min_plausible_value</td></tr>
<tr><td PORT="max_plausible_value">max_plausible_value</td></tr>
<tr><td PORT="wording_before">wording_before</td></tr>
<tr><td PORT="wording_after">wording_after</td></tr>
<tr><td PORT="data_entry_note">data_entry_note</td></tr>
//CONSTRAINT [PK_Descriptor] PRIMARY KEY ([id])
</table>>
];
DescriptorInapplicability [
URL="[[DescriptionsModel_v3.00.10#Table:_DescriptorInapplicability]]"
tooltip="The descriptor dependency rules"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#e5c96a" colspan="2">DescriptorInapplicability</td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="controlled_descriptor_id">controlled_descriptor_id</td><td>ut_1</td></tr>
<tr><td PORT="controlling_state_id">controlling_state_id</td><td>ut_1</td></tr>
<tr><td PORT="rule">rule</td><td></td></tr>
//CONSTRAINT [PK_DescriptorInapplicability] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_DescriptorInapplicability_1] UNIQUE ([controlled_descriptor_id],[controlling_state_id])
</table>>
];
DescriptorMapping_C2C [
URL="[[DescriptionsModel_v3.00.10#Table:_DescriptorMapping_C2C]]"
tooltip="Mapping of a categorical state to another categorical state"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#e5c96a" colspan="1">DescriptorMapping_C2C</td></tr>
<tr><td PORT="id">id</td></tr>
<tr><td PORT="from_state_id">from_state_id</td></tr>
<tr><td PORT="to_state_id">to_state_id</td></tr>
//CONSTRAINT [PK_DescriptorMapping_C2C] PRIMARY KEY ([id])
</table>>
];
DescriptorMapping_Q2C [
URL="[[DescriptionsModel_v3.00.10#Table:_DescriptorMapping_Q2C]]" fontcolor="gray"
tooltip="Mapping of a quantitative descriptor to a categorical state"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COLOR="gray">
<tr><td BGCOLOR="#e5c96a" colspan="1"><font color="black">DescriptorMapping_Q2C</font></td></tr>
<tr><td PORT="id">id</td></tr>
<tr><td PORT="from_descr_id">from_descr_id</td></tr>
<tr><td PORT="from_lowerbound">from_lowerbound</td></tr>
<tr><td PORT="from_upperbound">from_upperbound</td></tr>
<tr><td PORT="from_statistical_measure_id">from_statistical_measure_id</td></tr>
<tr><td PORT="from_statmeas_class_TO_CONSIDER">from_statmeas_class_TO_CONSIDER</td></tr>
<tr><td PORT="to_state_id">to_state_id</td></tr>
//CONSTRAINT [PK_DescriptorMapping_Q2C] PRIMARY KEY ([id])
</table>>
];
DescriptorStatusData [
URL="[[DescriptionsModel_v3.00.10#Table:_DescriptorStatusData]]"
tooltip="The status data of a descriptor for a certain description"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#00c900" colspan="2">DescriptorStatusData</td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="description_id">description_id</td><td>ut_1</td></tr>
<tr><td PORT="descriptor_id">descriptor_id</td><td>ut_1</td></tr>
<tr><td PORT="datastatus_id">datastatus_id</td><td>ut_1</td></tr>
<tr><td PORT="notes">notes</td><td></td></tr>
//CONSTRAINT [PK_DescriptorStatusData] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_DescriptorStatusData_1] UNIQUE ([description_id],[descriptor_id],[datastatus_id])
</table>>
];
DescriptorTree [
URL="[[DescriptionsModel_v3.00.10#Table:_DescriptorTree]]"
tooltip="The root and definition of a descriptor tree"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#ef6a6a" colspan="2">DescriptorTree</td></tr>
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
<tr><td PORT="is_complete">is_complete</td><td></td></tr>
<tr><td PORT="label">label</td><td>u</td></tr>
<tr><td PORT="type">type</td><td></td></tr>
<tr><td PORT="project_id">project_id</td><td PORT="project_id_e"></td></tr>
//CONSTRAINT [PK_DescriptorTree] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_DescriptorTree_1] UNIQUE ([label])
</table>>
];
DescriptorTreeNode [
URL="[[DescriptionsModel_v3.00.10#Table:_DescriptorTreeNode]]"
tooltip="The descriptor tree nodes representing either nodes of the tree or descriptors ("leafes" of the tree)"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#ef6a6a" colspan="2">DescriptorTreeNode</td></tr>
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
<tr><td PORT="parent_node_id">parent_node_id</td><td PORT="parent_node_id_e">ut_1</td></tr>
<tr><td PORT="label">label</td><td PORT="label_e">ut_1</td></tr>
<tr><td PORT="abbreviation">abbreviation</td><td PORT="abbreviation_e"></td></tr>
<tr><td PORT="display_order">display_order</td><td PORT="display_order_e"></td></tr>
<tr><td PORT="descriptortree_id">descriptortree_id</td><td PORT="descriptortree_id_e">ut_1</td></tr>
<tr><td PORT="descriptor_id">descriptor_id</td><td PORT="descriptor_id_e">ut_1</td></tr>
//CONSTRAINT [PK_DescriptorTreeNode] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_DescriptorTreeNode_1] UNIQUE ([descriptortree_id],[parent_node_id],[descriptor_id],[label])
</table>>
];
DescriptorTreeNodeRecFrequency [
URL="[[DescriptionsModel_v3.00.10#Table:_DescriptorTreeNodeRecFrequency]]"
tooltip="Selection of recommended frequency values for descriptor tree parts or single descriptors"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#ef6a6a" colspan="2">DescriptorTreeNodeRecFrequency</td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="node_id">node_id</td><td>ut_1</td></tr>
<tr><td PORT="frequency_id">frequency_id</td><td>ut_1</td></tr>
//CONSTRAINT [PK_DescriptorTreeNodeRecFrequency] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_DescriptorTreeNodeRecFrequency_1] UNIQUE ([node_id],[frequency_id])
</table>>
];
DescriptorTreeNodeRecModifier [
URL="[[DescriptionsModel_v3.00.10#Table:_DescriptorTreeNodeRecModifier]]"
tooltip="Selection of recommended modifier values for descriptor tree parts or single descriptors"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#ef6a6a" colspan="2">DescriptorTreeNodeRecModifier</td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="node_id">node_id</td><td>ut_1</td></tr>
<tr><td PORT="modifier_id">modifier_id</td><td>ut_1</td></tr>
//CONSTRAINT [PK_DescriptorTreeNodeRecModifier] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_DescriptorTreeNodeRecModifier_1] UNIQUE ([node_id],[modifier_id])
</table>>
];
DescriptorTreeNodeRecStatMeasure [
URL="[[DescriptionsModel_v3.00.10#Table:_DescriptorTreeNodeRecStatMeasure]]"
tooltip="Selection of recommended statistical measures for descriptor tree parts or single descriptors"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#ef6a6a" colspan="2">DescriptorTreeNodeRecStatMeasure</td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="node_id">node_id</td><td>ut_1</td></tr>
<tr><td PORT="measure_id">measure_id</td><td>ut_1</td></tr>
//CONSTRAINT [PK_DescriptorTreeNodeRecStatMeasure] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_DescriptorTreeNodeRecStatMeasure_1] UNIQUE ([node_id],[measure_id])
</table>>
];
Frequency [
URL="[[DescriptionsModel_v3.00.10#Table:_Frequency]]"
tooltip="Definition of frequency modifier values"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#e5c96a" colspan="2">Frequency</td></tr>
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
<tr><td PORT="label">label</td><td PORT="label_e">u</td></tr>
<tr><td PORT="lower_estimate">lower_estimate</td><td PORT="lower_estimate_e"></td></tr>
<tr><td PORT="upper_estimate">upper_estimate</td><td PORT="upper_estimate_e"></td></tr>
<tr><td PORT="display_order">display_order</td><td PORT="display_order_e"></td></tr>
//CONSTRAINT [PK_Frequency] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_Frequency_1] UNIQUE ([label])
</table>>
];
GeographicAreaProxy [
URL="[[DescriptionsModel_v3.00.10#Table:_GeographicAreaProxy]]"
tooltip="Geographic Area, proxy for WB component"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="lightblue" colspan="2">GeographicAreaProxy</td></tr>
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
<tr><td PORT="label">label</td><td PORT="label_e">u</td></tr>
//CONSTRAINT [PK_GeographicAreaProxy] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_GeographicAreaProxy_1] UNIQUE ([label])
</table>>
];
GeographicArea_Taxon [
URL="[[DescriptionsModel_v3.00.10#Table:_GeographicArea_Taxon]]"
tooltip="Presence (or likely presence) of taxon in a given geographic area"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="lightblue" colspan="2">GeographicArea_Taxon</td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="geographicarea_id">geographicarea_id</td><td>ut_1</td></tr>
<tr><td PORT="taxon_id">taxon_id</td><td>ut_1</td></tr>
//CONSTRAINT [PK_GeographicArea_Taxon] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_GeographicArea_Taxon_1] UNIQUE ([geographicarea_id],[taxon_id])
</table>>
];
Identifier [
URL="[[DescriptionsModel_v3.00.10#Table:_Identifier]]"
tooltip="Objects may have multiple external identifiers"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="lightblue" colspan="1">Identifier</td></tr>
<tr><td PORT="object_id">object_id</td></tr>
<tr><td PORT="uri">uri</td></tr>
<tr><td PORT="match">match</td></tr>
//CONSTRAINT [PK_Identifier] PRIMARY KEY ([uri])
</table>>
];
Modifier [
URL="[[DescriptionsModel_v3.00.10#Table:_Modifier]]"
tooltip="Definition of modifier values"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#e5c96a" colspan="2">Modifier</td></tr>
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
<tr><td PORT="class">class</td><td></td></tr>
<tr><td PORT="label">label</td><td>u</td></tr>
<tr><td PORT="display_order">display_order</td><td></td></tr>
//CONSTRAINT [PK_Modifier] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_Modifier_1] UNIQUE ([label])
</table>>
];
ObservationProxy [
URL="[[DescriptionsModel_v3.00.10#Table:_ObservationProxy]]"
tooltip="Observation; proxy for WB component"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="lightblue" colspan="2">ObservationProxy</td></tr>
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
<tr><td PORT="label">label</td><td PORT="label_e">u</td></tr>
//CONSTRAINT [PK_ObservationProxy] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_ObservationProxy_1] UNIQUE ([label])
</table>>
];
OrganismRelationData [
URL="[[DescriptionsModel_v3.00.10#Table:_OrganismRelationData]]"
tooltip="Categorical data (states recorded for a description)"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#00c900" colspan="2">OrganismRelationData</td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="description_id">description_id</td><td>ut_1</td></tr>
<tr><td PORT="taxon_id">taxon_id</td><td>ut_1</td></tr>
<tr><td PORT="notes">notes</td><td></td></tr>
<tr><td PORT="modifier_id">modifier_id</td><td>ut_1</td></tr>
<tr><td PORT="frequency_id">frequency_id</td><td>ut_1</td></tr>
//CONSTRAINT [PK_OrganismRelationData] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_OrganismRelationData_1] UNIQUE ([description_id],[taxon_id],[modifier_id],[frequency_id])
</table>>
];
OtherScope [
URL="[[DescriptionsModel_v3.00.10#Table:_OtherScope]]"
tooltip="Scope values for description scope values for scope types 'Other scope', 'Part', 'Stage' and 'Sex' "
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#e5c96a" colspan="2">OtherScope</td></tr>
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
<tr><td PORT="label">label</td><td PORT="label_e">u</td></tr>
<tr><td PORT="detail">detail</td><td PORT="detail_e"></td></tr>
<tr><td PORT="type">type</td><td PORT="type_e"></td></tr>
<tr><td PORT="sex_status_id">sex_status_id</td><td PORT="sex_status_id_e"></td></tr>
//CONSTRAINT [PK_OtherScope] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_OtherScope_1] UNIQUE ([label])
</table>>
];
Project [
URL="[[DescriptionsModel_v3.00.10#Table:_Project]]"
tooltip="Projects define separated workareas in a single database"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#ef6a6a" colspan="2">Project</td></tr>
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
<tr><td PORT="parent_project_id">parent_project_id</td><td PORT="parent_project_id_e"></td></tr>
<tr><td PORT="label">label</td><td PORT="label_e">u</td></tr>
<tr><td PORT="rights_text">rights_text</td><td PORT="rights_text_e"></td></tr>
<tr><td PORT="licence_uri">licence_uri</td><td PORT="licence_uri_e"></td></tr>
<tr><td PORT="detail">detail</td><td PORT="detail_e"></td></tr>
<tr><td PORT="restricted_to_descriptortree_id">restricted_to_descriptortree_id</td><td PORT="restricted_to_descriptortree_id_e"></td></tr>
<tr><td PORT="restricted_to_taxonset_id">restricted_to_taxonset_id</td><td PORT="restricted_to_taxonset_id_e"></td></tr>
<tr><td PORT="primary_language_code">primary_language_code</td><td PORT="primary_language_code_e"></td></tr>
<tr><td PORT="ProjectProxyID">ProjectProxyID</td><td PORT="ProjectProxyID_e"></td></tr>
//CONSTRAINT [PK_Project] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_Project_1] UNIQUE ([label])
</table>>
];
Project_AvailableScope [
URL="[[DescriptionsModel_v3.00.10#Table:_Project_AvailableScope]]"
tooltip="Scope values available for a certain project"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#ef6a6a" colspan="2">Project_AvailableScope</td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="project_id">project_id</td><td>ut_1</td></tr>
<tr><td PORT="scope_id">scope_id</td><td>ut_1</td></tr>
//CONSTRAINT [PK_Project_AvailableScope] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_Project_AvailableScope_1] UNIQUE ([project_id],[scope_id])
</table>>
];
QuantitativeSamplingData [
URL="[[DescriptionsModel_v3.00.10#Table:_QuantitativeSamplingData]]"
tooltip="The quantitative data recorded for a sampling event"
fontcolor="gray"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COLOR="gray">
<tr><td BGCOLOR="#cee12c" colspan="1"><font color="black">QuantitativeSamplingData</font></td></tr>
<tr><td PORT="id">id</td></tr>
<tr><td PORT="measure_id">measure_id</td></tr>
<tr><td PORT="sampling_unit_id">sampling_unit_id</td></tr>
<tr><td PORT="descriptor_id">descriptor_id</td></tr>
<tr><td PORT="value">value</td></tr>
<tr><td PORT="notes">notes</td></tr>
<tr><td PORT="modifier_id">modifier_id</td></tr>
//CONSTRAINT [PK_QuantitativeSamplingData] PRIMARY KEY ([id])
</table>>
];
QuantitativeSummaryData [
URL="[[DescriptionsModel_v3.00.10#Table:_QuantitativeSummaryData]]"
tooltip="The quantitative data recorded for a sampling event" fontcolor="gray"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COLOR="gray">
<tr><td BGCOLOR="#00c900" colspan="2"><font color="black">QuantitativeSummaryData</font></td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="measure_id">measure_id</td><td>ut_1</td></tr>
<tr><td PORT="description_id">description_id</td><td>ut_1</td></tr>
<tr><td PORT="descriptor_id">descriptor_id</td><td>ut_1</td></tr>
<tr><td PORT="value">value</td><td></td></tr>
<tr><td PORT="notes">notes</td><td></td></tr>
<tr><td PORT="modifier_id">modifier_id</td><td></td></tr>
//CONSTRAINT [PK_QuantitativeSummaryData] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_QuantitativeSummaryData_1] UNIQUE ([description_id],[measure_id],[descriptor_id])
</table>>
];
ReferenceProxy [
URL="[[DescriptionsModel_v3.00.10#Table:_ReferenceProxy]]"
tooltip="Reference (literature/source); proxy for WB component"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="lightblue" colspan="2">ReferenceProxy</td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="label">label</td><td>u</td></tr>
//CONSTRAINT [PK_ReferenceProxy] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_ReferenceProxy_1] UNIQUE ([label])
</table>>
];
Resource [
URL="[[DescriptionsModel_v3.00.10#Table:_Resource]]"
tooltip="Hyperlinks to separate rich text/media objects"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="blue" colspan="1"><font COLOR="white">Resource</font></td></tr>
<tr><td PORT="id">id</td></tr>
<tr><td PORT="terminology_role">terminology_role</td></tr>
<tr><td PORT="ranking_for_terminology">ranking_for_terminology</td></tr>
<tr><td PORT="descriptor_id">descriptor_id</td></tr>
<tr><td PORT="state_id">state_id</td></tr>
<tr><td PORT="taxon_role">taxon_role</td></tr>
<tr><td PORT="ranking_for_taxon_use">ranking_for_taxon_use</td></tr>
<tr><td PORT="taxon_id">taxon_id</td></tr>
<tr><td PORT="description_id">description_id</td></tr>
<tr><td PORT="scope_id">scope_id</td></tr>
<tr><td PORT="display_embedded">display_embedded</td></tr>
<tr><td PORT="label">label</td></tr>
<tr><td PORT="language_code">language_code</td></tr>
<tr><td PORT="display_order">display_order</td></tr>
//CONSTRAINT [PK_Resource] PRIMARY KEY ([id])
</table>>
];
ResourceVariant [
URL="[[DescriptionsModel_v3.00.10#Table:_ResourceVariant]]"
tooltip="Different resource variants/instances/service access points"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="blue" colspan="2"><font COLOR="white">ResourceVariant</font></td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="resource_id">resource_id</td><td>ut_1</td></tr>
<tr><td PORT="variant_id">variant_id</td><td>ut_1</td></tr>
<tr><td PORT="url">url</td><td></td></tr>
<tr><td PORT="pixel_width">pixel_width</td><td></td></tr>
<tr><td PORT="pixel_height">pixel_height</td><td></td></tr>
<tr><td PORT="duration">duration</td><td></td></tr>
<tr><td PORT="size">size</td><td></td></tr>
<tr><td PORT="mime_type">mime_type</td><td></td></tr>
//CONSTRAINT [PK_ResourceVariant] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_ResourceVariant_1] UNIQUE ([resource_id],[variant_id])
</table>>
];
ResourceVariant_Enum [
URL="[[DescriptionsModel_v3.00.10#Table:_ResourceVariantEnum]]"
tooltip="Classes for resource variants, values are predefined in the database"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="blue" colspan="2"><font COLOR="white">ResourceVariant_Enum</font></td></tr>
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
<tr><td PORT="label">label</td><td PORT="label_e">u</td></tr>
<tr><td PORT="code">code</td><td PORT="code_e">u</td></tr>
<tr><td PORT="detail">detail</td><td PORT="detail_e"></td></tr>
<tr><td PORT="quality_order">quality_order</td><td PORT="quality_order_e"></td></tr>
//CONSTRAINT [PK_ResourceVariant_Enum] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_ResourceVariant_Enum_1] UNIQUE ([label]),
//CONSTRAINT [UQ_ResourceVariant_Enum_2] UNIQUE ([code])
</table>>
];
ResourceWatchedTime [
URL="[[#Table:_ResourceWatchedTime]]"
tooltip="The time a resource thumb was watched (=mouse hover)"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="blue" colspan="1"><font COLOR="white">ResourceWatchedTime</font></td></tr>
<tr><td PORT="id">id</td></tr>
<tr><td PORT="resource_id">resource_id</td></tr>
<tr><td PORT="contributor_id">contributor_id</td></tr>
<tr><td PORT="watched_time">watched_time</td></tr>
</table>>
];
SamplingEvent [
URL="[[DescriptionsModel_v3.00.10#Table:_SamplingEvent]]"
tooltip="A sampling event may contain many sampling units" fontcolor="gray"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COLOR="gray">
<tr><td BGCOLOR="#cee12c" colspan="1"><font color="black">SamplingEvent</font></td></tr>
<tr><td PORT="id">id</td></tr>
<tr><td PORT="description_id">description_id</td></tr>
<tr><td PORT="label">label</td></tr>
<tr><td PORT="detail">detail</td></tr>
<tr><td PORT="date_time">date_time</td></tr>
<tr><td PORT="datetimespan_end">datetimespan_end</td></tr>
<tr><td PORT="geographic_area">geographic_area</td></tr>
<tr><td PORT="coord_dec_latitude">coord_dec_latitude</td></tr>
<tr><td PORT="coord_dec_longitude">coord_dec_longitude</td></tr>
<tr><td PORT="coord_literal">coord_literal</td></tr>
<tr><td PORT="coord_geodeticdatum">coord_geodeticdatum</td></tr>
//CONSTRAINT [PK_SamplingEvent] PRIMARY KEY ([id])
</table>>
];
SamplingUnit [
URL="[[DescriptionsModel_v3.00.10#Table:_SamplingUnit]]"
tooltip="Categorical data" fontcolor="gray"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COlOR="gray">
<tr><td BGCOLOR="#cee12c" colspan="1"><font color="black">SamplingUnit</font></td></tr>
<tr><td PORT="id">id</td></tr>
<tr><td PORT="sampling_event_id">sampling_event_id</td></tr>
//CONSTRAINT [PK_SamplingUnit] PRIMARY KEY ([id])
</table>>
];
SexStatus_Enum [
URL="[[DescriptionsModel_v3.00.10#Table:_SexStatus_Enum]]"
tooltip="Values of sex status predefined according to SDD 1.1 rev 5"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#e5c96a" colspan="2">SexStatus_Enum</td></tr>
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
<tr><td PORT="label">label</td><td PORT="label_e">u</td></tr>
<tr><td PORT="code">code</td><td PORT="code_e">u</td></tr>
<tr><td PORT="abbreviation">abbreviation</td><td PORT="abbreviation_e"></td></tr>
<tr><td PORT="detail">detail</td><td PORT="detail_e"></td></tr>
<tr><td PORT="display_order">display_order</td><td PORT="display_order_e"></td></tr>
//CONSTRAINT [PK_SexStatus_Enum] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_SexStatus_Enum_1] UNIQUE ([label]),
//CONSTRAINT [UQ_SexStatus_Enum_2] UNIQUE ([code])
</table>>
];
SpecimenProxy [
URL="[[DescriptionsModel_v3.00.10#Table:_SpecimenProxy]]"
tooltip="Specimens from collections; proxy for WB component" fontcolor="gray"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COLOR="gray">
<tr><td BGCOLOR="lightblue" colspan="1"><font color="black">SpecimenProxy</font></td></tr>
<tr><td PORT="id">id</td></tr>
<tr><td PORT="label">label</td>u</tr>
//CONSTRAINT [PK_SpecimenProxy] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_SpecimenProxy_1] UNIQUE ([label])
</table>>
];
StatisticalMeasure_Enum [
URL="[[DescriptionsModel_v3.00.10#Table:_StatisticalMeasure_Enum]]" fontcolor="gray"
tooltip="The statistical measures predefined according SDD 1.1 rev 5"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COLOR="gray">
<tr><td BGCOLOR="#e5c96a" colspan="2"><font color="black">StatisticalMeasure_Enum</font></td></tr>
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
<tr><td PORT="label">label</td><td>u</td></tr>
<tr><td PORT="code">code</td><td>u</td></tr>
<tr><td PORT="abbreviation">abbreviation</td><td></td></tr>
<tr><td PORT="display_order">display_order</td><td></td></tr>
//CONSTRAINT [PK_StatisticalMeasure_Enum] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_StatisticalMeasure_Enum_1] UNIQUE ([label]),
//CONSTRAINT [UQ_StatisticalMeasure_Enum_2] UNIQUE ([code])
</table>>
];
Tag [
URL="[[DescriptionsModel_v3.00.10#Table:_Tag]]"
tooltip="Objects may have multiple tags (= keywords)"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="lightblue" colspan="2">Tag</td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="tag">tag</td><td>ut_1</td></tr>
<tr><td PORT="object_id">object_id</td><td>ut_1</td></tr>
//CONSTRAINT [PK_Tag] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_Tag_1] UNIQUE ([tag],[object_id])
</table>>
];
TaxonProxy [
URL="[[DescriptionsModel_v3.00.10#Table:_TaxonProxy]]"
tooltip="Taxon/tax. hierarchy (simplified); proxy for WB component"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="lightblue" colspan="2">TaxonProxy</td></tr>
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
<tr><td PORT="label">label</td><td>u</td></tr>
<tr><td PORT="name">name</td><td>ut_1</td></tr>
<tr><td PORT="common_name">common_name</td><td></td></tr>
<tr><td PORT="rank_id">rank_id</td><td></td></tr>
<tr><td PORT="genus">genus</td><td></td></tr>
<tr><td PORT="infrageneric_epithet">infrageneric_epithet</td><td></td></tr>
<tr><td PORT="specific_epithet">specific_epithet</td><td></td></tr>
<tr><td PORT="infraspecific_rankstring">infraspecific_rankstring</td><td></td></tr>
<tr><td PORT="infraspecific_epithet">infraspecific_epithet</td><td></td></tr>
<tr><td PORT="cultivar_name_or_group">cultivar_name_or_group</td><td></td></tr>
<tr><td PORT="full_authorship_citation">full_authorship_citation</td><td></td></tr>
<tr><td PORT="base_citation">base_citation</td><td></td></tr>
<tr><td PORT="base_citation_bracketed">base_citation_bracketed</td><td></td></tr>
<tr><td PORT="combination_citation">combination_citation</td><td></td></tr>
<tr><td PORT="kingdom">kingdom</td><td>ut_1</td></tr>
<tr><td PORT="phylum_or_division">phylum_or_division</td><td></td></tr>
<tr><td PORT="class">class</td><td></td></tr>
<tr><td PORT="subclass">subclass</td><td></td></tr>
<tr><td PORT="order">order</td><td></td></tr>
<tr><td PORT="suborder">suborder</td><td></td></tr>
<tr><td PORT="family">family</td><td></td></tr>
<tr><td PORT="subfamily">subfamily</td><td></td></tr>
<tr><td PORT="project_id">project_id</td><td>ut_1</td></tr>
//CONSTRAINT [PK_TaxonProxy] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_TaxonProxy_1] UNIQUE ([label]),
//CONSTRAINT [UQ_TaxonProxy_2] UNIQUE ([name],[kingdom],[project_id])
</table>>
];
TaxonRank_Enum [
URL="[[DescriptionsModel_v3.00.10#Table:_TaxonRank_Enum]]"
tooltip="Ranks for taxa (species, genus, family, order, class, etc.)"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="lightblue" colspan="2">TaxonRank_Enum</td></tr>
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
<tr><td PORT="label">label</td><td PORT="label_e">u</td></tr>
<tr><td PORT="code">code</td><td PORT="code_e">u</td></tr>
<tr><td PORT="abbreviation">abbreviation</td><td PORT="abbreviation_e"></td></tr>
<tr><td PORT="detail">detail</td><td PORT="detail_e"></td></tr>
//CONSTRAINT [PK_TaxonRank_Enum] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_TaxonRank_Enum_1] UNIQUE ([label]),
//CONSTRAINT [UQ_TaxonRank_Enum_2] UNIQUE ([code])
</table>>
];
TaxonSet [
URL="[[DescriptionsModel_v3.00.10#Table:_TaxonSet]]"
tooltip="Groups (or sets) of taxa; including non-phylogenetic groups "
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="lightblue" colspan="2">TaxonSet</td></tr>
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
<tr><td PORT="label">label</td><td PORT="label_e">u</td></tr>
<tr><td PORT="default_set">default_set</td><td PORT="default_set_e"></td></tr>
<tr><td PORT="project_id">project_id</td><td PORT="project_id_e"></td></tr>
//CONSTRAINT [PK_TaxonSet] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_TaxonSet_1] UNIQUE ([label])
</table>>
];
TaxonSet_Taxon [
URL="[[DescriptionsModel_v3.00.10#Table:_TaxonSet_Taxon]]"
tooltip="Membership of taxa in a taxon set (n:m relation)"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="lightblue" colspan="2">TaxonSet_Taxon</td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="taxonset_id">taxonset_id</td><td>ut_1</td></tr>
<tr><td PORT="taxon_id">taxon_id</td><td>ut_1</td></tr>
//CONSTRAINT [PK_TaxonSet_Taxon] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_TaxonSet_Taxon_1] UNIQUE ([taxonset_id],[taxon_id])
</table>>
];
TextDescriptorData [
URL="[[DescriptionsModel_v3.00.10#Table:_TextDescriptorData]]"
tooltip="The text data of a description"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#00c900" colspan="2">TextDescriptorData</td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="description_id">description_id</td><td>ut_1</td></tr>
<tr><td PORT="descriptor_id">descriptor_id</td><td>ut_1</td></tr>
<tr><td PORT="content">content</td><td></td></tr>
<tr><td PORT="notes">notes</td><td></td></tr>
//CONSTRAINT [PK_TextDescriptorData] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_TextDescriptorData_1] UNIQUE ([description_id],[descriptor_id])
</table>>
];
TextSamplingData [
URL="[[DescriptionsModel_v3.00.10#Table:_TextSamplingData]]"
tooltip="Free-form text data recorded for a sampling event" fontcolor="gray"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" COLOR="gray">
<tr><td BGCOLOR="#cee12c" colspan="2"><font color="black">TextSamplingData</font></td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="sampling_unit_id">sampling_unit_id</td><td>ut_1</td></tr>
<tr><td PORT="descriptor_id">descriptor_id</td><td>ut_1</td></tr>
<tr><td PORT="content">content</td><td></td></tr>
<tr><td PORT="notes">notes</td><td></td></tr>
//CONSTRAINT [PK_TextSamplingData] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_TextSamplingData_1] UNIQUE ([sampling_unit_id],[descriptor_id])
</table>>
];
TODO_MultilingualCharDataNotes [
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="lightblue" colspan="1">TODO_MultilingualCharDataNotes</td></tr>
<tr><td PORT="table_is_just_a_note_-_Work_needs_to_be_done">table_is_just_a_note_-_Work_needs_to_be_done</td></tr>
<tr><td PORT="memo_char_and_taxon_notes_is_already_redundant_due_to_annotation">memo_char_and_taxon_notes_is_already_redundant_due_to_annotation</td></tr>
<tr><td PORT="memo_char_data_are_not_an_object_thus_not_annotated">memo_char_data_are_not_an_object_thus_not_annotated</td></tr>
//CONSTRAINT [PK_TODO_MultilingualCharDataNotes] PRIMARY KEY ([table_is_just_a_note_-_Work_needs_to_be_done])
</table>>
];
Translation [
URL="[[DescriptionsModel_v3.00.10#Table:_Translation]]"
tooltip="The translations of entries related to BaseEntity"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="lightblue" colspan="2">Translation</td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="object_id">object_id</td><td>ut_1</td></tr>
<tr><td PORT="language_code">language_code</td><td>ut_1</td></tr>
<tr><td PORT="column_id">column_id</td><td>ut_1</td></tr>
<tr><td PORT="contents">contents</td><td></td></tr>
//CONSTRAINT [PK_Translation] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_Translation_1] UNIQUE ([object_id],[language_code],[column_id])
</table>>
];
TranslationColumn_Enum [
URL="[[DescriptionsModel_v3.00.10#Table:_TranslationColumn_Enum]]"
tooltip="The TranslationColumn_Enum contains the column names that are translated in the Translation table"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="lightblue" colspan="2">TranslationColumn_Enum</td></tr>
<tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
<tr><td PORT="column">column</td><td PORT="column_e">u</td></tr>
//CONSTRAINT [PK_TranslationColumn_Enum] PRIMARY KEY ([id]),
//CONSTRAINT [UQ_TranslationColumn_Enum_1] UNIQUE ([column])
</table>>
];
ProjectProxy [
URL="[[DescriptionsModel_v3.00.10#Table:_ProjectProxy]]"
tooltip="The projects as stored in the module DiversityProjects"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#ef6a6a" colspan="1">ProjectProxy</td></tr>
<tr><td PORT="ProjectID">ProjectID</td></tr>
<tr><td PORT="Project">Project</td></tr>
<tr><td PORT="ProjectURI">ProjectURI</td></tr>
//CONSTRAINT [PK_DiversityProjectProxy] PRIMARY KEY CLUSTERED ([ProjectID] ASC) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
</table>>
];
UserProxy [
URL="[[DescriptionsModel_v3.00.10#Table:_UserProxy]]"
tooltip="The user as stored in the module DiversityAgents"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#ef6a6a" colspan="1">UserProxy</td></tr>
<tr><td PORT="LoginName">LoginName</td></tr>
<tr><td PORT="CombinedNameCache">CombinedNameCache</td></tr>
<tr><td PORT="AgentURI">AgentURI</td></tr>
<tr><td PORT="Queries">Queries</td></tr>
//CONSTRAINT [PK_UserProxy] PRIMARY KEY CLUSTERED ([LoginName] ASC) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
</table>>
];
ProjectUser [
URL="[[DescriptionsModel_v3.00.10#Table:_ProjectUser]]"
tooltip="The projects that a user can access"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#ef6a6a" colspan="1">ProjectUser</td></tr>
<tr><td PORT="LoginName">LoginName</td></tr>
<tr><td PORT="ProjectID">ProjectID</td></tr>
<tr><td PORT="ReadOnly">ReadOnly</td></tr>
//CONSTRAINT [PK_ProjectUser] PRIMARY KEY CLUSTERED ([LoginName] ASC, [ProjectID])WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY]
</table>>
];
TaxonQuiz [
URL="[[#Table:_TaxonQuiz]]"
tooltip="User’s correctly answered taxa"
label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
<tr><td BGCOLOR="#ef6a6a" colspan="2">TaxonQuiz</td></tr>
<tr><td PORT="id">id</td><td></td></tr>
<tr><td PORT="project_id">project_id</td><td>ut_1</td></tr>
<tr><td PORT="taxon_id">taxon_id</td><td>ut_1</td></tr>
<tr><td PORT="contributor_id">contributor_id</td><td>ut_1</td></tr>
<tr><td PORT="scope_id">scope_id</td><td>ut_1</td></tr>
<tr><td PORT="points">points</td><td></td></tr>
<tr><td PORT="success">success</td><td></td></tr>
</table>>
];
BaseEntity:id:e -> Annotation:object_id:w[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> CategoricalState:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> Contribution:object_id:w[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> DataStatus_Enum:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> Description:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> Descriptor:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> DescriptorTree:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> DescriptorTreeNode:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> Frequency:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> GeographicAreaProxy:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> Identifier:object_id:w[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> Modifier:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> ObservationProxy:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> OtherScope:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> Project:id:w[color="#0069ba" fontcolor="#0069ba" headlabel="1" arrowhead="none"];
BaseEntity:id:e -> ReferenceProxy:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> Resource:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> ResourceVariant_Enum:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> SexStatus_Enum:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> SpecimenProxy:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> StatisticalMeasure_Enum:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> Tag:object_id:w[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> TaxonProxy:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> TaxonRank_Enum:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> TaxonSet:id:w[color="#0069ba" fontcolor="#0069ba"];
BaseEntity:id:e -> Translation:object_id:w[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
BaseEntityTable_Enum:id -> BaseEntity:table_id;
CategoricalState:id_e:e -> CategoricalSamplingData:state_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
CategoricalState:id_e:e -> CategoricalSummaryData:state_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
CategoricalState:id_e:e -> DescriptorInapplicability:controlling_state_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
CategoricalState:id_e:e -> DescriptorMapping_C2C:from_state_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
CategoricalState:id_e:e -> DescriptorMapping_C2C:to_state_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817" style="dashed"];
CategoricalState:id_e:e -> DescriptorMapping_Q2C:to_state_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
CategoricalState:id_e:e -> Resource:state_id:w[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
Contributor:id_e:e -> Annotation:contributor_id;
Contributor:id_e:e -> Contribution:contributor_id;
DataStatus_Enum:id -> DescriptorStatusData:datastatus_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
Description:id:e -> CategoricalSummaryData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
Description:id:e -> DescriptionScope:description_id:w[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
Description:id:e -> DescriptorStatusData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
Description:id:e -> OrganismRelationData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
Description:id:e -> QuantitativeSummaryData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
Description:id:e -> Resource:description_id:w[label="DELETE SET NULL" fontsize=10 color="#00c900" fontcolor="#00c900"];
Description:id:e -> SamplingEvent:description_id:w[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
Description:id:e -> TextDescriptorData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
Descriptor:id:e -> CategoricalState:descriptor_id:w[color="#AF7817" fontcolor="#AF7817"];
Descriptor:id:e -> DescriptorInapplicability:controlled_descriptor_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
Descriptor:id:e -> DescriptorMapping_Q2C:from_descr_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
Descriptor:id:e -> DescriptorStatusData:descriptor_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
Descriptor:id:e -> DescriptorTreeNode:descriptor_id:w[color="#AF7817" fontcolor="#AF7817"];
Descriptor:id:e -> QuantitativeSamplingData:descriptor_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
Descriptor:id:e -> QuantitativeSummaryData:descriptor_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
Descriptor:id:e -> Resource:descriptor_id:w[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
Descriptor:id:e -> TextDescriptorData:descriptor_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
Descriptor:id:e -> TextSamplingData:descriptor_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
DescriptorTree:id_e:e -> DescriptorTreeNode:descriptortree_id:w[color="#CC0033" fontcolor="#CC0033"];
DescriptorTree:id_e:e -> Project:restricted_to_descriptortree_id[label="DELETE SET NULL" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
DescriptorTreeNode:id_e:e -> DescriptorTreeNodeRecFrequency:node_id[label="DELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
DescriptorTreeNode:id_e:e -> DescriptorTreeNodeRecModifier:node_id[label="DELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
DescriptorTreeNode:id_e:e -> DescriptorTreeNodeRecStatMeasure:node_id[label="DELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
DescriptorTreeNode:id:w -> DescriptorTreeNode:parent_node_id:w[color="#CC0033" fontcolor="#CC0033"];
Frequency:id_e:e -> CategoricalSummaryData:frequency_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
Frequency:id_e:e -> DescriptorTreeNodeRecFrequency:frequency_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
Frequency:id_e:e -> OrganismRelationData:frequency_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
GeographicAreaProxy:id_e:e -> DescriptionScope:geographicarea_id:w[label="DELETE CASCADE" fontsize=10];
GeographicAreaProxy:id_e:e -> GeographicArea_Taxon:geographicarea_id[label="DELETE CASCADE" fontsize=10];
GeographicAreaProxy:id_e:e -> SamplingEvent:geographic_area[label="DELETE CASCADE" fontsize=10 style="dashed"];
Modifier:id_e:e -> CategoricalSamplingData:modifier_id:w[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
Modifier:id_e:e -> CategoricalSummaryData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
Modifier:id_e:e -> DescriptorTreeNodeRecModifier:modifier_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
Modifier:id_e:e -> OrganismRelationData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
Modifier:id_e:e -> QuantitativeSamplingData:modifier_id:w[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
Modifier:id_e:e -> QuantitativeSummaryData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
ObservationProxy:id_e:e -> DescriptionScope:observation_id:w[label="DELETE CASCADE" fontsize=10];
OtherScope:id_e:e -> DescriptionScope:other_scope_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
OtherScope:id_e:e -> Project_AvailableScope:scope_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
OtherScope:id_e:e -> Resource:scope_id:w[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817" style="dashed"];
Project:id_e:e -> Description:project_id[color="#CC0033" fontcolor="#CC0033"];
Project:id:w -> DescriptorTree:project_id_e:w[color="#CC0033" fontcolor="#CC0033"];
Project:id_e:e -> Project_AvailableScope:project_id[label="DELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
Project:id_e:e -> TaxonProxy:project_id[color="#CC0033" fontcolor="#CC0033"];
Project:id_e:e -> TaxonSet:project_id[color="#CC0033" fontcolor="#CC0033"];
Project:id:w -> Project:parent_project_id:w[color="#CC0033" fontcolor="#CC0033"];
ProjectProxy:ProjectID -> Project:ProjectProxyID[label="DELETE SET DEFAULT" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
ProjectProxy:ProjectID -> ProjectUser:ProjectID[label="UPDATE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
ReferenceProxy:id -> DescriptionScope:source_reference_id:w[label="DELETE CASCADE" fontsize=10];
Resource:id -> ResourceVariant:resource_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"];
ResourceVariant_Enum:id_e:e -> ResourceVariant:variant_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"];
SamplingEvent:id:e -> SamplingUnit:sampling_event_id:w[label="DELETE CASCADE" fontsize=10 fontcolor="#cee12c" color="#cee12c"];
SamplingUnit:id -> CategoricalSamplingData:sampling_unit_id:w[label="DELETE CASCADE" fontsize=10 fontcolor="#cee12c" color="#cee12c"];
SamplingUnit:id -> QuantitativeSamplingData:sampling_unit_id:w[label="DELETE CASCADE" fontsize=10 fontcolor="#cee12c" color="#cee12c"];
SamplingUnit:id -> TextSamplingData:sampling_unit_id[label="DELETE CASCADE" fontsize=10 fontcolor="#cee12c" color="#cee12c"];
SexStatus_Enum:id_e:e -> OtherScope:sex_status_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
SpecimenProxy:id -> DescriptionScope:specimen_id:w[label="DELETE CASCADE" fontsize=10];
StatisticalMeasure_Enum:id_e:e -> DescriptorMapping_Q2C:from_statistical_measure_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
StatisticalMeasure_Enum:id_e:e -> DescriptorTreeNodeRecStatMeasure:measure_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
StatisticalMeasure_Enum:id_e:e -> QuantitativeSamplingData:measure_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
StatisticalMeasure_Enum:id_e:e -> QuantitativeSummaryData:measure_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
TaxonProxy:id_e:e -> DescriptionScope:taxon_id:w[label="DELETE CASCADE" fontsize=10];
TaxonProxy:id_e:e -> GeographicArea_Taxon:taxon_id[label="DELETE CASCADE" fontsize=10];
TaxonProxy:id_e:e -> OrganismRelationData:taxon_id[label="DELETE CASCADE" fontsize=10];
TaxonProxy:id_e:e -> Resource:taxon_id:w[label="DELETE SET NULL" fontsize=10];
TaxonProxy:id_e:e -> TaxonSet_Taxon:taxon_id[label="DELETE CASCADE" fontsize=10];
TaxonRank_Enum:id_e:e -> TaxonProxy:rank_id:w;
TaxonSet:id -> Project:restricted_to_taxonset_id_e[label="DELETE SET NULL" fontsize=10];
TaxonSet:id_e:e -> TaxonSet_Taxon:taxonset_id[label="DELETE CASCADE" fontsize=10];
TranslationColumn_Enum:id_e:e -> Translation:column_id;
UserProxy:LoginName -> ProjectUser:LoginName[label="UPDATE CASCADE\nDELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
TaxonProxy:id_e:e -> TaxonQuiz:taxon_id:w
Contributor:id_e:e -> TaxonQuiz:contributor_id:w
OtherScope:id_e:e -> TaxonQuiz:scope_id:w
Project:id_e:e -> TaxonQuiz:project_id:w[color="#CC0033" fontcolor="#CC0033"];
Resource:id -> ResourceWatchedTime:resource_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"]
Contributor:id_e:e -> ResourceWatchedTime:contributor_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"]
}
</graphviz>
Table: Contribution
Multiple contributors may contribute in different roles
| Column | Data type | Description |
|---|---|---|
| id | int | Database-internal ID of this record (primary key) |
| object_id | int | Reference (foreign key) to a BaseEntity |
| contributor_id | int | Reference (foreign key) to a contributor |
| role | nvarchar (255) | one of 'creator', 'contributor', 'editor', 'photographer' |
| timestamp | datetime | Time stamp of the contribution |
Table: Contributor
People contibuting to a work. Roles are recorded in Contribution
| Column | Data type | Description |
|---|---|---|
| id | int | Database-internal ID of this record (primary key) |
| avatar_uri | nvarchar (255) | Optional URI to an image representing the user (default: NULL) |
| nvarchar (255) | User’s email address (default: NULL) | |
| linked_agent_uri | nvarchar (255) | Linking to agents managed in an external component (default: NULL) |
| real_name | nvarchar (255) | Optional name the user gave (full name) (default: NULL) |
| web_pseudonym | nvarchar (255) | Optional alternative name to display publicly on the web (default: NULL) |
Note: in the Quiz all users/contributors are requested to input their full name.
Table: ResourceWatchedTime
The time a resource thumb was watched (=mouse hover)
| Column | Data type | Description |
|---|---|---|
| id | int | Database-internal ID of this record (primary key) |
| resource_id | int | Reference (foreign key) to a resource |
| contributor_id | int | Reference (foreign key) to a contributor |
| watched_time | int | watched time in milliseconds |
Table: TaxonQuiz
User’s correctly answered taxa.
- unique together = ('project_id', 'contributor_id', 'taxon_id', 'scope_id')
| Column | Data type | Description |
|---|---|---|
| id | int | Database-internal ID of this record (primary key) |
| taxon_id | int | Reference (foreign kex) to a taxon that has been answerd correctly |
| project_id | int | Reference (foreign key) to the project |
| contributor_id | int | Reference (foreign key) to a contributor |
| scope_id | int | Reference to a scope (default: 0) |
| points | int | Points through scoring characters, already 3 added if success (default: 0) |
| sucess | tinyint | Was the taxon answered correctly by the user? (default: 0) |
New projects
Schematic important relations for a project:
Project ├ code (used for URL) ├ label (directly used for user display and in text context) ├ TaxonSet (i.e. taxa, media-resources etc.) ├ DescritorTree (i.e. characters and its states, media-resources etc.) ├ … …
Steps to enter data for a new project:
- Create a project (table: Project)
- Project.code is important: it is used as URL part and within the Django application as internal project identifier it should never be changed
- eventually create or associate scopes, like “female”, “male” (table: OtherScope, Project_AvailableScope)
- Eventually create the taxa (table: TaxonProxy)
- associate taxa to the project (tables: TaxonSet, TaxonSet_Taxon)
- associate images of taxa (tables: Resource, ResourceVariant, BaseEntity.specific_rights_text should contain the corresponding picture’s author name like: “© Author Name”). A set of maximum of 16 thumbs will be displayed
- an image is associated correctly, when 1 taxon has 1 Resource, but 2 (or multiple) ResourceVariant(!!)
- resource variants as ReourceVariant_Enum.code "tiny_sample" (=thumb 75×75px) and "best_quality" (max 500×500px displayed) should have corresponding urls in ResourceVariant.url:
Resource
├ ResourceVariant
│ (e.g. with ResourceVariant_Enum.code='best_quality')
└ ResourceVariant
(e.g. with ResourceVariant_Enum.code='tiny_sample')
- eventually associate geographic area (table: GeographicAreaProxy, GeographicArea_Taxon)
- Create character and character states (table Descriptor, CategoricalState), character tree (tables: DescriptorTree, DescriptorTreeNode)
- associate images to characters or character states (tables: Resource, ResourceVariant, BaseEntity.specific_rights_text should contain the corresponding picture’s author name like: “© Author Name”), size of images with maximal height 40px (height should precced)
- Finally make the project publicly available: set the Project‘s tag (table: Tag)
- tag "Artenquiz" means it is a quiz
- tag "Public" means it will be publicly accessible
- tag "Identification" make the project available for identification (URL: …/mobile_bestimmung/, TODO: not yet implemented)
