NaTron RDBMS

Table geo.AdministrativeBoundaries

- A list of political and administrative boundaries organising geographically the Locations into administrative areas. The data was extracted from the GADM database (www.gadm.org), version 2.8, November 2015. The geodetic coordinates are processed with ArcGis 10.3 as centroid point, the boundary line has 1km precision. The Norwegian administrative topology is updated with the N250 product from Statens Kartverk https://kartkatalog.geonorge.no/metadata/kartverket/n250-kartdata/442cae64-b447-478d-b384-545bc1d9ab48.

Idx	Field Name	Data Type	Description
*	administrativeBoundaryID	uuid DEFAULT data.uuid_generate_v4()	- A global unique identifier for an administrative boundary.
	parentID	uuid
	originalID	integer	- The unique identifier for an administrative boundary originating from the GADM database.
	geom	geometry	- A geografic georeference containing the GIS geometric type as MULTIPOLYGON. Coordinates system is EPSG 4326 GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]].
*	continentID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the continent a country derive from. Example: Europe.
	country	varchar(75)	(DwC) - The name of the country or major administrative unit in which the Location occurs. Example: France.
	stateProvince	varchar(75)	(DwC) - The name of the next smaller administrative region than country (state, province, canton, department, region, etc.) in which the Location occurs. Example: Île-de-France.
	county	varchar(75)	(DwC) - The full, unabbreviated name of the next smaller administrative region than stateProvince (county, shire, etc.) in which the Location occurs. Example: Seine-et-Marne.
	district	varchar(75)	- The full, unabbreviated name of the next smaller administrative region than county (department, municipality, etc.) in which the Location occurs. Do not use this term for a nearby named place that does not contain the actual location. Example: Meaux.
	municipality	varchar(100)	(DwC) - The full, unabbreviated name of the next smaller administrative region than district (city, municipality, etc.) in which the Location occurs. Do not use this term for a nearby named place that does not contain the actual location. Example: Meaux-Nord
	parish	varchar(75)	- The full, unabbreviated name of the next smaller administrative region than municipality (municipality, village, etc.) in which the Location occurs. Do not use this term for a nearby named place that does not contain the actual location. Example: Varreddes
	administrativeName	varchar(100)	- The full, unabbreviated name of the smallest administrative rank in which the Location occurs. . Do not use this term for a nearby named place that does not contain the actual location.
*	administrativeRank	varchar(6) DEFAULT 'NAME_0'::character varying	- The rank name classifying the political and administrative names into a hierarchy. Example: NAME_0: country/land, NAME_1: state province/fylke, NAME_2: county/kommune, NAME_3: district, NAME_4: municipality, NAME_5: parish.
	isParent	integer	- A flag indicating if a geometric object is parent for geometric objects. Example: country Norway is parent for all the state provinces Sør-Trøndelag, Nord-Trøndelag, ....
*	featureClass	varchar(15) DEFAULT 'Country'::character varying	- The administrative hierarchy name corresponding to the administrative rank of the country political division. Example: Country, State province, County, District, Municipality, Parish
*	geodeticDatum	varchar(10) DEFAULT 'WGS84'::character varying	(DwC) - The ellipsoid, geodetic datum, or spatial reference system (SRS) upon which the geographic coordinates given in decimalLatitude and decimalLongitude as based. Example: "WGS84", "ED50". ZOOTRON_I equivalent: Datum.
*	decimalLatitude	numeric(12,8) DEFAULT 0	(DwC) - The geographic latitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location. Positive values are north of the Equator, negative values are south of it. Legal values lie between -90 and 90, inclusive. Example: 59,123456789. ZOOTRON_I equivalent: StLatitude
*	decimalLongitude	numeric(12,8) DEFAULT 0	(DwC) - The geographic longitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location. Positive values are east of the Greenwich Meridian, negative values are west of it. Legal values lie between -180 and 180, inclusive. Example: 10,123456789. ZOOTRON_I equivalent: StLongitude
*	modified	timestamp DEFAULT clock_timestamp()	(DwC) - The date the record is last modified. Example: 2016-02-08. ZOOTRON_I equivalent: DateOfModification.
*	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The user name identifying the person who modified last the record. The name has to comply an existing name from the database name register, starting with first/given name and ending with family/surname. Example: vmzomdav. ZOOTRON_I equivalent: UserRec as Operator.
	names	varchar(255)
	administrativeNumber	integer
Indexes
	l_AdministrativeBoundaries_pkey1	ON administrativeBoundaryID
	ndxAdministrativeBoundaries_administrativeMultiPolygon	ON geom
	ndxAdministrativeBoundaries_administrativeName	ON administrativeName
	ndxAdministrativeBoundaries_continentID	ON continentID
	ndxAdministrativeBoundaries_country	ON country
	ndxAdministrativeBoundaries_county	ON county
	ndxAdministrativeBoundaries_isParent	ON isParent
	ndxAdministrativeBoundaries_rank	ON administrativeRank
	ndxAdministrativeBoundaries_stateProvince	ON stateProvince
	ndxAdministrativeBoundaries_names	ON names
	ndxAdministrativeBoundaries_parentID	ON parentID
Foreign Keys
	FK_l_AdministrativeBoundaries_l_Continents	( continentID ) ref Continents (continentID)
Triggers
	administrative_before_edit

Table geo.AdministrativeNames

Idx	Field Name	Data Type
	administrativeBoundaryID	uuid
	administrativeRank	varchar(6)
	administrativeName	varchar(100)
	administrativeNames	text
Indexes
	ndx_administrativenames_administrativeboundaryid	ON administrativeBoundaryID
	ndx_administrativenames_names	ON administrativeNames
Foreign Keys
	fk_administrative_boundaries_names	( administrativeBoundaryID ) ref AdministrativeBoundaries (administrativeBoundaryID)

Table lib.ArtsnavneBasen

- A list of official taxa names with their taxonomical hierarchy.

Idx	Field Name	Data Type
*	PK_LatinskNavnID	integer
	ScientificName	varchar(255)
	Rike	varchar(255)
	Underrike	varchar(255)
	Rekke	varchar(255)
	Underrekke	varchar(255)
	Overklasse	varchar(255)
	Klasse	varchar(255)
	Underklasse	varchar(255)
	Infraklasse	varchar(255)
	Kohort	varchar(255)
	Overorden	varchar(255)
	Orden	varchar(255)
	Underorden	varchar(255)
	Infraorden	varchar(255)
	Overfamilie	varchar(255)
	Familie	varchar(255)
	Underfamilie	varchar(255)
	Tribus	varchar(255)
	Undertribus	varchar(255)
	Slekt	varchar(255)
	Underslekt	varchar(255)
	Seksjon	varchar(255)
	Art	varchar(255)
	Underart	varchar(255)
	Varietet	varchar(255)
	Form	varchar(255)
	FK_OverordnaLatinskNavnID	integer
	FK_TypeEksID	integer
	SistEndraMeningDato	timestamp
	Autorstreng	varchar(255)
	Hovedstatus	varchar(255)
	Bistatus	varchar(255)
	SistEndraDato	timestamp
	DagensDato	timestamp
	Forfatter	varchar(255)
	Aar	varchar(255)
	Referanse	varchar(255)
	Kommentar	varchar(255)
	PK_TaksonID	integer
	FK_GyldigLatinskNavnID	integer
	FinnesINorge	integer
Indexes
	r_ArtsnavneBasen_pkey	ON PK_LatinskNavnID
	ndx_r_ArtsnavneBasen_ScientificName	ON ScientificName
	ndx_artsnavnebasen_fk_latinsknavn	ON FK_OverordnaLatinskNavnID

Table lib.Backbone

Idx	Field Name	Data Type
*	taxonID	bigint
	datasetID	varchar(50)
	parentNameUsageID	bigint
	acceptedNameUsageID	bigint
	originalNameUsageID	bigint
	scientificName	varchar(500)
	scientificNameAuthorship	varchar(500)
	canonicalName	varchar(100)
	genericName	varchar(100)
	specificEpithet	varchar(100)
	infraspecificEpithet	varchar(100)
	taxonRank	varchar(100)
	nameAccordingTo	varchar(100)
	namePublishedIn	varchar(100)
	taxonomicStatus	varchar(100)
	nomenclaturalStatus	varchar(100)
	taxonRemarks	varchar(500)
	kingdom	varchar(100)
	phylum	varchar(100)
	class	varchar(100)
	order	varchar(100)
	family	varchar(100)
	genus	varchar(100)
*	taxonUUID	uuid DEFAULT data.uuid_generate_v4()
Indexes
	ndx_taxonid	ON taxonID

Table geo.Catchments

- A list of hydrografic regions/divisions grouping geografic land and water elements into a topografic hierarchy. Catchement are organised and chained per main water course using an icremented alpha numeric hierarchy code system as "catchementNumber". The register is hosted by Geonorge/Statens Kartverk https://kartkatalog.geonorge.no/metadata/norges-vassdrags-og-energidirektorat/regine-enhet/8721cdac-f959-4adc-9d54-d3b770e5fa1e

Idx	Field Name	Data Type
*	catchmentID	uuid DEFAULT data.uuid_generate_v4()
	geom	geometry
*	fjordID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	catchmentAreaNumber	varchar(9)
	catchmentNumber	varchar(12)
	catchmentName	varchar(30)
Indexes
	Catchmentid_pkey	ON catchmentID
	ndx_catchment_catchmentname	ON catchmentName
	ndx_catchment_catchmentnumber	ON catchmentNumber
	ndx_catchment_fjordid	ON fjordID
	ndx_catchment_geom	ON geom
Foreign Keys
	fk_catchment_fjord	( fjordID ) ref Fjords (fjordID)

Table lib.CollectionNames

- A list of collection names organizing taxonomic occurrences into organism group or collection type.

Idx	Field Name	Data Type	Description
*	collectionID	uuid DEFAULT data.uuid_generate_v4()	(DwC) - A global unique identifier for a collectionCode. Example: 1. ZOOTRON_I equivalent: CollectionNameRec.
	institutionCode	varchar(100) DEFAULT 'NTNU-VM'::character varying	(DwC) - The name (or acronym) in use by the institution having custody of the object(s) or information referred to in the record. Example: "NTNU-VM". ZOOTRON_I equivalent: InstitutionName.
*	collectionName	varchar(256)	(DwC) - The name, acronym, coden, or initialism identifying the collection or set of data from which the record derive. Example: "Fish", "Fish scale and otolitt", "Zooplankton". ZOOTRON_I equivalent: DatabaseName.
*	collectionCodeSuffix	integer DEFAULT nextval('lib."l_CollectionNames_collectionCodeSuffix_seq"'::regclass)	- The ordinal number identifying in GBIF DwC the collection or set of data from which the record derive. Example: 1. ZOOTRON_I equivalent: CollectionNameRec.
*	modified	timestamp DEFAULT clock_timestamp()	(DwC) - The date the record is last modified. Example: 2016-02-08. ZOOTRON_I equivalent: DateOfModification.
	collectionCode	varchar(15)
	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The user name identifying the person who modified last the record. The name has to comply an existing name from the database name register, starting with first/given name and ending with family/surname. Example: vmzomdav. ZOOTRON_I equivalent: UserRec as Operator.
	collectionName_old	varchar(256)
*	dataSchemaID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
Indexes
	l_CollectionNames_pkey	ON collectionID
	ndx_collectionCode	ON collectionName
	ndx_collectionCodeSuffix	ON collectionCodeSuffix
Foreign Keys
	fk_collection_dataschema	( dataSchemaID ) ref DataSchemas (dataSchemaID)

Table geo.Continents

- A list of continents and continent parts organising geographically the countries. These data were extracted from the GADM database (www.gadm.org), version 2.8, November 2015. The geodetic coordinates are processed with ArcGis 10.3 as centroid point.

