If the column has constrained values they are listed under values on the far right. Click on MORE to see full list and description of constrained values.
Back to table listings
Columns in table "ih"
Column |
Data Type |
Null |
Description |
Values |
*AddEmail |
text |
YES |
|
|
*AddEmuUserId |
text |
YES |
|
|
*AddPhysCity |
text |
YES |
|
|
*AddPhysCountry |
text |
YES |
|
|
*AddPhysPost |
text |
YES |
|
|
*AddPhysState |
text |
YES |
|
|
*AddPhysStreet |
text |
YES |
|
|
*AddPostCity |
text |
YES |
|
|
*AddPostPost |
text |
YES |
|
|
*AddPostState |
text |
YES |
|
|
*AddPostStreet |
text |
YES |
|
|
*AddWeb |
text |
YES |
|
|
*AdmDateModified |
text |
YES |
|
|
*AdmTimeModified |
text |
YES |
|
|
*eparties_key |
integer |
YES |
|
|
*HisCommenced |
text |
YES |
|
|
*IhhAssociatedHerbaria |
text |
YES |
|
|
*IhhCites |
text |
YES |
|
|
*IhhExchange |
text |
YES |
|
|
*IhhGeography |
text |
YES |
|
|
*IhhInstitutionType |
text |
YES |
|
|
*IhhStatus |
text |
YES |
|
|
*IhhTotal |
text |
YES |
|
|
*irn |
text |
YES |
|
|
lat |
numeric |
YES |
Decimal latitude |
|
long |
numeric |
YES |
Decimal longitude |
|
*NamBranch |
text |
YES |
|
|
*NamDepartment |
text |
YES |
|
|
*NamFax |
text |
YES |
|
|
*NamOrganisation |
text |
YES |
|
|
*NamSection |
text |
YES |
|
|
*NotNotes |
text |
YES |
|
|
observationGranularity |
text |
NO |
|
|
sourceType |
text |
NO |
|
|
specimen_duplicate_institutions |
character varying |
NO |
|
|
*url |
text |
YES |
|
|
url_old |
text |
YES |
|
|
acronym |
text |
YES |
Standard Index Herbaiorum herbarium acronym |
|
fk_gnrs_id |
bigint |
YES |
Foreign key to table gnrs |
|
poldiv_full |
text |
YES |
[internal use] |
|
country_verbatim |
text |
YES |
Verbatim country, as submitted |
|
state_province_verbatim |
text |
YES |
Verbatim state/province, as submitted. |
|
country |
text |
YES |
Standard country name from geonames database (GNRS) |
|
state_province |
text |
YES |
Standard state/province name from geonames database (GNRS) |
|
latlong_verbatim |
text |
YES |
Verbatim latitude and longitude |
|
lat_text |
text |
YES |
Verbatim latitude |
|
long_text |
text |
YES |
Verbatim longitude |
|
|