Benutzer:Andreas Plank/DiversityDescriptions Base - Versionsgeschichte

imported>Andreas Plank: /* Database */

2014-07-28T13:22:03Z

Database

← Nächstältere Version		Version vom 28. Juli 2014, 15:22 Uhr
Zeile 440:		Zeile 440:
	Resource [		Resource [
	label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >		label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
	<tr><td BGCOLOR="~~lightblue~~" colspan="2">Resource</td></tr>		<tr><td BGCOLOR="blue" colspan="2"><font COLOR="white">Resource</font></td></tr>
	<tr><td PORT="id">id</td><td></td></tr>		<tr><td PORT="id">id</td><td></td></tr>
	<tr><td PORT="terminology_role">terminology_role</td><td></td></tr>		<tr><td PORT="terminology_role">terminology_role</td><td></td></tr>
Zeile 460:		Zeile 460:
	ResourceVariant [		ResourceVariant [
	label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >		label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
	<tr><td BGCOLOR="~~lightblue~~" colspan="2">ResourceVariant</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>
	<tr><td PORT="resource_id">resource_id</td><td>ut_1</td></tr>		<tr><td PORT="resource_id">resource_id</td><td>ut_1</td></tr>
Zeile 476:		Zeile 476:
	ResourceVariant_Enum [		ResourceVariant_Enum [
	label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >		label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >
	<tr><td BGCOLOR="~~lightblue~~" colspan="2">ResourceVariant_Enum</td></tr>		<tr><td BGCOLOR="blue" colspan="2"><font COLOR="white">ResourceVariant_Enum</font></td></tr>
	<tr><td PORT="id">id</td><td></td></tr>		<tr><td PORT="id">id</td><td></td></tr>
	<tr><td PORT="label">label</td><td>u</td></tr>		<tr><td PORT="label">label</td><td>u</td></tr>

imported>Andreas Plank: +Legend

2014-07-28T13:17:24Z

+Legend

← Nächstältere Version		Version vom 28. Juli 2014, 15:17 Uhr
Zeile 1:		Zeile 1:
	== Database ==		== 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=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0">
			<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="#00c900" COLOR="#00c900">Description of items</td></tr>
			<tr><td BGCOLOR="#e5c96a" COLOR="#e5c96a">Descriptor</td></tr>
			<tr><td BGCOLOR="blue" COLOR="blue"><font COLOR="white">Resources</font></td></tr>
			<tr><td>u=unique</td></tr>
			<tr><td>ut_1=unique together</td></tr>
			</table>>
			];
			}
			</graphviz>

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

imported>Andreas Plank am 28. Juli 2014 um 13:12 Uhr

2014-07-28T13:12:19Z

Änderungen zeigen

imported>Andreas Plank: /* Database */

2014-07-28T12:51:42Z

Database

Änderungen zeigen

imported>Andreas Plank: /* Database */

2014-07-28T12:46:22Z

Database

Änderungen zeigen

imported>Andreas Plank am 28. Juli 2014 um 12:43 Uhr

2014-07-28T12:43:42Z

← Nächstältere Version		Version vom 28. Juli 2014, 14:43 Uhr
Zeile 780:		Zeile 780:
	Project:id -> TaxonSet:project_id[color="red" fontcolor="red"];		Project:id -> TaxonSet:project_id[color="red" fontcolor="red"];
	Project:id:w -> Project:parent_project_id:w[color="red" fontcolor="red"];		Project:id:w -> Project:parent_project_id:w[color="red" fontcolor="red"];
	ProjectProxy:ProjectID -> Project:ProjectProxyID[label="DELETE SET DEFAULT" fontsize=10];		ProjectProxy:ProjectID -> Project:ProjectProxyID[label="DELETE SET DEFAULT" fontsize=10 color="red" fontcolor="red"];
	ProjectProxy:ProjectID -> ProjectUser:ProjectID[label="UPDATE CASCADE" fontsize=10];		ProjectProxy:ProjectID -> ProjectUser:ProjectID[label="UPDATE CASCADE" fontsize=10 color="red" fontcolor="red"];
	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];		Resource:id -> ResourceVariant:resource_id[label="DELETE CASCADE" fontsize=10];
Zeile 804:		Zeile 804:
	TaxonSet:id -> TaxonSet_Taxon:taxonset_id[label="DELETE CASCADE" fontsize=10];		TaxonSet:id -> TaxonSet_Taxon:taxonset_id[label="DELETE CASCADE" fontsize=10];
	TranslationColumn_Enum:id -> Translation:column_id;		TranslationColumn_Enum:id -> Translation:column_id;
	UserProxy:LoginName -> ProjectUser:LoginName[label="UPDATE CASCADE\nDELETE CASCADE" fontsize=10];		UserProxy:LoginName -> ProjectUser:LoginName[label="UPDATE CASCADE\nDELETE CASCADE" fontsize=10 color="red" fontcolor="red"];

	}		}
	</graphviz>		</graphviz>

imported>Andreas Plank: /* Database */

2014-07-28T12:29:15Z

Database

imported>Andreas Plank: /* Database */

2014-07-28T12:23:17Z

Database

imported>Andreas Plank am 28. Juli 2014 um 12:16 Uhr

2014-07-28T12:16:58Z

Änderungen zeigen

imported>Andreas Plank: Die Seite wurde neu angelegt: „== Database == digraph DD_Base_Scheme_20140717 { g…“

2014-07-28T11:47:37Z

Die Seite wurde neu angelegt: „== Database == <graphviz caption='Scheme of Diversity Descriptions Base' alt='Diversity Descriptions Base' format='png'> digraph DD_Base_Scheme_20140717 { g…“

Änderungen zeigen

← Nächstältere Version		Version vom 28. Juli 2014, 14:29 Uhr
Zeile 756:		Zeile 756:
	DescriptorTree:id -> DescriptorTreeNode:descriptortree_id[color="red" fontcolor="red"];		DescriptorTree:id -> DescriptorTreeNode:descriptortree_id[color="red" fontcolor="red"];
	DescriptorTree:id -> Project:restricted_to_descriptortree_id[label="DELETE SET NULL" fontsize=10 color="red" fontcolor="red"];		DescriptorTree:id -> Project:restricted_to_descriptortree_id[label="DELETE SET NULL" fontsize=10 color="red" fontcolor="red"];
	~~DescriptorTreeNode:id -> DescriptorTreeNode:parent_node_id[color="red" fontcolor="red"];~~
	DescriptorTreeNode:id -> DescriptorTreeNodeRecFrequency:node_id[label="DELETE CASCADE" fontsize=10 color="red" fontcolor="red"];		DescriptorTreeNode:id -> DescriptorTreeNodeRecFrequency:node_id[label="DELETE CASCADE" fontsize=10 color="red" fontcolor="red"];
	DescriptorTreeNode:id -> DescriptorTreeNodeRecModifier:node_id[label="DELETE CASCADE" fontsize=10 color="red" fontcolor="red"];		DescriptorTreeNode:id -> DescriptorTreeNodeRecModifier:node_id[label="DELETE CASCADE" fontsize=10 color="red" fontcolor="red"];
	DescriptorTreeNode:id -> DescriptorTreeNodeRecStatMeasure:node_id[label="DELETE CASCADE" fontsize=10 color="red" fontcolor="red"];		DescriptorTreeNode:id -> DescriptorTreeNodeRecStatMeasure:node_id[label="DELETE CASCADE" fontsize=10 color="red" fontcolor="red"];
			DescriptorTreeNode:id:w -> DescriptorTreeNode:parent_node_id:w[color="red" fontcolor="red"];
	Frequency:id -> CategoricalSummaryData:frequency_id[label="DELETE SET NULL" fontsize=10 color="brown" fontcolor="brown"];		Frequency:id -> CategoricalSummaryData:frequency_id[label="DELETE SET NULL" fontsize=10 color="brown" fontcolor="brown"];
	Frequency:id -> DescriptorTreeNodeRecFrequency:frequency_id[label="DELETE CASCADE" fontsize=10 color="brown" fontcolor="brown"];		Frequency:id -> DescriptorTreeNodeRecFrequency:frequency_id[label="DELETE CASCADE" fontsize=10 color="brown" fontcolor="brown"];
Zeile 777:		Zeile 777:
	Project:id -> DescriptorTree:project_id[color="red" fontcolor="red"];		Project:id -> DescriptorTree:project_id[color="red" fontcolor="red"];
	Project:id -> Project_AvailableScope:project_id[label="DELETE CASCADE" fontsize=10 color="red" fontcolor="red"];		Project:id -> Project_AvailableScope:project_id[label="DELETE CASCADE" fontsize=10 color="red" fontcolor="red"];
	~~Project:id -> Project:parent_project_id[color="red" fontcolor="red"];~~
	Project:id -> TaxonProxy:project_id[color="red" fontcolor="red"];		Project:id -> TaxonProxy:project_id[color="red" fontcolor="red"];
	Project:id -> TaxonSet:project_id[color="red" fontcolor="red"];		Project:id -> TaxonSet:project_id[color="red" fontcolor="red"];
			Project:id:w -> Project:parent_project_id:w[color="red" fontcolor="red"];
	ProjectProxy:ProjectID -> Project:ProjectProxyID[label="DELETE SET DEFAULT" fontsize=10];		ProjectProxy:ProjectID -> Project:ProjectProxyID[label="DELETE SET DEFAULT" fontsize=10];
	ProjectProxy:ProjectID -> ProjectUser:ProjectID[label="UPDATE CASCADE" fontsize=10];		ProjectProxy:ProjectID -> ProjectUser:ProjectID[label="UPDATE CASCADE" fontsize=10];

← Nächstältere Version		Version vom 28. Juli 2014, 14:23 Uhr
Zeile 754:		Zeile 754:
	Descriptor:id -> TextDescriptorData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="brown" fontcolor="brown"];		Descriptor:id -> TextDescriptorData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="brown" fontcolor="brown"];
	Descriptor:id -> TextSamplingData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="brown" fontcolor="brown"];		Descriptor:id -> TextSamplingData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="brown" fontcolor="brown"];
	DescriptorTree:id -> DescriptorTreeNode:descriptortree_id;		DescriptorTree:id -> DescriptorTreeNode:descriptortree_id[color="red" fontcolor="red"];
	DescriptorTree:id -> Project:restricted_to_descriptortree_id[label="DELETE SET NULL" fontsize=10];		DescriptorTree:id -> Project:restricted_to_descriptortree_id[label="DELETE SET NULL" fontsize=10 color="red" fontcolor="red"];
	DescriptorTreeNode:id -> DescriptorTreeNodeRecFrequency:node_id[label="DELETE CASCADE" fontsize=10];		DescriptorTreeNode:id -> DescriptorTreeNode:parent_node_id[color="red" fontcolor="red"];
	DescriptorTreeNode:id -> DescriptorTreeNodeRecModifier:node_id[label="DELETE CASCADE" fontsize=10];		DescriptorTreeNode:id -> DescriptorTreeNodeRecFrequency:node_id[label="DELETE CASCADE" fontsize=10 color="red" fontcolor="red"];
	DescriptorTreeNode:id -> DescriptorTreeNodeRecStatMeasure:node_id[label="DELETE CASCADE" fontsize=10];		DescriptorTreeNode:id -> DescriptorTreeNodeRecModifier:node_id[label="DELETE CASCADE" fontsize=10 color="red" fontcolor="red"];
	~~DescriptorTreeNode:id:w -> DescriptorTreeNode:parent_node_id:w~~;		DescriptorTreeNode:id -> DescriptorTreeNodeRecStatMeasure:node_id[label="DELETE CASCADE" fontsize=10 color="red" fontcolor="red"];
	Frequency:id -> CategoricalSummaryData:frequency_id[label="DELETE SET NULL" fontsize=10 color="brown" fontcolor="brown"];		Frequency:id -> CategoricalSummaryData:frequency_id[label="DELETE SET NULL" fontsize=10 color="brown" fontcolor="brown"];
	Frequency:id -> DescriptorTreeNodeRecFrequency:frequency_id[label="DELETE CASCADE" fontsize=10 color="brown" fontcolor="brown"];		Frequency:id -> DescriptorTreeNodeRecFrequency:frequency_id[label="DELETE CASCADE" fontsize=10 color="brown" fontcolor="brown"];