Idx	Field Name	Data Type	Description
*	continentID	uuid DEFAULT data.uuid_generate_v4()	- A unique local identifier for a continent and continent part.
	continent	varchar(75)	(DwC) - The name of the continent in which the Location occurs. Example: Europe.
	continentPart	varchar(75)	- The name of the continent part in which the Location occurs. Example: Northern Europe.
*	modified	timestamp DEFAULT clock_timestamp()	(DwC) - The date the record is last modified. Example: 2016-02-08. ZOOTRON_I equivalent: DateOfModification.
	continentOriginalID	integer	- The unique identifier for a continent originating from the GADM database.
*	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The user name identifying the person who modified last the record. The name has to comply an existing name from the database name register, starting with first/given name and ending with family/surname. Example: vmzomdav. ZOOTRON_I equivalent: UserRec as Operator.
Indexes
	l_Continents_pkey1	ON continentID
	ndxContinents_continent	ON continent
	ndxContinents_continentPart	ON continentPart
	ndxContinents_continentID	ON continentOriginalID

Table lib.DataSchemas

- A list of data schema names defining the data architecture and layout with which occurrence data are save as.

Idx	Field Name	Data Type	Description
*	dataSchemaID	uuid DEFAULT data.uuid_generate_v4()	- A global unique identifier for a data schema name. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
*	dataSchemaName	varchar(256)	(DwC) - The name identifying the data layout. Example: 1. ZOOTRON_I equivalent: DatabaseName.
*	catalogNumberPrefix	integer DEFAULT nextval('lib."l_DataSchemas_catalogNumberPrefix_seq"'::regclass)	(DwC) - An identifier making a catalogNumber unique across the collection names. Example: 1. ZOOTRON_I equivalent: DatabaseRec.
*	modified	timestamp DEFAULT clock_timestamp()	(DwC) - The date the record is last modified. Example: 2016-02-08. ZOOTRON_I equivalent: DateOfModification.
	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The user name identifying the person who modified last the record. The name has to comply an existing name from the database name register, starting with first/given name and ending with family/surname. Example: vmzomdav. ZOOTRON_I equivalent: UserRec as Operator.
	dataSchemaName_old	varchar(256)
*	databaseID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	dsCollectionCode	varchar(15)
Indexes
	l_DataSchemas_pkey	ON dataSchemaID
	ndx_dataSchemaName	ON dataSchemaName
	ndx_catalogNumberPrefix	ON catalogNumberPrefix
	fki_fk_database_dataschema	ON databaseID
Foreign Keys
	fk_database_dataschema	( databaseID ) ref Databases (databaseID)

Table lib.Databases

Idx	Field Name	Data Type
*	databaseID	uuid DEFAULT data.uuid_generate_v4()
	databaseName	varchar(50)
Indexes
	pk_database	ON databaseID

Table lib.Datasets

A list of resource names from which sampling events and occurrences derive.

Idx	Field Name	Data Type	Description
*	NaTron_datasetID	uuid DEFAULT data.uuid_generate_v4()	(DwC) - A global unique publishing identifier for a dataset name. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
	ipt_datasetid	uuid
*	NaTron_datasetName	varchar(256)	The resource name identifying a project or dataset name from which a set of sampling events and occurrences derive. Example: Vefsnavassdraget.1973-1978.JIK.(Bunndyr).
	datasetRemark	text	- The description or explanation on how the data is collected and or processed into the database. In general any description necessary to the understanding of the geographical and ecological data. Example: Primary data er punched from the report... .
	taxonomicCoverage	text	- A list of vernecular and or taxonomic names seperated with "\|" describing the taxonomic extent for the dataset name. Example: Benthic invertabrates \| Pelagic invertebrate \| Salmo trutta.
*	archiveID	varchar(255) DEFAULT 0	- A hierarchical enumeration and or ordinal number as archive reference representing a physical place where hard copy documentation can be stored. Best practice: use an ontological combination of building name with room number and other container separated with "\|" as an enumeration separator.
*	modified	timestamp DEFAULT clock_timestamp()	(DwC) - The date the record is last modified. Example: 2016-02-08. ZOOTRON_I equivalent: DateOfModification.
*	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The user name identifying the person who modified last the record. The name has to comply an existing name from the database name register, starting with first/given name and ending with family/surname. Example: vmzomdav. ZOOTRON_I equivalent: UserRec as Operator.
	geographicCoverage	text	- A list of administrative division and or locality names seperated with "\|" describing the geographical extent for the dataset name. Example: Sørfold \| Kobbelva.
	registrationStatus	varchar(25) DEFAULT 'Unknown'::character varying	The digitalization level describing how much data is processed. "Unknown", "No record processed", "Partially digitized", "Fully digitized"
	description	text	A brief overview of the resource that is being documented broken into paragraphs. Hint: Abstract is a good candidat.
	temporalCoverage	text	Please enter metadata about the time periods covered by the resource. First select the type of time period, then fill in the form fields that appear.
	project	text	Please enter metadata about the project under which the data in this resource were produced. e.g. Title, Funding, Study Area Description and Design Description.
	samplingMethods	text	Please enter metadata about the sampling methods used for the data represented by the resource. e.g. Study Extent, Sampling Description, Quality Control, Step Description.
	Aktivitet_id	varchar(10) DEFAULT 'NA'::character varying	The code in Vannmiljø to identify the activity. https://vannmiljokoder.miljodirektoratet.no/Activity.aspx
	exportToVannmiljo	bool DEFAULT false	The flag to mark dataset for export to Vannmiljø.
	Parameter_id	varchar(25) DEFAULT 'UKJENT'::character varying	The code in Vannmiljø identifying a parameter. https://vannmiljokoder.miljodirektoratet.no/Parameter.aspx?p=BIO Felt for å oppgi hvilken parameter som er målt eller observert, f.eks. kjemiske komponenter, biologiske indikatorer eller fysiske egenskaper. Parameter_id hentes fra egen søkbar liste av lovlige verdier. Det følger også informasjon om lovlige kombinasjoner av Parameter_id, Medium_id, Prøvetakingsmetode_id og Enhet_id.
	contractingAuthority	varchar(255)	Felt for å oppgi hvem som står ansvarlig for anskaffelsen av et overvåkingsoppdrag. Oppdragsgiver er i mange tilfeller synonym med den virksomheten som har ansvaret for forvaltningen av datasettet i Vannmiljø. Dersom det er gitt pålegg om overvåking gjennom myndighetsutøvelse er det den pålagte virksomheten som er oppdragsgiver. Pålegget innebærer også krav om registrering/import av data i Vannmiljø. Virksomheten skal oppgis med gjenkjennelig navn, dvs. enten med fullt navn eller med den forkortelse som oppdragsgiver selv oppgir.
Indexes
	l_Datasets_pkey	ON NaTron_datasetID
	ndx_datasetName	ON NaTron_datasetName
	ndx_datasetID	ON ipt_datasetid
	fki_fk_registrationStatus_Datasets	ON registrationStatus
Foreign Keys
	fk_registrationStatus_Datasets	( registrationStatus ) ref RegistrationStatus (registrationStatus)
Triggers
	datasets_before_edit

Table lib.DocumentStatus

- A list of anacronym describing the status of a document.

Idx	Field Name	Data Type	Description
*	documentStatus	varchar(25)	The storage state describing how the document is stored: "Unknown", "Analog", "Digitized", "Both".
Indexes
	documentStatus_pkey	ON documentStatus

Table lib.DocumentTypes

- A list anacronym describing a document.

Idx	Field Name	Data Type	Description
*	documentType	varchar(25)	- Select from the list the anacronym describing the type of document to be uploaded.
Indexes
	documentType_pkey	ON documentType

Table data.Documentations

- A list of documents associated to the data. Documents can be articles, photos and other digital documention.

Idx	Field Name	Data Type	Description
*	documentationID	uuid DEFAULT data.uuid_generate_v4()	- A unique global identifier for a documentation.
*	category	varchar(25) DEFAULT 'Unknown'::character varying	- The name describing the register source the documentation is associated to. Example: Datasets, Publications, Locations, Events....
*	objectID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The foreign key for the objectID binding a documentation to a datasetID, publicationID, locationID, eventID, samplingProtocolID, taxonID, occurenceID. The origin/value of the objektID is defined by the category. Example: FA9BDA94-A25B-428F-A65A-74ABDFD80E6D.
	recordedBy	varchar(255)	(DwC) - The names identifying the persons who deposit the documentation, Use the "\|" to seperate names. Example: Gaute Kjærstad \| Lars Rønning.
	date	timestamp	(DwC) - The date and time when the document is issued or published.
	fileName	varchar(100)	- The name of the file the document is saved as.
	uri	varchar(255)	- The full internet address to access the documentation to be uploaded.
	modified	timestamp DEFAULT clock_timestamp()
*	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	documentName	varchar(255)	- The name describing the content of the document.
	modified1	date DEFAULT clock_timestamp()
	originalFileName	varchar(255)	The literal name of the submit data file as it is uploaded.
	documentStatus	varchar(25) DEFAULT 'Unknown'::character varying	The storage state describing how the document is stored: "Unknown", "Analog", "Digitized", "Both".
	archiveReference	varchar(50)	The reference describing the location of a document in a fysical archive structure. Example: "box 3, file...". The "archiveReference" has to be used with the "Datasets"."archiveID" locating a document in a place name. "Building ..., Rom..."
*	parentDocumentationID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - A global unique identifier that groups/nest/serialize documentations. A "parentEventID" identifies the main Whittaker Plot in nested documentations, each with its own "documentationID". Use the "documentationID" of a higher hierarchical dependence as "parentDocumentationID" to nest lower "documentationID" as child event. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
	documentType	varchar(25)
	registrationDate	date DEFAULT clock_timestamp()	- The date the record is first registered.
Indexes
	Documentations_pkey	ON documentationID
	ndx_documentations_objectID	ON objectID
	ndx_documentations_documentName	ON documentName
	fki_fk_Documentations_DocumentStatus	ON documentStatus
	ndx_documentations_type	ON documentType
Foreign Keys
	fk_Documentations_DocumentStatus	( documentStatus ) ref DocumentStatus (documentStatus)
	fk_Documentations_DocumentTypes	( documentType ) ref DocumentTypes (documentType)
Triggers
	documentations_before_edit

Table data.Events

- A list of sampling events with which occurrences and measurements or facts are collected. Sampling events can be nested within each other (e.g. a gill-net chain event can consist data recorded on several indivdiual gillnets). The nesting is described by a recursive datamodel, where each child event is identified back to its parent using the parentEventID (UUID).

Idx	Field Name	Data Type	Description
*	eventID	uuid DEFAULT data.uuid_generate_v4()	(DwC) - A global unique publishing identifier for a sampling event. Use the "parentEventID" to serialize/nest "eventID". GBIF portal https://www.gbif.org/. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
*	parentEventID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - A global unique identifier that groups/nest/serialize sampling events. A "parentEventID" identifies the main Whittaker Plot in nested samples, each with its own "eventID". Use the "eventID" of a higher hierarchical dependence as "parentEventID" to nest lower "eventID" as child event. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
*	dataSchemaID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The foreign key for a dataSchemaName in the lib.DataSchema register ("Pattedyr", "Fisk forskning"), organising data collection into an organism data collection type. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
*	collectionID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the "collectionCode", "CollectionName" and "institutionCode" in the lib.CollectionName register ("Type", "Fugl"), organising data into object collection. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
*	NaTron_datasetID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the "datasetName" in the lib.Dataset register ("10-års vernedevassdrag", "Åbjøra 15 år etter regulering"), organising data collection into ecological/research project theme. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
*	locationID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the "locality", "siteNumber" and "stationNumber" in the Location register a sampling event originates from. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
	experiment	varchar(25)	A name organising/associating sampling events into an experiment within a locality, site and station. Example: Browsed, Unbrowsed, Storfragment, Småfragment, Rotenone treated, before treatment...
	recordedBy	varchar(255)	(DwC) - The names identifying the persons who deposit the specimen, Use the "\|" to seperate names. Example: Gaute Kjærstad \| Lars Rønning.
