unhighlight
highlightVegBank Data Dictionary - Search Fields
|
| Search VegBank Tables Here |
«previous | 31 | 32 | page 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | next» |
| Table | Field | DB Field Name | Req'd? | Data Type | Misc Flag | List? | Definition |
|---|---|---|---|---|---|---|---|
| Party Member | Role | role_ID | no | Integer | FK | no | Link to the role which defines the child's role in the parent party. |
| Party Member | Member Start | memberStart | required | Date | n/a | no | Start date for the child's membership in the parent party. |
| Party Member | Member Stop | memberStop | no | Date | n/a | no | Stop date for the child's membership in the parent party. |
| Place | ID | PLOTPLACE_ID | no | serial | PK | no | Database generated identifier assigned to each unique plot occurrence at a place. |
| Place | Plot | PLOT_ID | required | Integer | FK | no | Link to a specific plot. |
| Place | Calculated? | calculated | no | Boolean | n/a | no | TRUE If occurrence is calculated based on geo-coordinates, FALSE if assigned by the author (If, both methods used, the author assigned value takes priority). |
| Place | Place Name | NAMEDPLACE_ID | required | Integer | FK | no | Link to a specific named place or region |
| Plot | ID | PLOT_ID | no | serial | PK | no | Database generated identifier assigned to each unique plot. |
| Plot | Author Plot Code | authorPlotCode | required | varchar (30) | n/a | no | Author's Plot number/code, or the original plot number if taken from literature. |
| Plot | Reference | reference_ID | no | Integer | FK | no | Link to the source reference from which this plot record was taken |