AGENT
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 | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| agent | varchar | ||
| type | int | agent_type | |
| forename | varchar | ||
| middlename | varchar | ||
| surename | varchar | ||
| title | varchar | ||
| profession | varchar | ||
| profession_en | varchar | ||
| institution | int | agent | |
| institution_name | varchar | ||
| institution_name_en | varchar | ||
| address | varchar | ||
| address1 | varchar | ||
| address2 | varchar | ||
| country | int | list_country | |
| country_txt | varchar | ||
| phone | varchar | ||
| varchar | |||
| http | varchar | ||
| address_2 | varchar | ||
| address1_2 | varchar | ||
| address2_2 | varchar | ||
| country_2 | varchar | ||
| phone_2 | varchar | ||
| fax_2 | varchar | ||
| email_2 | varchar | ||
| http_2 | varchar | ||
| old_name | varchar | ||
| new_name | varchar | ||
| username | varchar | ||
| date_born | date | ||
| date_deceased | date | ||
| relation | varchar | ||
| selected | int | ||
| remarks | text | ||
| isikukood | double | ||
| orcid | varchar | ||
| privileges | int | ||
| id | int(auto increment) | ||
| timestamp | datetime | ||
| deleted | varchar | ||
| personal_code | varchar | ||
| database | int | database |
