Zum Inhalt springen

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

Aus Flora von Bayern
← Zum vorherigen VersionsunterschiedZum nächsten Versionsunterschied →
imported>Andreas Plank
KKeine Bearbeitungszusammenfassung
imported>Andreas Plank
KKeine Bearbeitungszusammenfassung
Zeile 9: Zeile 9:
   edge [color = "black" arrowhead="dot"];   
   edge [color = "black" arrowhead="dot"];   
   Legend [
   Legend [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0">
       <tr><td COLOR="white"><font face="bold">Legend</font></td></tr>
       <tr><td COLOR="white"><font face="bold">Legend</font></td></tr>
       <tr><td BGCOLOR="#ef6a6a" COLOR="#ef6a6a">Project specific settings</td></tr>
       <tr><td BGCOLOR="#ef6a6a" COLOR="#ef6a6a">Project specific settings</td></tr>
Zeile 25: Zeile 25:


digraph DD_Quiz_Scheme_20140717{
digraph DD_Quiz_Scheme_20140717{
   graph [rankdir = "LR" splines="curved"];
   graph [rankdir = "LR" splines="line" outputorder="edgesfirst"];
   node [fontsize = "10", shape = "plaintext"];
   node [fontsize = "10", shape = "plaintext"];
   edge [color = "black" arrowhead="dot"];   
   edge [color = "black" arrowhead="dot"];   


   Annotation [
   Annotation [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="1">Annotation</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="1">Annotation</td></tr>
       <tr><td PORT="id">id</td></tr>
       <tr><td PORT="id">id</td></tr>
Zeile 45: Zeile 45:
   ];
   ];
   BaseEntity [
   BaseEntity [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" >BaseEntity</td></tr>
       <tr><td BGCOLOR="lightblue" >BaseEntity</td></tr>
       <tr><td PORT="id">id</td></tr>
       <tr><td PORT="id">id</td></tr>
Zeile 55: Zeile 55:
   ];
   ];
   BaseEntityTable_Enum [
   BaseEntityTable_Enum [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="2">BaseEntityTable_Enum</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="2">BaseEntityTable_Enum</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 64: Zeile 64:
   ];
   ];
   CategoricalSamplingData [
   CategoricalSamplingData [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="2">CategoricalSamplingData</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="2">CategoricalSamplingData</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 77: Zeile 77:
   ];
   ];
   CategoricalState [
   CategoricalState [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#e5c96a" colspan="2">CategoricalState</td></tr>
       <tr><td BGCOLOR="#e5c96a" colspan="2">CategoricalState</td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
Zeile 91: Zeile 91:
   ];
   ];
   CategoricalSummaryData [
   CategoricalSummaryData [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#00c900" colspan="2">CategoricalSummaryData</td></tr>
       <tr><td BGCOLOR="#00c900" colspan="2">CategoricalSummaryData</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 104: Zeile 104:
   ];
   ];
   Contribution [
   Contribution [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="1">Contribution</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="1">Contribution</td></tr>
       <tr><td PORT="id">id</td></tr>
       <tr><td PORT="id">id</td></tr>
Zeile 115: Zeile 115:
   ];
   ];
   Contributor [
   Contributor [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="2">Contributor</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="2">Contributor</td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
Zeile 128: Zeile 128:
   ];
   ];
   DataStatus_Enum [
   DataStatus_Enum [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#e5c96a" colspan="2">DataStatus_Enum</td></tr>
       <tr><td BGCOLOR="#e5c96a" colspan="2">DataStatus_Enum</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 142: Zeile 142:
   ];
   ];
   Description [
   Description [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#00c900" colspan="1">Description</td></tr>
       <tr><td BGCOLOR="#00c900" colspan="1">Description</td></tr>
       <tr><td PORT="id">id</td></tr>
       <tr><td PORT="id">id</td></tr>
Zeile 152: Zeile 152:
   ];
   ];
   DescriptionScope [
   DescriptionScope [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#00c900" colspan="1">DescriptionScope</td></tr>
       <tr><td BGCOLOR="#00c900" colspan="1">DescriptionScope</td></tr>
       <tr><td PORT="id">id</td></tr>
       <tr><td PORT="id">id</td></tr>
Zeile 169: Zeile 169:
   ];
   ];
   Descriptor [
   Descriptor [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#e5c96a">Descriptor</td></tr>
       <tr><td BGCOLOR="#e5c96a">Descriptor</td></tr>
       <tr><td PORT="id">id</td></tr>
       <tr><td PORT="id">id</td></tr>
Zeile 194: Zeile 194:
   ];
   ];
   DescriptorInapplicability [
   DescriptorInapplicability [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#e5c96a" colspan="2">DescriptorInapplicability</td></tr>
       <tr><td BGCOLOR="#e5c96a" colspan="2">DescriptorInapplicability</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 205: Zeile 205:
   ];
   ];
   DescriptorMapping_C2C [
   DescriptorMapping_C2C [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#e5c96a" colspan="1">DescriptorMapping_C2C</td></tr>
       <tr><td BGCOLOR="#e5c96a" colspan="1">DescriptorMapping_C2C</td></tr>
       <tr><td PORT="id">id</td></tr>
       <tr><td PORT="id">id</td></tr>
Zeile 214: Zeile 214:
   ];
   ];
   DescriptorMapping_Q2C [
   DescriptorMapping_Q2C [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#e5c96a" colspan="1">DescriptorMapping_Q2C</td></tr>
       <tr><td BGCOLOR="#e5c96a" colspan="1">DescriptorMapping_Q2C</td></tr>
       <tr><td PORT="id">id</td></tr>
       <tr><td PORT="id">id</td></tr>
Zeile 227: Zeile 227:
   ];
   ];
   DescriptorStatusData [
   DescriptorStatusData [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#e5c96a" colspan="2">DescriptorStatusData</td></tr>
       <tr><td BGCOLOR="#e5c96a" colspan="2">DescriptorStatusData</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 239: Zeile 239:
   ];
   ];
   DescriptorTree [
   DescriptorTree [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#ef6a6a" colspan="2">DescriptorTree</td></tr>
       <tr><td BGCOLOR="#ef6a6a" colspan="2">DescriptorTree</td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
Zeile 251: Zeile 251:
   ];
   ];
   DescriptorTreeNode [
   DescriptorTreeNode [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#ef6a6a" colspan="2">DescriptorTreeNode</td></tr>
       <tr><td BGCOLOR="#ef6a6a" colspan="2">DescriptorTreeNode</td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
Zeile 265: Zeile 265:
   ];
   ];
   DescriptorTreeNodeRecFrequency [
   DescriptorTreeNodeRecFrequency [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#ef6a6a" colspan="2">DescriptorTreeNodeRecFrequency</td></tr>
       <tr><td BGCOLOR="#ef6a6a" colspan="2">DescriptorTreeNodeRecFrequency</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 275: Zeile 275:
   ];
   ];
   DescriptorTreeNodeRecModifier [
   DescriptorTreeNodeRecModifier [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#ef6a6a" colspan="2">DescriptorTreeNodeRecModifier</td></tr>
       <tr><td BGCOLOR="#ef6a6a" colspan="2">DescriptorTreeNodeRecModifier</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 285: Zeile 285:
   ];
   ];
   DescriptorTreeNodeRecStatMeasure [
   DescriptorTreeNodeRecStatMeasure [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#ef6a6a" colspan="2">DescriptorTreeNodeRecStatMeasure</td></tr>
       <tr><td BGCOLOR="#ef6a6a" colspan="2">DescriptorTreeNodeRecStatMeasure</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 295: Zeile 295:
   ];
   ];
   Frequency [
   Frequency [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#e5c96a" colspan="2">Frequency</td></tr>
       <tr><td BGCOLOR="#e5c96a" colspan="2">Frequency</td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
Zeile 307: Zeile 307:
   ];
   ];
   GeographicAreaProxy [
   GeographicAreaProxy [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="2">GeographicAreaProxy</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="2">GeographicAreaProxy</td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
Zeile 316: Zeile 316:
   ];
   ];
   GeographicArea_Taxon [
   GeographicArea_Taxon [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="2">GeographicArea_Taxon</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="2">GeographicArea_Taxon</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 326: Zeile 326:
   ];
   ];
   Identifier [
   Identifier [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="1">Identifier</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="1">Identifier</td></tr>
       <tr><td PORT="object_id">object_id</td></tr>
       <tr><td PORT="object_id">object_id</td></tr>
Zeile 335: Zeile 335:
   ];
   ];
   Modifier [
   Modifier [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#e5c96a" colspan="2">Modifier</td></tr>
       <tr><td BGCOLOR="#e5c96a" colspan="2">Modifier</td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
Zeile 346: Zeile 346:
   ];
   ];
   ObservationProxy [
   ObservationProxy [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="2">ObservationProxy</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="2">ObservationProxy</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 355: Zeile 355:
   ];
   ];
   OrganismRelationData [
   OrganismRelationData [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="2">OrganismRelationData</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="2">OrganismRelationData</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 368: Zeile 368:
   ];
   ];
   OtherScope [
   OtherScope [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#e5c96a" colspan="2">OtherScope</td></tr>
       <tr><td BGCOLOR="#e5c96a" colspan="2">OtherScope</td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
Zeile 380: Zeile 380:
   ];
   ];
   Project [
   Project [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#ef6a6a" colspan="2">Project</td></tr>
       <tr><td BGCOLOR="#ef6a6a" colspan="2">Project</td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
Zeile 397: Zeile 397:
   ];
   ];
   Project_AvailableScope [
   Project_AvailableScope [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#ef6a6a" colspan="2">Project_AvailableScope</td></tr>
       <tr><td BGCOLOR="#ef6a6a" colspan="2">Project_AvailableScope</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 407: Zeile 407:
   ];
   ];
   QuantitativeSamplingData [
   QuantitativeSamplingData [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="1">QuantitativeSamplingData</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="1">QuantitativeSamplingData</td></tr>
       <tr><td PORT="id">id</td></tr>
       <tr><td PORT="id">id</td></tr>
Zeile 420: Zeile 420:
   ];
   ];
   QuantitativeSummaryData [
   QuantitativeSummaryData [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#00c900" colspan="2">QuantitativeSummaryData</td></tr>
       <tr><td BGCOLOR="#00c900" colspan="2">QuantitativeSummaryData</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 434: Zeile 434:
   ];
   ];
   ReferenceProxy [
   ReferenceProxy [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="2">ReferenceProxy</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="2">ReferenceProxy</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 443: Zeile 443:
   ];
   ];
   Resource [
   Resource [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="blue" colspan="1"><font COLOR="white">Resource</font></td></tr>
       <tr><td BGCOLOR="blue" colspan="1"><font COLOR="white">Resource</font></td></tr>
       <tr><td PORT="id">id</td></tr>
       <tr><td PORT="id">id</td></tr>
Zeile 463: Zeile 463:
   ];
   ];
   ResourceVariant [
   ResourceVariant [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="blue" colspan="2"><font COLOR="white">ResourceVariant</font></td></tr>
       <tr><td BGCOLOR="blue" colspan="2"><font COLOR="white">ResourceVariant</font></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 479: Zeile 479:
   ];
   ];
   ResourceVariant_Enum [
   ResourceVariant_Enum [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="blue" colspan="2"><font COLOR="white">ResourceVariant_Enum</font></td></tr>
       <tr><td BGCOLOR="blue" colspan="2"><font COLOR="white">ResourceVariant_Enum</font></td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
Zeile 492: Zeile 492:
   ];
   ];
   SamplingEvent [
   SamplingEvent [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="1">SamplingEvent</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="1">SamplingEvent</td></tr>
       <tr><td PORT="id">id</td></tr>
       <tr><td PORT="id">id</td></tr>
Zeile 509: Zeile 509:
   ];
   ];
   SamplingUnit [
   SamplingUnit [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="1">SamplingUnit</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="1">SamplingUnit</td></tr>
       <tr><td PORT="id">id</td></tr>
       <tr><td PORT="id">id</td></tr>
Zeile 517: Zeile 517:
   ];
   ];
   SexStatus_Enum [
   SexStatus_Enum [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#e5c96a" colspan="2">SexStatus_Enum</td></tr>
       <tr><td BGCOLOR="#e5c96a" colspan="2">SexStatus_Enum</td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
Zeile 531: Zeile 531:
   ];
   ];
   SpecimenProxy [
   SpecimenProxy [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="1">SpecimenProxy</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="1">SpecimenProxy</td></tr>
       <tr><td PORT="id">id</td></tr>
       <tr><td PORT="id">id</td></tr>
Zeile 540: Zeile 540:
   ];
   ];
   StatisticalMeasure_Enum [
   StatisticalMeasure_Enum [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#e5c96a" colspan="2">StatisticalMeasure_Enum</td></tr>
       <tr><td BGCOLOR="#e5c96a" colspan="2">StatisticalMeasure_Enum</td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
Zeile 553: Zeile 553:
   ];
   ];
   Tag [
   Tag [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="2">Tag</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="2">Tag</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 563: Zeile 563:
   ];
   ];
   TaxonProxy [
   TaxonProxy [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="2">TaxonProxy</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="2">TaxonProxy</td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
Zeile 595: Zeile 595:
   ];
   ];
   TaxonRank_Enum [
   TaxonRank_Enum [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="2">TaxonRank_Enum</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="2">TaxonRank_Enum</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
       <tr><td PORT="label">label</td><td>u</td></tr>
       <tr><td PORT="label">label</td><td PORT="label_e">u</td></tr>
       <tr><td PORT="code">code</td><td>u</td></tr>
       <tr><td PORT="code">code</td><td PORT="code_e">u</td></tr>
       <tr><td PORT="abbreviation">abbreviation</td><td></td></tr>
       <tr><td PORT="abbreviation">abbreviation</td><td PORT="abbreviation_e"></td></tr>
       <tr><td PORT="detail">detail</td><td></td></tr>
       <tr><td PORT="detail">detail</td><td PORT="detail_e"></td></tr>
       //CONSTRAINT [PK_TaxonRank_Enum] PRIMARY KEY ([id]),
       //CONSTRAINT [PK_TaxonRank_Enum] PRIMARY KEY ([id]),
       //CONSTRAINT [UQ_TaxonRank_Enum_1] UNIQUE ([label]),
       //CONSTRAINT [UQ_TaxonRank_Enum_1] UNIQUE ([label]),
Zeile 608: Zeile 608:
   ];
   ];
   TaxonSet [
   TaxonSet [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="2">TaxonSet</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="2">TaxonSet</td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
Zeile 619: Zeile 619:
   ];
   ];
   TaxonSet_Taxon [
   TaxonSet_Taxon [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="2">TaxonSet_Taxon</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="2">TaxonSet_Taxon</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 629: Zeile 629:
   ];
   ];
   TextDescriptorData [
   TextDescriptorData [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#00c900" colspan="2">TextDescriptorData</td></tr>
       <tr><td BGCOLOR="#00c900" colspan="2">TextDescriptorData</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 641: Zeile 641:
   ];
   ];
   TextSamplingData [
   TextSamplingData [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="2">TextSamplingData</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="2">TextSamplingData</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 653: Zeile 653:
   ];
   ];
   TODO_MultilingualCharDataNotes [
   TODO_MultilingualCharDataNotes [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="1">TODO_MultilingualCharDataNotes</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="1">TODO_MultilingualCharDataNotes</td></tr>
       <tr><td PORT="table_is_just_a_note_-_Work_needs_to_be_done">table_is_just_a_note_-_Work_needs_to_be_done</td></tr>
       <tr><td PORT="table_is_just_a_note_-_Work_needs_to_be_done">table_is_just_a_note_-_Work_needs_to_be_done</td></tr>
Zeile 662: Zeile 662:
   ];
   ];
   Translation [
   Translation [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="2">Translation</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="2">Translation</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 674: Zeile 674:
   ];
   ];
   TranslationColumn_Enum [
   TranslationColumn_Enum [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="lightblue" colspan="2">TranslationColumn_Enum</td></tr>
       <tr><td BGCOLOR="lightblue" colspan="2">TranslationColumn_Enum</td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
       <tr><td PORT="id">id</td><td PORT="id_e"></td></tr>
Zeile 683: Zeile 683:
   ];
   ];
   ProjectProxy [
   ProjectProxy [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#ef6a6a" colspan="1">ProjectProxy</td></tr>
       <tr><td BGCOLOR="#ef6a6a" colspan="1">ProjectProxy</td></tr>
       <tr><td PORT="ProjectID">ProjectID</td></tr>
       <tr><td PORT="ProjectID">ProjectID</td></tr>
Zeile 692: Zeile 692:
   ];
   ];
   UserProxy [
   UserProxy [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#ef6a6a" colspan="1">UserProxy</td></tr>
       <tr><td BGCOLOR="#ef6a6a" colspan="1">UserProxy</td></tr>
       <tr><td PORT="LoginName">LoginName</td></tr>
       <tr><td PORT="LoginName">LoginName</td></tr>
Zeile 702: Zeile 702:
   ];
   ];
   ProjectUser [
   ProjectUser [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#ef6a6a" colspan="1">ProjectUser</td></tr>
       <tr><td BGCOLOR="#ef6a6a" colspan="1">ProjectUser</td></tr>
       <tr><td PORT="LoginName">LoginName</td></tr>
       <tr><td PORT="LoginName">LoginName</td></tr>
Zeile 712: Zeile 712:


   TaxonQuiz [
   TaxonQuiz [
     label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
     label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
       <tr><td BGCOLOR="#ef6a6a" colspan="2">TaxonQuiz</td></tr>
       <tr><td BGCOLOR="#ef6a6a" colspan="2">TaxonQuiz</td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
       <tr><td PORT="id">id</td><td></td></tr>
Zeile 723: Zeile 723:
   ];
   ];


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

Version vom 11. August 2014, 16:10 Uhr

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" splines="line" outputorder="edgesfirst"];
 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
tableu

> 

  ];
 CategoricalSamplingData [

label=<

     //CONSTRAINT [PK_CategoricalSamplingData] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_CategoricalSamplingData_1] UNIQUE ([sampling_unit_id],[state_id],[modifier_id])
CategoricalSamplingData
id
sampling_unit_idut_1
state_idut_1
notes
modifier_idut_1
frequency_value

> 

  ];
 CategoricalState [

label=<

     //CONSTRAINT [PK_CategoricalState] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_CategoricalState_1] UNIQUE ([label],[descriptor_id])
CategoricalState
id
descriptor_idut_1
labelut_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_idut_1
state_idut_1
notes
modifier_idut_1
frequency_idut_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
emailu
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
labelu
codeu
abbreviationu
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_idut_1
controlling_state_idut_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_idut_1
descriptor_idut_1
datastatus_idut_1
notes

> 

  ];
 DescriptorTree [

label=<

     //CONSTRAINT [PK_DescriptorTree] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_DescriptorTree_1] UNIQUE ([label])
DescriptorTree
id
is_complete
labelu
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_idut_1
labelut_1
abbreviation
display_order
descriptortree_idut_1
descriptor_idut_1

> 

  ];
 DescriptorTreeNodeRecFrequency [

label=<

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

> 

  ];
 DescriptorTreeNodeRecModifier [

label=<

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

> 

  ];
 DescriptorTreeNodeRecStatMeasure [

label=<

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

> 

  ];
 Frequency [

label=<

     //CONSTRAINT [PK_Frequency] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_Frequency_1] UNIQUE ([label])
Frequency
id
labelu
lower_estimate
upper_estimate
display_order

> 

  ];
 GeographicAreaProxy [

label=<

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

> 

  ];
 GeographicArea_Taxon [

label=<

     //CONSTRAINT [PK_GeographicArea_Taxon] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_GeographicArea_Taxon_1] UNIQUE ([geographicarea_id],[taxon_id])
GeographicArea_Taxon
id
geographicarea_idut_1
taxon_idut_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
labelu
display_order

> 

  ];
 ObservationProxy [

label=<

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

> 

  ];
 OrganismRelationData [

label=<

     //CONSTRAINT [PK_OrganismRelationData] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_OrganismRelationData_1] UNIQUE ([description_id],[taxon_id],[modifier_id],[frequency_id])
OrganismRelationData
id
description_idut_1
taxon_idut_1
notes
modifier_idut_1
frequency_idut_1

> 

  ];
 OtherScope [

label=<

     //CONSTRAINT [PK_OtherScope] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_OtherScope_1] UNIQUE ([label])
OtherScope
id
labelu
detail
type
sex_status_id

> 

  ];
 Project [

label=<

     //CONSTRAINT [PK_Project] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_Project_1] UNIQUE ([label])
Project
id
parent_project_id
labelu
rights_text
licence_uri
detail
restricted_to_descriptortree_id
restricted_to_taxonset_id
primary_language_code
ProjectProxyID

> 

  ];
 Project_AvailableScope [

label=<

     //CONSTRAINT [PK_Project_AvailableScope] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_Project_AvailableScope_1] UNIQUE ([project_id],[scope_id])
Project_AvailableScope
id
project_idut_1
scope_idut_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_idut_1
description_idut_1
descriptor_idut_1
value
notes
modifier_id

> 

  ];
 ReferenceProxy [

label=<

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

> 

  ];
 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_idut_1
variant_idut_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
labelu
codeu
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
labelu
codeu
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
labelu
codeu
abbreviation
display_order

> 

  ];
 Tag [

label=<

     //CONSTRAINT [PK_Tag] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_Tag_1] UNIQUE ([tag],[object_id])
Tag
id
tagut_1
object_idut_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
labelu
nameut_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
kingdomut_1
phylum_or_division
class
subclass
order
suborder
family
subfamily
project_idut_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
labelu
codeu
abbreviation
detail

> 

  ];
 TaxonSet [

label=<

     //CONSTRAINT [PK_TaxonSet] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_TaxonSet_1] UNIQUE ([label])
TaxonSet
id
labelu
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_idut_1
taxon_idut_1

> 

  ];
 TextDescriptorData [

label=<

     //CONSTRAINT [PK_TextDescriptorData] PRIMARY KEY ([id]),
     //CONSTRAINT [UQ_TextDescriptorData_1] UNIQUE ([description_id],[descriptor_id])
TextDescriptorData
id
description_idut_1
descriptor_idut_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_idut_1
descriptor_idut_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_idut_1
language_codeut_1
column_idut_1
contents

> 

  ];
 TranslationColumn_Enum [

label=<

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

> 

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

> 

  ];

 TaxonQuiz [

label=<

TaxonQuiz
id
project_idut_1
taxon_idut_1
contributor_idut_1
points
success

> 

  ];

 BaseEntity:id:e -> Annotation:object_id:w[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> CategoricalState:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> Contribution:object_id:w[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> DataStatus_Enum:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> Description:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> Descriptor:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> DescriptorTree:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> DescriptorTreeNode:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> Frequency:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> GeographicAreaProxy:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> Identifier:object_id:w[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> Modifier:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> ObservationProxy:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> OtherScope:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> Project:id:w[color="#0069ba" fontcolor="#0069ba" headlabel="1" arrowhead="none"];
 BaseEntity:id:e -> ReferenceProxy:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> Resource:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> ResourceVariant_Enum:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> SexStatus_Enum:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> SpecimenProxy:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> StatisticalMeasure_Enum:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> Tag:object_id:w[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> TaxonProxy:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> TaxonRank_Enum:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> TaxonSet:id:w[color="#0069ba" fontcolor="#0069ba"];
 BaseEntity:id:e -> Translation:object_id:w[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
 BaseEntityTable_Enum:id -> BaseEntity:table_id;
 CategoricalState:id_e:e -> CategoricalSamplingData:state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 CategoricalState:id_e:e -> CategoricalSummaryData:state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 CategoricalState:id_e:e -> DescriptorInapplicability:controlling_state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 CategoricalState:id_e:e -> DescriptorMapping_C2C:from_state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 CategoricalState:id_e:e -> DescriptorMapping_C2C:to_state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817" style="dashed"];
 CategoricalState:id_e:e -> DescriptorMapping_Q2C:to_state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 CategoricalState:id_e:e -> Resource:state_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Contributor:id_e:e -> Annotation:contributor_id;
 Contributor:id_e:e -> Contribution:contributor_id;
 DataStatus_Enum:id -> DescriptorStatusData:datastatus_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Description:id:e -> CategoricalSummaryData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
 Description:id:e -> DescriptionScope:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
 Description:id:e -> DescriptorStatusData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
 Description:id:e -> OrganismRelationData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
 Description:id:e -> QuantitativeSummaryData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
 Description:id:e -> Resource:description_id[label="DELETE SET NULL" fontsize=10 color="#00c900" fontcolor="#00c900"];
 Description:id:e -> SamplingEvent:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
 Description:id:e -> TextDescriptorData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
 Descriptor:id:e -> CategoricalState:descriptor_id[color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id:e -> DescriptorInapplicability:controlled_descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id:e -> DescriptorMapping_Q2C:from_descr_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id:e -> DescriptorStatusData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id:e -> DescriptorTreeNode:descriptor_id[color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id:e -> QuantitativeSamplingData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id:e -> QuantitativeSummaryData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id:e -> Resource:descriptor_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id:e -> TextDescriptorData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Descriptor:id:e -> TextSamplingData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 DescriptorTree:id_e:e -> DescriptorTreeNode:descriptortree_id[color="#CC0033" fontcolor="#CC0033"];
 DescriptorTree:id_e:e -> Project:restricted_to_descriptortree_id[label="DELETE SET NULL" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
 DescriptorTreeNode:id_e:e -> DescriptorTreeNodeRecFrequency:node_id[label="DELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
 DescriptorTreeNode:id_e:e -> DescriptorTreeNodeRecModifier:node_id[label="DELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
 DescriptorTreeNode:id_e:e -> 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_e:e -> CategoricalSummaryData:frequency_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Frequency:id_e:e -> DescriptorTreeNodeRecFrequency:frequency_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Frequency:id_e:e -> OrganismRelationData:frequency_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 GeographicAreaProxy:id_e:e -> DescriptionScope:geographicarea_id[label="DELETE CASCADE" fontsize=10];
 GeographicAreaProxy:id_e:e -> GeographicArea_Taxon:geographicarea_id[label="DELETE CASCADE" fontsize=10];
 GeographicAreaProxy:id_e:e -> SamplingEvent:geographic_area[label="DELETE CASCADE" fontsize=10 style="dashed"];
 Modifier:id_e:e -> CategoricalSamplingData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Modifier:id_e:e -> CategoricalSummaryData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Modifier:id_e:e -> DescriptorTreeNodeRecModifier:modifier_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Modifier:id_e:e -> OrganismRelationData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Modifier:id_e:e -> QuantitativeSamplingData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 Modifier:id_e:e -> 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_e:e -> DescriptionScope:other_scope_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 OtherScope:id_e:e -> Project_AvailableScope:scope_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 OtherScope:id_e:e -> Resource:scope_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817" style="dashed"];
 Project:id_e:e -> Description:project_id[color="#CC0033" fontcolor="#CC0033"];
 Project:id:w   -> DescriptorTree:project_id_e[color="#CC0033" fontcolor="#CC0033"];
 Project:id_e:e -> Project_AvailableScope:project_id[label="DELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
 Project:id_e:e -> TaxonProxy:project_id[color="#CC0033" fontcolor="#CC0033"];
 Project:id_e:e -> 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 color="#000074" fontcolor="#000074"];
 ResourceVariant_Enum:id_e:e -> ResourceVariant:variant_id[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"];
 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_e:e -> 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_e:e -> DescriptorMapping_Q2C:from_statistical_measure_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 StatisticalMeasure_Enum:id_e:e -> DescriptorTreeNodeRecStatMeasure:measure_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 StatisticalMeasure_Enum:id_e:e -> QuantitativeSamplingData:measure_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 StatisticalMeasure_Enum:id_e:e -> QuantitativeSummaryData:measure_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
 TaxonProxy:id_e:e -> DescriptionScope:taxon_id[label="DELETE CASCADE" fontsize=10];
 TaxonProxy:id_e:e -> GeographicArea_Taxon:taxon_id[label="DELETE CASCADE" fontsize=10];
 TaxonProxy:id_e:e -> OrganismRelationData:taxon_id[label="DELETE CASCADE" fontsize=10];
 TaxonProxy:id_e:e -> Resource:taxon_id[label="DELETE SET NULL" fontsize=10];
 TaxonProxy:id_e:e -> TaxonSet_Taxon:taxon_id[label="DELETE CASCADE" fontsize=10];
 TaxonRank_Enum:id_e:e -> TaxonProxy:rank_id:w;
 TaxonSet:id -> Project:restricted_to_taxonset_id_e[label="DELETE SET NULL" fontsize=10];
 TaxonSet:id_e:e -> TaxonSet_Taxon:taxonset_id[label="DELETE CASCADE" fontsize=10];
 TranslationColumn_Enum:id_e:e -> Translation:column_id;
 UserProxy:LoginName -> ProjectUser:LoginName[label="UPDATE CASCADE\nDELETE CASCADE" fontsize=10 color="#CC0033" fontcolor="#CC0033"];
 TaxonProxy:id_e:e -> TaxonQuiz:taxon_id
 Contributor:id_e:e -> TaxonQuiz:contributor_id
 Project:id_e:e -> TaxonQuiz:project_id:w[color="#CC0033" fontcolor="#CC0033"];

} </graphviz>

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)
Abgerufen von „https://www.bayernflora.de/index.php?title=Benutzer:Andreas_Plank/DiversityDescriptions_Quiz&oldid=14895“