*	samplingProtocolID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the sampling protocol name in the lib.SamplingProtocols register ("Surber", "Gillnet"), a sampling event is collected with. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
	samplingEffort	integer	(DwC) - The number of time or the number of samplingProtocol a sample consist of as a sampling event. Example: 1, 2...
	eventDate	timestamp	DWC - The date and time when the sampling event is taken - only use date when no sampling time is noted. Use number of hours +/- greenwich time to identify the time zone. Example: 2004-10-19 10:23:54+02.
*	dateQualifier	varchar(20) DEFAULT '0-No date'::character varying	- An identifier for the date accurracy. Example: "O-No date";"Doubtful day/month";"Estimated date";"Complete date".
	seasonNumber	varchar(10)	- An alphanumeric acronym identifier ordering, incrementing and grouping sampling events as sampling season. Scattered or series of sampling eventDates overlapping months can be sequenced using seasonNumber and used to automate periodic time spent. Example Winter...
	periodNumber	varchar(10)	- An alphanumeric acronym identifier ordering, incrementing and grouping sampling events as field work period. A field work periode can overlap two months and have several sampling days, sequencing several sampling eventDates will automate periodic time spent. Example: Field work 1...
	samplingDuration	numeric(12,8) DEFAULT 0	- The sampling duration the sampling event is carried in day decimal, decimal as time fraction of 24 hour day in second. Example: 1 day = 1 12 hours = 0,5 2 days and 12 hours = 2,5. There is 86400 seconds in 1 day and 1440 minutes in 1 day. 1 second = 0,000011574 = (246060)/1 1 minute = 0,000694444 = (24*60)/1 1 hour = 0,041666667 = 24/1.
	sampleNumber	varchar(50)	An alphanumeric acronym identifier ordering and incrementing sampling events within a locality, site, station, experiment and eventDate. Example: 1,2,2A,2B,3-infinit.
	roundNumber	varchar(10)	- An alphanumeric acronym identifier ordering and incrementing sampling events within an eventDate and sampleNumber. example 1, 2, 3A...
	sampleSizeUnit	varchar(25) DEFAULT ''::character varying	(DwC) - The unit the sampling event is assest with. Example: mesh size (my, mm, omf) area (km,hectar,meter) volume (meter, cm). See samplingSizeValue for the size value corresponding to the unit.
	sampleSizeValue	numeric(12,4)	(DwC) - The amount, quantity or number of the samplingSizeUnit use to assess the sampling event. example 500, 1, 3...
	minimumDistanceAboveSurfaceInMeters	numeric(12,2)	DWC - The lesser distance in a range of distance from a reference surface in the vertical direction, in meters. Use positive values for locations above the surface, negative values for locations below. If depth measures are given, the reference surface is the location given by the depth, otherwise the reference surface is the location given by the elevation.
	maximumDistanceAboveSurfaceInMeters	numeric(12,2)	DWC - The greater distance in a range of distance from a reference surface in the vertical direction, in meters. Use positive values for locations above the surface, negative values for locations below. If depth measures are given, the reference surface is the location given by the depth, otherwise the reference surface is the location given by the elevation.
	fieldNumber	varchar(512)	(DwC) - An identifier given to the event in the field. Often serves as a link between field notes and the Event. When not given, a computarized concatenation of variables from "Locations" and "Events" identifying an event field notat. Example: Nidelva st.1 elfisk 2016-06-15 sample 2
	eventRemarks	text	(DwC) - Comments or notes on the Event. Example: any text.
*	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The user name identifying the person who modified last the record. The name has to comply an existing name from the database name register, starting with first/given name and ending with family/surname. Example: vmzomdav. ZOOTRON_I equivalent: UserRec as Operator.
*	modified	timestamp DEFAULT clock_timestamp()	(DwC) - The date the record is last modified. Example: 2016-02-08. ZOOTRON_I equivalent: DateOfModification.
	zootronEventRef_txt	varchar(255)
	toDelete	integer DEFAULT 0
	isFieldNumberGeneric	bool DEFAULT true	The flag for the database to auto-generate a fieldNumber. Remove the flag to enable fieldNumber edition.
	isVannmiljo	bool DEFAULT false	The flag indicating if the data is exported to Vannmiljø
	vannmiljoDate	timestamp	The date and time the data is exported to Vannmiljø.
	dataProcessingID	varchar(25)	A partial unique alpha numerical key identifier for a location and event at a dataset level for processing occurrence data. Use this field as a simplified fieldNumber when the fieldNumber is generic. Use preferably an ontological kode system as a processingID to identify a location and an event within a dataset. When existing, the key is used to bind occurrences to sampling event during data processing. Example: the processingID for "locality: Lindalsvatnet \| siteNumber: 1 \| stationNumber: 1 \| eventDate: 1979-08-17 \| samplingProtocol: Grabb van Veen \| seasonNumber: 1 \| periodNumber: 2 \| sampleNumber: 3 \| roundNumber: 1" is "Lind01".
Indexes
	pk_event	ON eventID
	ndx_Events_collectionID	ON collectionID
	ndx_Events_dataSchemaID	ON dataSchemaID
	ndx_Events_datasetID	ON NaTron_datasetID
	ndx_Events_locationID	ON locationID
	ndx_Events_sampleNumber	ON sampleNumber
	ndx_Events_eventDate	ON eventDate
	ndx_Events_samplingProtocolID	ON samplingProtocolID
	ndx_Events_zootronEventRef_txt	ON zootronEventRef_txt
	ndx_Events_parenEventID	ON parentEventID
	ndx_Events_todelete	ON toDelete
Foreign Keys
	fk_events_eventid_parenteventid	( parentEventID ) ref Events (eventID)
	fk_events_collectionnames	( collectionID ) ref CollectionNames (collectionID)
	fk_event_dataschema	( dataSchemaID ) ref DataSchemas (dataSchemaID)
	fk_events_datasets	( NaTron_datasetID ) ref Datasets (NaTron_datasetID)
	fk_event_location	( locationID ) ref Locations (locationID)
	fk_event_samplingprotocol	( samplingProtocolID ) ref SamplingProtocols (samplingProtocolID)
Triggers
	events_before_edit

Table geo.Fjords

A list of georeferenced fjords with which Norwegian marin locaties are organised into. The fjord dataset cover the Norwegian coast and is a map service at the Miljø Direktøratet at https://kartkatalog.miljodirektoratet.no/MapService/Details/fjordkatalogen?lang=nb-no. Fjordkatalogen inneholder inndeling av norske fjorder og sjøområder i enheter som er avgrenset i enhetlige «basseng» av kystlinje, terskler og andre naturlige, fysiske skiller. Det er etablert egne faktaark for denne tjenesten som viser detaljert informasjon om den enkelte fjord-id.

Idx	Field Name	Data Type
*	fjordID	uuid DEFAULT data.uuid_generate_v4()
	geom	geometry
	seaNumber	varchar(2)
	sea	varchar(50)
	coastNumber	varchar(4)
	fjordHierarchyNumber	varchar(14)
	fjordSystemName	varchar(30)
	fjordName	varchar(30)
	area	float8
	perimeter	float8
Indexes
	fjordID_pkey	ON fjordID
	ndx_fjord_geom	ON geom

Table data.Growth

- A list of measured interval between growth line/ring from an organism part.

Idx	Field Name	Data Type	Description
*	growthID	uuid DEFAULT data.uuid_generate_v4()	- A unique global identifier for an organism growth. Example: 1. ZOOTRON_I equivalent: GrowthRec.
*	occurrenceID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the OccurrenceID binding a growth to an occurrence. Example: FA9BDA94-A25B-428F-A65A-74ABDFD80E6D.
	materialSampleType	varchar(25) DEFAULT ''::character varying	- The name identifying the organism part from which the measurements are taken. Example: Fish shell, Trunck.
	recordNumber	integer	- The ordinal number in which the measurements are taken. Example: 1, 2, 3.
	measurementMethod	varchar(25) DEFAULT ''::character varying	- The name qualifying the method a measurement is taken. Example: Magnified, Real size.
	measurementType	varchar(25) DEFAULT ''::character varying	- The name qualifying how the measurement is taken. Example: Radius, Diameter, Circumference.
	measurementUnit	varchar(25) DEFAULT ''::character varying	- The unit the measurement is taken as. Example: Millimeter, Centimeter.
	samp_size	numeric(7,2)	- The ratio/fraction lenght/size for the measured materialSampleType with which measurementValue is calculated from. Example: 25.4
	measurementValue	numeric(7,2)	- The value of the measured interval. Example: 5.6, 8, 9.6.
	modified	date DEFAULT clock_timestamp()
	sampleSize	float8	- The total lenght/size for the measured materialSampleType. Example: 25.4
	measurementRemarks	varchar(150)
*	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	registrationDate	date DEFAULT clock_timestamp()	- The date the record is first registered.
Indexes
	Growth_pkey	ON growthID
	ndxGrowthOccurrenceID	ON occurrenceID
Foreign Keys
	FK_Growth_Occurrences	( occurrenceID ) ref Occurrences (occurrenceID)
Triggers
	growth_before_edit

Table lib.HolderFunctions

- A list of anacronym describing the function of an holder within a role and a dataSchema.

Idx	Field Name	Data Type	Description
*	holderFunction	varchar(25)	- A unique anacronym as an identifier for an holderFunction name.
Indexes
	holderFunction_pkey	ON holderFunction

Table data.Identifications

- A list of taxonomic identifications describing the taxonomical revision of occurrences.

Idx	Field Name	Data Type	Description
*	identificationID	uuid DEFAULT data.uuid_generate_v4()	- A unique local identifier for an identification. Example: 1. ZOOTRON_I equivalent: RevisionRec.
*	occurrenceID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the OccurrenceID binding an identification to an occurrence. Example: FA9BDA94-A25B-428F-A65A-74ABDFD80E6D.
	identifiedBy	varchar(25) DEFAULT ''::character varying	(DwC) - The names identifying the persons who determined the specimen. Example: Gaute Kjærstad. The foreign key for the "personID" identifying the person who species determined the specimen. Older species determinations are referred in the Identifications register. Example: 1. ZOOTRON_I equivalent: UserRec as Determinator.
	year	integer	- the year the specimen is species determined last. Newer species determination are referred in the Occurrences register. Example: 2016. ZOOTRON_I equivalent: Year
*	deriveTaxonID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The foreign key for the taxon the verbatimTaxon origins from. Example: 1. ZOOTRON_I equivalent: SpeciesRec.
	previousIdentifications	varchar(50) DEFAULT ''::character varying	- The literal name from the object label identifying the taxon name. Example: "Littorina rudis var. jugosa". ZOOTRON_I equivalent: SpeciesRec.
	identificationQualifier	varchar(10)	- A brief phrase or a standard term ("Det.", "Rev.") to express the Identification. Example: Det., rev.. ZOOTRON_I equivalent: Synonym/Taxon.
	modified	timestamp DEFAULT clock_timestamp()	- the date the record is last modified. Example: 2016-02-08
	toDelete	integer DEFAULT 0
*	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	typeStatus	varchar(25) DEFAULT ''::character varying
	registrationDate	date DEFAULT clock_timestamp()	- The date the record is first registered.
