DATASET
Referencing tables: analysis | attachment_link | dataset_analysis | dataset_author | dataset_geolocation | dataset_reference | doi |
| Field | Data type | Description | Referenced table |
|---|---|---|---|
| user_added | varchar | ||
| date_added | datetime | ||
| user_changed | varchar | ||
| date_changed | datetime | ||
| creators | varchar | ||
| title | varchar | ||
| title_alternative | varchar | ||
| title_translated | varchar | ||
| title_translated_language | int | list_language | |
| publisher | varchar | ||
| publication_year | varchar | ||
| subjects | varchar | ||
| language | int | list_language | |
| resource_type | int | doi_resource_type | |
| resource | varchar | ||
| version | varchar | ||
| description | text | ||
| abstract | text | ||
| methods | text | ||
| dataset_html | text | ||
| date | date | ||
| date_txt | varchar | ||
| reference | int | reference | |
| locality | int | locality | |
| is_private | tinyint | ||
| owner | int | agent | |
| owner_txt | varchar | ||
| copyright_agent | int | agent | |
| licence | int | list_licence | |
| remarks | text | ||
| database | int | database | |
| timestamp | datetime | ||
| id | int(auto increment) | ||
| name | varchar | ||
| name_en | varchar | ||
| description_en | text | ||
| attachments | int | attachment |
