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
 
(59 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"]; 
  "BaseEntity" [
    fillcolor="blue"
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
      <tr><td BGCOLOR="lightblue">BaseEntity</td></tr>
      <tr><td PORT="id">id</td></tr>
      <tr><td>derived_cleanup_flag</td></tr>
      <tr><td>specific_rights_text</td></tr>
      <tr><td>specific_licence_uri</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>>
  ];
  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>
    </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>label</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>>
  ];
  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>descriptor_id</td></tr>
      <tr><td>label</td></tr>
      <tr><td>abbreviation</td></tr>
      <tr><td>detail</td></tr>
      <tr><td>wording</td></tr>
      <tr><td>display_order</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>label</td></tr>
      <tr><td>code</td></tr>
      <tr><td>abbreviation</td></tr>
      <tr><td>detail</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>label</td></tr>
    <tr><td>rights_text</td></tr>
    <tr><td>licence_uri</td></tr>
    <tr><td>detail</td></tr>
    <tr><td PORT="restricted_to_descriptortree_id">restricted_to_descriptortree_id</td></tr>
    <tr><td>restricted_to_taxonset_id</td></tr>
    <tr><td>primary_language_code</td></tr>
    <tr><td PORT="ProjectProxyID">ProjectProxyID</td></tr>
  </table>>
  ];


"ProjectUser" [
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">ProjectUser</td></tr>
    <tr><td PORT="LoginName">LoginName</td></tr>
    <tr><td PORT="ProjectID">ProjectID</td></tr>
    <tr><td>ReadOnly</td></tr>
  </table>>
  ];


"ProjectProxy" [
== Unklare oder Fehlende Beziehungen ==
  label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
* Resource.scope_id → OtherScope.id ? --[[Benutzer:Andreas Plank|Andreas Plank]] ([[Benutzer Diskussion:Andreas Plank|Diskussion]]) 16:35, 31. Jul. 2014 (CEST)
    <tr><td BGCOLOR="lightblue">ProjectProxy</td></tr>
* DescriptorMapping_C2C.to_state_id → CategoricalState.id ? --[[Benutzer:Andreas Plank|Andreas Plank]] ([[Benutzer Diskussion:Andreas Plank|Diskussion]]) 18:20, 31. Jul. 2014 (CEST)
    <tr><td PORT="ProjectID">ProjectID</td></tr>
* SamplingEvent.geographic_area → GeographicAreaProxy.id ? --[[Benutzer:Andreas Plank|Andreas Plank]] ([[Benutzer Diskussion:Andreas Plank|Diskussion]]) 16:28, 1. Aug. 2014 (CEST)
    <tr><td PORT="Project">Project</td></tr>
    <tr><td PORT="ProjectURI">ProjectURI</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>>
  ];


  Descriptor [
== Fragen ==
    label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
* 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)
      <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>
    </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>
    </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>is_complete</td></tr>
    <tr><td>label</td></tr>
    <tr><td>type</td></tr>
    <tr><td PORT="project_id">project_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>
    </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>AgentURI</td></tr>
    <tr><td>Queries</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>label</td></tr>
    <tr><td>detail</td></tr>
    <tr><td>type</td></tr>
    <tr><td>sex_status_id</td></tr>
  </table>>
  ];
 
  BaseEntity:id -> CategoricalState:id;
  BaseEntity:id -> Contribution:object_id;
  BaseEntity:id -> DataStatus_Enum:id;
  BaseEntity:id -> DescriptorTree:id;
  BaseEntity:id -> Descriptor:id;
  BaseEntity:id -> Description:id;
  BaseEntity:id -> ObservationProxy:id;
  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;
  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“