Indexes
	Identifications_pkey	ON identificationID
	ndxIdentificationsDeriveTaxonID	ON deriveTaxonID
	ndxIdentificationsOccurrenceID	ON occurrenceID
Foreign Keys
	FK_Identifications_Occurrences	( occurrenceID ) ref Occurrences (occurrenceID)
	FK_Identifications_Taxa	( deriveTaxonID ) ref Taxa (taxonID)
	Fk_Identifications_TypeStatus	( typeStatus ) ref TypeStatus (typeStatus)
Triggers
	identifications_before_edit

Table geo.Lentic

- A list of water bodies with which locaities are identified or related to through a proximity analysis. The "Innsjødatabase" dataset is hosted by Geonorge https://kartkatalog.geonorge.no/metadata/norges-vassdrags-og-energidirektorat/innsjodatabase/823b8639-9a49-41bf-8571-3608435eb149.

Idx	Field Name	Data Type
*	lenticID	uuid DEFAULT data.uuid_generate_v4()
	geom	geometry
	originalID	bigint
	waterBodyNumber	bigint
*	catchmentID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	catchmentNumber	varchar(15)
	waterBody	varchar(150)
	riverNameHierarchy	varchar(125)
	Area_m2	float8
	distanceTo_SSR	float8
Indexes
	lentic_pkey	ON lenticID
	ndx_lentic_catchmentid	ON catchmentID
	ndx_lentic_catchmentnumber	ON catchmentNumber
	ndx_lentic_geom	ON geom
	ndx_lentic_waterbody	ON waterBody
Foreign Keys
	fk_lentic_catchment	( catchmentID ) ref Catchments (catchmentID)

Table geo.LocationNames

- A list of place names for both land and water elements with which localities are identified or related to through a proximity analysis. The "Navn fra Sentralt Stedsnavnregister (SSR)" dataset is hosted by Geonorge https://kartkatalog.geonorge.no/metadata/uuid/30caed2f-454e-44be-b5cc-26bb5c0110ca.

Idx	Field Name	Data Type
*	locationNameID	uuid DEFAULT data.uuid_generate_v4()
	geom	geometry
*	higherGeographyID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	locationName	varchar(254)
	locationTypeID	bigint
	originalid	bigint
*	catchmentID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
Indexes
	pk_locationnameid	ON locationNameID
	ndx_location_locationtypeid	ON locationTypeID
	ndx_locationname_adminid	ON higherGeographyID
	ndx_locationname_catchment	ON catchmentID
	ndx_locationname_geom	ON geom
Foreign Keys
	fk_Locationname_administrativeboundary	( higherGeographyID ) ref AdministrativeBoundaries (administrativeBoundaryID)
	fk_locationname_locationtype	( locationTypeID ) ref LocationTypes (locationTypeID)

Table geo.LocationTypes

- A list of object types classifying a "localitionName" in the "LocationNames" register into landscape categories.

Idx	Field Name	Data Type	Description
*	locationTypeID	integer
	registerName	varchar(25)	The name of the register a location type describe a location as.
	locationTypeCategory	varchar(25)
	locationType	varchar(50)
	locationTypeDescription	text
Indexes
	r_l_localityObjectTypes_pkey	ON locationTypeID
	ndxr_r_l_localityObjectTypes_objectTypeCategori	ON locationTypeCategory
	ndxr_r_l_localityObjectTypes_objectTypeDatasetName	ON registerName
	ndxr_r_l_localityObjectTypes_objectTypeName	ON locationType

Table data.Locations

- A list of georeferenced sampling localities, sites and stations where sampling events occur.

Marin bathymetry, elvation, administrative names and place names, water courses, water bodies as well as water catchement are computerized using geometric proximity analysis in PostGis http://postgis.net/.

Analog coordinates in a well know standard format are converted to geodesic coordinate using the "mgrs 1.3.5" program https://pypi.python.org/pypi/mgrs.
supported format
"utm",
"mgrs",
"hddd.ddddd",
"hddd mm.mmm" and
"hddd mm ss.s".
To know more about the coordinate format read the comments for both "verbatimCoordinateSystem" and ""cartographicCoordinates".

Idx	Field Name	Data Type	Description
*	locationID	uuid DEFAULT data.uuid_generate_v4()	(DwC) - A unique global identifier for a location. Example: 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'.
	geom	geometry	- A geografic georeference containing the location geometric as multipoint. Coordinates system is EPSG 4326 GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS 84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.0174532925199433,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]].
*	higherGeographyID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the lowest administrative division: county, state province, country (Trondheim, Sør-Trøndelag, Norway). Example: 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'. A GIS proximity analysis assign the value automatically on insert or update based. The key refers to an administrativeName in the geo.AdministrativeBoundaries register.
*	fjordID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The foreign key for the fjord a locality is related to. Example: 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'. A GIS proximity analysis assign the value automatically on insert or update based. The key refers to a fjordName in the geo.Fjords register.
	distanceToFjord	float8	- The distance in meter the related fjord is near to the locality. Example: 50.5. A GIS proximity analysis assign the value automatically on insert or update based.
*	catchmentID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The foreign key for the catchment/bassin a locality is related to. Example (122.Z \| 122.E4AB \| Gaula): 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'. A GIS proximity analysis assign the value automatically on insert or update based. The key refers to a catchmentName in the geo.Catchments register.
*	loticID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The foreign key for the watercourse a locality is related to. Example: 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'. A GIS proximity analysis assign the value automatically on insert or update based. The key refers to a riverName in the geo.Lotic register.
	distanceToLotic	float8	- The distance in meter the related river is near to the locality. Example: 50.5. A GIS proximity analysis assign the value automatically on insert or update based.
*	lenticID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The foreign key for the waterbody a locality is related to. Example: 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'. A GIS proximity analysis assign the value automatically on insert or update based. The key refers to a waterBodyName in the geo.Lentic register.
	distanceToLentic	float8	- The distance in meter the related waterbody is near to the locality. Example: 50.5. A GIS proximity analysis assign the value automatically on insert or update based.
*	locationNameID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The foreign key for the location name a locality is related to. Example: 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'. A GIS proximity analysis assign the value automatically on insert or update based. The key refers to a locationName in the geo.LocationNames register.
	distanceToLocationName	float8	- The distance in meter the related location name is near to the locality. Example: 50.5. A GIS proximity analysis assign the value automatically on insert or update.
*	locality	varchar(255)	(DwC) - The most representative full cartographic name identifying the geographical sampling place, site or station. Example: Sørlendet, Nidelva, Jonsvatnet. Anacronym for site and station should be stored in "siteNumber" and "stationNumber".
	verbatimLocality	varchar(256)	(DwC) - The original textual description for a locality, station and site. Example: "Gaula ved Melhus station 1.", "Dam sør vest Langvatnet", "Nidelva, Nea.
	siteNumber	varchar(25)	- The alphanumeric acronym identifying, ordering and incrementing sampling stations per site and locality. Example: siteA, A, B, 2A, down stream, littoral.
	stationNumber	varchar(25)	- The alphanumeric anacronym identifying, ordering and incrementing stations within a locality and a site. Example: 0, 1, 1A, 1B, A1, A2.
	cartographicCoordinates	varchar(40)	- Either the map or the interprated "verbatimCoordinates" in metric or geodesic position given in a well known gps/cartographic "Garmin" format (utm, mgrs or Longitude/Latitude) in meter or degree. The delimiter characters for degree, minute and second °, ' and '' are replaced with one single space. Coordinate precision should be stored in the "coordinateUncertaintyInMeters". Supported format: Metric mgrs: "32VNR1234512345" or utm: "32 V 0512345 7012345" geodesic "hddd.ddddd": "N64.62022 E12.29833" or "hddd mm.mmm": "N64 37.213 E12 17.900" or "hddd mm ss.s": "N64 37 12.8 E12 17 54.0". The format is checked upon a constraint and the "cartographicCoordinates" is transformed to "decimalLatitude" and "decimalLongitude" using the "mgrs 1.3.5" program. https://pypi.python.org/pypi/mgrs. Transformation is calculated in "WGS84" or "ED50". The transformation in "ED50" is only supported for an area within the extent of Norway. Use the "verbatimSRS" to store geodetic datum. mgrs: https://en.wikipedia.org/wiki/Military_Grid_Reference_System utm: https://en.wikipedia.org/wiki/Universal_Transverse_Mercator_coordinate_system
	verbatimCoordinateSystem	varchar(15)	(DwC) - The standarized spatial coordinate system for the "cartographicCoordinates" with which the geodesic coordinate ("decimalLatitude" and "decimalLongitude") is calculated. Use "verbatimSRS" for none standardized format to describe the spatial coordinate system for the literal coordinates which is stored in the "verbatimCoordinates". Example: metric "utm" = "12 A 123456 1234567" or "mgrs" = "12ABC1234512345 geodesic -"hddd.ddddd" = "N64.55555 E12.55555" or "hddd mm.mmm" = "N64 55.555 E12 55.555" or "hddd mm ss.s" = "N64 55 55.5 E12 55 55.5". The value is generated and computarized through a constraint based on the content of the "cartographicCoordinates".
	verbatimCoordinates	varchar(40)	(DwC) - The original and textual spatial coordinates of a Location as it is written on the media source. Use the "verbatimSRS" to store geodetic datum. Use the "cartographicCoordinates" for interprated coordinate given in a respective "Garmin" standard format. Accepted format for the "cartographicCoordinates" are: utm, mgrs, hddd.ddddd, hddd mm.mmm and hddd mm ss.s.
	verbatimSRS	varchar(25)	(Dwc) - The ellipsoid, geodetic datum, or spatial reference system (SRS) upon which coordinates given in verbatimLatitude and verbatimLongitude, or verbatimCoordinates are based. Recommended best practice is use the EPSG code as a controlled vocabulary to provide an SRS, if known. Otherwise use a controlled vocabulary for the name or code of the geodetic datum, if known. Otherwise use a controlled vocabulary for the name or code of the ellipsoid, if known. If none of these is known, use the value "unknown".
	coordinateUncertaintyInMeters	integer	(DwC) - The horizontal distance (in meters) from the given decimalLatitude and decimalLongitude describing the smallest circle containing the whole of the Location. Leave the value empty if the uncertainty is unknown, cannot be estimated, or is not applicable (because there are no coordinates). Zero is not a valid value for this term.
	geodeticDatum	varchar(10) DEFAULT 'WGS84'::character varying	(DwC) - The ellipsoid, geodetic datum, or spatial reference system (SRS) upon which the geographic coordinates given in decimalLatitude and decimalLongitude as based. Example: "WGS84", "ED50". The value is computarized automatically to "WGS84" when using "cartographicCoordinates". Use "verbatimSRS" and or "verbatimCoordinates" for literal and analog coordinates with a geodetic datum other than "WGS84".
*	decimalLatitude	numeric(12,8) DEFAULT 0	(DwC) - The geographic latitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location. Positive values are north of the Equator, negative values are south of it. Legal values lie between -90 and 90, inclusive. Example: 59,123456789.
*	decimalLongitude	numeric(12,8) DEFAULT 0	(DwC) - The geographic longitude (in decimal degrees, using the spatial reference system given in geodeticDatum) of the geographic center of a Location. Positive values are east of the Greenwich Meridian, negative values are west of it. Legal values lie between -180 and 180, inclusive. Example: 10,123456789.
	updateMinimumElevationInMeters	bool DEFAULT true	- Procedural flagg to update "minimumElevationInMeters" with either bathymetry or elevation when update and insert proceedure is run.
	minimumElevationInMeters	float8	(DwC) - The lower limit of the range of elevation (altitude, usually above sea level), in meters. Example: 10.
	locationRemarks	text	(DwC) - Comments or notes about the Location. Example: any text.
