VegBank Data Dictionary - Search Fields
| Search VegBank Tables Here |
««more pages | «previous | 1 | page 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next» |
Table | Field | DB Field Name | Req'd? | Data Type | Misc Flag | List? | Definition |
---|---|---|---|---|---|---|---|
Community Correlation | Correlation Stop | correlationStop | no | Date | n/a | no | This is the stop date for recognition by a party of a correlation between two concepts. |
Community Lineage | ID | COMMLINEAGE_ID | no | serial | PK | no | Database assigned value to each unique record in the commLineage table. |
Community Lineage | Parent Community Status | parentCommStatus_ID | required | Integer | FK | no | This is the foreign key into the commStatus table "pointing" to a parent concept. |
Community Lineage | Child Community Status | childCommStatus_ID | required | Integer | FK | no | This is the foreign key into the commStatus table "pointing" to a child concept. |
Community Name | ID | COMMNAME_ID | no | serial | PK | no | Database assigned value to each unique record in the commName table. |
Community Name | Community Name | commName | required | text | n/a | no | The community name. |
Community Name | Reference | reference_ID | no | Integer | FK | no | Foreign key into reference to identify the source of the name. |
Community Name | Date Entered | dateEntered | no | Date | n/a | no | Field stores the date that the name was entered into the database. |
Community Status | ID | COMMSTATUS_ID | no | serial | PK | no | Database assigned value to each unique record in the commStatus table. |
Community Status | Community Concept | COMMCONCEPT_ID | required | Integer | FK | no | Foreign key to identify the concept to which a party assigns a status |