VegBank Data Dictionary - Search Fields
| Search VegBank Tables Here |
««more pages | «previous | 1 | 2 | 3 | page 4 | 5 | 6 | 7 | 8 | 9 | 10 | next» |
Table | Field | DB Field Name | Req'd? | Data Type | Misc Flag | List? | Definition |
---|---|---|---|---|---|---|---|
Community Usage | Community Name | COMMNAME_ID | required | Integer | FK | no | This field is the foreign key into the commName table. |
Community Usage | Usage Start | usageStart | no | Date | n/a | no | This is the date on which the party applied the name to the concept. |
Community Usage | Usage Stop | usageStop | no | Date | n/a | no | This is the date on which the party ceased to apply the name to the concept. |
Community Usage | Community Name Status | commNameStatus | no | varchar (20) | n/a | closed | This field shows the status of the application of the name to the concept by the party (standard, not standard, undetermined). |
Community Usage | Class System | classSystem | no | varchar (50) | n/a | open | This is the name of the classification system wherein the name is applied (e.g., Scientific, Spanish common). |
Community Usage | Comm Status | COMMSTATUS_ID | no | Integer | FK | no | Comm Status which applies to this commUsage. |
Plant Concept | ID | PLANTCONCEPT_ID | no | serial | PK | no | Database assigned value to each unique record in the commConcept table. |
Plant Concept | Plant Name | PLANTNAME_ID | required | Integer | FK | no | This is a foreign key into the plant name list, the entry in which when combined with a reference constitutes a concept. |
Plant Concept | Reference | reference_ID | required | Integer | FK | no | This is a foreign key to the reference in which the name was used, thereby defining a concept. |
Plant Concept | Plant Description | plantDescription | no | text | n/a | no | The plantDescription is a description of the plantConcept by the party contributing the plantConcept. |