*	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The user name identifying the person who modified last the record. The name has to comply an existing name from the database name register, starting with first/given name and ending with family/surname. Example: vmzomdav. ZOOTRON_I equivalent: UserRec as Operator.
*	modified	timestamp DEFAULT clock_timestamp()	(DwC) - The date and time the record is last modified. Example: 2016-02-08. ZOOTRON_I equivalent: DateOfModification.
	zootronLocationRef_txt	varchar(255)	A data reference used for data migration and updates from ZOOTRON.
	toDelete	integer DEFAULT 0	- A flag for the vacuum procedure when removing obsolete locations.
*	gid	integer DEFAULT nextval('data.gid_location'::regclass)	Unique identifier for displaying geometry records in ArcGis.
	geom_poly	geometry
*	parentLocationID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - A global unique identifier that groups/nest/serialize locations. A "parentLocationID" identifies the main Whittaker location in nested locations, each with its own "locationID". Use the "locationID" of a higher hierarchical dependence as "parentLocationID" to nest lower "locationID" as child location. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
	Vannlok_kode	varchar(25)	The unique locality/location code in Vannmiljø. https://vannmiljokoder.miljodirektoratet.no/Default.aspx Kode som knytter registreringen til en bestemt vannlokalitet.
	Medium_id	varchar(5) DEFAULT 'NA'::character varying	the code in Vannmiljø to enditify the medium. https://vannmiljokoder.miljodirektoratet.no/Medium.aspx. Felt for å oppgi hvilket medium en parameter er målt i (vann, sediment, biota eller partikler). Medium_id hentes fra egen søkbar liste av lovlige verdier. Vær oppmerksom på lovlige kombinasjoner av Parameter_id og Medium_id
	geom_line	geometry
	geom_points	geometry
	sameAs	varchar
	isTrue	bool
*	eastingInMeter	numeric DEFAULT 0
*	northingInMeter	numeric DEFAULT 0
Indexes
	pk_location	ON locationID
	ndx_location_zootronLocationRef_txt	ON zootronLocationRef_txt
	ndx_location_locality	ON locality
	ndx_location_catchment_id	ON catchmentID
	ndx_location_highergeography_id	ON higherGeographyID
	ndx_location_fjord_id	ON fjordID
	ndx_location_lentic_id	ON lenticID
	ndx_location_lotic_id	ON loticID
	ndx_locations_geom	ON geom
	ndx_locations_locationname_id	ON locationNameID
	ndx_location_sitenumber	ON siteNumber
	ndx_location_stationnumber	ON stationNumber
	ndx_location_cartographicCoordinates	ON cartographicCoordinates
	fki_fk_location_vannmiljo_medium	ON Medium_id
	ndx_locarion_todelete	ON toDelete
	unique_gid_location	ON gid
Foreign Keys
	fk_locations_locationid_parenteventid	( parentLocationID ) ref Locations (locationID)
	fk_location_administrative	( higherGeographyID ) ref AdministrativeBoundaries (administrativeBoundaryID)
	fk_location_catchment	( catchmentID ) ref Catchments (catchmentID)
	fk_location_fjord	( fjordID ) ref Fjords (fjordID)
	fk_location_lentic	( lenticID ) ref Lentic (lenticID)
	fk_location_locationname	( locationNameID ) ref LocationNames (locationNameID)
	fk_location_lotic	( loticID ) ref Lotic (loticID)
Triggers
	locations_before_edit

Table geo.Lotic

- A list of water course with which localities are identified or related to through a proximity analysis. The "ELVIS elvenett" dataset is hosted by Geonorge https://kartkatalog.geonorge.no/metadata/norges-vassdrags-og-energidirektorat/elvis-elvenett/3f95a194-0968-4457-a500-912958de3d39.

Idx	Field Name	Data Type
*	loticID	uuid DEFAULT data.uuid_generate_v4()
	geom	geometry
*	catchmentID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	originalID	bigint
	locationType	varchar(32)
	riverStreamNumber	varchar(12)
	riverID	varchar(15)
	riverName	varchar(30)
	waterBodyNumber	bigint
	catchmentNumber	varchar(15)
	catchmentAreaNumber	varchar(15)
	riverNameHierarchy	varchar(100)
Indexes
	m_lotic_pkey	ON loticID
	ndx_lotic_catchmentid	ON catchmentID
	ndx_lotic_geom	ON geom
Foreign Keys
	fk_lotic_catchment	( catchmentID ) ref Catchments (catchmentID)

Table data.MaterialSamples

- A list of tissue samples deriving from preserved occurences.

Idx	Field Name	Data Type	Description
*	materialSampleID	uuid DEFAULT data.uuid_generate_v4()	- A unique global identifier for a MaterialSample.
*	occurrenceID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the OccurrenceID binding an material sample to an occurrence. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
	recordedBy	varchar(25) DEFAULT ''::character varying	(DwC) - The names identifying the persons who deposit/take the tissue sample, Use the "\|" to seperate names. Example: Gaute Kjærstad \| Lars Rønning. ZOOTRON_I equivalent: UserRec as Legator
	materialSampleType	varchar(25) DEFAULT ''::character varying	- The name defyning the type sample a tissue type will be processed/examined as. Example: DNA, Environmental
	dcterms_type	varchar(25) DEFAULT ''::character varying	- The name defyning the body part a tissue sample is taken from the preserved occurrence. Example: Feather, Lever, Muscle.
	catalogNumber	varchar(50) DEFAULT ''::character varying	- The alphanumeric name/code or catalogNumber identifying literally the materialSampleID/tissue sample number. Example: SOE364.
	accession	varchar(25)
*	modified	timestamp DEFAULT clock_timestamp()
*	estimatedIndividualCount	integer DEFAULT 0
	individualCount	integer
	toDelete	integer DEFAULT 0
*	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	voucher	varchar(25)
	eventDate	timestamp	(DwC) - The date and time when the tissue sample is extracted.
	preservationType	varchar(25)	(DwC) - A list (concatenated and separated) of preparations and preservation methods for a specimen. Example: Ethanol, Frozen, fossil, cast, photograph, DNA extract, skin \| skull \| skeleton, whole animal (ETOH) \| tissue (EDTA)
	modifiedold	date DEFAULT clock_timestamp()
	freezer	varchar(25)
	rack	varchar(25)
	box_plate	varchar(25)
	vial	varchar(25)
	sampleNumber	varchar(50)	An alphanumeric acronym identifier ordering and incrementing material sample for an occurrence. Example: 1,2,2A,2B,3-infinit.
*	parentMaterialSampleID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	registrationDate	date DEFAULT clock_timestamp()	- The date the record is first registered.
Indexes
	MaterialSamples_pkey	ON materialSampleID
	ndx_MaterialSamples_occurrenceID	ON occurrenceID
Foreign Keys
	FK_MaterialSamples_Occurrences	( occurrenceID ) ref Occurrences (occurrenceID)
Triggers
	materialsamples_before_edit

Table lib.Notices

Idx	Field Name	Data Type
*	noticeID	uuid DEFAULT data.uuid_generate_v4()
*	dataSchemaID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	noticeKey	varchar(15)
	notice	varchar
	modifiedBy	varchar(40)
*	modified	timestamp DEFAULT clock_timestamp()

Table tel.Observations

- A list of human or machin recorded occurences based on a ringing and observational data or tracking device.

Idx	Field Name	Data Type	Description
*	observationID	uuid DEFAULT data.uuid_generate_v4()	- A unique global identifier for a tracking information.
*	occurrenceID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the OccurrenceID binding a tracking information to an occurrence. Example: FA9BDA94-A25B-428F-A65A-74ABDFD80E6D.
	geom	geometry
*	decimalLatitude	numeric(12,8) DEFAULT 0
*	decimalLongitude	numeric(12,8) DEFAULT 0
	observationNumber	integer
	observationSequence	integer
	sex	varchar(25)	(DwC) - The sex of the biological individual(s) represented in the Occurrence. Example: Male, Female, Hermaphrodite.
	behavior	varchar(50)
	observationPrecision	varchar(25)
	simultaneouslyAsGroup	varchar(25)	the collection of observationNumber separated with "\|" to marke several individ observed at the same time .
	simultaneouslyAs	varchar(25)
	sameAs	varchar(25)	the collection of observationNumber separated with "\|" to mark several observion as the same individ
	observationRemarks	varchar
	uncertain	bool
	dynamicProperties	varchar(25)
	registrationDate	date DEFAULT clock_timestamp()	- The date the record is first registered.
*	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	modified	date DEFAULT clock_timestamp()
Indexes
	pk_observations	ON observationID
	fki_fk_observations_occurrences	ON occurrenceID
Foreign Keys
	fk_observations_occurrences	( occurrenceID ) ref Occurrences (occurrenceID)
Triggers
	observations_before_edit
	observations_on_delete

Table data.Occurrences

- A list of taxonomic occurrences with their properties and descriptions.

Idx	Field Name	Data Type	Description
*	occurrenceID	uuid DEFAULT data.uuid_generate_v4()	(DwC) - A global unique publishing identifier for an occurrence on the GBIF portal https://www.gbif.org/. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
	parentOccurrenceID	uuid	- The foreign occurrenceID key a new occurrenceID derive from. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
*	organismID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - An identifier for the Organism instance (as opposed to a particular digital record of the Organism). May be a globally unique identifier or an identifier specific to the data set.
*	occurrenceStatus	varchar(25) DEFAULT 'Present'::character varying	(DwC) - A statement about the presence or absence of a Taxon at a Location for an event, Obsolete where the entire taxon at an occurrence is revised to a new object. Example: Present, Absent, Obsolete
*	eventID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the "eventID" binding an occurrence to a sampling event. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
*	storingObjectID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The foreign key for the "storingObjectID" identifying the object address in the collection. Example: 1. ZOOTRON_I equivalent: StoringRec.
	catalogNumber	varchar(15)	(DwC) - A litteral collection reference for data and/or collection objects. Example: 01-00001524.
	recordNumber	integer	(DwC) - An identifier given to the Occurrence at the time it was recorded. Often serves as a link between field notes and an Occurrence record, such as a specimen collector's number. Example: Fish number.
*	taxonID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the taxon name. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
	organismName	varchar(255)	- (Dwc) A textual name or label with marking date assigned to an Organism instance, often used as tag number with tracking device. Use "\|" as a separator for multiple "organismName". Example: "8B00005 - 01/01/2015 \| 8B10007 - 25/06/2015"
	typeStatus	varchar(25) DEFAULT ''::character varying	(DwC) - A nomenclatural types (type status, typified scientific name, publication) applied to the subject. Example: Holotype, Paratype.
	identifiedBy	varchar(125)	(DwC) - The names identifying the persons who determined the specimen. Example: Gaute Kjærstad.
	year	integer	(DwC) - The year The specimen is species determined last. Older species determination are referred in the Identifications register. Example: 2016. ZOOTRON_I equivalent: Year
	identificationQualifier	varchar(10)	(DwC) - A brief phrase or a standard term ("cf.", "aff.") to express the determiners doubts about the Identification. Example: cf., var.. ZOOTRON_I equivalent: DoubtfulSpecies.
	preparedBy	varchar(25)
	preparations	varchar(25)	(DwC) - The preparation and preservation method for a specimen. Example: Dry, Ethanol, Montert. ZOOTRON_I equivalent: Preparation.
	preparationYear	integer
*	basisOfRecord	varchar(25) DEFAULT 'Unknown'::character varying	(DwC) - The specific nature of the data record. Example: HumanObservation, MachineObservation, PreservedSpecimen.
	age	integer	- The age in number of years. Example: 1. ZOOTRON_I equivalent: Age (scale), Age.
	lifeStage	varchar(25)	(DwC) - The age class or life stage of the biological individual(s) at the time the Occurrence was recorded. Example: Larvae, Adult. ZOOTRON_I equivalent: Stadium.
