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

← Zum vorherigen Versionsunterschied Zum nächsten Versionsunterschied →

Version vom 2. Juli 2014, 17:47 Uhr

digraph DD_Quiz {

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

 Annotation [

label=<

Annotation

id

object_id

language_code

contributor_id

timestamp

content

is_internal

is_latest_revision

MEMO_WhichVersionsInheritIsNotSolved

>

 ];
 BaseEntity [

label=<

BaseEntity

id

derived_cleanup_flag

specific_rights_text

specific_licence_uri

>

 ];
 CategoricalState [

label=<

CategoricalState

id

descriptor_id

label

abbreviation

detail

wording

display_order

>

 ];
 CategoricalSummaryData [

label=<

CategoricalSummaryData

id

description_id

state_id

notes

modifier_id

frequency_id

>

 ];
 Contribution [

label=<

Contribution

id

object_id

contributor_id

role

timestamp

>

 ];
 Contributor [

label=<

Contributor

id

email

web_pseudonym

avatar_uri

real_name

linked_agent_uri

>

 ];
 DataStatus_Enum [

label=<

DataStatus_Enum

id

label

code

abbreviation

detail

>

 ];
 Description [

label=<

Description

id

label

detail

project_id

>

 ];
 Description_Query [

label=<

Description_Query

id

label

detail

project_id

>

 ];
 DescriptionScope [

label=<

DescriptionScope

id

description_id

label

dwbURI

type

taxon_id

specimen_id

observation_id

source_reference_id

geographicarea_id

other_scope_id

>

 ];
 Descriptor [

label=<

Descriptor

id

label

abbreviation

detail

display_order

subclass

statistical_measurement_scale

usually_exclusive

state_collection_model

mandatory

repeatability

availability

measurement_unit

measurement_unit_precedes_value

min_plausible_value

max_plausible_value

wording_before

wording_after

data_entry_note

>

 ];
 Descriptor_Query [

label=<

Descriptor_Query

id

label

abbreviation

detail

display_order

subclass

statistical_measurement_scale

usually_exclusive

state_collection_model

mandatory

repeatability

availability

measurement_unit

measurement_unit_precedes_value

min_plausible_value

max_plausible_value

wording_before

wording_after

data_entry_note

>

 ];
 DescriptorInapplicability [

label=<

DescriptorInapplicability

id

controlled_descriptor_id

controlling_state_id

rule

>

 ];
 DescriptorMapping_C2C [

label=<

DescriptorMapping_C2C

id

from_state_id

to_state_id

>

 ];
 DescriptorMapping_Q2C [

label=<

DescriptorMapping_Q2C

id

from_descr_id

from_lowerbound

from_upperbound

from_statistical_measure_id

from_statmeas_class_TO_CONSIDER

to_state_id

>

 ];
 DescriptorStatusData [

label=<

DescriptorStatusData

id

description_id

descriptor_id

datastatus_id

notes

>

 ];
 DescriptorTree [

label=<

DescriptorTree

id

is_complete

label

type

project_id

>

 ];
 DescriptorTreeNode [

label=<

DescriptorTreeNode

id

parent_node_id

label

abbreviation

display_order

descriptortree_id

descriptor_id

>

 ];
 DescriptorTreeNodeRecFrequency [

label=<

DescriptorTreeNodeRecFrequency

id

node_id

frequency_id

>

 ];
 DescriptorTreeNodeRecModifier [

label=<

DescriptorTreeNodeRecModifier

id

node_id

modifier_id

>

 ];
 DescriptorTreeNodeRecStatMeasure [

label=<

DescriptorTreeNodeRecStatMeasure

id

node_id

measure_id

>

 ];
 Frequency [

label=<

Frequency

id

label

lower_estimate

upper_estimate

display_order

>

 ];
 GeographicAreaProxy [

label=<

GeographicAreaProxy

id

label

>

 ];
 Identifier [

label=<

Identifier

object_id

uri

match

>

 ];
 Modifier [

label=<

Modifier

id

class

label

display_order

>

 ];
 ObservationProxy [

label=<

ObservationProxy

id

label

>

 ];
 OtherScope [

label=<

OtherScope

id

label

detail

type

sex_status_id

>

 ];
 Project [

label=<

Project

id

parent_project_id

label

rights_text

licence_uri

detail

restricted_to_descriptortree_id

restricted_to_taxonset_id

primary_language_code

ProjectProxyID

>

 ];
 Project_AvailableScope [

label=<

Project_AvailableScope

id

project_id

scope_id

>

 ];
 Project_Query [

label=<

Project_Query

id

parent_project_id

label

rights_text

licence_uri

detail

restricted_to_descriptortree_id

restricted_to_taxonset_id

primary_language_code

ProjectProxyID

>

 ];
 ProjectProxy [

label=<

ProjectProxy

ProjectID

Project

ProjectURI

>

 ];
 ProjectUser [

label=<

ProjectUser

LoginName

ProjectID

ReadOnly

>

 ];
 QuantitativeSummaryData [

label=<

QuantitativeSummaryData

id

measure_id

description_id

descriptor_id

value

notes

modifier_id

>

 ];
 ReferenceProxy [

label=<

ReferenceProxy

id

label

>

 ];
 Resource [

label=<

Resource

id

terminology_role

ranking_for_terminology

descriptor_id

state_id

taxon_role

ranking_for_taxon_use

taxon_id

description_id

scope_id

display_embedded

label

language_code

display_order

>

 ];
 ResourceVariant [

label=<

ResourceVariant

id

resource_id

variant_id

url

pixel_width

pixel_height

duration

size

mime_type

>

 ];
 ResourceVariant_Enum [

label=<

ResourceVariant_Enum

id

label

code

detail

quality_order

>

 ];
 SexStatus_Enum [

label=<

SexStatus_Enum

id

label

code

abbreviation

detail

display_order

>

 ];
 SpecimenProxy [

label=<

SpecimenProxy

id

label

>

 ];
 StatisticalMeasure_Enum [

label=<

StatisticalMeasure_Enum

id

label

code

abbreviation

display_order

>

 ];
 Tag [

label=<

Tag

id

tag

object_id

>

 ];
 TaxonProxy [

label=<

TaxonProxy

id

label

name

common_name

rank_id

genus

infrageneric_epithet

specific_epithet

infraspecific_rankstring

infraspecific_epithet

cultivar_name_or_group

full_authorship_citation

base_citation

base_citation_bracketed

combination_citation

kingdom

phylum_or_division

class

subclass

order

suborder

family

subfamily

project_id

>

 ];
 TextDescriptorData [

label=<

TextDescriptorData

id

description_id

descriptor_id

content

notes

>

 ];
 Translation [

label=<

Translation

id

object_id

language_code

label

abbreviation

detail

wording_before

wording_after

>

 ];
 UserProxy [

label=<

UserProxy

LoginName

CombinedNameCache

AgentURI

Queries

>

];

 BaseEntity:id -> Annotation:object_id[color="#0069ba"];
 BaseEntity:id -> CategoricalState:id[color="#0069ba"];
 BaseEntity:id -> Contribution:object_id[color="#0069ba"];
 BaseEntity:id -> DataStatus_Enum:id[color="#0069ba"];
 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;

} </graphviz>

