unhighlight
highlightVegBank Data Dictionary - Search Fields
|
| Search VegBank Tables Here |
| ««more pages | «previous | page 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | next» |
| Table | Field | DB Field Name | Req'd? | Data Type | Misc Flag | List? | Definition |
|---|---|---|---|---|---|---|---|
| Community Concept | ID | COMMCONCEPT_ID | no | serial | PK | no | Database assigned value to each unique record in the commConcept table. |
| Community Concept | Community Name | COMMNAME_ID | required | Integer | FK | no | Foreign key into the commName table providing the name used for the community when it was defined by usage in a publication (which could be this database). |
| Community Concept | Community Name | commName | no | text | denorm | no | The name the community is based on, denorm of commName_ID |
| Community Concept | Reference | reference_ID | no | Integer | FK | no | Foreign key into the Reference table to identify a reference in which the community was identified by a name. This could be a regular publication, or a self reference created by completing the commDescription field in reference |
| Community Concept | Community Description | commDescription | no | text | n/a | no | The commDescription is a description of the community concept by the party that contributed the concept. |
| Community Concept | Accession Code | accessionCode | no | varchar (100) | n/a | no | Code that uniquely references this record, allowing reference to this record for this version of this database. Better than a primary key, which is automatically generated by a database and not globally unique. VegBank Accession codes are only generated by VegBank, and therefore data integrity can be guaranteed, unlike with a primary key (number). |
| Community Concept | Plot Count | d_obscount | no | Integer | denorm | no | Number of observations associated with this entity. |
| Community Concept | Currently Accepted by Someone | d_currentaccepted | no | Boolean | denorm | no | Currently accepted by at least one party. |
| Community Correlation | ID | COMMCORRELATION_ID | no | serial | PK | no | Database assigned value to each unique record in the communityCorrelation table. |
| Community Correlation | Community Status | COMMSTATUS_ID | required | Integer | FK | no | This is the foreign key into the CommStatus table "pointing" to a concept no longer viewed as standard by the party. |