DATABASE SCHEMA

Explore data model:

AGENT

Contents: persons and organizations

Description: table AGENT contains information about persons and institutions/organizations that have direct connection to collections incl. sample collectors, identifiers, borrowers, describers, but for example also the company that delivers the material.

Referencing tables: accession | analysis | attachment | collection | conop_distribution | dataset | dataset_author | deaccession | doi | doi_agent | drillcore | drillcore_image | drillcore_study | image | imageset | lab | loan | locality | locality_stratigraphy | location | preparation | preparation_taxa | sample | sample_palaeontology | sample_series | soil_site | specimen | specimen_description | specimen_identification | specimen_identification_geology | specimen_image | taxon_description | taxon_list | taxon_page | visit |


Field Database column Data type Description Referenced table
address address varchar
address1 address1 varchar aadress 2. rida
address2 address2 varchar aadress 3. rida
agent agent varchar isiku kordumatu nimi üldjuhul piisab perekonnanimest, kui on mitu sama perekonnanimega isikut, siis lisatakse perenimi järel komaga eraldatuna eesnime esitäht (ilma punktita) või terve nimi
country country_id int list_country
country_txt country varchar riik
date_added date_added datetime Timestamp when record was created
date_born date_born date sünniaeg
date_changed date_changed datetime
date_deceased date_deceased date surmaaeg
email email varchar e-mail
forename forename varchar eesnimi eraisiku puhul
http http varchar kodulehekülje aadress
id id int(auto increment) Automatically generated unique sequential primary key (record ID)
institution institution int institutsioon, täidetakse ainult juhul kui näit. eraisik kuulub kuhugi asutusse agent
institution_name institution_name varchar institutsiooni pikk nimi, täidetakse ainult institutsiooni puhul
institution_name_en institution_name_en varchar
new_name new_name varchar praegune perekonnanimi
old_name old_name varchar endine perekonnanimi
phone phone varchar telefon koos koodidega
profession profession varchar amet
profession_en profession_en varchar
remarks remarks text lisainfo vabas vormis
surename surename varchar perekonnanimi eraisiku puhul
timestamp timestamp datetime ajatempel, mis kajastab samuti andmete viimast muutmist, sisestab andmebaasimootor
title title varchar title
type type int agendi tüüp, valik: isik, akadeemiline asutus, firma, ... agent_type
user_added user_added varchar User who first saved record
user_changed user_changed varchar User who last saved record