Database Fields & Schema

This page describes the database schema for the legacy MUSIT Oracle database. It is auto-generated from the original documentation Felter i Karplanter.html.

Entity Relationship Diagram

The following diagram is automatically inferred from the documentation descriptions.

erDiagram
  CLASSIFICATION_TERM {
    string ENTERED_CLASSTERM  
    string CLASSTERM  
    string VALID_CLASSTERM  
    string INFRASPES_RANK  
    string INFRASPES_NAME  
    string SENSU_TERM  "s.str s.lat..."
  }
  NOTE {
    string NOTE_TEXT  "Note koblet til classification_event..."
  }
  HIERARCHICAL_PLACE {
    string HIERARCHICAL_PLACE_ID  "Søkefelt for å finne riktig hierchical_p..."
  }
  LOCALITY_PLACE {
    string LOCALITY  
  }
  ECOLOGY_PLACE {
    string ECOLOGY  
  }
  BIO_GEOGRAFISK_REGION {
    string BIO_GEO_REGION  
  }
  KOORDINATE_PLACE {
    string CA_UTM  
    string COORDINATE_ADDED_LATER  
    string DATUM  
    string ZONE  
    string BELT  
    string COORDINATE_STRING  
    string COORDINATE_EXPECTED_OUTPUT_ECHO  
    string PRECISION  
    string MAP_SHEET  
    string CA_ALTITUDE  
    string ALTITUDE_STRING  
    string ALTITUDE_EXPECTED_OUTPUT_ECHO  
    string CA_DEPTH  "Kun zoologi..."
    string DEPTH_STRING  "Kun zoologi..."
    string ACCURACY  
    string Ikkeibruk  "Ikke i bruk..."
  }
  EVENT_ROLE_PERSON_NAME {
    string PERSON_NAME_IDROLE_ID  "Kobling mellom Collecting event- og pers..."
    string ROLE_ID  "Navnet er utledet via håndskrift hvis ro..."
    string SORTING_SEQUENCE  "Hvilken rekkefølge skal samlerne vises i..."
    string PERSON_NAMEROLE_ID  "Se Leg..."
  }
  LEGNR {
    string MUSEUM_OBJECT_LEGNR_PERSON  "Kobling mellom object (belegg) og person..."
  }
  PERSON_NAME {
    string PERSON_NAME_ID  
    string TITLE  
    string PERSON_GIVEN_NAME  
    string PERSON_SURNAME  
  }
  ACTOR {
    string ACTOR_TYPE  
    string ACTORNAME  
    string GROUP_MEMBER_NAMES  
    string BIRTHDATE  
    string DEATHDATE  
    string ADRESS  
    string POSTAL_ADDRESS  
    string EMAIL_ADDRESS  
    string PHONE_NUMBER  
    string GENDER  
    string URL  
    string URL_NOTE  
    string NOTE  
  }
  OBJECT_ATTRIBUTES {
    string IS_REG  
    string IS_CORR  
    string IS_APPROVED  
    string OBJECT_WITHHELD  
    string REG_DATE  
    string KORR_DATE  
    string APPROVED_DATE  
    string LAST_MODIFIED  
    string REG_USER  
    string KORR_USER  
    string APPROVE_USER  
    string LAST_MODIFIED_BY  
    string IS_KORR  
  }
  DOCUMENT_OBJECT__REFERENCE_DOCUMENT {
    string DOCUMENT_REFERENCEDOCUMENT_TITLEDOCUMENT_TYPE  "DOCUMENT_OBJECT kobler REFERENCE_OBJECT ..."
  }
  EVENT_DOCUMENT__REFERENCE_DOCUMENT {
    string DOCUMENT_REFERENCEDOCUMENT_TITLEDOCUMENT_TYPE  "EVENT_DOCUMENT kobler REFERENCE_OBJECT t..."
  }
  TYPIFICATION_EVENT {
    string TYPIFICATION_TYPE_ID  "Holotype, Isotype,......."
  }
  PERSON_NAME_EVENT_ROLE {
    string PERSON_NAME_IDROLE_ID  "Kobling mellom typification_event og per..."
  }
  EVENT_DOCUMENT_REFERENCE_DOCUMENT {
    string DOCUMENT_REFERENCEDOCUMENT_TITLEDOCUMENT_TYPE  "EVENT_DOCUMENT kobler REFERENCE_OBJECT t..."
  }
  EVENT_NOTE__NOTE {
    string NOTE_TEXT  "Note koblet til TYPIFICATION_EVENT..."
  }
  TIMESPAN {
    string FROM_DATETO_DATE  "TIMESPAN koblet til TYPIFICATION_EVENT..."
  }

