Zum Inhalt springen

Benutzer:Andreas Plank/DiversityDescriptions Quiz: Unterschied zwischen den Versionen

Aus Flora von Bayern
← Zum vorherigen Versionsunterschied
imported>Andreas Plank
K +TaxonQuiz
imported>Andreas Plank
K verlinkt nach http://diversityworkbench.net/Portal/DiversityDescriptions_Quiz_%28Artenquiz%29
 
(10 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 3: Zeile 3:
== Database ==
== Database ==


<graphviz caption='Legend of DiversityDescriptions datebase scheme' alt='Legend of DiversityDescriptions' format='png'>
Siehe [http://diversityworkbench.net/Portal/DiversityDescriptions_Quiz_%28Artenquiz%29 http://diversityworkbench.net/Portal/DiversityDescriptions_Quiz_(Artenquiz)]
digraph DD_Legend {
  graph [rankdir = "LR"];
  node [fontsize = "10", shape = "plaintext"];
  edge [color = "black" arrowhead="dot"]; 
  Legend [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td COLOR="white"><font face="bold">Legend</font></td></tr>
      <tr><td BGCOLOR="#ef6a6a" COLOR="#ef6a6a">Project specific settings</td></tr>
      <tr><td BGCOLOR="#00c900" COLOR="#00c900">Description of items</td></tr>
      <tr><td BGCOLOR="#e5c96a" COLOR="#e5c96a">Descriptor</td></tr>
      <tr><td BGCOLOR="blue" COLOR="blue"><font COLOR="white">Resources</font></td></tr>
      <tr><td>u=unique</td></tr>
      <tr><td>ut_1=unique together</td></tr>
    </table>>
  ];
}
</graphviz>
 
<graphviz caption='Scheme of Diversity Descriptions Quiz' alt='Diversity Descriptions Quiz' format='png'>
 
digraph DD_Quiz_Scheme_20140717{
  graph [rankdir = "LR"];
  node [fontsize = "10", shape = "plaintext"];
  edge [color = "black" arrowhead="dot"]; 
 
  Annotation [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="lightblue" colspan="2">CategoricalSamplingData</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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="#e5c96a" colspan="1">DescriptorMapping_Q2C</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 [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="#e5c96a" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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>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="display_order">display_order</td><td></td></tr>
      <tr><td PORT="descriptortree_id">descriptortree_id</td><td>ut_1</td></tr>
      <tr><td PORT="descriptor_id">descriptor_id</td><td>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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="#e5c96a" colspan="2">Frequency</td></tr>
      <tr><td PORT="id">id</td><td></td></tr>
      <tr><td PORT="label">label</td><td>u</td></tr>
      <tr><td PORT="lower_estimate">lower_estimate</td><td></td></tr>
      <tr><td PORT="upper_estimate">upper_estimate</td><td></td></tr>
      <tr><td PORT="display_order">display_order</td><td></td></tr>
      //CONSTRAINT [PK_Frequency] PRIMARY KEY ([id]),
      //CONSTRAINT [UQ_Frequency_1] UNIQUE ([label])
    </table>>
  ];
  GeographicAreaProxy [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="lightblue" colspan="2">GeographicAreaProxy</td></tr>
      <tr><td PORT="id">id</td><td></td></tr>
      <tr><td PORT="label">label</td><td>u</td></tr>
      //CONSTRAINT [PK_GeographicAreaProxy] PRIMARY KEY ([id]),
      //CONSTRAINT [UQ_GeographicAreaProxy_1] UNIQUE ([label])
    </table>>
  ];
  GeographicArea_Taxon [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="lightblue" colspan="2">ObservationProxy</td></tr>
      <tr><td PORT="id">id</td><td></td></tr>
      <tr><td PORT="label">label</td><td>u</td></tr>
      //CONSTRAINT [PK_ObservationProxy] PRIMARY KEY ([id]),
      //CONSTRAINT [UQ_ObservationProxy_1] UNIQUE ([label])
    </table>>
  ];
  OrganismRelationData [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="lightblue" 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 [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="#e5c96a" colspan="2">OtherScope</td></tr>
      <tr><td PORT="id">id</td><td></td></tr>
      <tr><td PORT="label">label</td><td>u</td></tr>
      <tr><td PORT="detail">detail</td><td></td></tr>
      <tr><td PORT="type">type</td><td></td></tr>
      <tr><td PORT="sex_status_id">sex_status_id</td><td></td></tr>
      //CONSTRAINT [PK_OtherScope] PRIMARY KEY ([id]),
      //CONSTRAINT [UQ_OtherScope_1] UNIQUE ([label])
    </table>>
  ];
  Project [
    label=<<table BORDER="0" 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></td></tr>
      <tr><td PORT="label">label</td><td>u</td></tr>
      <tr><td PORT="rights_text">rights_text</td><td></td></tr>
      <tr><td PORT="licence_uri">licence_uri</td><td></td></tr>
      <tr><td PORT="detail">detail</td><td></td></tr>
      <tr><td PORT="restricted_to_descriptortree_id">restricted_to_descriptortree_id</td><td></td></tr>
      <tr><td PORT="restricted_to_taxonset_id">restricted_to_taxonset_id</td><td></td></tr>
      <tr><td PORT="primary_language_code">primary_language_code</td><td></td></tr>
      <tr><td PORT="ProjectProxyID">ProjectProxyID</td><td></td></tr>
      //CONSTRAINT [PK_Project] PRIMARY KEY ([id]),
      //CONSTRAINT [UQ_Project_1] UNIQUE ([label])
    </table>>
  ];
  Project_AvailableScope [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="lightblue" colspan="1">QuantitativeSamplingData</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 [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="#00c900" colspan="2">QuantitativeSummaryData</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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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></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="detail">detail</td><td></td></tr>
      <tr><td PORT="quality_order">quality_order</td><td></td></tr>
      //CONSTRAINT [PK_ResourceVariant_Enum] PRIMARY KEY ([id]),
      //CONSTRAINT [UQ_ResourceVariant_Enum_1] UNIQUE ([label]),
      //CONSTRAINT [UQ_ResourceVariant_Enum_2] UNIQUE ([code])
    </table>>
  ];
  SamplingEvent [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="lightblue" colspan="1">SamplingEvent</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 [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="lightblue" colspan="1">SamplingUnit</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 [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="#e5c96a" colspan="2">SexStatus_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></td></tr>
      <tr><td PORT="detail">detail</td><td></td></tr>
      <tr><td PORT="display_order">display_order</td><td></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 [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="lightblue" colspan="1">SpecimenProxy</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 [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="#e5c96a" colspan="2">StatisticalMeasure_Enum</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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="lightblue" colspan="2">TaxonRank_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></td></tr>
      <tr><td PORT="detail">detail</td><td></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 [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="lightblue" colspan="2">TaxonSet</td></tr>
      <tr><td PORT="id">id</td><td></td></tr>
      <tr><td PORT="label">label</td><td>u</td></tr>
      <tr><td PORT="default_set">default_set</td><td></td></tr>
      <tr><td PORT="project_id">project_id</td><td></td></tr>
      //CONSTRAINT [PK_TaxonSet] PRIMARY KEY ([id]),
      //CONSTRAINT [UQ_TaxonSet_1] UNIQUE ([label])
    </table>>
  ];
  TaxonSet_Taxon [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="lightblue" colspan="2">TextSamplingData</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" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
      <tr><td BGCOLOR="lightblue" colspan="2">TranslationColumn_Enum</td></tr>
      <tr><td PORT="id">id</td><td></td></tr>
      <tr><td PORT="column">column</td><td>u</td></tr>
      //CONSTRAINT [PK_TranslationColumn_Enum] PRIMARY KEY ([id]),
      //CONSTRAINT [UQ_TranslationColumn_Enum_1] UNIQUE ([column])
    </table>>
  ];
  ProjectProxy [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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 [
    label=<<table BORDER="0" 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="points">points</td><td></td></tr>
      <tr><td PORT="success">success</td><td></td></tr>
    </table>>
  ];
 
  BaseEntity:id -> Annotation:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> CategoricalState:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> Contribution:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> DataStatus_Enum:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> Description:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> Descriptor:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> DescriptorTree:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> DescriptorTreeNode:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> Frequency:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> GeographicAreaProxy:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> Identifier:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> Modifier:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> ObservationProxy:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> OtherScope:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> Project:id[color="#0069ba" fontcolor="#0069ba" headlabel="1" arrowhead="none"];
  BaseEntity:id -> ReferenceProxy:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> Resource:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> ResourceVariant_Enum:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> SexStatus_Enum:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> SpecimenProxy:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> StatisticalMeasure_Enum:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> Tag:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> TaxonProxy:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> TaxonRank_Enum:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> TaxonSet:id[color="#0069ba" fontcolor="#0069ba"];
  BaseEntity:id -> Translation:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
  BaseEntityTable_Enum:id -> BaseEntity:table_id;
  CategoricalState:id_e -> CategoricalSamplingData:state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  CategoricalState:id_e -> CategoricalSummaryData:state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  CategoricalState:id_e -> DescriptorInapplicability:controlling_state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  CategoricalState:id_e -> DescriptorMapping_C2C:from_state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  CategoricalState:id_e -> DescriptorMapping_C2C:to_state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817" style="dashed"];
  CategoricalState:id_e -> DescriptorMapping_Q2C:to_state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  CategoricalState:id_e -> Resource:state_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  Contributor:id_e -> Annotation:contributor_id;
  Contributor:id_e -> Contribution:contributor_id;
  DataStatus_Enum:id -> DescriptorStatusData:datastatus_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  Description:id -> CategoricalSummaryData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
  Description:id -> DescriptionScope:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
  Description:id -> DescriptorStatusData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
  Description:id -> OrganismRelationData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
  Description:id -> QuantitativeSummaryData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
  Description:id -> Resource:description_id[label="DELETE SET NULL" fontsize=10 color="#00c900" fontcolor="#00c900"];
  Description:id -> SamplingEvent:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
  Description:id -> TextDescriptorData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
  Descriptor:id -> CategoricalState:descriptor_id[color="#AF7817" fontcolor="#AF7817"];
  Descriptor:id -> DescriptorInapplicability:controlled_descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  Descriptor:id -> DescriptorMapping_Q2C:from_descr_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  Descriptor:id -> DescriptorStatusData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  Descriptor:id -> DescriptorTreeNode:descriptor_id[color="#AF7817" fontcolor="#AF7817"];
  Descriptor:id -> QuantitativeSamplingData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  Descriptor:id -> QuantitativeSummaryData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  Descriptor:id -> Resource:descriptor_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  Descriptor:id -> TextDescriptorData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  Descriptor:id -> TextSamplingData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  DescriptorTree:id_e -> DescriptorTreeNode:descriptortree_id[color="#CC0033" fontcolor="#CC0033"];
  DescriptorTree:id_e -> Project:restricted_to_descriptortree_id[label="DELETE SET NULL" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
  DescriptorTreeNode:id_e -> DescriptorTreeNodeRecFrequency:node_id[label="DELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
  DescriptorTreeNode:id_e -> DescriptorTreeNodeRecModifier:node_id[label="DELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
  DescriptorTreeNode:id_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 -> CategoricalSummaryData:frequency_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  Frequency:id -> DescriptorTreeNodeRecFrequency:frequency_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  Frequency:id -> OrganismRelationData:frequency_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  GeographicAreaProxy:id -> DescriptionScope:geographicarea_id[label="DELETE CASCADE" fontsize=10];
  GeographicAreaProxy:id -> GeographicArea_Taxon:geographicarea_id[label="DELETE CASCADE" fontsize=10];
  GeographicAreaProxy:id -> SamplingEvent:geographic_area[label="DELETE CASCADE" fontsize=10 style="dashed"];
  Modifier:id_e -> CategoricalSamplingData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  Modifier:id_e -> CategoricalSummaryData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  Modifier:id_e -> DescriptorTreeNodeRecModifier:modifier_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  Modifier:id_e -> OrganismRelationData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  Modifier:id_e -> QuantitativeSamplingData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  Modifier:id_e -> QuantitativeSummaryData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  ObservationProxy:id -> DescriptionScope:observation_id[label="DELETE CASCADE" fontsize=10];
  OtherScope:id -> DescriptionScope:other_scope_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  OtherScope:id -> Project_AvailableScope:scope_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  OtherScope:id -> Resource:scope_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817" style="dashed"];
  Project:id_e -> Description:project_id[color="#CC0033" fontcolor="#CC0033"];
  Project:id  -> DescriptorTree:project_id_e[color="#CC0033" fontcolor="#CC0033"];
  Project:id_e -> Project_AvailableScope:project_id[label="DELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
  Project:id_e -> TaxonProxy:project_id[color="#CC0033" fontcolor="#CC0033"];
  Project:id_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[label="DELETE CASCADE" fontsize=10];
  Resource:id -> ResourceVariant:resource_id[label="DELETE CASCADE" fontsize=10];
  ResourceVariant_Enum:id -> ResourceVariant:variant_id[label="DELETE CASCADE" fontsize=10];
  SamplingEvent:id -> SamplingUnit:sampling_event_id[label="DELETE CASCADE" fontsize=10];
  SamplingUnit:id -> CategoricalSamplingData:sampling_unit_id[label="DELETE CASCADE" fontsize=10];
  SamplingUnit:id -> QuantitativeSamplingData:sampling_unit_id[label="DELETE CASCADE" fontsize=10];
  SamplingUnit:id -> TextSamplingData:sampling_unit_id[label="DELETE CASCADE" fontsize=10];
  SexStatus_Enum:id -> OtherScope:sex_status_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  SpecimenProxy:id -> DescriptionScope:specimen_id[label="DELETE CASCADE" fontsize=10];
  StatisticalMeasure_Enum:id_e -> DescriptorMapping_Q2C:from_statistical_measure_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  StatisticalMeasure_Enum:id_e -> DescriptorTreeNodeRecStatMeasure:measure_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  StatisticalMeasure_Enum:id_e -> QuantitativeSamplingData:measure_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  StatisticalMeasure_Enum:id_e -> QuantitativeSummaryData:measure_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
  TaxonProxy:id_e -> DescriptionScope:taxon_id[label="DELETE CASCADE" fontsize=10];
  TaxonProxy:id_e -> GeographicArea_Taxon:taxon_id[label="DELETE CASCADE" fontsize=10];
  TaxonProxy:id_e -> OrganismRelationData:taxon_id[label="DELETE CASCADE" fontsize=10];
  TaxonProxy:id_e -> Resource:taxon_id[label="DELETE SET NULL" fontsize=10];
  TaxonProxy:id_e -> TaxonSet_Taxon:taxon_id[label="DELETE CASCADE" fontsize=10];
  TaxonRank_Enum:id -> TaxonProxy:rank_id;
  TaxonSet:id -> Project:restricted_to_taxonset_id[label="DELETE SET NULL" fontsize=10];
  TaxonSet:id -> TaxonSet_Taxon:taxonset_id[label="DELETE CASCADE" fontsize=10];
  TranslationColumn_Enum:id -> Translation:column_id;
  UserProxy:LoginName -> ProjectUser:LoginName[label="UPDATE CASCADE\nDELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
  TaxonProxy:id -> TaxonQuiz:taxon_id
  Contributor:id_e -> TaxonQuiz:contributor_id
  Project:id_e -> TaxonQuiz:project_id[color="#CC0033" fontcolor="#CC0033"];
}
</graphviz>


== Unklare oder Fehlende Beziehungen ==
== Unklare oder Fehlende Beziehungen ==

Aktuelle Version vom 13. August 2014, 13:21 Uhr

Database

Siehe http://diversityworkbench.net/Portal/DiversityDescriptions_Quiz_(Artenquiz)

Unklare oder Fehlende Beziehungen

Fragen

  • Resource.label soll Text sein kein nvarchar(255)? Wegen label=caption ws. besser Text --Andreas Plank (Diskussion) 18:00, 30. Jul. 2014 (CEST)
Abgerufen von „https://www.bayernflora.de/index.php?title=Benutzer:Andreas_Plank/DiversityDescriptions_Quiz&oldid=1556“