|
|
| (65 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) |
| Zeile 1: |
Zeile 1: |
| <graphviz caption='Hello SVG and PNG' alt='phylogenetic tree' format='png'>
| | __TOC__ |
| digraph DD_Quiz {
| |
| graph [rankdir = "LR"];
| |
| node [fontsize = "10" shape = "plaintext"];
| |
|
| |
| "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>>
| |
| ];
| |
| "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>>
| |
| ];
| |
| 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" [
| | == Database == |
| 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" [
| | 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">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>>
| |
| ];
| |
|
| |
|
| "DescriptorTree" [
| | == 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">DescriptorTree</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="id">id</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>is_complete</td></tr>
| | |
| <tr><td>label</td></tr>
| | == Fragen == |
| <tr><td>type</td></tr>
| | * 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 PORT="project_id">project_id</td></tr>
| |
| </table>>
| |
| ];
| |
| "BaseEntity":id -> "ObservationProxy":id;
| |
| "BaseEntity":id -> CategoricalState:id;
| |
| "BaseEntity":id -> "DataStatus_Enum":id;
| |
| "BaseEntity":id -> "Project":id;
| |
| "BaseEntity":id -> "DescriptorTree":id;
| |
| "Project":id -> "Project":parent_project_id;
| |
| "Project":restricted_to_descriptortree_id -> "DescriptorTree":project_id;
| |
| "ProjectProxy":ProjectID -> "ProjectUser":ProjectID;
| |
| "Project":ProjectProxyID -> "ProjectProxy":ProjectID;
| |
| }
| |
| </graphviz>
| |
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)