*	occurrenceCondition	varchar(10) DEFAULT 'Alive'::character varying	- The condition of a specimen when observed/sampled at the event. Example: "Alive", "Dead". ZOOTRON_I equivalent: TaxaCondition
	sex	varchar(25)	(DwC) - The sex of the biological individual(s) represented in the Occurrence. Example: Male, Female, Hermaphrodite. ZOOTRON_I equivalent: Sex.
*	organismQuantityType	varchar(255) DEFAULT 'Occurrence'::character varying	(DwC) - The type of quantification system used for the quantity of organisms. Example: Occurrence, Individual, Biomass. ZOOTRON_I equivalent: Coef., Occurrence
	organismQuantity	varchar(255) DEFAULT 'Not counted'::character varying	(DwC) - A number or enumeration value for the quantity of organisms. Example: x, xx, xxx, o. ZOOTRON_I equivalent: CalculatedQuantity, Occurrence
*	estimatedIndividualCount	integer DEFAULT 0	- A qualifier for the number of occurrence. Example Yes, No. ZOOTRON_I equivalent: EstimatedQuantity
	individualCount	integer	(DwC) - The number of individuals represented present at the time of the Occurrence. Example: 1. ZOOTRON_I equivalent: Quantity.
	occurrenceRemarks	text	(DwC)- Comments or notes about the Occurrence. ZOOTRON_I equivalent: Remark
	habitat	varchar(50)	(DwC) - A category or description of the habitat from which an occurrence is sampled from. ZOOTRON_I equivalent: Habitat.
	registrationDate_old	date DEFAULT clock_timestamp()	- The date the record is first registered. Example: 2016-02-08. ZOOTRON_I equivalent: DateOfRegistration.
	organismScope	varchar(255)	DwC. A description of the kind of Organism instance. Can be used to indicate whether the Organism instance represents a discrete organism or if it represents a particular type of aggregation.
	isPreparationOnStandByOld	integer DEFAULT 0
	preparationAssessmentOrderOld	integer
*	isVannmiljoe	integer DEFAULT 0	- Identify if the record is send to vannmiljø.
	registrationDate	timestamp DEFAULT clock_timestamp()	- The date the record is first registered. Example: 2016-02-08. ZOOTRON_I equivalent: DateOfRegistration.
	modified	timestamp DEFAULT clock_timestamp()
*	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The user name identifying the person who modified last the record. The name has to comply an existing name from the database name register, starting with first/given name and ending with family/surname. Example: vmzomdav. ZOOTRON_I equivalent: UserRec as Operator.
*	isProof	integer DEFAULT 0	- Identify if the record is proof. Example: Yes, No. ZOOTRON_I equivalent: IsCorrected.
	proofDate	date	- The date when the record is last set to proof. Example: 2016-02-08. ZOOTRON_I equivalent: DateOfCorrection.
*	accessRights	varchar(50) DEFAULT 'Under approval'::character varying	(DwC) - Identify if the record access. Example: Under approval, To publish. ZOOTRON_I equivalent: ADB.
	publishDate	date	- The date when the record is last published. Example: 2016-02-08. ZOOTRON_I equivalent: DateOfADB
	toDelete	integer DEFAULT 0
Indexes
	Occurrences_pkey	ON occurrenceID
	ndx_Occurrences_eventID	ON eventID
	ndx_Occurrences_storingObjectID	ON storingObjectID
	ndx_Occurrences_taxonID	ON taxonID
	fki_Fk_Occurrences_TypeStatus	ON typeStatus
	ndx_occurrence_modified	ON modified
	ndx_occurrence_registrationDate	ON registrationDate
	ndx_accessRights	ON accessRights
	ndx_identifiedBy	ON identifiedBy
	ndx_isProof	ON isProof
	ndx_preparations	ON preparations
	ndx_preparedBy	ON preparedBy
	fki_fk_occurrences_organism	ON organismID
Foreign Keys
	FK_Occurrences_Events	( eventID ) ref Events (eventID)
	fk_occurrences_organism	( organismID ) ref Organisms (organismID)
	FK_Occurrences_l_StoringObjects	( storingObjectID ) ref StoringObjects (storingObjectID)
	FK_Occurrences_l_Taxa	( taxonID ) ref Taxa (taxonID)
	Fk_Occurrences_TypeStatus	( typeStatus ) ref TypeStatus (typeStatus)
Triggers
	occurrences_before_edit

Table data.Organisms

Idx	Field Name	Data Type
*	organismID	uuid DEFAULT data.uuid_generate_v4()
*	taxonID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
*	locationID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	recordNumber	integer
*	eastingInCentimeter	integer DEFAULT 0
*	northingInCentimeter	integer DEFAULT 0
*	decimalLatitude	numeric(12,8) DEFAULT 0
*	decimalLongitude	numeric(12,8) DEFAULT 0
	geom	geometry
	isCurrent	bool DEFAULT true
*	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	registrationDate	date DEFAULT clock_timestamp()
*	modified	timestamp DEFAULT clock_timestamp()
Indexes
	Organism_pkey	ON organismID
	fki_fk_organism_location	ON locationID
	fki_fk_organisms_taxa	ON taxonID
Foreign Keys
	fk_organism_location	( locationID ) ref Locations (locationID)
	fk_organisms_taxa	( taxonID ) ref Taxa (taxonID)

Table lib.RegistrationStatus

- A list of human or machin recorded occurences based on a ringing and observational data or tracking device.

Idx	Field Name	Data Type	Description
*	registrationStatus	varchar(25)	- A unique global identifier for a tracking information.
Indexes
	registrationStatus_pkey	ON registrationStatus

Table data.ResourceRelationships

- A list of related organisms/objects.

Idx	Field Name	Data Type	Description
*	resourceRelationshipID	uuid DEFAULT data.uuid_generate_v4()	(DwC) - An instance of an Organism is the mother of another instance of an Organism. A uniquely identified Occurrence represents the same Occurrence as another uniquely identified Occurrence. A MaterialSample is a subsample of another MaterialSample.
*	resourceID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key as an identifier for an instance of relationship between one resource (the subject) and another (relatedResource, the object), in this case the resourceID is the occurrenceID.
*	relatedResourceID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key as an identifier identifier for a related resource (the object, rather than the subject of the relationship). in this case the taxonID
	relationshipOfResource	varchar(25)	(DwC) - The relationship of the resource identified by relatedResourceID to the subject (optionally identified by the resourceID). example: sameAs, duplicate of, mother of, endoparasite of, host to, sibling of, valid synonym of, located within
	individualCount	integer	(DwC) - The number of individuals represented present at the time of the Occurrence.
*	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	modifiedold	date DEFAULT clock_timestamp()
	registrationDate	date DEFAULT clock_timestamp()	- The date the record is first registered.
*	organismQuantityType	varchar(255) DEFAULT 'Occurrence'::character varying	(DwC) - The type of quantification system used for the quantity of organisms. Example: Occurrence, Individual, Biomass
	organismQuantity	varchar(255) DEFAULT 'Not counted'::character varying	(DwC) - A number or enumeration value for the quantity of organisms. Example: x, xx, xxx, o.
*	estimatedIndividualCount	integer DEFAULT 0	- A qualifier for the number of occurrence. Example Yes, No.
	sampleNumber	varchar(50)	An alphanumeric acronym identifier ordering and incrementing sampling events within an organism as organismScopeNumber Example: 1,2,2A,2B,3-infinit.
	organismScope	varchar(50)	The name of organism part the related source/organism find place.
*	modified	timestamp DEFAULT clock_timestamp()
Indexes
	resourceRelationship_pkey	ON resourceRelationshipID
	fki_fk_resourceRelationShip_occurrences	ON resourceID
Foreign Keys
	fk_resourceRelationShip_occurrences	( resourceID ) ref Occurrences (occurrenceID)
Triggers
	resourcerelationships_before_edit

Table lib.RightsHolders

- A list of persons with their level of data-access involved and or contributing in the data collection of a dataset.

Idx	Field Name	Data Type	Description
*	rightsHolderID	uuid DEFAULT data.uuid_generate_v4()	(DwC) - A global unique identifier for a right holder function/rolle. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
*	userID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The foreign key for the "userName". Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f. ZOOTRON_I equivalent: UserRec.
*	modified	timestamp DEFAULT clock_timestamp()	(DwC) - The date the record is last modified. Example: 2016-02-08. ZOOTRON_I equivalent: DateOfModification.
	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The user name identifying the person who modified last the record. The name has to comply an existing name from the database name register, starting with first/given name and ending with family/surname. Example: vmzomdav. ZOOTRON_I equivalent: UserRec as Operator.
*	NaTron_datasetID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the "datasetName" a person is involved in. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f. ZOOTRON_I equivalent: DatasetRec.
*	holderRole	varchar(25) DEFAULT 'Unknown'::character varying	- The name describing the rolle a person has in the data collection of a dataset. Example: Project leader, Data owner, Data curator, Legator
*	dataSchemaID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the "dataSchemaName" a person contributes with data. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f
	holderFunction	varchar(25) DEFAULT 'Unknown'::character varying
Indexes
	l_RightsHolders_pkey	ON rightsHolderID
	ndx_RightsHolders_userID	ON userID
	ndx_RightsHolders_datasetID	ON NaTron_datasetID
	fki_FK_RightsHolders_HolderFunctions	ON holderFunction
Foreign Keys
	FK_l_RightsHolders_l_Datasets	( NaTron_datasetID ) ref Datasets (NaTron_datasetID)
	FK_l_RightsHolders_l_Users	( userID ) ref Users (userID)
	FK_RightsHolders_HolderFunctions	( holderFunction ) ref HolderFunctions (holderFunction)

Table lib.SamplingProtocols

- List of the sampling protocols describing an experiment/sampling method with which occurrences are collected.

Idx	Field Name	Data Type	Description
*	samplingProtocolID	uuid DEFAULT data.uuid_generate_v4()	- A unique local identifier for a sampling protocol. Example: 1. ZOOTRON_I equivalent: MethodRec
	samplingProtocol	varchar(255)	(DwC) - An ontological defination name for the sampling protocol. Use "\|" as a separator to identify sampling protocol name part. Example: Gillnet\|Benthic. ZOOTRON_I equivalent: MethodName
	samplingProtocolRemark	text	- A description of the samplingProtocol/ method use to collect samples. ZOORON_I equivalent: MethodDescription
*	modified	timestamp DEFAULT clock_timestamp()	(DwC) - The date the record is last modified. Example: 2016-02-08. ZOOTRON_I equivalent: DateOfModification.
*	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The user name identifying the person who modified last the record. The name has to comply an existing name from the database name register, starting with first/given name and ending with family/surname. Example: vmzomdav. ZOOTRON_I equivalent: UserRec as Operator.
	sampleSizeUnit	varchar(25)
	sampleSizeValue	numeric(12,4)
