Project

General

Profile

« Previous | Next » 

Revision 3722

VegBIEN: Reversed aggregateoccurrence<->plantobservation relationship to point from plantobservation->aggregateoccurrence, so plantobservation could be scoped by aggregateoccurrence in the same way as all other core tables are scoped by their parent tables. This reversed direction was an anomaly due to the need to have a trigger auto-set aggregateoccurrence.count to 1 when there was an associated plantobservation. This was most easily accomplished on the aggregateoccurrence table itself, but required the reversed relationship. The trigger has now been reimplemented on plantobservation, which externally updates aggregateoccurrence.count.

View differences:

Makefile
116 116
	env \
117 117
left_in_root='$(rootAttrs)/*s/individualOrganismObservation/*ID->/*s/plotObservation' \
118 118
left_out_root='/*s/plotObservation' \
119
right_in_root='/plantobservation/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent' \
119
right_in_root='/plantobservation/*_id/aggregateoccurrence/*_id/taxonoccurrence/*_id/locationevent' \
120 120
right_out_root='/locationevent' \
121 121
$(chRoot)
122 122
vegxMaps += VegX-VegBIEN.plots.csv

Also available in: Unified diff