@@ Zeile 7: / Zeile 7: @@
    Annotation [
-     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
+     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
        <tr><td BGCOLOR="lightblue">Annotation</td></tr>
        <tr><td PORT="id">id</td></tr>
@@ Zeile 31: / Zeile 31: @@
    CategoricalState [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">CategoricalState</td></tr>
+       <tr><td BGCOLOR="#e5c96a">CategoricalState</td></tr>
        <tr><td PORT="id">id</td></tr>
        <tr><td PORT="descriptor_id">descriptor_id</td></tr>
@@ Zeile 75: / Zeile 75: @@
    DataStatus_Enum [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">DataStatus_Enum</td></tr>
+       <tr><td BGCOLOR="#e5c96a">DataStatus_Enum</td></tr>
        <tr><td PORT="id">id</td></tr>
        <tr><td PORT="label">label</td></tr>
@@ Zeile 119: / Zeile 119: @@
    Descriptor [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">Descriptor</td></tr>
+       <tr><td BGCOLOR="#e5c96a">Descriptor</td></tr>
        <tr><td PORT="id">id</td></tr>
        <tr><td PORT="label">label</td></tr>
@@ Zeile 167: / Zeile 167: @@
    DescriptorInapplicability [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">DescriptorInapplicability</td></tr>
+       <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>
@@ Zeile 206: / Zeile 206: @@
    DescriptorTree [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">DescriptorTree</td></tr>
+       <tr><td BGCOLOR="#ef6a6a">DescriptorTree</td></tr>
        <tr><td PORT="id">id</td></tr>
        <tr><td PORT="is_complete">is_complete</td></tr>
@@ Zeile 216: / Zeile 216: @@
    DescriptorTreeNode [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">DescriptorTreeNode</td></tr>
+       <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>
@@ Zeile 228: / Zeile 228: @@
    DescriptorTreeNodeRecFrequency [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">DescriptorTreeNodeRecFrequency</td></tr>
+       <tr><td BGCOLOR="#ef6a6a">DescriptorTreeNodeRecFrequency</td></tr>
        <tr><td PORT="id">id</td></tr>
        <tr><td PORT="node_id">node_id</td></tr>
@@ Zeile 236: / Zeile 236: @@
    DescriptorTreeNodeRecModifier [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">DescriptorTreeNodeRecModifier</td></tr>
+       <tr><td BGCOLOR="#ef6a6a">DescriptorTreeNodeRecModifier</td></tr>
        <tr><td PORT="id">id</td></tr>
        <tr><td PORT="node_id">node_id</td></tr>
@@ Zeile 244: / Zeile 244: @@
    DescriptorTreeNodeRecStatMeasure [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">DescriptorTreeNodeRecStatMeasure</td></tr>
+       <tr><td BGCOLOR="#ef6a6a">DescriptorTreeNodeRecStatMeasure</td></tr>
        <tr><td PORT="id">id</td></tr>
        <tr><td PORT="node_id">node_id</td></tr>
@@ Zeile 252: / Zeile 252: @@
    Frequency [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">Frequency</td></tr>
+       <tr><td BGCOLOR="#e5c96a">Frequency</td></tr>
        <tr><td PORT="id">id</td></tr>
        <tr><td PORT="label">label</td></tr>
@@ Zeile 277: / Zeile 277: @@
    Modifier [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">Modifier</td></tr>
+       <tr><td BGCOLOR="#e5c96a">Modifier</td></tr>
        <tr><td PORT="id">id</td></tr>
        <tr><td PORT="class">class</td></tr>
@@ Zeile 293: / Zeile 293: @@
    OtherScope [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">OtherScope</td></tr>
+       <tr><td BGCOLOR="#e5c96a">OtherScope</td></tr>
        <tr><td PORT="id">id</td></tr>
        <tr><td PORT="label">label</td></tr>
@@ Zeile 303: / Zeile 303: @@
    Project [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">Project</td></tr>
+       <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>
@@ Zeile 318: / Zeile 318: @@
    Project_AvailableScope [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">Project_AvailableScope</td></tr>
+       <tr><td BGCOLOR="#ef6a6a">Project_AvailableScope</td></tr>
        <tr><td PORT="id">id</td></tr>
        <tr><td PORT="project_id">project_id</td></tr>
@@ Zeile 326: / Zeile 326: @@
    Project_Query [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">Project_Query</td></tr>
+       <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>
@@ Zeile 341: / Zeile 341: @@
    ProjectProxy [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">ProjectProxy</td></tr>
+       <tr><td BGCOLOR="#ef6a6a">ProjectProxy</td></tr>
        <tr><td PORT="ProjectID">ProjectID</td></tr>
        <tr><td PORT="Project">Project</td></tr>
@@ Zeile 349: / Zeile 349: @@
    ProjectUser [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">ProjectUser</td></tr>
+       <tr><td BGCOLOR="#ef6a6a">ProjectUser</td></tr>
        <tr><td PORT="LoginName">LoginName</td></tr>
        <tr><td PORT="ProjectID">ProjectID</td></tr>
@@ Zeile 419: / Zeile 419: @@
    SexStatus_Enum [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">SexStatus_Enum</td></tr>
+       <tr><td BGCOLOR="#e5c96a">SexStatus_Enum</td></tr>
        <tr><td PORT="id">id</td></tr>
        <tr><td PORT="label">label</td></tr>
@@ Zeile 437: / Zeile 437: @@
    StatisticalMeasure_Enum [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">StatisticalMeasure_Enum</td></tr>
+       <tr><td BGCOLOR="#e5c96a">StatisticalMeasure_Enum</td></tr>
        <tr><td PORT="id">id</td></tr>
        <tr><td PORT="label">label</td></tr>
@@ Zeile 507: / Zeile 507: @@
    UserProxy [
      label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
-       <tr><td BGCOLOR="lightblue">UserProxy</td></tr>
+       <tr><td BGCOLOR="#ef6a6a">UserProxy</td></tr>
        <tr><td PORT="LoginName">LoginName</td></tr>
        <tr><td PORT="CombinedNameCache">CombinedNameCache</td></tr>
@@ Zeile 538: / Zeile 538: @@
    BaseEntity:id -> Tag:object_id[color="#0069ba"];
    BaseEntity:id -> TaxonProxy:id[color="#0069ba"];
-   BaseEntity:id -> Translation:object_id[color="#E70F00"];
+   BaseEntity:id -> Translation:object_id[color="#0069ba"];
    CategoricalState:id -> CategoricalSummaryData:state_id[color="#866327"];
    CategoricalState:id -> DescriptorInapplicability:controlling_state_id[color="#866327"];