Turboveg 3 Indexes
HomeTablesSchemasDiagramsForeign KeysIndexes

Indexes

NameTableColumnsUniqueClustered
_ecodbase_index01_ecodbasetaxonid
_headerdata_index01_headerdataplotobservationid
_headerdata_index02_headerdatareleve_nr
_speciesdata_index01_speciesdataplotobservationid
_speciesdata_index02_speciesdatareleve_nr
associa_index01associaplotobservationid
associa_index02associaplotobservationid, lookupdataid

covercodes_index01covercodeslookupdataid, code

custodians_index01custodiansname

datasetgroups_index01datasetgroupsname

datasets_index01datasetsdatasetgroupid
datasets_index02datasetsname

datasetgroups_index02fieldgroupsname

fields_index01fieldsfielddomainid, fieldname, fieldtype

locations_index01locationsthe_geom
lookupcaptions_index01lookupcaptionslookuptableid, columnno

lookuptabledata_index01lookupdatalookuptableid, lookuptableid, description1, description2, description3, description4

lookuptables_index01lookuptablesfilename, description

pictures_index01picturesplotobservationid
plotobservationheaderdata_index01plotobservationheaderdataplotobservationid
plotobservationheaderdata_index02plotobservationheaderdatafieldid
plotobservations_index01plotobservationsplotid
plotobservations_index02plotobservationsguid

plots_index01plotsdatasetid
profiledata_index01profiledataprofileid, fieldid
profiles_index01profilesname

projects_index01projectsname

speciesobservationdata_index01speciesobservationdataspeciesobservationid
speciesobservationdata_index02speciesobservationdatafieldid
observationsspecies_index01speciesobservationsplotobservationid
observationsspecies_index02speciesobservationsplotobservationid, taxonid, vegetationlayerid, originaltaxonconcept

observationsspecies_index03speciesobservationstaxonid
taxa_index01taxataxonlistid, scientificname, tv2speciesid

taxa_index02taxatv2speciesid
taxa_index03taxataxonlistid
taxa_index04taxasbsspeciesid
speciesgroups_index01taxongroupsname

floras_index01taxonlistsname

traitdata_index01traitdatataxonid
traitdata_index02traitdatataxonid, fieldid

units_index01unitsname