DATABASE SCHEMA

Explore data model:

ATTACHMENT_LINK

Referencing tables: None


Field Database column Data type Description Referenced table
analysis analysis int analysis
attachment attachment_id int attachment
collection collection int collection
dataset dataset int dataset
date_added date_added datetime
date_changed date_changed datetime
doi doi int doi
drillcore drillcore int drillcore
drillcore_box drillcore_box int drillcore_box
id id int(auto increment)
locality locality int locality
preparation preparation int preparation
reference reference int reference
remarks remarks text
sample sample int sample
sample_series sample_series int sample_series
specimen specimen int specimen
storage storage int location
user_added user_added varchar
user_changed user_changed varchar