Field Descriptions

Felter i Karplante-applikasjonen:

Taxon

Felt	Tabell	Feltnavn i tabell	Kommentar
Entered taxon name	CLASSIFICATION_TERM	ENTERED_CLASSTERM
Valid taxon name	CLASSIFICATION_TERM	CLASSTERM
Accepted taxon name	CLASSIFICATION_TERM	VALID_CLASSTERM
Infraspesific rank and name	CLASSIFICATION_TERM	INFRASPES_RANK
Infraspesific name	CLASSIFICATION_TERM	INFRASPES_NAME
Sensu	CLASSIFICATION_TERM	SENSU_TERM	s.str s.lat
Note	NOTE	NOTE_TEXT	Note koblet til classification_event

Places

</tr> </tr> </tbody> </table> </div>

Coordinate module

Coordinate module i MusitBotanikk

Main coordinate

Felt	Tabell	Feltnavn i tabell	Kommentar
Admplace	HIERARCHICAL_PLACE	HIERARCHICAL_PLACE_ID	Søkefelt for å finne riktig hierchical_place_id, som representerer et «Administrativt sted», som kommune,fylke, land etc. Brukes også for hav, kontinent. Steder med en hierarkisk struktur
Municipality	HIERARCHICAL_PLACE		Read only, og avledet av Admplace (hierarchical_place_id)
Country/Province	HIERARCHICAL_PLACE		Samme som over
Country	HIERARCHICAL_PLACE		Samme som over
Locality	LOCALITY_PLACE	LOCALITY
Ecology	ECOLOGY_PLACE	ECOLOGY
Biogeografisk region	BIO_GEOGRAFISK_REGION	BIO_GEO_REGION
Ca coord	KOORDINATE_PLACE	CA_UTM
Coordinate added later	KOORDINATE_PLACE	COORDINATE_ADDED_LATER
Datum	KOORDINATE_PLACE	DATUM
Zone	KOORDINATE_PLACE	ZONE
Band	KOORDINATE_PLACE	BELT
Coordinate	KOORDINATE_PLACE	COORDINATE_STRING
</td>	KOORDINATE_PLACE	COORDINATE_EXPECTED_OUTPUT_ECHO
Coord precision	KOORDINATE_PLACE	PRECISION
Map sheet	KOORDINATE_PLACE	MAP_SHEET
Ca	KOORDINATE_PLACE	CA_ALTITUDE
Altitude	KOORDINATE_PLACE	ALTITUDE_STRING
</td>	KOORDINATE_PLACE	ALTITUDE_EXPECTED_OUTPUT_ECHO

</tr> </tr> </tr> </tbody> </table> </div>

Derived coordinate

Felt	Tabell	Feltnavn i tabell	Kommentar
Ca coord	KOORDINATE_PLACE	CA_UTM
Coordinate added later	KOORDINATE_PLACE	COORDINATE_ADDED_LATER
Datum	KOORDINATE_PLACE	DATUM
Zone	KOORDINATE_PLACE	ZONE
Band	KOORDINATE_PLACE	BELT
Coordinate	KOORDINATE_PLACE	COORDINATE_STRING
</td>	KOORDINATE_PLACE	COORDINATE_EXPECTED_OUTPUT_ECHO
Coord precision	KOORDINATE_PLACE	PRECISION
Map sheet	KOORDINATE_PLACE	MAP_SHEET
Ca altitude	KOORDINATE_PLACE	CA_ALTITUDE
</td>	KOORDINATE_PLACE	ALTITUDE_STRING
Ca depth	KOORDINATE_PLACE	CA_DEPTH	Kun zoologi
</td>	KOORDINATE_PLACE	DEPTH_STRING	Kun zoologi
Accuracy	KOORDINATE_PLACE	ACCURACY
Source	KOORDINATE_PLACE	Ikke i bruk	Ikke i bruk

