VegBank Data Dictionary - Search Fields
| Search VegBank Tables Here |
«previous | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | page 39 | 40 | next» |
Table | Field | DB Field Name | Req'd? | Data Type | Misc Flag | List? | Definition |
---|---|---|---|---|---|---|---|
Revision | ID | REVISION_ID | no | serial | PK | no | Database generated identifier assigned to each unique revision. |
Revision | Table Name | tableName | required | varchar (50) | n/a | no | Name of the table where the change occurred. |
Revision | Table Attribute | tableAttribute | required | varchar (50) | n/a | no | The name of the attribute where the chance occurred. |
Revision | Table Record | tableRecord | required | Integer | n/a | no | The number of the record in which the change occurred (i.e., the value of the primary key associated with the value in which the change occurred) |
Revision | Revision Date | revisionDate | required | Date | n/a | no | The date on which the revision was made. |
Revision | Previous Value Text | previousValueText | required | text | n/a | no | The previous value as a character string. |
Revision | Previous Value Type | previousValueType | required | varchar (20) | n/a | no | The data type of the attribute changed. |
Revision | Previous Revision | previousRevision_ID | no | Integer | FK | no | Pointer to a previous record of a revision. |
Soil Observation | ID | SOILOBS_ID | no | serial | PK | no | Database generated identifier assigned to each unique soil observation. |
Soil Observation | Observation | OBSERVATION_ID | required | Integer | FK | no | Link to the observation event to which this soil observation is associated. |