Zum Inhalt springen

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

Aus Flora von Bayern
← Zum vorherigen Versionsunterschied
imported>Andreas Plank
KKeine Bearbeitungszusammenfassung
imported>Andreas Plank
K verlinkt nach http://diversityworkbench.net/Portal/DiversityDescriptions_Quiz_%28Artenquiz%29
 
(58 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 1: Zeile 1:
<graphviz caption='Scheme of Diversity Descriptions Quiz' alt='Diversity Descriptions Quiz' format='png'>
__TOC__


digraph DD_Quiz {
== Database ==
  graph [rankdir = "LR"];
  node [fontsize = "10", shape = "plaintext"];
  edge [color = "brown"]; 


  Annotation [
Siehe [http://diversityworkbench.net/Portal/DiversityDescriptions_Quiz_%28Artenquiz%29 http://diversityworkbench.net/Portal/DiversityDescriptions_Quiz_(Artenquiz)]
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">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>
    </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="derived_cleanup_flag">derived_cleanup_flag</td></tr>
      <tr><td PORT="specific_rights_text">specific_rights_text</td></tr>
      <tr><td PORT="specific_licence_uri">specific_licence_uri</td></tr>
    </table>>
  ];
  CategoricalState [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">CategoricalState</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="descriptor_id">descriptor_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="wording">wording</td></tr>
      <tr><td PORT="display_order">display_order</td></tr>
    </table>>
  ];
  CategoricalSummaryData [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">CategoricalSummaryData</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="description_id">description_id</td></tr>
      <tr><td PORT="state_id">state_id</td></tr>
      <tr><td PORT="notes">notes</td></tr>
      <tr><td PORT="modifier_id">modifier_id</td></tr>
      <tr><td PORT="frequency_id">frequency_id</td></tr>
    </table>>
  ];
  Contribution [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">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>
    </table>>
  ];
  Contributor [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">Contributor</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="email">email</td></tr>
      <tr><td PORT="web_pseudonym">web_pseudonym</td></tr>
      <tr><td PORT="avatar_uri">avatar_uri</td></tr>
      <tr><td PORT="real_name">real_name</td></tr>
      <tr><td PORT="linked_agent_uri">linked_agent_uri</td></tr>
    </table>>
  ];
  DataStatus_Enum [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">DataStatus_Enum</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="label">label</td></tr>
      <tr><td PORT="code">code</td></tr>
      <tr><td PORT="abbreviation">abbreviation</td></tr>
      <tr><td PORT="detail">detail</td></tr>
    </table>>
  ];
  Description [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">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>
    </table>>
  ];
  Description_Query [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">Description_Query</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>
    </table>>
  ];
  DescriptionScope [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">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>
    </table>>
  ];
  Descriptor [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">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>
    </table>>
  ];
  Descriptor_Query [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">Descriptor_Query</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>
    </table>>
  ];
  DescriptorInapplicability [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">DescriptorInapplicability</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="controlled_descriptor_id">controlled_descriptor_id</td></tr>
      <tr><td PORT="controlling_state_id">controlling_state_id</td></tr>
      <tr><td PORT="rule">rule</td></tr>
    </table>>
  ];
  DescriptorMapping_C2C [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">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>
    </table>>
  ];
  DescriptorMapping_Q2C [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">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>
    </table>>
  ];
  DescriptorStatusData [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">DescriptorStatusData</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="description_id">description_id</td></tr>
      <tr><td PORT="descriptor_id">descriptor_id</td></tr>
      <tr><td PORT="datastatus_id">datastatus_id</td></tr>
      <tr><td PORT="notes">notes</td></tr>
    </table>>
  ];
  DescriptorTree [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">DescriptorTree</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="is_complete">is_complete</td></tr>
      <tr><td PORT="label">label</td></tr>
      <tr><td PORT="type">type</td></tr>
      <tr><td PORT="project_id">project_id</td></tr>
    </table>>
  ];
  DescriptorTreeNode [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">DescriptorTreeNode</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="parent_node_id">parent_node_id</td></tr>
      <tr><td PORT="label">label</td></tr>
      <tr><td PORT="abbreviation">abbreviation</td></tr>
      <tr><td PORT="display_order">display_order</td></tr>
      <tr><td PORT="descriptortree_id">descriptortree_id</td></tr>
      <tr><td PORT="descriptor_id">descriptor_id</td></tr>
    </table>>
  ];
  DescriptorTreeNodeRecFrequency [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">DescriptorTreeNodeRecFrequency</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="node_id">node_id</td></tr>
      <tr><td PORT="frequency_id">frequency_id</td></tr>
    </table>>
  ];
  DescriptorTreeNodeRecModifier [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">DescriptorTreeNodeRecModifier</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="node_id">node_id</td></tr>
      <tr><td PORT="modifier_id">modifier_id</td></tr>
    </table>>
  ];
  DescriptorTreeNodeRecStatMeasure [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">DescriptorTreeNodeRecStatMeasure</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="node_id">node_id</td></tr>
      <tr><td PORT="measure_id">measure_id</td></tr>
    </table>>
  ];
  Frequency [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">Frequency</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="label">label</td></tr>
      <tr><td PORT="lower_estimate">lower_estimate</td></tr>
      <tr><td PORT="upper_estimate">upper_estimate</td></tr>
      <tr><td PORT="display_order">display_order</td></tr>
    </table>>
  ];
  GeographicAreaProxy [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">GeographicAreaProxy</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="label">label</td></tr>
    </table>>
  ];
  Identifier [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">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>
    </table>>
  ];
  Modifier [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">Modifier</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="class">class</td></tr>
      <tr><td PORT="label">label</td></tr>
      <tr><td PORT="display_order">display_order</td></tr>
    </table>>
  ];
  ObservationProxy [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">ObservationProxy</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="label">label</td></tr>
    </table>>
  ];
  OtherScope [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">OtherScope</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="type">type</td></tr>
      <tr><td PORT="sex_status_id">sex_status_id</td></tr>
    </table>>
  ];
  Project [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">Project</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="parent_project_id">parent_project_id</td></tr>
      <tr><td PORT="label">label</td></tr>
      <tr><td PORT="rights_text">rights_text</td></tr>
      <tr><td PORT="licence_uri">licence_uri</td></tr>
      <tr><td PORT="detail">detail</td></tr>
      <tr><td PORT="restricted_to_descriptortree_id">restricted_to_descriptortree_id</td></tr>
      <tr><td PORT="restricted_to_taxonset_id">restricted_to_taxonset_id</td></tr>
      <tr><td PORT="primary_language_code">primary_language_code</td></tr>
      <tr><td PORT="ProjectProxyID">ProjectProxyID</td></tr>
    </table>>
  ];
  Project_AvailableScope [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">Project_AvailableScope</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="project_id">project_id</td></tr>
      <tr><td PORT="scope_id">scope_id</td></tr>
    </table>>
  ];
  Project_Query [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">Project_Query</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="parent_project_id">parent_project_id</td></tr>
      <tr><td PORT="label">label</td></tr>
      <tr><td PORT="rights_text">rights_text</td></tr>
      <tr><td PORT="licence_uri">licence_uri</td></tr>
      <tr><td PORT="detail">detail</td></tr>
      <tr><td PORT="restricted_to_descriptortree_id">restricted_to_descriptortree_id</td></tr>
      <tr><td PORT="restricted_to_taxonset_id">restricted_to_taxonset_id</td></tr>
      <tr><td PORT="primary_language_code">primary_language_code</td></tr>
      <tr><td PORT="ProjectProxyID">ProjectProxyID</td></tr>
    </table>>
  ];
  ProjectProxy [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">ProjectProxy</td></tr>
      <tr><td PORT="ProjectID">ProjectID</td></tr>
      <tr><td PORT="Project">Project</td></tr>
      <tr><td PORT="ProjectURI">ProjectURI</td></tr>
    </table>>
  ];
  ProjectUser [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">ProjectUser</td></tr>
      <tr><td PORT="LoginName">LoginName</td></tr>
      <tr><td PORT="ProjectID">ProjectID</td></tr>
      <tr><td PORT="ReadOnly">ReadOnly</td></tr>
    </table>>
  ];
  QuantitativeSummaryData [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">QuantitativeSummaryData</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="measure_id">measure_id</td></tr>
      <tr><td PORT="description_id">description_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>
    </table>>
  ];
  ReferenceProxy [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">ReferenceProxy</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="label">label</td></tr>
    </table>>
  ];
  Resource [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">Resource</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>
    </table>>
  ];
  ResourceVariant [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">ResourceVariant</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="resource_id">resource_id</td></tr>
      <tr><td PORT="variant_id">variant_id</td></tr>
      <tr><td PORT="url">url</td></tr>
      <tr><td PORT="pixel_width">pixel_width</td></tr>
      <tr><td PORT="pixel_height">pixel_height</td></tr>
      <tr><td PORT="duration">duration</td></tr>
      <tr><td PORT="size">size</td></tr>
      <tr><td PORT="mime_type">mime_type</td></tr>
    </table>>
  ];
  ResourceVariant_Enum [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">ResourceVariant_Enum</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="label">label</td></tr>
      <tr><td PORT="code">code</td></tr>
      <tr><td PORT="detail">detail</td></tr>
      <tr><td PORT="quality_order">quality_order</td></tr>
    </table>>
  ];
  SexStatus_Enum [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">SexStatus_Enum</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="label">label</td></tr>
      <tr><td PORT="code">code</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>
    </table>>
  ];
  SpecimenProxy [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">SpecimenProxy</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="label">label</td></tr>
    </table>>
  ];
  StatisticalMeasure_Enum [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">StatisticalMeasure_Enum</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="label">label</td></tr>
      <tr><td PORT="code">code</td></tr>
      <tr><td PORT="abbreviation">abbreviation</td></tr>
      <tr><td PORT="display_order">display_order</td></tr>
    </table>>
  ];
  Tag [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">Tag</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="tag">tag</td></tr>
      <tr><td PORT="object_id">object_id</td></tr>
    </table>>
  ];
  TaxonProxy [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">TaxonProxy</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="label">label</td></tr>
      <tr><td PORT="name">name</td></tr>
      <tr><td PORT="common_name">common_name</td></tr>
      <tr><td PORT="rank_id">rank_id</td></tr>
      <tr><td PORT="genus">genus</td></tr>
      <tr><td PORT="infrageneric_epithet">infrageneric_epithet</td></tr>
      <tr><td PORT="specific_epithet">specific_epithet</td></tr>
      <tr><td PORT="infraspecific_rankstring">infraspecific_rankstring</td></tr>
      <tr><td PORT="infraspecific_epithet">infraspecific_epithet</td></tr>
      <tr><td PORT="cultivar_name_or_group">cultivar_name_or_group</td></tr>
      <tr><td PORT="full_authorship_citation">full_authorship_citation</td></tr>
      <tr><td PORT="base_citation">base_citation</td></tr>
      <tr><td PORT="base_citation_bracketed">base_citation_bracketed</td></tr>
      <tr><td PORT="combination_citation">combination_citation</td></tr>
      <tr><td PORT="kingdom">kingdom</td></tr>
      <tr><td PORT="phylum_or_division">phylum_or_division</td></tr>
      <tr><td PORT="class">class</td></tr>
      <tr><td PORT="subclass">subclass</td></tr>
      <tr><td PORT="order">order</td></tr>
      <tr><td PORT="suborder">suborder</td></tr>
      <tr><td PORT="family">family</td></tr>
      <tr><td PORT="subfamily">subfamily</td></tr>
      <tr><td PORT="project_id">project_id</td></tr>
    </table>>
  ];
  TextDescriptorData [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">TextDescriptorData</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td PORT="description_id">description_id</td></tr>
      <tr><td PORT="descriptor_id">descriptor_id</td></tr>
      <tr><td PORT="content">content</td></tr>
      <tr><td PORT="notes">notes</td></tr>
    </table>>
  ];
  Translation [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">Translation</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="label">label</td></tr>
      <tr><td PORT="abbreviation">abbreviation</td></tr>
      <tr><td PORT="detail">detail</td></tr>
      <tr><td PORT="wording_before">wording_before</td></tr>
      <tr><td PORT="wording_after">wording_after</td></tr>
    </table>>
  ];
  UserProxy [
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">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>
    </table>>
  ];


  BaseEntity:id -> CategoricalState:id;
== Unklare oder Fehlende Beziehungen ==
  BaseEntity:id -> Contribution:object_id;
* Resource.scope_id → OtherScope.id ? --[[Benutzer:Andreas Plank|Andreas Plank]] ([[Benutzer Diskussion:Andreas Plank|Diskussion]]) 16:35, 31. Jul. 2014 (CEST)
  BaseEntity:id -> DataStatus_Enum:id;
* DescriptorMapping_C2C.to_state_id → CategoricalState.id ? --[[Benutzer:Andreas Plank|Andreas Plank]] ([[Benutzer Diskussion:Andreas Plank|Diskussion]]) 18:20, 31. Jul. 2014 (CEST)
  BaseEntity:id -> DescriptorTree:id;
* SamplingEvent.geographic_area → GeographicAreaProxy.id ? --[[Benutzer:Andreas Plank|Andreas Plank]] ([[Benutzer Diskussion:Andreas Plank|Diskussion]]) 16:28, 1. Aug. 2014 (CEST)
  BaseEntity:id -> Descriptor:id;
 
  BaseEntity:id -> Description:id;
== Fragen ==
  BaseEntity:id -> ObservationProxy:id;
* Resource.label soll Text sein kein nvarchar(255)? Wegen label=caption ws. besser Text --[[Benutzer:Andreas Plank|Andreas Plank]] ([[Benutzer Diskussion:Andreas Plank|Diskussion]]) 18:00, 30. Jul. 2014 (CEST)
  BaseEntity:id -> OtherScope:id;
  BaseEntity:id -> Project:id;
  BaseEntity:id -> Tag:object_id;
  BaseEntity:id -> Translation:object_id;
  Contribution:contributor_id -> Contributor:id;
  Descriptor:id -> DescriptorStatusData:descriptor_id;
  Description:id -> DescriptorStatusData:description_id;
  Description:id -> CategoricalSummaryData:description_id;
  DataStatus_Enum:id -> DescriptorStatusData:datastatus_id;
  Project:id -> Project:parent_project_id;
  Project:restricted_to_descriptortree_id ->  DescriptorTree:project_id;
  ProjectProxy:ProjectID -> ProjectUser:ProjectID;
  Project:ProjectProxyID -> ProjectProxy:ProjectID;
  ProjectUser:LoginName -> UserProxy:LoginName[arrowhead=none];
  Project:id -> Project_AvailableScope:project_id;
  Project_AvailableScope:scope_id -> OtherScope:id;
}
</graphviz>

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“