AGENT
Referencing tables: accession | agent_type | analysis | attachment | collection | database | dataset | dataset_author | deaccession | doi | doi_agent | drillcore | drillcore_study | imageset | lab | library | library_agent | loan | locality | locality_description | locality_stratigraphy | location | preparation | project | project_agent | sample | sample_series | site | soil_site | specimen | specimen_description | specimen_identification | specimen_identification_geology | specimen_image | taxon_description | taxon_list | taxon_page | visit | list_country |
| 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 | ||
| old_name | varchar | ||
| new_name | varchar | ||
| date_born | date | ||
| date_deceased | date | ||
| orcid | varchar | ||
| remarks | text | ||
| id | int(auto increment) | ||
| personal_code | varchar | ||
| database | int | database |
