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
 
(55 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="#e5c96a">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="#e5c96a">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="#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>
    </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="#e5c96a">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="#ef6a6a">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="#ef6a6a">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="#ef6a6a">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="#ef6a6a">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="#ef6a6a">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="#e5c96a">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="#e5c96a">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="#e5c96a">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="#ef6a6a">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="#ef6a6a">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="#ef6a6a">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="#ef6a6a">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="#ef6a6a">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="#e5c96a">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="#e5c96a">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="#ef6a6a">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 -> Annotation:object_id[color="#0069ba"];
== Unklare oder Fehlende Beziehungen ==
  BaseEntity:id -> CategoricalState:id[color="#0069ba"];
* Resource.scope_id → OtherScope.id ? --[[Benutzer:Andreas Plank|Andreas Plank]] ([[Benutzer Diskussion:Andreas Plank|Diskussion]]) 16:35, 31. Jul. 2014 (CEST)
  BaseEntity:id -> Contribution:object_id[color="#0069ba"];
* 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 -> DataStatus_Enum:id[color="#0069ba"];
* SamplingEvent.geographic_area → GeographicAreaProxy.id ? --[[Benutzer:Andreas Plank|Andreas Plank]] ([[Benutzer Diskussion:Andreas Plank|Diskussion]]) 16:28, 1. Aug. 2014 (CEST)
  BaseEntity:id -> Description:id[color="#0069ba"];
  BaseEntity:id -> Descriptor:id[color="#0069ba"];
  BaseEntity:id -> DescriptorTree:id[color="#0069ba"];
  BaseEntity:id -> DescriptorTreeNode:id[color="#0069ba"];
  BaseEntity:id -> Frequency:id[color="#0069ba"];
  BaseEntity:id -> GeographicAreaProxy:id[color="#0069ba"];
  BaseEntity:id -> Identifier:object_id[color="#0069ba"];
  BaseEntity:id -> Modifier:id[color="#0069ba"];
  BaseEntity:id -> ObservationProxy:id[color="#0069ba"];
  BaseEntity:id -> OtherScope:id[color="#0069ba"];
  BaseEntity:id -> Project:id[color="#0069ba"];
  BaseEntity:id -> ReferenceProxy:id[color="#0069ba"];
  BaseEntity:id -> Resource:id[color="#0069ba"];
  BaseEntity:id -> ResourceVariant_Enum:id[color="#0069ba"];
  BaseEntity:id -> SexStatus_Enum:id[color="#0069ba"];
  BaseEntity:id -> SpecimenProxy:id[color="#0069ba"];
  BaseEntity:id -> StatisticalMeasure_Enum:id[color="#0069ba"];
  BaseEntity:id -> Tag:object_id[color="#0069ba"];
  BaseEntity:id -> TaxonProxy:id[color="#0069ba"];
  BaseEntity:id -> Translation:object_id[color="#0069ba"];
  CategoricalState:id -> CategoricalSummaryData:state_id[color="#866327"];
  CategoricalState:id -> DescriptorInapplicability:controlling_state_id[color="#866327"];
  CategoricalState:id -> DescriptorMapping_C2C:from_state_id[color="#866327"];
  CategoricalState:id -> DescriptorMapping_Q2C:to_state_id[color="#866327"];
  CategoricalState:id -> Resource:state_id[color="#866327"];
  Contributor:id -> Annotation:contributor_id[color="#E70F00"];
  Contributor:id -> Contribution:contributor_id[color="#E70F00"];
  DataStatus_Enum:id -> DescriptorStatusData:datastatus_id;
  Description:id -> CategoricalSummaryData:description_id[color="#C6DC97"];
  Description:id -> DescriptionScope:description_id[color="#C6DC97"];
  Description:id -> DescriptorStatusData:description_id[color="#C6DC97"];
  Description:id -> QuantitativeSummaryData:description_id[color="#C6DC97"];
  Description:id -> Resource:description_id[color="#C6DC97"];
  Description:id -> TextDescriptorData:description_id[color="#C6DC97"];
  Descriptor:id -> CategoricalState:descriptor_id[color="#FBDB7B"];
  Descriptor:id -> DescriptorInapplicability:controlled_descriptor_id[color="#FBDB7B"];
  Descriptor:id -> DescriptorMapping_Q2C:from_descr_id[color="#FBDB7B"];
  Descriptor:id -> DescriptorStatusData:descriptor_id[color="#FBDB7B"];
  Descriptor:id -> DescriptorTreeNode:descriptor_id[color="#FBDB7B"];
  Descriptor:id -> QuantitativeSummaryData:descriptor_id[color="#FBDB7B"];
  Descriptor:id -> Resource:descriptor_id[color="#FBDB7B"];
  Descriptor:id -> TextDescriptorData:descriptor_id[color="#FBDB7B"];
  DescriptorTree:id -> DescriptorTreeNode:descriptortree_id[color="#FB7C7C"];
  DescriptorTree:id -> Project:restricted_to_descriptortree_id[color="#FB7C7C"];
  DescriptorTreeNode:id -> DescriptorTreeNode:parent_node_id[color="#FB7C7C"];
  DescriptorTreeNode:id -> DescriptorTreeNodeRecFrequency:node_id[color="#FB7C7C"];
  DescriptorTreeNode:id -> DescriptorTreeNodeRecModifier:node_id[color="#FB7C7C"];
  DescriptorTreeNode:id -> DescriptorTreeNodeRecStatMeasure:node_id[color="#FB7C7C"];
  Frequency:id -> CategoricalSummaryData:frequency_id[color="#fbdb7b"];
  Frequency:id -> DescriptorTreeNodeRecFrequency:frequency_id[color="#fbdb7b"];
  GeographicAreaProxy:id -> DescriptionScope:geographicarea_id;
  Modifier:id -> CategoricalSummaryData:modifier_id[color="#fbdb7b"];
  Modifier:id -> DescriptorTreeNodeRecModifier:modifier_id[color="#fbdb7b"];
  Modifier:id -> QuantitativeSummaryData:modifier_id[color="#fbdb7b"];
  ObservationProxy:id -> DescriptionScope:observation_id;
  OtherScope:id -> DescriptionScope:other_scope_id;
  OtherScope:id -> Project_AvailableScope:scope_id;
  Project:id -> Description:project_id;
  Project:id -> DescriptorTree:project_id;
  Project:id -> Project:parent_project_id;
  Project:id -> Project_AvailableScope:project_id;
  Project:id -> TaxonProxy:project_id;
  ProjectProxy:ProjectID -> Project:ProjectProxyID;
  ProjectProxy:ProjectID -> ProjectUser:ProjectID;
  ReferenceProxy:id -> DescriptionScope:source_reference_id;
  Resource:id -> ResourceVariant:resource_id;
  ResourceVariant_Enum:id -> ResourceVariant:variant_id;
  SexStatus_Enum:id -> OtherScope:sex_status_id;
  SpecimenProxy:id -> DescriptionScope:specimen_id;
  StatisticalMeasure_Enum:id -> DescriptorMapping_Q2C:from_statistical_measure_id;
  StatisticalMeasure_Enum:id -> DescriptorTreeNodeRecStatMeasure:measure_id;
  StatisticalMeasure_Enum:id -> QuantitativeSummaryData:measure_id;
  TaxonProxy:id -> DescriptionScope:taxon_id;
  TaxonProxy:id -> Resource:taxon_id;
  UserProxy:LoginName -> ProjectUser:LoginName;


}
== Fragen ==
</graphviz>
* 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)

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“