VegBank Data Dictionary - Search Fields
| Search VegBank Tables Here |
««more pages | «previous | 1 | 2 | 3 | 4 | 5 | page 6 | 7 | 8 | 9 | 10 | next» |
Table | Field | DB Field Name | Req'd? | Data Type | Misc Flag | List? | Definition |
---|---|---|---|---|---|---|---|
Plant Name | ID | PLANTNAME_ID | no | serial | PK | no | Database assigned value to each unique record in the plantName table. |
Plant Name | Plant Name | plantName | required | varchar (255) | n/a | no | The plant name. |
Plant Name | Reference | reference_ID | no | Integer | FK | no | Foreign key into the reference table to identify the original source of the name (usually the type description). |
Plant Name | Date Entered | dateEntered | no | Date | n/a | no | Field stores the date that the name was entered into the database. |
Plant Status | ID | PLANTSTATUS_ID | no | serial | PK | no | Database assigned value to each unique record in the plantStatus table. |
Plant Status | Plant Concept | PLANTCONCEPT_ID | required | Integer | FK | no | Foreign key to identify the concept to which a party assigns a status |
Plant Status | Reference | reference_ID | no | Integer | FK | no | Link to a reference where the status was reported |
Plant Status | Plant Concept Status | plantConceptStatus | required | varchar (20) | n/a | closed | Status of the concept by the party (accepted, not accepted, undetermined) |
Plant Status | Start Date | startDate | required | Date | n/a | no | This is the date for which the status assignment by the party started. |
Plant Status | Stop Date | stopDate | no | Date | n/a | no | This is the date for which the status assignment by the party ended. |