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 | file_collection | image | imageset | lab | library | library_agent | loan | locality | locality_description | locality_stratigraphy | location | preparation | project | project_agent | reference_author | sample | sample_palaeontology | sample_series | site | soil_site | specimen | specimen_description | specimen_identification | specimen_identification_geology | specimen_image | taxon_description | taxon_list | taxon_page | visit |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | User who first saved record | |
| date_added | datetime | Timestamp when record was created | |
| user_changed | varchar | User who last saved record | |
| date_changed | datetime | ||
| 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 | |
| type | int | agendi tüüp, valik: isik, akadeemiline asutus, firma, ... | agent_type |
| forename | varchar | eesnimi eraisiku puhul | |
| middlename | varchar | initsiaalide raisiku puhul | |
| surename | varchar | perekonnanimi eraisiku puhul | |
| title | varchar | title | |
| profession | varchar | amet | |
| profession_en | varchar | ||
| institution | int | institutsioon, täidetakse ainult juhul kui näit. eraisik kuulub kuhugi asutusse | agent |
| institution_name | varchar | institutsiooni pikk nimi, täidetakse ainult institutsiooni puhul | |
| institution_name_en | varchar | ||
| address | varchar | ||
| address1 | varchar | aadress 2. rida | |
| address2 | varchar | aadress 3. rida | |
| country | int | list_country | |
| country_txt | varchar | riik | |
| phone | varchar | telefon koos koodidega | |
| varchar | |||
| http | varchar | kodulehekülje aadress | |
| address_2 | varchar | aadress kodus 1. rida | |
| address1_2 | varchar | aadress kodus 2. rida | |
| address2_2 | varchar | aadress kodus 3. rida | |
| country_2 | varchar | ||
| phone_2 | varchar | telefon kodus | |
| fax_2 | varchar | faks kodus | |
| email_2 | varchar | isiklik e-mail | |
| http_2 | varchar | ||
| old_name | varchar | endine perekonnanimi | |
| new_name | varchar | praegune perekonnanimi | |
| username | varchar | kasutajanimi kollektsioonide infosüsteemis | |
| date_born | date | sünniaeg | |
| date_deceased | date | surmaaeg | |
| relation | varchar | seos kollektsioonidega vaba tekstina | |
| selected | int | kirjete valimiseks kasutatav väli (jah / ei) | |
| remarks | text | lisainfo vabas vormis | |
| isikukood | double | ||
| orcid | varchar | ||
| privileges | int | ||
| id | int(auto increment) | Automatically generated unique sequential primary key (record ID) | |
| timestamp | datetime | ajatempel, mis kajastab samuti andmete viimast muutmist, sisestab andmebaasimootor | |
| deleted | varchar | ||
| personal_code | varchar | ||
| database | int | database |