</tr> </tr> </tr> </tr> </tbody> </table> </div>

Leg & Det (Persons and dates)

Leg

Felter	Tabell	Felter i tabell	Kommentar
Lat	DERIVED_COORDINATES	LATITUDE
</td>	DERIVED_COORDINATES	LONGITUDE
UTM	DERIVED_COORDINATES	UTM_X
</td>	DERIVED_COORDINATES	UTM_Y
UTM 33	DERIVED_COORDINATES	UTM33_X
</td>	DERIVED_COORDINATES	UTM33_Y
Derived type	DERIVED_COORDINATES	DERIVED_COORDINATE_TYPE
North / South	DERIVED_COORDINATES	NORTH_SOUTH
Zone & Band	DERIVED_COORDINATES	ZONE
</td>	DERIVED_COORDINATES	BAND
Datum	DERIVED_COORDINATES	DATUM
Derived coordinate ID	DERIVED_COORDINATES	KOORDINATE_PLACE_ID

Felt	Tabell	Feltnavn i tabell	Kommentar
Leg (Person name)	EVENT_ROLE_PERSON_NAME	PERSON_NAME_ID/ROLE_ID	Kobling mellom Collecting event- og personnavn-tabellene med rolle som LEG (eller LEGSCR)
Leg no	LEGNR	MUSEUM_OBJECT_LEGNR_PERSON	Kobling mellom object (belegg) og person (og dermed personnavn)
SCR	EVENT_ROLE_PERSON_NAME	ROLE_ID	Navnet er utledet via håndskrift hvis rolle er LEGSCR)
No #	EVENT_ROLE_PERSON_NAME	SORTING_SEQUENCE	Hvilken rekkefølge skal samlerne vises i?

Det

Felt	Tabell	Feltnavn i tabell	Kommentar
Det (Person name)	EVENT_ROLE_PERSON_NAME	PERSON_NAME/ROLE_ID	Se Leg
Scr	EVENT_ROLE_PERSON_NAME	ROLE_ID	Se Leg
No #	EVENT_ROLE_PERSON_NAME	SORTING_SEQUENCE	Se Leg

Person module

Personmodulen

Personnavn-tabellen (PERSON_NAME)

Kolonnenavn	Type	Kommentar
PERSON_NAME_ID	NUMBER	Primary key for tabellen
ACTOR_ID	NUMBER	FOREIGN KEY til actor
PERSON_SURNAME	VARCHAR2	Etternavn
PERSON_MIDDLE_NAME	VARCHAR2	Mellomnavn (brukes sjelden/aldri, neppe relevant)
PERSON_GIVEN_NAME	VARCHAR2	Fornavn
TITLE	VACHAR2	Tittel (Dr. , Sir., Hr., osv) Brukes noe
PERSON_NAME_TYPE	NUMBER	Hvilket museum hører personen til? Foreign key til type-tabellen

Actor-tabellen (ACTOR)

Kolonnenavn	Type	Kommentar
ACTOR_ID	NUMBER	Primary key for tabellen
ACTOR_TYPE	NUMBER	Type for Actor, stort sett person
ACTORNAME	VARCHAR2	Navn
VALID_PERSON_NAME_ID	NUMBER	Foreign key til “gyldig/forestrukket» variant av navnet
GROUP_MEMBER_NAMES	VARCHAR2	Ikke brukt. Opprinnelig tenkt at Actor kan være gruppe
BIRTHDATE	DATE	Ikke brukt
DEATHDATE	DATE	Ikke brukt
ADRESS	VARCHAR2	Ikke brukt
POSTAL_ADDRESS	VARCHAR2	Ikke brukt
EMAIL_ADDRESS	VARCHAR2	Kanskje brukt (?)
PHONE_NUMBER	VARCHAR2	Ikke brukt
INSTITUTION	VARCHAR2	Ikke brukt
GENDER	VARCHAR2	Ikke brukt
URL	VARCHAR2
URL_NOTE	VARCHAR2	Brukes som referanse til kjente personbaser, som Wikidata, OrcID osv.
NOTE	VARCHAR2	Data om personen som ikke er lagt ut i felter. Usikker på relevans

Felter i Personmodulen

Names

