VegBank Data Dictionary - Search Fields
| Search VegBank Tables Here |
«previous | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | page 30 | next» |
Table | Field | DB Field Name | Req'd? | Data Type | Misc Flag | List? | Definition |
---|---|---|---|---|---|---|---|
Observation | Notes Public | notesPublic | no | Boolean | n/a | no | TRUE indicates that public notes pertaining to this plot exist in "vegPlot.note" |
Observation | Notes Mgt | notesMgt | no | Boolean | n/a | no | TRUE indicates that nonpublic management notes pertaining to this plot exist in "vegPlot.note" |
Observation | Revisions | revisions | no | Boolean | n/a | no | TRUE indicates that revisions exist in vegPlot.Revision |
Observation Contributor | ID | OBSERVATIONCONTRIBUTOR_ID | no | serial | PK | no | Database generated identifier assigned to each unique contribution to an observation event. |
Observation Contributor | Observation | OBSERVATION_ID | required | Integer | FK | no | Foreign key pointing to a given plot observation event to which the contribution was made. |
Observation Contributor | Party | PARTY_ID | required | Integer | FK | no | Foreign key pointing to the specific party that made the contribution. |
Observation Contributor | Role | ROLE_ID | required | Integer | FK | no | Foreign key that identifies the role that the party had in the plot observation (e.g., PI, contact, research advisor, field assistant, taxonomist, owner, guide, etc.). |
Observation Contributor | Contribution Date | contributionDate | no | Date | n/a | no | The date of the specific contribution, which will generally be within the time span of the plot observation event defined by the obsStartDate and obsStopDate |
Observation Synonym | ID | OBSERVATIONSYNONYM_ID | no | serial | PK | no | Database generated identifier assigned to each unique interpretation of an observation as a synonym. |
Observation Synonym | Synonym Observation | synonymObservation_ID | required | Integer | FK | no | Link to the observation table identifying which observation is being reduced to synonymy. |