|
1
|
<table border="1" cellpadding="0" cellspacing="0">
|
|
2
|
<tr><td>Curent Situation</td><td> </td><td>OPTION A: no model changes: comments here</td><td>OPTION B field changes only</td><td>B comments</td><td>OPTION C changes</td><td> </td><td>comments about field</td><td>MTL's thoughts on option C</td></tr>
|
|
3
|
<tr><td>TableName</td><td>FieldName</td><td> </td><td> </td><td> </td><td>TableName</td><td>FieldName</td><td>see bugs 786 and 1079</td><td> </td></tr>
|
|
4
|
<tr><td>stemCount</td><td>STEMCOUNT_ID</td><td>split into 2 tables is not necessary</td><td> </td><td> </td><td>stem</td><td>STEM_ID</td><td>consolidated to one stem table</td><td> </td></tr>
|
|
5
|
<tr><td>stemCount</td><td>TAXONOBSERVATION_ID</td><td> </td><td> </td><td> </td><td>stem</td><td>TAXONOBSERVATION_ID</td><td> </td><td> </td></tr>
|
|
6
|
<tr><td>stemCount</td><td>stemDiameter</td><td> </td><td> </td><td> </td><td>stem</td><td>stemDiameter</td><td> </td><td> </td></tr>
|
|
7
|
<tr><td>stemCount</td><td>stemDiameterAccuracy</td><td> </td><td> </td><td> </td><td>stem</td><td>stemDiameterAccuracy</td><td> </td><td> </td></tr>
|
|
8
|
<tr><td>stemCount</td><td>stemHeight</td><td> </td><td> </td><td> </td><td>stem</td><td>stemHeight</td><td> </td><td> </td></tr>
|
|
9
|
<tr><td>stemCount</td><td>stemHeightAccuracy</td><td> </td><td> </td><td> </td><td>stem</td><td>stemHeightAccuracy</td><td> </td><td> </td></tr>
|
|
10
|
<tr><td>stemCount</td><td>stemCount</td><td> </td><td> </td><td> </td><td>stem</td><td>stemCount</td><td> </td><td> </td></tr>
|
|
11
|
<tr><td>stemCount</td><td>stemTaxonArea</td><td> </td><td> </td><td> </td><td>stem</td><td>stemTaxonArea</td><td> </td><td> </td></tr>
|
|
12
|
<tr><td>stemLocation</td><td>STEMLOCATION_ID</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
|
|
13
|
<tr><td>stemLocation</td><td>STEMCOUNT_ID</td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td><td> </td></tr>
|
|
14
|
<tr><td>stemLocation</td><td>stemCode</td><td> </td><td> </td><td> </td><td>stem</td><td>stemCode</td><td>author's code</td><td> </td></tr>
|
|
15
|
<tr><td>stemLocation</td><td>stemXPosition</td><td> </td><td> </td><td> </td><td>stem</td><td>stemXPosition</td><td> </td><td> </td></tr>
|
|
16
|
<tr><td>stemLocation</td><td>stemYPosition</td><td> </td><td> </td><td> </td><td>stem</td><td>stemYPosition</td><td> </td><td> </td></tr>
|
|
17
|
<tr><td> </td><td> </td><td>previous stem accessible via stemCode and obs.previousObservation_ID</td><td> </td><td> </td><td>stem</td><td>PREVIOUSSTEM_ID</td><td>recursive key back to previous observation of same stem</td><td>"unnecessary or minimally an implementation field. Previous observation + same stem code should suffice."</td></tr>
|
|
18
|
<tr><td>taxonInterpretation</td><td>TAXONINTERPRETATION_ID</td><td> </td><td>TAXONINTERPRETATION_ID</td><td> </td><td>taxonClass</td><td>TAXONCLASS_ID</td><td> </td><td> </td></tr>
|
|
19
|
<tr><td>taxonInterpretation</td><td>TAXONOBSERVATION_ID</td><td> </td><td>TAXONOBSERVATION_ID</td><td> </td><td>taxonClass</td><td>TAXONOBSERVATION_ID</td><td> </td><td> </td></tr>
|
|
20
|
<tr><td>taxonInterpretation</td><td>interpretationDate</td><td> </td><td>interpretationDate</td><td> </td><td>taxonClass</td><td>interpretationDate</td><td> </td><td> </td></tr>
|
|
21
|
<tr><td>taxonInterpretation</td><td>PARTY_ID</td><td> </td><td>PARTY_ID</td><td> </td><td>taxonClass</td><td>PARTY_ID</td><td> </td><td> </td></tr>
|
|
22
|
<tr><td>taxonInterpretation</td><td>ROLE_ID</td><td> </td><td>ROLE_ID</td><td> </td><td>taxonClass</td><td>ROLE_ID</td><td> </td><td> </td></tr>
|
|
23
|
<tr><td>taxonInterpretation</td><td>interpretationType</td><td>"add values 'author, less precise, but absolutely certain' AND 'author, more precise, but less certain'"</td><td>interpretationType</td><td>leave values alone</td><td>taxonClass</td><td>interpretationType</td><td>"Author, Computer, Correction"</td><td> </td></tr>
|
|
24
|
<tr><td>taxonInterpretation</td><td>reference_ID</td><td> </td><td>reference_ID</td><td> </td><td>taxonClass</td><td>reference_ID</td><td> </td><td> </td></tr>
|
|
25
|
<tr><td>taxonInterpretation</td><td>originalInterpretation</td><td> </td><td>originalInterpretation</td><td> </td><td>taxonClass</td><td>originalInterpretation</td><td>boolean</td><td> </td></tr>
|
|
26
|
<tr><td>taxonInterpretation</td><td>currentInterpretation</td><td> </td><td>currentInterpretation</td><td> </td><td>taxonClass</td><td>currentInterpretation</td><td>boolean</td><td> </td></tr>
|
|
27
|
<tr><td>taxonInterpretation</td><td>notes</td><td> </td><td>notes</td><td> </td><td>taxonClass</td><td>notes</td><td> </td><td> </td></tr>
|
|
28
|
<tr><td>taxonInterpretation</td><td>notesPublic</td><td> </td><td>notesPublic</td><td> </td><td>taxonClass</td><td>notesPublic</td><td>implementation field</td><td> </td></tr>
|
|
29
|
<tr><td>taxonInterpretation</td><td>notesMgt</td><td> </td><td>notesMgt</td><td> </td><td>taxonClass</td><td>notesMgt</td><td>implementation field</td><td> </td></tr>
|
|
30
|
<tr><td>taxonInterpretation</td><td>revisions</td><td> </td><td>revisions</td><td> </td><td>taxonClass</td><td>revisions</td><td>implementation field</td><td> </td></tr>
|
|
31
|
<tr><td> </td><td> </td><td> </td><td> </td><td> </td><td>taxonClass</td><td>taxonClassType</td><td>"exact, aggregate, one-of, subset"</td><td>I suggested this in new comment on bug 1079</td></tr>
|
|
32
|
<tr><td> </td><td> </td><td> </td><td> </td><td> </td><td>taxonInterpretation</td><td>TAXONINTERPRETATION_ID</td><td> </td><td> </td></tr>
|
|
33
|
<tr><td> </td><td> </td><td> </td><td> </td><td> </td><td>taxonInterpretation</td><td>TAXONCLASS_ID</td><td> </td><td> </td></tr>
|
|
34
|
<tr><td>taxonInterpretation</td><td>PLANTCONCEPT_ID</td><td> </td><td>PLANTCONCEPT_ID</td><td> </td><td>taxonInterpretation</td><td>PLANTCONCEPT_ID</td><td> </td><td> </td></tr>
|
|
35
|
<tr><td>taxonInterpretation</td><td>PLANTNAME_ID</td><td> </td><td>PLANTNAME_ID</td><td> </td><td>taxonInterpretation</td><td>PLANTNAME_ID</td><td> </td><td>"keep this as PLANTNAME_ID or just a text field, as in TaxonObservation?"</td></tr>
|
|
36
|
<tr><td> </td><td> </td><td> </td><td>classFit</td><td>values?</td><td>taxonInterpretation</td><td>classFit</td><td>"absolutely right, good answer, understandable but wrong"</td><td> </td></tr>
|
|
37
|
<tr><td> </td><td> </td><td> </td><td>classConfidence</td><td>H-M-low</td><td>taxonInterpretation</td><td>classConfidence</td><td>"high, medium, low"</td><td> </td></tr>
|
|
38
|
<tr><td>taxonObservation</td><td>TAXONOBSERVATION_ID</td><td> </td><td>TAXONOBSERVATION_ID</td><td> </td><td>taxonObservation</td><td>TAXONOBSERVATION_ID</td><td> </td><td> </td></tr>
|
|
39
|
<tr><td>taxonObservation</td><td>OBSERVATION_ID</td><td> </td><td>OBSERVATION_ID</td><td> </td><td>taxonObservation</td><td>OBSERVATION_ID</td><td> </td><td> </td></tr>
|
|
40
|
<tr><td>taxonObservation</td><td>PLANTNAME_ID</td><td>nulls allowed for weird taxa</td><td>PLANTNAME_ID</td><td>nulls allowed for weird taxa</td><td>taxonObservation</td><td>plantName</td><td>text field now</td><td> </td></tr>
|
|
41
|
<tr><td>taxonObservation</td><td>reference_ID</td><td> </td><td>reference_ID</td><td> </td><td>taxonObservation</td><td>reference_ID</td><td> </td><td> </td></tr>
|
|
42
|
<tr><td>taxonObservation</td><td>taxonCollection</td><td>treat voucher as separate issue</td><td>taxonCollection</td><td>treat voucher as separate issue</td><td> </td><td> </td><td>collection handled in voucher table</td><td> </td></tr>
|
|
43
|
<tr><td>taxonObservation</td><td>taxonCover</td><td> </td><td>taxonCover</td><td> </td><td>taxonObservation</td><td>taxonCover</td><td> </td><td> </td></tr>
|
|
44
|
<tr><td>taxonObservation</td><td>taxonBasalArea</td><td> </td><td>taxonBasalArea</td><td> </td><td>taxonObservation</td><td>taxonBasalArea</td><td> </td><td> </td></tr>
|
|
45
|
<tr><td>taxonObservation</td><td>taxonInferenceArea</td><td> </td><td>taxonInferenceArea</td><td> </td><td>taxonObservation</td><td>taxonInferenceArea</td><td> </td><td> </td></tr>
|
|
46
|
<tr><td>taxonObservation</td><td>cheatPlantName</td><td> </td><td>cheatPlantName</td><td> </td><td> </td><td> </td><td>cheatPlantName no longer needed</td><td> </td></tr>
|
|
47
|
<tr><td> </td><td> </td><td>"deal with this idea with business rules: if a 'cheatplantname' occurs on a plot more than once, any records that have a stemCount record are considered 'individual', those without would be considered 'collective' (new BusRule: only one 'collective' taxonObs per cheatplantName per observation should be allowed. For option A, that would mean that only one taxonObs is allowed without stemCount record(s) referencing it."</td><td>taxonObservationType</td><td>add field</td><td>taxonObservation</td><td>taxonObservationType</td><td>"individual, collective"</td><td>"perhaps new terms are needed - 'entire taxon' or 'partial taxon' might be better terms as someone might have a taxonObservation and voucher for multiple individuals, but still just a subset of the taxon on a plot"</td></tr>
|
|
48
|
<tr><td> </td><td> </td><td> </td><td> </td><td> </td><td>voucher</td><td>VOUCHER_ID</td><td>"new table to attach to taxonObs (and, by reference, stem)"</td><td>"voucher could be very easily added, regardless of option A,B,C being chosen. I feel that this is a separate issue."</td></tr>
|
|
49
|
<tr><td> </td><td> </td><td> </td><td> </td><td> </td><td>voucher</td><td>TaxonObservation_ID</td><td> </td><td> </td></tr>
|
|
50
|
<tr><td> </td><td> </td><td> </td><td> </td><td> </td><td>voucher</td><td>Party_ID</td><td>collector</td><td> </td></tr>
|
|
51
|
<tr><td> </td><td> </td><td> </td><td> </td><td> </td><td>voucher</td><td>CollectionNumber</td><td> </td><td> </td></tr>
|
|
52
|
<tr><td> </td><td> </td><td> </td><td> </td><td> </td><td>voucher</td><td>Museum</td><td> </td><td> </td></tr>
|
|
53
|
<tr><td> </td><td> </td><td> </td><td> </td><td> </td><td>voucher</td><td>AccessionNumber</td><td> </td><td> </td></tr>
|
|
54
|
<tr><td> </td><td> </td><td> </td><td> </td><td> </td><td>voucher</td><td>CollectionDate</td><td> </td><td> </td></tr>
|
|
55
|
</table>
|