*	samplingEffort	integer DEFAULT 0
*	samplingDuration	numeric(12,8) DEFAULT 0
	Parameter_id	varchar	The code in Vannmiljø identifying a parameter. https://vannmiljokoder.miljodirektoratet.no/Parameter.aspx?p=BIO Felt for å oppgi hvilken parameter som er målt eller observert, f.eks. kjemiske komponenter, biologiske indikatorer eller fysiske egenskaper. Parameter_id hentes fra egen søkbar liste av lovlige verdier. Det følger også informasjon om lovlige kombinasjoner av Parameter_id, Medium_id, Prøvetakingsmetode_id og Enhet_id.
	Provetakmetode_id	varchar(30)	The code in Vannmiljø to identify a provetakmetode. https://vannmiljokoder.miljodirektoratet.no/SamplingMethod.aspx Felt for å oppgi hvilken standard prøvetakingsmetode som er benyttet. Provetakingsmetode_id bygger på Norsk Standards nummerering eller internasjonal standard CEN/ISO. Dersom det ikke er utarbeidet noen standard for vedkommende parameter eller metoden er ukjent, skal Provetakingsmetode_id oppgis som UKJENT. Provetakingsmetode_id hentes fra egen søkbar liste av lovlige verdier. Vær oppmerksom på lovlige kombinasjoner av Parameter_id, Medium_id og Provetakingsmetode_id.
	Analysemetode_id	varchar(30)	The code in Vannmiljø to identify an analysemetode. https://vannmiljokoder.miljodirektoratet.no/AnalysisMethod.aspx Tilsvarende som for Provetakingsmetode_id.
	Enhet_id	integer DEFAULT 0	The code in Vannmiljø to identify an enhet_id. https://vannmiljokoder.miljodirektoratet.no/Unit.aspx. Felt for å angi standard enhet eller benevning til registreringsverdien. Vannmiljøsystemet tillater bare en benevning for kombinasjonen parameter, medium og prøvetakingsmetode. Parameter kan også være ubenevnt.
Indexes
	l_SamplingProtocols_pkey	ON samplingProtocolID
	ndx_samplingProtocol	ON samplingProtocol
	fki_fk_samplingProtocol_vannmiljo_analysemetode	ON Analysemetode_id
	fki_fk_samplingProtocol_vannmiljo_enhet	ON Enhet_id
	fki_fk_samplingProtocol_vannmiljo_provetakmetode	ON Provetakmetode_id

Table lib.SamplingProtocols_per_DataSchemas

- A List of the sampling protocols attributed to the dataSchemas.

Idx	Field Name	Data Type	Description
*	samplingProtocol_per_dataSchema_ID	uuid DEFAULT data.uuid_generate_v4()
*	samplingProtocolID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the "samplingProtocolID" binding a sampling protocol to a data schema.
*	dataSchemaID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The foreign key for the "dataSchemaID" binding a data schema to a sampling protocol.
*	modifiedByID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
*	modified	timestamp DEFAULT clock_timestamp()
Indexes
	l_SamplingProtocols_per_DataSchemas_pkey	ON samplingProtocol_per_dataSchema_ID
	ndx_l_SamplingProtocols_per_DataSchemas_samplingProtocolID	ON samplingProtocolID
	ndx_l_l_SamplingProtocols_per_DataSchemas_dataSchemaID	ON dataSchemaID
Foreign Keys
	FK_l_SamplingProtocols_dataSchemaID	( dataSchemaID ) ref DataSchemas (dataSchemaID)
	FK_l_SamplingProtocols_samplingProtocolID	( samplingProtocolID ) ref SamplingProtocols (samplingProtocolID)

Table data.StomachContents

- A list of taxa registered in stomach contents.

Idx	Field Name	Data Type	Description
*	stomachContentID	uuid DEFAULT data.uuid_generate_v4()	- A unique global identifier for a fish stomach content.
*	occurrenceID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the OccurrenceID binding a stomach content to an occurrence. Example: FA9BDA94-A25B-428F-A65A-74ABDFD80E6D.
*	taxonID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the taxon name describing the stomach content.
*	vernacularName	varchar(15) DEFAULT 'None'::character varying	- A name classifying the taxon name into a nutritiant group. Example: None, Bunndyr, Plankton, Mysis, Luftinsekt, Fisk, Andre.
*	organismQuantityType	varchar(50) DEFAULT 'Individual'::character varying	(DwC) - The method to quantified the stomach content. Example: individualCount and Percent, Percent, individualCount.
	organismQuantity	integer	- The volume percent a taxon represents as part of the stomach content. When the percent is derived from a sub volume and not the whole stomach type the sub-volume in samplingSizeValue. Example: after a secondary taxa determination 2 taxa represent each 50% of 80% of the taxa group. To process 50% Baetis rhodani of 80% Ephemeroptera type 80% in the field "samplingSizeValue" and then 50% in the field "organismQuantity".
	samplingSizeValue	integer	(DwC) - A volume percent value as a fraction/part or whole stomach volume a taxa represents in "organismQuantity". The value is always 100 when the "organismQuantity" value is a ratio of the whole stomach.
	individualCount	integer	(DwC) - The number of individuals represented in the stomach content.
	modified	date DEFAULT clock_timestamp()	(DwC) - the date the record is last modified. Example: 2016-02-08
	organismRemarks	varchar(150)
*	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The user name identifying the person who modified last the record. The name has to comply an existing name from the database name register, starting with first/given name and ending with family/surname. Example: vmzomdav. ZOOTRON_I equivalent: UserRec as Operator.
	registrationDate	date DEFAULT clock_timestamp()	- The date the record is first registered.
Indexes
	StomachContents_pkey	ON stomachContentID
	ndxStomachContentsOccurrenceID	ON occurrenceID
Foreign Keys
	FK_StomachContents_Occurrences	( occurrenceID ) ref Occurrences (occurrenceID)
	FK_StomachContents_l_Taxa	( taxonID ) ref Taxa (taxonID)
Triggers
	stomachcontents_before_edit

Table lib.StoringObjects

- A list of digital addresse references to locate preserved specimens in the collections.

Idx	Field Name	Data Type	Description
*	storingObjectID	uuid DEFAULT data.uuid_generate_v4()	- A unique local identifier for a digital address. Example: 1. ZOOTRON_I equivalent: StoringRec.
*	dataSchemaID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The foreign key identifying the collection a digital address derive. Example: 1. ZOOTRON_I equivalent: DatabaseRec.
*	editorID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The foreign key identifying the operator who have access to a serie of digital address from. Example: 1. ZOOTRON_I equivalent: EditorRec.
*	building	varchar(25) DEFAULT 'Unknown'::character varying	- The name identifying the building . Example: 1. ZOOTRON_I equivalent: Building.
	room	varchar(25)	- The name identifying the Room. Example: 1. ZOOTRON_I equivalent: Room.
	bookshelf	varchar(25)	- The name identifying the Bookshelf. Example: 1. ZOOTRON_I equivalent: Bookshelf.
	section	varchar(25)	- The name identifying the Section. Example: 1. ZOOTRON_I equivalent: Section.
	shelf_skap	varchar(25)	- The name identifying the Shelf-skap. Example: 1. ZOOTRON_I equivalent: Shelf-skap.
	mainStoringNumber	integer DEFAULT 0	- An ordinal number identifying the upper collection object in which objectNumbers are stored in. Example: 1. ZOOTRON_I equivalent: MainStoringNr.
	dbObjectNumber	integer	- An INCREMENTED ordinal number identifying the next available object number in a serie of label numbers. Collection with predifined object number must use the objectNumber to assign label number. Example: 1. ZOOTRON_I equivalent: DBsubStoringNr.
	objectNumber	integer DEFAULT 0	- An ordinal number identifying the object LABEL number to attribute to the dbObjectNumber when the object to register already has a signed label object number. This only apply to a collection for which preserved specimen already have a pre-established serie of collection number. For collection following the incremented ordinal DBsubStoringNr, the SubStoringNr reads the DBsubStoringNr as label number. Example: 1. ZOOTRON_I equivalent: SubStoringNr.
	isDry	integer	- The flag identifying series of dbObjectNumber according to a conservation type, a collection can contains both dry and ethanol preserved specimen where each collection number serie starts with 1. Example: 1. ZOOTRON_I equivalent: IsDry.
	isEmpty	integer DEFAULT '-1'::integer	- The flag identifying which collection numbers are available. Example: 1. ZOOTRON_I equivalent: isEmpty.
	isInUse	integer DEFAULT 0	- The flag identifying which collection numbers are allocated to a preserved specimen. Example: 1. ZOOTRON_I equivalent: isInUse.
	isStored	integer DEFAULT 0	- The flag identifying which collection numbers are stored but not loaned. Example: 1. ZOOTRON_I equivalent: isStored.
	isLoaned	integer DEFAULT 0	- The flag identifying which collection numbers are loaned. Example: 1. ZOOTRON_I equivalent: isLoaned.
	makeSubStoringLabel	integer DEFAULT 0	- The flag identifying which collection numbers to issue object label. Example: 1. ZOOTRON_I equivalent: makeSubStoringLabel.
	makeMainStoringLabel	integer DEFAULT 0	- The flag identifying which collection numbers to issue main label. Example: 1. ZOOTRON_I equivalent: makeMainStoringLabel.
*	controlledByID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The foreign key identifying the person who controlled last the preserved specimen in the collection. ZOOTRON_I equivalent: UserRec as Operator.
	modified	timestamp DEFAULT clock_timestamp()	(DwC) - The date the record is last modified.
	modifiedBy	varchar(40)
	modifiedOld	date	- the date the record is last modified. Example: 2016-02-08. ZOOTRON_I equivalent: DateOfModification.
	zootronb_dbObjectNumber	integer
	isPreparationOnStandBy	integer DEFAULT 0
	preparationAssessmentOrder	integer
Indexes
	l_StoringObjects_pkey	ON storingObjectID
	ndxlStoringObjectsEditorID	ON editorID
	ndxlStoringObjectsMainStoringNumber	ON mainStoringNumber
	ndxlStoringObjectsdataSchemaID	ON dataSchemaID
	ndxlStoringObjectsdbObjectNumber	ON dbObjectNumber
	ndxlStoringObjectsisDry	ON isDry
	ndxlStoringObjectsisEmpty	ON isEmpty
	ndxStoringObjectRoom	ON room
Foreign Keys
	FK_l_StoringObjects_l_DataSchemas	( dataSchemaID ) ref DataSchemas (dataSchemaID)

Table lib.Taxa

- A list of taxa names with their taxonomical hierarchy.

Idx	Field Name	Data Type	Description
*	taxonID	uuid DEFAULT data.uuid_generate_v4()	(DwC) - A unique local identifier for a taxon. Example: 1. ZOOTRON_I equivalent: SpeciesRec.
	PK_LatinskNavnID	integer DEFAULT 0	- A unique identifier for a taxon from the "Artsnavne" database. Example: 1. ZOOTRON_I equivalent: ADB-ID.
	namePublishedInID	varchar(255)	(DwC) - An identifier for the publication in which the scientificName was originally established under the rules of the associated nomenclaturalCode. Example: http://www2.artsdatabanken.no/artsnavn/Contentpages/Sok.aspx. ZOOTRON_I equivalent: Publicationrec
	scientificOrder	numeric(18,8)	- The ordinal number to sort the scientific name according to a nomenclature. Example: 1. ZOOTRON_I equivalent: ScientificOrder.
	phylum	varchar(100)	(DwC) - The full scientific name of the phylum or division in which the taxon is classified. Example: Animalia. ZOOTRON_I equivalent: phylum.
	class_	varchar(100)	(DwC) - The full scientific name of the class in which the taxon is classified. Example: Gnathostomata Osteichthyes. ZOOTRON_I equivalent: Class.
	order_	varchar(150)	(DwC) - The full scientific name of the order in which the taxon is classified. Example: Salmoniformes. ZOOTRON_I equivalent: Order
	family	varchar(200)	(DwC) - The full scientific name of the family in which the taxon is classified. Example: Salmonidae. ZOOTRON_I equivalent: Family.
	genus	varchar(100)	(DwC) - The full scientific name of the genus in which the taxon is classified. Example: Salmo. ZOOTRON_I equivalent: Genus.
	species	varchar(100)	- The full scientific name of the species. Example: salar. ZOOTRON_I equivalent: Species
	scientificNameAuthorship	varchar(100)	(DwC) - The authorship information for the scientificName formatted according to the conventions of the applicable nomenclaturalCode. Example: Linnaeus, 1758. ZOOTRON_I equivalent: Author
	scientificName	varchar(150)	(DwC) - The full scientific name, with authorship and date information if known. When forming part of an Identification, this should be the name in lowest level taxonomic rank that can be determined. This term should not contain identification qualifications, which should instead be supplied in the identificationQualifier term. Example: . ZOOTRON_I equivalent: ScientificName.
	vernacularName	varchar(150)	(DwC) - A common or vernacular names seperated with "\|" for the scientific name. Example: Salmon\|Laks.
	taxonomicStatus	varchar(25)	(DwC) - The status of the use of the scientificName as a label for a taxon. Requires taxonomic opinion to define the scope of a taxon. Example: "invalid", "misapplied", "homotypic synonym", "accepted".. ZOOTRON_I equivalent: Status and Valid
	taxonRank	varchar(10)	(DwC) - The taxonomic rank of the most specific name in the scientificName. Example: Phylum, Class, Order, Family, Genus, Species. ZOOTRON_I equivalent: SpeciesCode
	researchTaxonGroupRank	varchar(10)	- The taxonomic rank on which the scientific name is associated as a group name. Example: Phylum, Class, Order, Family, Genus, Species. ZOOTRON_I equivalent: researchTaxonGroupRank.
	collectionTaxonGroupRank	varchar(10)	- The taxonomic rank on which the scientific name is associated as a group name. Example: Phylum, Class, Order, Family, Genus, Species. ZOOTRON_I equivalent: researchTaxonGroupRank.
