Table Columns

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

  Sort columns ordinally
  Sort columns alphabetically

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