Benutzer:Andreas Plank/DiversityDescriptions Quiz - Versionsgeschichte

imported>Andreas Plank: verlinkt nach http://diversityworkbench.net/Portal/DiversityDescriptions_Quiz_%28Artenquiz%29

2014-08-13T11:21:46Z

verlinkt nach http://diversityworkbench.net/Portal/DiversityDescriptions_Quiz_%28Artenquiz%29

imported>Andreas Plank: Sampling data

2014-08-12T13:22:47Z

Sampling data

imported>Andreas Plank: +ResourceWatchedTime

2014-08-12T13:05:33Z

+ResourceWatchedTime

← Nächstältere Version		Version vom 12. August 2014, 15:05 Uhr
Zeile 13:		Zeile 13:
	<tr><td BGCOLOR="#ef6a6a" COLOR="#ef6a6a">Project specific settings</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="#00c900" COLOR="#00c900">Description of items</td></tr>
			<tr><td BGCOLOR="#cee12c" COLOR="#cee12c">Sample data</td></tr>
	<tr><td BGCOLOR="#e5c96a" COLOR="#e5c96a">Descriptor</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 BGCOLOR="blue" COLOR="blue"><font COLOR="white">Resources</font></td></tr>
Zeile 65:		Zeile 66:
	CategoricalSamplingData [		CategoricalSamplingData [
	label=<<table BORDER="0" BGCOLOR="white" 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="#cee12c" colspan="2">CategoricalSamplingData</td></tr>
	<tr><td PORT="id">id</td><td></td></tr>		<tr><td PORT="id">id</td><td></td></tr>
	<tr><td PORT="sampling_unit_id">sampling_unit_id</td><td>ut_1</td></tr>		<tr><td PORT="sampling_unit_id">sampling_unit_id</td><td>ut_1</td></tr>
Zeile 228:		Zeile 229:
	DescriptorStatusData [		DescriptorStatusData [
	label=<<table BORDER="0" BGCOLOR="white" 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="#00c900" colspan="2">DescriptorStatusData</td></tr>
	<tr><td PORT="id">id</td><td></td></tr>		<tr><td PORT="id">id</td><td></td></tr>
	<tr><td PORT="description_id">description_id</td><td>ut_1</td></tr>		<tr><td PORT="description_id">description_id</td><td>ut_1</td></tr>
Zeile 356:		Zeile 357:
	OrganismRelationData [		OrganismRelationData [
	label=<<table BORDER="0" BGCOLOR="white" 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="#00c900" colspan="2">OrganismRelationData</td></tr>
	<tr><td PORT="id">id</td><td></td></tr>		<tr><td PORT="id">id</td><td></td></tr>
	<tr><td PORT="description_id">description_id</td><td>ut_1</td></tr>		<tr><td PORT="description_id">description_id</td><td>ut_1</td></tr>
Zeile 408:		Zeile 409:
	QuantitativeSamplingData [		QuantitativeSamplingData [
	label=<<table BORDER="0" BGCOLOR="white" 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="#cee12c" colspan="1">QuantitativeSamplingData</td></tr>
	<tr><td PORT="id">id</td></tr>		<tr><td PORT="id">id</td></tr>
	<tr><td PORT="measure_id">measure_id</td></tr>		<tr><td PORT="measure_id">measure_id</td></tr>
Zeile 491:		Zeile 492:
	</table>>		</table>>
	];		];

			ResourceWatchedTime [
			label=<<table BORDER="0" BGCOLOR="white" CELLBORDER="1" CELLSPACING="0" >
			<tr><td BGCOLOR="blue" colspan="1"><font COLOR="white">ResourceWatchedTime</font></td></tr>
			<tr><td PORT="id">id</td></tr>
			<tr><td PORT="resource_id">resource_id</td></tr>
			<tr><td PORT="contributor_id">contributor_id</td></tr>
			<tr><td PORT="watched_time">watched_time</td></tr>
			</table>>
			];

	SamplingEvent [		SamplingEvent [
	label=<<table BORDER="0" BGCOLOR="white" 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="#cee12c" colspan="1">SamplingEvent</td></tr>
	<tr><td PORT="id">id</td></tr>		<tr><td PORT="id">id</td></tr>
	<tr><td PORT="description_id">description_id</td></tr>		<tr><td PORT="description_id">description_id</td></tr>
Zeile 510:		Zeile 522:
	SamplingUnit [		SamplingUnit [
	label=<<table BORDER="0" BGCOLOR="white" 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="#cee12c" colspan="1">SamplingUnit</td></tr>
	<tr><td PORT="id">id</td></tr>		<tr><td PORT="id">id</td></tr>
	<tr><td PORT="sampling_event_id">sampling_event_id</td></tr>		<tr><td PORT="sampling_event_id">sampling_event_id</td></tr>
Zeile 642:		Zeile 654:
	TextSamplingData [		TextSamplingData [
	label=<<table BORDER="0" BGCOLOR="white" 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="#cee12c" colspan="2">TextSamplingData</td></tr>
	<tr><td PORT="id">id</td><td></td></tr>		<tr><td PORT="id">id</td><td></td></tr>
	<tr><td PORT="sampling_unit_id">sampling_unit_id</td><td>ut_1</td></tr>		<tr><td PORT="sampling_unit_id">sampling_unit_id</td><td>ut_1</td></tr>
Zeile 766:		Zeile 778:
	Description:id:e -> 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:e -> Resource:description_id:w[label="DELETE SET NULL" fontsize=10 color="#00c900" fontcolor="#00c900"];		Description:id:e -> Resource:description_id:w[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 -> SamplingEvent:description_id:w[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
	Description:id:e -> 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:e -> CategoricalState:descriptor_id:w[color="#AF7817" fontcolor="#AF7817"];		Descriptor:id:e -> CategoricalState:descriptor_id:w[color="#AF7817" fontcolor="#AF7817"];
Zeile 811:		Zeile 823:
	Resource:id -> ResourceVariant:resource_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"];		Resource:id -> ResourceVariant:resource_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"];
	ResourceVariant_Enum:id_e:e -> ResourceVariant:variant_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"];		ResourceVariant_Enum:id_e:e -> ResourceVariant:variant_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"];
	SamplingEvent:id -> SamplingUnit:sampling_event_id[label="DELETE CASCADE" fontsize=10];		SamplingEvent:id:e -> SamplingUnit:sampling_event_id:w[label="DELETE CASCADE" fontsize=10];
	SamplingUnit:id -> CategoricalSamplingData:sampling_unit_id:w[label="DELETE CASCADE" fontsize=10];		SamplingUnit:id -> CategoricalSamplingData:sampling_unit_id:w[label="DELETE CASCADE" fontsize=10];
	SamplingUnit:id -> QuantitativeSamplingData:sampling_unit_id:w[label="DELETE CASCADE" fontsize=10];		SamplingUnit:id -> QuantitativeSamplingData:sampling_unit_id:w[label="DELETE CASCADE" fontsize=10];
Zeile 834:		Zeile 846:
	Contributor:id_e:e -> TaxonQuiz:contributor_id		Contributor:id_e:e -> TaxonQuiz:contributor_id
	Project:id_e:e -> TaxonQuiz:project_id:w[color="#CC0033" fontcolor="#CC0033"];		Project:id_e:e -> TaxonQuiz:project_id:w[color="#CC0033" fontcolor="#CC0033"];
			Resource:id -> ResourceWatchedTime:resource_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"]
			Contributor:id_e:e -> ResourceWatchedTime:contributor_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"]
	}		}
	</graphviz>		</graphviz>

imported>Andreas Plank am 11. August 2014 um 14:25 Uhr

2014-08-11T14:25:10Z

imported>Andreas Plank am 11. August 2014 um 14:18 Uhr

2014-08-11T14:18:16Z

imported>Andreas Plank am 11. August 2014 um 14:15 Uhr

2014-08-11T14:15:40Z

imported>Andreas Plank am 11. August 2014 um 14:12 Uhr

2014-08-11T14:12:34Z

← Nächstältere Version		Version vom 11. August 2014, 16:12 Uhr
Zeile 750:		Zeile 750:
	BaseEntity:id:e -> Translation:object_id:w[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:e -> CategoricalSamplingData:state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];		CategoricalState:id_e:e -> CategoricalSamplingData:state_id:w[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 -> CategoricalSummaryData:state_id:w[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 -> DescriptorInapplicability:controlling_state_id:w[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:from_state_id:w[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_C2C:to_state_id:w[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 -> DescriptorMapping_Q2C:to_state_id:w[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"];		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 -> Annotation:contributor_id;

imported>Andreas Plank am 11. August 2014 um 14:10 Uhr

2014-08-11T14:10:39Z

Änderungen zeigen

imported>Andreas Plank am 11. August 2014 um 13:52 Uhr

2014-08-11T13:52:58Z

imported>Andreas Plank am 11. August 2014 um 11:59 Uhr

2014-08-11T11:59:33Z

← Nächstältere Version		Version vom 12. August 2014, 15:22 Uhr
Zeile 13:		Zeile 13:
	<tr><td BGCOLOR="#ef6a6a" COLOR="#ef6a6a">Project specific settings</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="#00c900" COLOR="#00c900">Description of items</td></tr>
	<tr><td BGCOLOR="#cee12c" COLOR="#cee12c">~~Sample~~ data</td></tr>		<tr><td BGCOLOR="#cee12c" COLOR="#cee12c">Sampling data</td></tr>
	<tr><td BGCOLOR="#e5c96a" COLOR="#e5c96a">Descriptor</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 BGCOLOR="blue" COLOR="blue"><font COLOR="white">Resources</font></td></tr>
Zeile 823:		Zeile 823:
	Resource:id -> ResourceVariant:resource_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"];		Resource:id -> ResourceVariant:resource_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"];
	ResourceVariant_Enum:id_e:e -> ResourceVariant:variant_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"];		ResourceVariant_Enum:id_e:e -> ResourceVariant:variant_id:w[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"];
	SamplingEvent:id:e -> SamplingUnit:sampling_event_id:w[label="DELETE CASCADE" fontsize=10];		SamplingEvent:id:e -> SamplingUnit:sampling_event_id:w[label="DELETE CASCADE" fontsize=10 fontcolor="#cee12c" color="#cee12c"];
	SamplingUnit:id -> CategoricalSamplingData:sampling_unit_id:w[label="DELETE CASCADE" fontsize=10];		SamplingUnit:id -> CategoricalSamplingData:sampling_unit_id:w[label="DELETE CASCADE" fontsize=10 fontcolor="#cee12c" color="#cee12c"];
	SamplingUnit:id -> QuantitativeSamplingData:sampling_unit_id:w[label="DELETE CASCADE" fontsize=10];		SamplingUnit:id -> QuantitativeSamplingData:sampling_unit_id:w[label="DELETE CASCADE" fontsize=10 fontcolor="#cee12c" color="#cee12c"];
	SamplingUnit:id -> TextSamplingData:sampling_unit_id[label="DELETE CASCADE" fontsize=10];		SamplingUnit:id -> TextSamplingData:sampling_unit_id[label="DELETE CASCADE" fontsize=10 fontcolor="#cee12c" color="#cee12c"];
	SexStatus_Enum:id_e: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:w[label="DELETE CASCADE" fontsize=10];		SpecimenProxy:id -> DescriptionScope:specimen_id:w[label="DELETE CASCADE" fontsize=10];

← Nächstältere Version		Version vom 11. August 2014, 16:25 Uhr
Zeile 756:		Zeile 756:
	CategoricalState:id_e:e -> DescriptorMapping_C2C:to_state_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817" style="dashed"];		CategoricalState:id_e:e -> DescriptorMapping_C2C:to_state_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817" style="dashed"];
	CategoricalState:id_e:e -> DescriptorMapping_Q2C:to_state_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];		CategoricalState:id_e:e -> DescriptorMapping_Q2C:to_state_id:w[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"];		CategoricalState:id_e:e -> Resource:state_id:w[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
	Contributor:id_e:e -> Annotation:contributor_id;		Contributor:id_e:e -> Annotation:contributor_id;
	Contributor:id_e:e -> Contribution:contributor_id;		Contributor:id_e:e -> Contribution:contributor_id;
Zeile 765:		Zeile 765:
	Description:id:e -> 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:e -> 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:e -> Resource:description_id[label="DELETE SET NULL" fontsize=10 color="#00c900" fontcolor="#00c900"];		Description:id:e -> Resource:description_id:w[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 -> 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"];		Description:id:e -> TextDescriptorData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
Zeile 790:		Zeile 790:
	GeographicAreaProxy:id_e: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: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:e -> CategoricalSamplingData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];		Modifier:id_e:e -> CategoricalSamplingData:modifier_id:w[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 -> 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 -> 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 -> 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 -> QuantitativeSamplingData:modifier_id:w[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"];		Modifier:id_e:e -> QuantitativeSummaryData:modifier_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
	ObservationProxy:id -> DescriptionScope:observation_id:w[label="DELETE CASCADE" fontsize=10];		ObservationProxy:id -> DescriptionScope:observation_id:w[label="DELETE CASCADE" fontsize=10];
	OtherScope:id_e:e -> DescriptionScope:other_scope_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];		OtherScope:id_e:e -> DescriptionScope:other_scope_id:w[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 -> 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"];		OtherScope:id_e:e -> Resource:scope_id:w[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_e:e -> Description:project_id[color="#CC0033" fontcolor="#CC0033"];
	Project:id:w -> DescriptorTree:project_id_e[color="#CC0033" fontcolor="#CC0033"];		Project:id:w -> DescriptorTree:project_id_e[color="#CC0033" fontcolor="#CC0033"];
Zeile 809:		Zeile 809:
	ProjectProxy:ProjectID -> ProjectUser:ProjectID[label="UPDATE CASCADE" 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:w[label="DELETE CASCADE" fontsize=10];		ReferenceProxy:id -> DescriptionScope:source_reference_id:w[label="DELETE CASCADE" fontsize=10];
	Resource:id -> ResourceVariant:resource_id[label="DELETE CASCADE" fontsize=10 color="#000074" fontcolor="#000074"];		Resource:id -> ResourceVariant:resource_id:w[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"];		ResourceVariant_Enum:id_e:e -> ResourceVariant:variant_id:w[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:w[label="DELETE CASCADE" fontsize=10];
	SamplingUnit:id -> QuantitativeSamplingData:sampling_unit_id[label="DELETE CASCADE" fontsize=10];		SamplingUnit:id -> QuantitativeSamplingData:sampling_unit_id:w[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: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"];
Zeile 819:		Zeile 819:
	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 -> 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 -> 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 -> QuantitativeSamplingData:measure_id:w[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"];		StatisticalMeasure_Enum:id_e:e -> QuantitativeSummaryData:measure_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
	TaxonProxy:id_e:e -> DescriptionScope:taxon_id:w[label="DELETE CASCADE" fontsize=10];		TaxonProxy:id_e:e -> DescriptionScope:taxon_id:w[label="DELETE CASCADE" fontsize=10];
	TaxonProxy:id_e: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:e -> OrganismRelationData: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 -> Resource:taxon_id:w[label="DELETE SET NULL" fontsize=10];
	TaxonProxy:id_e: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_e:e -> TaxonProxy:rank_id:w;		TaxonRank_Enum:id_e:e -> TaxonProxy:rank_id:w;

← Nächstältere Version		Version vom 11. August 2014, 16:18 Uhr
Zeile 761:		Zeile 761:
	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:e -> 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:e -> DescriptionScope:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];		Description:id:e -> DescriptionScope:description_id:w[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 -> 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 -> OrganismRelationData:description_id[label="DELETE CASCADE" fontsize=10 color="#00c900" fontcolor="#00c900"];
Zeile 787:		Zeile 787:
	Frequency:id_e: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: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:e -> DescriptionScope:geographicarea_id[label="DELETE CASCADE" fontsize=10];		GeographicAreaProxy:id_e:e -> DescriptionScope:geographicarea_id:w[label="DELETE CASCADE" fontsize=10];
	GeographicAreaProxy:id_e: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: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"];
Zeile 796:		Zeile 796:
	Modifier:id_e: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: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:w[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 -> DescriptionScope:other_scope_id:w[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 -> 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"];		OtherScope:id_e:e -> Resource:scope_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817" style="dashed"];
Zeile 808:		Zeile 808:
	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"];
	ProjectProxy:ProjectID -> ProjectUser:ProjectID[label="UPDATE CASCADE" 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];		ReferenceProxy:id -> DescriptionScope:source_reference_id:w[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: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"];
Zeile 816:		Zeile 816:
	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: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:w[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 -> 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 -> 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 -> 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"];		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 -> DescriptionScope:taxon_id:w[label="DELETE CASCADE" fontsize=10];
	TaxonProxy:id_e: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:e -> OrganismRelationData:taxon_id[label="DELETE CASCADE" fontsize=10];		TaxonProxy:id_e:e -> OrganismRelationData:taxon_id[label="DELETE CASCADE" fontsize=10];

← Nächstältere Version		Version vom 11. August 2014, 16:15 Uhr
Zeile 768:		Zeile 768:
	Description:id:e -> 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:e -> 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:e -> CategoricalState:descriptor_id[color="#AF7817" fontcolor="#AF7817"];		Descriptor:id:e -> CategoricalState:descriptor_id:w[color="#AF7817" fontcolor="#AF7817"];
	Descriptor:id:e -> DescriptorInapplicability:controlled_descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];		Descriptor:id:e -> DescriptorInapplicability:controlled_descriptor_id:w[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 -> DescriptorMapping_Q2C:from_descr_id:w[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 -> DescriptorStatusData:descriptor_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
	Descriptor:id:e -> DescriptorTreeNode:descriptor_id[color="#AF7817" fontcolor="#AF7817"];		Descriptor:id:e -> DescriptorTreeNode:descriptor_id:w[color="#AF7817" fontcolor="#AF7817"];
	Descriptor:id:e -> QuantitativeSamplingData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];		Descriptor:id:e -> QuantitativeSamplingData:descriptor_id:w[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 -> QuantitativeSummaryData:descriptor_id:w[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 -> Resource:descriptor_id:w[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 -> TextDescriptorData:descriptor_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
	Descriptor:id:e -> TextSamplingData:descriptor_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];		Descriptor:id:e -> TextSamplingData:descriptor_id:w[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
	DescriptorTree:id_e:e -> DescriptorTreeNode:descriptortree_id[color="#CC0033" fontcolor="#CC0033"];		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"];		DescriptorTree:id_e:e -> Project:restricted_to_descriptortree_id[label="DELETE SET NULL" fontsize=10 color="#CC0033" fontcolor="#CC0033"];

← Nächstältere Version		Version vom 11. August 2014, 15:52 Uhr
Zeile 25:		Zeile 25:

	digraph DD_Quiz_Scheme_20140717{		digraph DD_Quiz_Scheme_20140717{
	graph [rankdir = "LR"];		graph [rankdir = "LR" splines="curved"];
	node [fontsize = "10", shape = "plaintext"];		node [fontsize = "10", shape = "plaintext"];
	edge [color = "black" arrowhead="dot"];		edge [color = "black" arrowhead="dot"];
Zeile 481:		Zeile 481:
	label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >		label=<<table BORDER="0" 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></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="detail">detail</td><td></td></tr>		<tr><td PORT="detail">detail</td><td PORT="detail_e"></td></tr>
	<tr><td PORT="quality_order">quality_order</td><td></td></tr>		<tr><td PORT="quality_order">quality_order</td><td PORT="quality_order_e"></td></tr>
	//CONSTRAINT [PK_ResourceVariant_Enum] PRIMARY KEY ([id]),		//CONSTRAINT [PK_ResourceVariant_Enum] PRIMARY KEY ([id]),
	//CONSTRAINT [UQ_ResourceVariant_Enum_1] UNIQUE ([label]),		//CONSTRAINT [UQ_ResourceVariant_Enum_1] UNIQUE ([label]),
Zeile 723:		Zeile 723:
	];		];

	BaseEntity:id -> Annotation:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> Annotation:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> CategoricalState:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> CategoricalState:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> Contribution:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> Contribution:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> DataStatus_Enum:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> DataStatus_Enum:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> Description:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> Description:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> Descriptor:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> Descriptor:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> DescriptorTree:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> DescriptorTree:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> DescriptorTreeNode:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> DescriptorTreeNode:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> Frequency:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> Frequency:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> GeographicAreaProxy:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> GeographicAreaProxy:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> Identifier:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> Identifier:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> Modifier:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> Modifier:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> ObservationProxy:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> ObservationProxy:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> OtherScope:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> OtherScope:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> Project:id[color="#0069ba" fontcolor="#0069ba" headlabel="1" arrowhead="none"];		BaseEntity:id:e -> Project:id[color="#0069ba" fontcolor="#0069ba" headlabel="1" arrowhead="none"];
	BaseEntity:id -> ReferenceProxy:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> ReferenceProxy:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> Resource:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> Resource:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> ResourceVariant_Enum:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> ResourceVariant_Enum:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> SexStatus_Enum:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> SexStatus_Enum:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> SpecimenProxy:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> SpecimenProxy:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> StatisticalMeasure_Enum:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> StatisticalMeasure_Enum:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> Tag:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> Tag:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> TaxonProxy:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> TaxonProxy:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> TaxonRank_Enum:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> TaxonRank_Enum:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> TaxonSet:id[color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> TaxonSet:id[color="#0069ba" fontcolor="#0069ba"];
	BaseEntity:id -> Translation:object_id[label="DELETE CASCADE" fontsize=10 color="#0069ba" fontcolor="#0069ba"];		BaseEntity:id:e -> Translation:object_id[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 -> CategoricalSamplingData:state_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];
Zeile 809:		Zeile 809:
	ProjectProxy:ProjectID -> ProjectUser:ProjectID[label="UPDATE CASCADE" 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];		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 color="#000074" fontcolor="#000074"];
	ResourceVariant_Enum:id -> ResourceVariant:variant_id[label="DELETE CASCADE" fontsize=10];		ResourceVariant_Enum:id_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];

← Nächstältere Version		Version vom 11. August 2014, 13:59 Uhr
Zeile 519:		Zeile 519:
	label=<<table BORDER="0" CELLBORDER="1" CELLSPACING="0" >		label=<<table BORDER="0" 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></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>
	<tr><td PORT="display_order">display_order</td><td></td></tr>		<tr><td PORT="display_order">display_order</td><td PORT="display_order_e"></td></tr>
	//CONSTRAINT [PK_SexStatus_Enum] PRIMARY KEY ([id]),		//CONSTRAINT [PK_SexStatus_Enum] PRIMARY KEY ([id]),
	//CONSTRAINT [UQ_SexStatus_Enum_1] UNIQUE ([label]),		//CONSTRAINT [UQ_SexStatus_Enum_1] UNIQUE ([label]),
Zeile 815:		Zeile 815:
	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 -> OtherScope:sex_status_id[label="DELETE SET NULL" fontsize=10 color="#AF7817" fontcolor="#AF7817"];		SexStatus_Enum:id_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 -> DescriptorMapping_Q2C:from_statistical_measure_id[label="DELETE CASCADE" fontsize=10 color="#AF7817" fontcolor="#AF7817"];