Benutzer:Andreas Plank/DiversityDescriptions Quiz

Project

<graphviz caption='Scheme of Diversity Descriptions Quiz Project' alt='Diversity Descriptions Quiz Project' format='png'>

digraph DD_Quiz_Project_20140702 {

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

 subgraph Project_uniqueness {
   Project [

label=<

Project
id
parent_project_id	u1
label	u
rights_text
licence_uri
detail
restricted_to_descriptortree_id	u1
restricted_to_taxonset_id	u1
primary_language_code
ProjectProxyID

>

   ];
   UT_Project_u1 [

label=<

u1

>

   ];
 }
 Project:id:w -> Project:parent_project_id:w[len=0.1, minlen=0.1];

 // unique together
 Project:u1_parent_project -> UT_Project_u1:u1:n[dir=none];
 Project:u1_restricted_to_descriptortree -> UT_Project_u1:u1:s[dir=none];
 Project:u1_restricted_to_taxonset -> UT_Project_u1:u1:s[dir=none];

} </graphviz>

Database

<graphviz caption='Scheme of Diversity Descriptions Quiz' alt='Diversity Descriptions Quiz' format='png'>

digraph DD_Quiz_20140702 {

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

 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

>

 ];
 subgraph Project_uniqueness {
   Project [

label=<

Project
id
parent_project_id	u1
label	u
rights_text
licence_uri
detail
restricted_to_descriptortree_id	u1
restricted_to_taxonset_id	u1
primary_language_code
ProjectProxyID

>

   ];
   UT_Project_u1 [

label=<

u1

>

   ];
 }

 Project_AvailableScope [

label=<

Project_AvailableScope
id
project_id	u
scope_id	u

>

 ];
 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

>

 ];
 TaxonRank_Enum [

label=<

TaxonRank_Enum

id

label

code

abbreviation

detail

>

 ];
 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

>

 ];
 Legend [

label=<

Legend

Project specific settings

Description of items

Descriptor

Resources

u=unique

u1=unique together

>

 ];

 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="brown"];
 CategoricalState:id -> DescriptorInapplicability:controlling_state_id[color="brown"];
 CategoricalState:id -> DescriptorMapping_C2C:from_state_id[color="brown"];
 CategoricalState:id -> DescriptorMapping_Q2C:to_state_id[color="brown"];
 CategoricalState:id -> Resource:state_id[color="brown"];
 Contributor:id -> Annotation:contributor_id;
 Contributor:id -> Contribution:contributor_id;
 DataStatus_Enum:id -> DescriptorStatusData:datastatus_id;
 Description:id -> CategoricalSummaryData:description_id[color="#00c900"];
 Description:id -> DescriptionScope:description_id[color="#00c900"];
 Description:id -> DescriptorStatusData:description_id[color="#00c900"];
 Description:id -> QuantitativeSummaryData:description_id[color="#00c900"];
 Description:id -> Resource:description_id[color="#00c900"];
 Description:id -> TextDescriptorData:description_id[color="#00c900"];
 Descriptor:id -> CategoricalState:descriptor_id[color="brown"];
 Descriptor:id -> DescriptorInapplicability:controlled_descriptor_id[color="brown"];
 Descriptor:id -> DescriptorMapping_Q2C:from_descr_id[color="brown"];
 Descriptor:id -> DescriptorStatusData:descriptor_id[color="brown"];
 Descriptor:id -> DescriptorTreeNode:descriptor_id[color="brown"];
 Descriptor:id -> QuantitativeSummaryData:descriptor_id[color="brown"];
 Descriptor:id -> Resource:descriptor_id[color="brown"];
 Descriptor:id -> TextDescriptorData:descriptor_id[color="brown"];
 DescriptorTree:id -> DescriptorTreeNode:descriptortree_id;
 DescriptorTree:id -> Project:restricted_to_descriptortree_id;
 DescriptorTreeNode:id -> DescriptorTreeNode:parent_node_id;
 DescriptorTreeNode:id -> DescriptorTreeNodeRecFrequency:node_id;
 DescriptorTreeNode:id -> DescriptorTreeNodeRecModifier:node_id;
 DescriptorTreeNode:id -> DescriptorTreeNodeRecStatMeasure:node_id;
 Frequency:id -> CategoricalSummaryData:frequency_id;
 Frequency:id -> DescriptorTreeNodeRecFrequency:frequency_id;
 GeographicAreaProxy:id -> DescriptionScope:geographicarea_id;
 Modifier:id -> CategoricalSummaryData:modifier_id;
 Modifier:id -> DescriptorTreeNodeRecModifier:modifier_id;
 Modifier:id -> QuantitativeSummaryData:modifier_id;
 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:w -> Project:parent_project_id:w[len=0.1, minlen=0.1];
 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;
 TaxonProxy:rank_id -> TaxonRank_Enum:id[taillabel="?", color="red", style="dashed"]
 UserProxy:LoginName -> ProjectUser:LoginName;

 // unique together
 // Project_AvailableScope:scope_id_unique:e -> Project_AvailableScope:project_id_unique:e[label="unique\ntogether", arrowhead=none, fontsize=10]
 UT_Project_AvailableScope_u1 [

label=<

u1

>

 ]
 Project_AvailableScope:project_id_unique -> UT_Project_AvailableScope_u1:u1:n[arrowhead=none];  
 Project_AvailableScope:scope_id_unique -> UT_Project_AvailableScope_u1:u1:s[arrowhead=none];

 Project:u1_parent_project -> UT_Project_u1:u1:n[dir=none];
 Project:u1_restricted_to_descriptortree -> UT_Project_u1:u1:s[dir=none];
 Project:u1_restricted_to_taxonset -> UT_Project_u1:u1:s[dir=none];
 {rank=same; Project; UT_Project_u1; }

} </graphviz>

Unklare Beziehungen

1. TaxonProxy.rank_id → ???