Benutzer:Andreas Plank/DiversityDescriptions Quiz

Database

<graphviz caption='Legend of DiversityDescriptions datebase scheme' alt='Legend of DiversityDescriptions' format='png'> digraph DD_Legend {

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

label=<

Legend

Project specific settings

Description of items

Descriptor

Resources

u=unique

ut_1=unique together

>

 ];

} </graphviz>

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

digraph DD_Quiz_Scheme_20140717{

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

 Annotation [

label=<

     //CONSTRAINT [PK_Annotation] PRIMARY KEY ([id])

Annotation

id

object_id

language_code

contributor_id

timestamp

content

is_internal

is_latest_revision

MEMO_WhichVersionsInheritIsNotSolved

>

  ];
 BaseEntity [

label=<

     //CONSTRAINT [PK_BaseEntity] PRIMARY KEY ([id])

BaseEntity

id

table_id

specific_rights_text

specific_licence_uri

>

  ];
 BaseEntityTable_Enum [

label=<

     //CONSTRAINT [PK_BaseEntityTable_Enum] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_BaseEntityTable_Enum_1] UNIQUE ([table])

BaseEntityTable_Enum
id
table	u

>

  ];
 CategoricalSamplingData [

label=<

     //CONSTRAINT [PK_CategoricalSamplingData] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_CategoricalSamplingData_1] UNIQUE ([sampling_unit_id],[state_id],[modifier_id])

CategoricalSamplingData
id
sampling_unit_id	ut_1
state_id	ut_1
notes
modifier_id	ut_1
frequency_value

>

  ];
 CategoricalState [

label=<

     //CONSTRAINT [PK_CategoricalState] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_CategoricalState_1] UNIQUE ([label],[descriptor_id])

CategoricalState
id
descriptor_id	ut_1
label	ut_1
abbreviation
detail
wording
display_order

>

  ];
 CategoricalSummaryData [

label=<

     //CONSTRAINT [PK_CategoricalSummaryData] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_CategoricalSummaryData_1] UNIQUE ([description_id],[state_id],[modifier_id],[frequency_id])

CategoricalSummaryData
id
description_id	ut_1
state_id	ut_1
notes
modifier_id	ut_1
frequency_id	ut_1

>

  ];
 Contribution [

label=<

     //CONSTRAINT [PK_Contribution] PRIMARY KEY ([id])

Contribution

id

object_id

contributor_id

role

timestamp

>

  ];
 Contributor [

label=<

     //CONSTRAINT [PK_Contributor] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_Contributor_1] UNIQUE ([email])

Contributor
id
email	u
web_pseudonym
avatar_uri
real_name
linked_agent_uri

>

  ];
 DataStatus_Enum [

label=<

     //CONSTRAINT [PK_DataStatus_Enum] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_DataStatus_Enum_1] UNIQUE ([code]),
     //CONSTRAINT [UQ_DataStatus_Enum_2] UNIQUE ([abbreviation]),
     //CONSTRAINT [UQ_DataStatus_Enum_3] UNIQUE ([label])

DataStatus_Enum
id
label	u
code	u
abbreviation	u
detail

>

  ];
 Description [

label=<

     //CONSTRAINT [PK_Description] PRIMARY KEY ([id])

Description

id

label

detail

project_id

>

  ];
 DescriptionScope [

label=<

     //CONSTRAINT [PK_DescriptionScope] PRIMARY KEY ([id])

DescriptionScope

id

description_id

label

dwbURI

type

taxon_id

specimen_id

observation_id

source_reference_id

geographicarea_id

other_scope_id

>

  ];
 Descriptor [

label=<

     //CONSTRAINT [PK_Descriptor] PRIMARY KEY ([id])

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

>

  ];
 DescriptorInapplicability [

label=<

     //CONSTRAINT [PK_DescriptorInapplicability] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_DescriptorInapplicability_1] UNIQUE ([controlled_descriptor_id],[controlling_state_id])

DescriptorInapplicability
id
controlled_descriptor_id	ut_1
controlling_state_id	ut_1
rule

>

  ];
 DescriptorMapping_C2C [

label=<

     //CONSTRAINT [PK_DescriptorMapping_C2C] PRIMARY KEY ([id])

DescriptorMapping_C2C

id

from_state_id

to_state_id

>

  ];
 DescriptorMapping_Q2C [

label=<

     //CONSTRAINT [PK_DescriptorMapping_Q2C] PRIMARY KEY ([id])

DescriptorMapping_Q2C

id

from_descr_id

from_lowerbound

from_upperbound

from_statistical_measure_id

from_statmeas_class_TO_CONSIDER

to_state_id

>

  ];
 DescriptorStatusData [

label=<

     //CONSTRAINT [PK_DescriptorStatusData] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_DescriptorStatusData_1] UNIQUE ([description_id],[descriptor_id],[datastatus_id])

DescriptorStatusData
id
description_id	ut_1
descriptor_id	ut_1
datastatus_id	ut_1
notes

>

  ];
 DescriptorTree [

label=<

     //CONSTRAINT [PK_DescriptorTree] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_DescriptorTree_1] UNIQUE ([label])

DescriptorTree
id
is_complete
label	u
type
project_id

>

  ];
 DescriptorTreeNode [

label=<

     //CONSTRAINT [PK_DescriptorTreeNode] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_DescriptorTreeNode_1] UNIQUE ([descriptortree_id],[parent_node_id],[descriptor_id],[label])

DescriptorTreeNode
id
parent_node_id	ut_1
label	ut_1
abbreviation
display_order
descriptortree_id	ut_1
descriptor_id	ut_1

>

  ];
 DescriptorTreeNodeRecFrequency [

label=<

     //CONSTRAINT [PK_DescriptorTreeNodeRecFrequency] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_DescriptorTreeNodeRecFrequency_1] UNIQUE ([node_id],[frequency_id])

DescriptorTreeNodeRecFrequency
id
node_id	ut_1
frequency_id	ut_1

>

  ];
 DescriptorTreeNodeRecModifier [

label=<

     //CONSTRAINT [PK_DescriptorTreeNodeRecModifier] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_DescriptorTreeNodeRecModifier_1] UNIQUE ([node_id],[modifier_id])

DescriptorTreeNodeRecModifier
id
node_id	ut_1
modifier_id	ut_1

>

  ];
 DescriptorTreeNodeRecStatMeasure [

label=<

     //CONSTRAINT [PK_DescriptorTreeNodeRecStatMeasure] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_DescriptorTreeNodeRecStatMeasure_1] UNIQUE ([node_id],[measure_id])

DescriptorTreeNodeRecStatMeasure
id
node_id	ut_1
measure_id	ut_1

>

  ];
 Frequency [

label=<

     //CONSTRAINT [PK_Frequency] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_Frequency_1] UNIQUE ([label])

Frequency
id
label	u
lower_estimate
upper_estimate
display_order

>

  ];
 GeographicAreaProxy [

label=<

     //CONSTRAINT [PK_GeographicAreaProxy] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_GeographicAreaProxy_1] UNIQUE ([label])

GeographicAreaProxy
id
label	u

>

  ];
 GeographicArea_Taxon [

label=<

     //CONSTRAINT [PK_GeographicArea_Taxon] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_GeographicArea_Taxon_1] UNIQUE ([geographicarea_id],[taxon_id])

GeographicArea_Taxon
id
geographicarea_id	ut_1
taxon_id	ut_1

>

  ];
 Identifier [

label=<

     //CONSTRAINT [PK_Identifier] PRIMARY KEY ([uri])

Identifier

object_id

uri

match

>

  ];
 Modifier [

label=<

     //CONSTRAINT [PK_Modifier] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_Modifier_1] UNIQUE ([label])

Modifier
id
class
label	u
display_order

>

  ];
 ObservationProxy [

label=<

     //CONSTRAINT [PK_ObservationProxy] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_ObservationProxy_1] UNIQUE ([label])

ObservationProxy
id
label	u

>

  ];
 OrganismRelationData [

label=<

     //CONSTRAINT [PK_OrganismRelationData] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_OrganismRelationData_1] UNIQUE ([description_id],[taxon_id],[modifier_id],[frequency_id])

OrganismRelationData
id
description_id	ut_1
taxon_id	ut_1
notes
modifier_id	ut_1
frequency_id	ut_1

>

  ];
 OtherScope [

label=<

     //CONSTRAINT [PK_OtherScope] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_OtherScope_1] UNIQUE ([label])

OtherScope
id
label	u
detail
type
sex_status_id

>

  ];
 Project [

label=<

     //CONSTRAINT [PK_Project] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_Project_1] UNIQUE ([label])

Project
id
parent_project_id
label	u
rights_text
licence_uri
detail
restricted_to_descriptortree_id
restricted_to_taxonset_id
primary_language_code

>

  ];
 Project_AvailableScope [

label=<

     //CONSTRAINT [PK_Project_AvailableScope] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_Project_AvailableScope_1] UNIQUE ([project_id],[scope_id])

Project_AvailableScope
id
project_id	ut_1
scope_id	ut_1

>

  ];
 QuantitativeSamplingData [

label=<

     //CONSTRAINT [PK_QuantitativeSamplingData] PRIMARY KEY ([id])

QuantitativeSamplingData

id

measure_id

sampling_unit_id

descriptor_id

value

notes

modifier_id

>

  ];
 QuantitativeSummaryData [

label=<

     //CONSTRAINT [PK_QuantitativeSummaryData] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_QuantitativeSummaryData_1] UNIQUE ([description_id],[measure_id],[descriptor_id])

QuantitativeSummaryData
id
measure_id	ut_1
description_id	ut_1
descriptor_id	ut_1
value
notes
modifier_id

>

  ];
 ReferenceProxy [

label=<

     //CONSTRAINT [PK_ReferenceProxy] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_ReferenceProxy_1] UNIQUE ([label])

ReferenceProxy
id
label	u

>

  ];
 Resource [

label=<

     //CONSTRAINT [PK_Resource] PRIMARY KEY ([id])

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=<

     //CONSTRAINT [PK_ResourceVariant] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_ResourceVariant_1] UNIQUE ([resource_id],[variant_id])

ResourceVariant
id
resource_id	ut_1
variant_id	ut_1
url
pixel_width
pixel_height
duration
size
mime_type

>

  ];
 ResourceVariant_Enum [

label=<

     //CONSTRAINT [PK_ResourceVariant_Enum] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_ResourceVariant_Enum_1] UNIQUE ([label]),
     //CONSTRAINT [UQ_ResourceVariant_Enum_2] UNIQUE ([code])

ResourceVariant_Enum
id
label	u
code	u
detail
quality_order

>

  ];
 SamplingEvent [

label=<

     //CONSTRAINT [PK_SamplingEvent] PRIMARY KEY ([id])

SamplingEvent

id

description_id

label

detail

date_time

datetimespan_end

geographic_area

coord_dec_latitude

coord_dec_longitude

coord_literal

coord_geodeticdatum

>

  ];
 SamplingUnit [

label=<

     //CONSTRAINT [PK_SamplingUnit] PRIMARY KEY ([id])

SamplingUnit

id

sampling_event_id

>

  ];
 SexStatus_Enum [

label=<

     //CONSTRAINT [PK_SexStatus_Enum] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_SexStatus_Enum_1] UNIQUE ([label]),
     //CONSTRAINT [UQ_SexStatus_Enum_2] UNIQUE ([code])

SexStatus_Enum
id
label	u
code	u
abbreviation
detail
display_order

>

  ];
 SpecimenProxy [

label=<

u

     //CONSTRAINT [PK_SpecimenProxy] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_SpecimenProxy_1] UNIQUE ([label])

SpecimenProxy

id

label

>

  ];
 StatisticalMeasure_Enum [

label=<

     //CONSTRAINT [PK_StatisticalMeasure_Enum] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_StatisticalMeasure_Enum_1] UNIQUE ([label]),
     //CONSTRAINT [UQ_StatisticalMeasure_Enum_2] UNIQUE ([code])

StatisticalMeasure_Enum
id
label	u
code	u
abbreviation
display_order

>

  ];
 Tag [

label=<

     //CONSTRAINT [PK_Tag] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_Tag_1] UNIQUE ([tag],[object_id])

Tag
id
tag	ut_1
object_id	ut_1

>

  ];
 TaxonProxy [

label=<

     //CONSTRAINT [PK_TaxonProxy] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_TaxonProxy_1] UNIQUE ([label]),
     //CONSTRAINT [UQ_TaxonProxy_2] UNIQUE ([name],[kingdom],[project_id])

TaxonProxy
id
label	u
name	ut_1
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	ut_1
phylum_or_division
class
subclass
order
suborder
family
subfamily
project_id	ut_1

>

  ];
 TaxonRank_Enum [

label=<

     //CONSTRAINT [PK_TaxonRank_Enum] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_TaxonRank_Enum_1] UNIQUE ([label]),
     //CONSTRAINT [UQ_TaxonRank_Enum_2] UNIQUE ([code])

TaxonRank_Enum
id
label	u
code	u
abbreviation
detail

>

  ];
 TaxonSet [

label=<

     //CONSTRAINT [PK_TaxonSet] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_TaxonSet_1] UNIQUE ([label])

TaxonSet
id
label	u
default_set
project_id

>

  ];
 TaxonSet_Taxon [

label=<

     //CONSTRAINT [PK_TaxonSet_Taxon] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_TaxonSet_Taxon_1] UNIQUE ([taxonset_id],[taxon_id])

TaxonSet_Taxon
id
taxonset_id	ut_1
taxon_id	ut_1

>

  ];
 TextDescriptorData [

label=<

     //CONSTRAINT [PK_TextDescriptorData] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_TextDescriptorData_1] UNIQUE ([description_id],[descriptor_id])

TextDescriptorData
id
description_id	ut_1
descriptor_id	ut_1
content
notes

>

  ];
 TextSamplingData [

label=<

     //CONSTRAINT [PK_TextSamplingData] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_TextSamplingData_1] UNIQUE ([sampling_unit_id],[descriptor_id])

TextSamplingData
id
sampling_unit_id	ut_1
descriptor_id	ut_1
content
notes

>

  ];
 TODO_MultilingualCharDataNotes [

label=<

     //CONSTRAINT [PK_TODO_MultilingualCharDataNotes] PRIMARY KEY ([table_is_just_a_note_-_Work_needs_to_be_done])

TODO_MultilingualCharDataNotes

table_is_just_a_note_-_Work_needs_to_be_done

memo_char_and_taxon_notes_is_already_redundant_due_to_annotation

memo_char_data_are_not_an_object_thus_not_annotated

>

  ];
 Translation [

label=<

     //CONSTRAINT [PK_Translation] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_Translation_1] UNIQUE ([object_id],[language_code],[column_id])

Translation
id
object_id	ut_1
language_code	ut_1
column_id	ut_1
contents

>

  ];
 TranslationColumn_Enum [

label=<

     //CONSTRAINT [PK_TranslationColumn_Enum] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_TranslationColumn_Enum_1] UNIQUE ([column])

TranslationColumn_Enum
id
column	u

>

  ];
 ProjectProxy [

label=<

     //CONSTRAINT [PK_DiversityProjectProxy] PRIMARY KEY CLUSTERED ([ProjectID] ASC) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]

ProjectProxy

ProjectID

Project

ProjectURI

>

  ];
 UserProxy [

label=<

     //CONSTRAINT [PK_UserProxy] PRIMARY KEY CLUSTERED ([LoginName] ASC) WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]

UserProxy

LoginName

CombinedNameCache

AgentURI

Queries

>

  ];
 ProjectUser [

label=<

     //CONSTRAINT [PK_ProjectUser] PRIMARY KEY CLUSTERED ([LoginName] ASC, [ProjectID])WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]

ProjectUser

LoginName

ProjectID

ReadOnly

>

  ];

 BaseEntity:id -> Annotation:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> CategoricalState:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> Contribution:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> DataStatus_Enum:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> Description:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> Descriptor:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> DescriptorTree:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> DescriptorTreeNode:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> Frequency:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> GeographicAreaProxy:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> Identifier:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> Modifier:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> ObservationProxy:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> OtherScope:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> Project:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> ReferenceProxy:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> Resource:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> ResourceVariant_Enum:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> SexStatus_Enum:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> SpecimenProxy:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> StatisticalMeasure_Enum:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> Tag:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> TaxonProxy:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> TaxonRank_Enum:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> TaxonSet:id[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id -> Translation:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
 BaseEntityTable_Enum:id -> BaseEntity:table_id;
 CategoricalState:id -> CategoricalSamplingData:state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 CategoricalState:id -> CategoricalSummaryData:state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 CategoricalState:id -> DescriptorInapplicability:controlling_state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 CategoricalState:id -> DescriptorMapping_C2C:from_state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 CategoricalState:id -> DescriptorMapping_Q2C:to_state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 CategoricalState:id -> Resource:state_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Contributor:id -> Annotation:contributor_id;
 Contributor:id -> Contribution:contributor_id;
 DataStatus_Enum:id -> DescriptorStatusData:datastatus_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Description:id -> CategoricalSummaryData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
 Description:id -> DescriptionScope:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
 Description:id -> DescriptorStatusData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
 Description:id -> OrganismRelationData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
 Description:id -> QuantitativeSummaryData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
 Description:id -> Resource:description_id[label="DELETE SET NULL" fontsize=10 color="#00c900" fontcolor="#00c900"];
 Description:id -> SamplingEvent:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
 Description:id -> TextDescriptorData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
 Descriptor:id -> CategoricalState:descriptor_id[color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id -> DescriptorInapplicability:controlled_descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id -> DescriptorMapping_Q2C:from_descr_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id -> DescriptorStatusData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id -> DescriptorTreeNode:descriptor_id[color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id -> QuantitativeSamplingData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id -> QuantitativeSummaryData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id -> Resource:descriptor_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id -> TextDescriptorData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id -> TextSamplingData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 DescriptorTree:id -> DescriptorTreeNode:descriptortree_id[color="#CC0033" fontcolor="#CC0033"];
 DescriptorTree:id -> Project:restricted_to_descriptortree_id[label="DELETE SET NULL" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
 DescriptorTreeNode:id -> DescriptorTreeNodeRecFrequency:node_id[label="DELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
 DescriptorTreeNode:id -> DescriptorTreeNodeRecModifier:node_id[label="DELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
 DescriptorTreeNode:id -> DescriptorTreeNodeRecStatMeasure:node_id[label="DELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
 DescriptorTreeNode:id:w -> DescriptorTreeNode:parent_node_id:w[color="#CC0033" fontcolor="#CC0033"];
 Frequency:id -> CategoricalSummaryData:frequency_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Frequency:id -> DescriptorTreeNodeRecFrequency:frequency_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Frequency:id -> OrganismRelationData:frequency_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 GeographicAreaProxy:id -> DescriptionScope:geographicarea_id[label="DELETE CASCADE" fontsize=10];
 GeographicAreaProxy:id -> GeographicArea_Taxon:geographicarea_id[label="DELETE CASCADE" fontsize=10];
 Modifier:id -> CategoricalSamplingData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Modifier:id -> CategoricalSummaryData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Modifier:id -> DescriptorTreeNodeRecModifier:modifier_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Modifier:id -> OrganismRelationData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Modifier:id -> QuantitativeSamplingData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Modifier:id -> QuantitativeSummaryData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 ObservationProxy:id -> DescriptionScope:observation_id[label="DELETE CASCADE" fontsize=10];
 OtherScope:id -> DescriptionScope:other_scope_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 OtherScope:id -> Project_AvailableScope:scope_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 OtherScope:id -> Resource:scope_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817" style="dashed"];
 Project:id -> Description:project_id[color="#CC0033" fontcolor="#CC0033"];
 Project:id -> DescriptorTree:project_id[color="#CC0033" fontcolor="#CC0033"];
 Project:id -> Project_AvailableScope:project_id[label="DELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
 Project:id -> TaxonProxy:project_id[color="#CC0033" fontcolor="#CC0033"];
 Project:id -> TaxonSet:project_id[color="#CC0033" fontcolor="#CC0033"];
 Project:id:w -> Project:parent_project_id:w[color="#CC0033" fontcolor="#CC0033"];
 ProjectProxy:ProjectID -> Project:ProjectProxyID[label="DELETE SET DEFAULT" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
 ProjectProxy:ProjectID -> ProjectUser:ProjectID[label="UPDATE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
 ReferenceProxy:id -> DescriptionScope:source_reference_id[label="DELETE CASCADE" fontsize=10];
 Resource:id -> ResourceVariant:resource_id[label="DELETE CASCADE" fontsize=10];
 ResourceVariant_Enum:id -> ResourceVariant:variant_id[label="DELETE CASCADE" fontsize=10];
 SamplingEvent:id -> SamplingUnit:sampling_event_id[label="DELETE CASCADE" fontsize=10];
 SamplingUnit:id -> CategoricalSamplingData:sampling_unit_id[label="DELETE CASCADE" fontsize=10];
 SamplingUnit:id -> QuantitativeSamplingData:sampling_unit_id[label="DELETE CASCADE" fontsize=10];
 SamplingUnit:id -> TextSamplingData:sampling_unit_id[label="DELETE CASCADE" fontsize=10];
 SexStatus_Enum:id -> OtherScope:sex_status_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 SpecimenProxy:id -> DescriptionScope:specimen_id[label="DELETE CASCADE" fontsize=10];
 StatisticalMeasure_Enum:id -> DescriptorMapping_Q2C:from_statistical_measure_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 StatisticalMeasure_Enum:id -> DescriptorTreeNodeRecStatMeasure:measure_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 StatisticalMeasure_Enum:id -> QuantitativeSamplingData:measure_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 StatisticalMeasure_Enum:id -> QuantitativeSummaryData:measure_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 TaxonProxy:id -> DescriptionScope:taxon_id[label="DELETE CASCADE" fontsize=10];
 TaxonProxy:id -> GeographicArea_Taxon:taxon_id[label="DELETE CASCADE" fontsize=10];
 TaxonProxy:id -> OrganismRelationData:taxon_id[label="DELETE CASCADE" fontsize=10];
 TaxonProxy:id -> Resource:taxon_id[label="DELETE SET NULL" fontsize=10];
 TaxonProxy:id -> TaxonSet_Taxon:taxon_id[label="DELETE CASCADE" fontsize=10];
 TaxonRank_Enum:id -> TaxonProxy:rank_id;
 TaxonSet:id -> Project:restricted_to_taxonset_id[label="DELETE SET NULL" fontsize=10];
 TaxonSet:id -> TaxonSet_Taxon:taxonset_id[label="DELETE CASCADE" fontsize=10];
 TranslationColumn_Enum:id -> Translation:column_id;
 UserProxy:LoginName -> ProjectUser:LoginName[label="UPDATE CASCADE\nDELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];

} </graphviz>

Unklare oder Fehlende Beziehungen

• Resource.scope_id → OtherScope.id ? --Andreas Plank (Diskussion) 16:35, 31. Jul. 2014 (CEST)
• DescriptorMapping_C2C.to_state_id → CategoricalState.id ? --Andreas Plank (Diskussion) 18:20, 31. Jul. 2014 (CEST)

Fragen

• Resource.label soll Text sein kein nvarchar(255)? Wegen label=caption ws. besser Text --Andreas Plank (Diskussion) 18:00, 30. Jul. 2014 (CEST)