*	modifiedByID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	- The user name identifying the person who modified last the record. The name has to comply an existing name from the database name register, starting with first/given name and ending with family/surname. Example: vmzomdav. ZOOTRON_I equivalent: UserRec as Operator.
*	modified	timestamp DEFAULT clock_timestamp()	(DwC) - The date the record is last modified. Example: 2016-02-08. ZOOTRON_I equivalent: DateOfModification.
	kingdom	varchar(100)	(DwC) - The full scientific name of the kingdom or division in which the taxon is classified. Example: Animalia. ZOOTRON_I equivalent: kingdom.
	accessLimitation	integer
	modifiedBy	varchar(40)
	backboneID	bigint
	names	varchar(255)
Indexes
	l_Taxa_pkey	ON taxonID
	ndx_adb_ID	ON PK_LatinskNavnID
	ndx_scientificName	ON scientificName
	ndx_scientificOrder	ON scientificOrder
	ndx_vernacularName	ON vernacularName
	ndx_Taxa_names	ON names
Triggers
	taxa_before_edit

Table lib.TaxaIndicators

Idx	Field Name	Data Type
*	indicatorID	uuid DEFAULT data.uuid_generate_v4()
	indicatorIndex	varchar(25)
	indicatorName	varchar(125)
*	taxonID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	taxonGroupRank	varchar(10)
	indicatorValue	integer DEFAULT 0
	modifiedBy	varchar(40)
*	modified	timestamp DEFAULT clock_timestamp()
	groupAs	varchar(50)
Indexes
	indicatorID_pkey	ON indicatorID
	fki_fk_taxa_taxaIndicator	ON taxonID
Foreign Keys
	fk_taxa_taxaIndicator	( taxonID ) ref Taxa (taxonID)

Table tel.Telemetry

- A list of machin recorded occurences based on a tracking device.

Idx	Field Name	Data Type	Description
*	telemetryID	uuid DEFAULT data.uuid_generate_v4()	- A unique global identifier for a tracking information. Example: 1. ZOOTRON_I equivalent: GrowthRec.
*	occurrenceID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The foreign key for the OccurrenceID binding a tracking information to an occurrence. Example: FA9BDA94-A25B-428F-A65A-74ABDFD80E6D.
*	eventID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	eventDate	timestamp	- The date and time when the occurrence is traced.
	sensor_value	varchar(10)
	toDelete	integer DEFAULT 0
Indexes
	Telemetry_pkey	ON telemetryID
	ndxTelemetryEventID	ON eventID
	ndxTelemetryOccurrenceID	ON occurrenceID
	ndxTelemetrysamplingDateTime	ON eventDate
Foreign Keys
	FK_Telemetry_Events	( eventID ) ref Events (eventID)
	FK_Telemetry_Occurrences	( occurrenceID ) ref Occurrences (occurrenceID)

Table tel.Tracking

- A list of human or machin recorded occurences based on a ringing and observational data or tracking device.

Field Name	Data Type	Description
trackingID	uuid	- A unique global identifier for a tracking information.
occurrenceID	uuid	(DwC) - The foreign key for the OccurrenceID binding a tracking information to an occurrence. Example: FA9BDA94-A25B-428F-A65A-74ABDFD80E6D.
eventDate	timestamptz	- The date and time when the occurrence is traced.
decimalLatitude	numeric(12,8)
decimalLongitude	numeric(12,8)
dynamicProperties	varchar(25)
registrationDate	date DEFAULT clock_timestamp()	- The date the record is first registered.

Table lib.TypeStatus

Idx	Field Name	Data Type
*	typeStatus	varchar(25)
Indexes
	pk_typeStatus	ON typeStatus

Table lib.Users

- A list of user names acting in the database as operator, loaner and rights-holder.

Idx	Field Name	Data Type	Description
*	userID	uuid DEFAULT data.uuid_generate_v4()	- A global unique identifier for a person name. Example: ea9e11e3-0822-49b1-bc7c-b9236a004e9f.
*	userName	varchar(256) DEFAULT 'Not member'::character varying	- The name identifying a user in the application log in session. the name has to comply with the database log in user name registry. Example: Your NTNU user name.
*	firstname	varchar(256)	- The name identifying the first name of a person.
*	surname	varchar(256)	- The name identifying the surname of a person.
*	innsider	integer DEFAULT 0	- The flag identifying whether the person works for the NTNU-VM. The value of the flag iterates with the archive number in the loan procedure. Example: True.
*	isActiveUser	integer DEFAULT 0	- The flag identifying whether the person is enabled in the log in procedure.
*	registrationTime	timestamp DEFAULT clock_timestamp()	- The time stamp when the person is created in the registry. Example: 18/08/1997.11.20.52. ZOOTRON_I equivalent: IDTimeRegistration
	institutUniversity	varchar(256)	- The firm, institution or university name where the person has his/her profession. Example: NTNU Vitenskapsmuseet.
	department	varchar(256)	- The department, section or unit name where the person has his/her profession. Example: Seksjon for Naturhistorie.
	address	varchar(256)	- The department, section or unit name where the person has his/her profession. Example: Erling Skakkesgate 47A. ZOOTRON_I equivalent: Address
	cityCode	varchar(25)	- The city code where the person has his/her profession.
	city	varchar(125)	- The city name where the person has his/her profession.
	country	varchar(125)	- The country name where the person has his/her profession. Example: Norway.
	phone	varchar(256)
	fax	varchar(125)	- The fax numbers separated with "\|". Example: +4792499979 \| +4773592288.
	email	varchar(256)	- The email addresses separated with "\|". Example: marc.daverdin@ntnu.no \| marc.daverdin@outlook.no.
	professionStatus	varchar(25)	- The name identifying the profession status of the person. Example: Prof. Dr..
*	language	varchar(25) DEFAULT 'English'::character varying	- The language the correspondence should be send as. Example: English, Norwegian.
	modified	timestamp DEFAULT clock_timestamp()	(DwC) - The date the record is last modified. Example: 2016-02-08. ZOOTRON_I equivalent: DateOfModification.
	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid	(DwC) - The user name identifying the person who modified last the record. The name has to comply an existing name from the database name register, starting with first/given name and ending with family/surname. Example: vmzomdav. ZOOTRON_I equivalent: UserRec as Operator.
Indexes
	l_Users_pkey	ON userID
	ndx_l_Users_innsider	ON innsider
	ndx_l_Users_isActiveUser	ON isActiveUser
	ndx_l_Users_surname_firstname	ON surname, firstname
	ndx_l_Users_userName	ON userName

Table geo.bathymetry_elevation_world_1km

A 30-arc second elevation including bathymetry and covering the whole world. The "GEBCO" dataset is hosted by https://www.gebco.net/. The GEBCO_2014 Grid is accompanied by a Source Identifier (SID) Grid. This identifies which cells are based on actual depth values and which contain predicted depth values.

Idx	Field Name	Data Type
*	rid	integer DEFAULT nextval('geo.bathymetry_elevation_word_1km_rid_seq'::regclass)
	rast	raster
	st_convexhull(rast)	varchar
Indexes
	bathymetry_elevation_world_1km_pkey	ON rid
	bathymetry_elevation_world_1km_st_convexhull_idx	ON st_convexhull(rast)

Table geo.bathymetry_norway_coast

A polygonised bathymetry dataset covering the Norwegian fjords and outer coast line. The dataset is hosted by Geonorge https://kartkatalog.geonorge.no/metadata/uuid/d4e39f46-f0b5-47eb-8d7a-1c866bd65e44

Idx	Field Name	Data Type
*	bathymetryID	integer DEFAULT nextval('geo."DybdeAreal_id_seq"'::regclass)
	geom	geometry
	depth_max	float8
	depth_min	float8
Indexes
	bathymetry_norway_coast_pkey	ON bathymetryID
	ndx_bathymetry_norway_coast_geom	ON geom

Table geo.elevation_norway_25m

Idx	Field Name	Data Type
*	rid	integer DEFAULT nextval('geo.elevation_norway_25m_rid_seq'::regclass)
	rast	raster
	st_convexhull(rast)	varchar
Indexes
	elevation_norway_25m_pkey	ON rid
	elevation_norway_25m_st_convexhull_idx	ON st_convexhull(rast)

Table data.mof

A list of measurements or facts deriving from either sampling events og occurrences.

Idx	Field Name	Data Type	Description
*	mofID	uuid DEFAULT data.uuid_generate_v4()
*	occurrenceID	uuid DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	measurementDeterminedBy	varchar(125) DEFAULT ''::character varying
	measurementDeterminedDate	timestamp
	measurementType	varchar(50) DEFAULT ''::character varying
	measurementUnit	varchar(50) DEFAULT ''::character varying
	measurementValue	varchar(25)
	measurementAccuracy	varchar(25)
	measurementMethod	varchar(25)
	modified	date DEFAULT clock_timestamp()
	toDelete	integer DEFAULT 0
*	modifiedBy	varchar(40) DEFAULT 'ea9e11e3-0822-49b1-bc7c-b9236a004e9f'::uuid
	registrationDate	date DEFAULT clock_timestamp()	- The date the record is first registered.
Indexes
	mof_pkey	ON mofID
	ndxmofOccurrenceID	ON occurrenceID
	ndxmofmeasurementType	ON measurementType, measurementUnit
Foreign Keys
	FK_mof_Occurrences	( occurrenceID ) ref Occurrences (occurrenceID)
Triggers
	mof_before_edit

Table eco.mof

Idx	Field Name	Data Type
*	mofID	uuid DEFAULT data.uuid_generate_v4()
	eventID	uuid
	measurementDeterminedBy	varchar(125)
	measurementDeterminedDate	date
	measurementType	varchar(50)
	measurementUnit	varchar(50)
	measurementValue	varchar(25)
	measurementAccuracy	varchar(25)
	measurementMethod	varchar(25)
	modifiedBy	varchar(40)
	modified	date
	toDelete	integer
Indexes
	pk_eco_mof	ON mofID
	fki_fk_eco_mof_events	ON eventID
	ndx_eco_mof_measurmentType	ON measurementType
	ndx_eco_mof_measurmentUnit	ON measurementUnit
Foreign Keys
	fk_eco_mof_events	( eventID ) ref Events (eventID)