Felt	Tabell	Feltnavn i tabell	Kommentar
ID	PERSON_NAME	PERSON_NAME_ID
Title	PERSON_NAME	TITLE
Given name	PERSON_NAME	PERSON_GIVEN_NAME
Surname	PERSON_NAME	PERSON_SURNAME

Synonyms

Additional information

Felt	Tabell	Feltnavn i tabell	Kommentar
Legal entity type	ACTOR	ACTOR_TYPE
Display name	ACTOR	ACTORNAME
Group name	ACTOR	GROUP_MEMBER_NAMES
Birth date	ACTOR	BIRTHDATE
Death date	ACTOR	DEATHDATE
Address	ACTOR	ADRESS
Postal address	ACTOR	POSTAL_ADDRESS
Email	ACTOR	EMAIL_ADDRESS
Phone number	ACTOR	PHONE_NUMBER
Gender	ACTOR	GENDER
URL	ACTOR	URL
URL note	ACTOR	URL_NOTE
Note	ACTOR	NOTE

Date (for innsamling og bestemmelse)

Diverse felter fordelt i faner nederst på siden

Notes

Felt	Tabell	Feltnavn i tabell	Kommentar
Collectors note	NOTE	NOTE_TEXT	Note koblet til collecting event
Adm note	NOTE	NOTE_TEXT	Note koblet til objektet (belegget)

Adm

</tr> </tr> </tr> </tbody> </table> </div>

Literature

Felt	Tabell	Feltnavn i tabell	Kommentar
Reg.?	OBJECT_ATTRIBUTES	IS_REG
Corrected?	OBJECT_ATTRIBUTES	IS_CORR
Approved?	OBJECT_ATTRIBUTES	IS_APPROVED
Object withheld	OBJECT_ATTRIBUTES	OBJECT_WITHHELD
Reg date	OBJECT_ATTRIBUTES	REG_DATE
Corr date	OBJECT_ATTRIBUTES	KORR_DATE
Approved date	OBJECT_ATTRIBUTES	APPROVED_DATE
Last modified date	OBJECT_ATTRIBUTES	LAST_MODIFIED
Reg by	OBJECT_ATTRIBUTES	REG_USER
Corr by	OBJECT_ATTRIBUTES	KORR_USER
Approved by	OBJECT_ATTRIBUTES	APPROVE_USER
Last modified by	OBJECT_ATTRIBUTES	LAST_MODIFIED_BY
</td>	OBJECT_ATTRIBUTES	IS_REG
</td>	OBJECT_ATTRIBUTES	IS_KORR
</td>	OBJECT_ATTRIBUTES	IS_APPROVED

Felt	Tabell	Feltnavn i tabell	Kommentar
Specimen literature	DOCUMENT_OBJECT/ REFERENCE_DOCUMENT	DOCUMENT_REFERENCE, DOCUMENT_TITLE, DOCUMENT_TYPE	DOCUMENT_OBJECT kobler REFERENCE_OBJECT til objektet (belegget)
Taxon literature	EVENT_DOCUMENT, REFERENCE_DOCUMENT	DOCUMENT_REFERENCE, DOCUMENT_TITLE, DOCUMENT_TYPE	EVENT_DOCUMENT kobler REFERENCE_OBJECT til bestemelseshendelsen (taxonet)

Type info

Felt	Tabell	Feltnavn i tabell	Kommentar
Type status	TYPIFICATION_EVENT	TYPIFICATION_TYPE_ID	Holotype, Isotype,....
Designated by	PERSON_NAME_EVENT_ROLE	PERSON_NAME_ID/ROLE_ID	Kobling mellom typification_event og person_name
Publication	EVENT_DOCUMENT/REFERENCE_DOCUMENT	DOCUMENT_REFERENCE, DOCUMENT_TITLE, DOCUMENT_TYPE	EVENT_DOCUMENT kobler REFERENCE_OBJECT til TYPIFICATION_EVENT
Note	EVENT_NOTE, NOTE	NOTE_TEXT	Note koblet til TYPIFICATION_EVENT
Year	TIMESPAN	FROM_DATE, TO_DATE	TIMESPAN koblet til TYPIFICATION_EVENT

Other data/Administrative data

Felt	Tabell	Feltnavn i tabell	Kommentar
Dataset
Duplicates
Project name
Same sheet as
Ex herb.
Artsobs no
Voucher
UUID
Analysis request