Benutzer:Andreas Plank/DiversityDescriptions Quiz

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 -> 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;
 Description:id -> CategoricalSummaryData: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>