Zeile 774:		Zeile 774:
	OtherScope:id -> DescriptionScope:other_scope_id[label="DELETE CASCADE" fontsize=10 color="brown" fontcolor="brown"];		OtherScope:id -> DescriptionScope:other_scope_id[label="DELETE CASCADE" fontsize=10 color="brown" fontcolor="brown"];
	OtherScope:id -> Project_AvailableScope:scope_id[label="DELETE CASCADE" fontsize=10 color="brown" fontcolor="brown"];		OtherScope:id -> Project_AvailableScope:scope_id[label="DELETE CASCADE" fontsize=10 color="brown" fontcolor="brown"];
	Project:id -> Description:project_id;		Project:id -> Description:project_id[color="red" fontcolor="red"];
	Project:id -> DescriptorTree:project_id;		Project:id -> DescriptorTree:project_id[color="red" fontcolor="red"];
	Project:id -> Project_AvailableScope:project_id[label="DELETE CASCADE" fontsize=10];		Project:id -> Project_AvailableScope:project_id[label="DELETE CASCADE" fontsize=10 color="red" fontcolor="red"];
	Project:id -> ~~TaxonProxy~~:~~project_id~~;		Project:id -> Project:parent_project_id[color="red" fontcolor="red"];
	Project:id -> ~~TaxonSet~~:project_id;		Project:id -> TaxonProxy:project_id[color="red" fontcolor="red"];
	Project:id:w -> ~~Project~~:~~parent_project_id:w~~;		Project:id -> TaxonSet:project_id[color="red" fontcolor="red"];
	ProjectProxy:ProjectID -> Project:ProjectProxyID[label="DELETE SET DEFAULT" fontsize=10];		ProjectProxy:ProjectID -> Project:ProjectProxyID[label="DELETE SET DEFAULT" fontsize=10];
	ProjectProxy:ProjectID -> ProjectUser:ProjectID[label="UPDATE CASCADE" fontsize=10];		ProjectProxy:ProjectID -> ProjectUser:ProjectID[label="UPDATE CASCADE" fontsize=10];