Difference between revisions of "DiversityDescriptions Quiz (Artenquiz)"

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>