DATABASE SCHEMA

Explore data model:

ANALYSIS

Referencing tables: analysis_results | attachment_link | dataset_analysis |


Field Database column Data type Description Referenced table
agent agent int agent
agent_txt agent_txt varchar
analysis_method method int analysis_method
database database_id int database
dataset dataset_id int dataset
date date date
date_added date_added datetime
date_changed date_changed datetime
date_end date_end date
date_free date_free varchar
id id int(auto increment)
instrument instrument_id int lab_instrument
instrument_txt instrument_txt varchar
is_private private int
lab lab_id int lab
lab_analysis_number lab_analysis_number varchar
lab_sample_number lab_sample_number varchar
lab_txt lab_txt varchar
location location varchar
mass mass int
material material varchar
method_details method_details varchar
method_details_en method_details_en varchar
owner owner int agent
reference reference_id int reference
remarks remarks text
sample sample_id int sample
storage storage_id int location
timestamp timestamp datetime
user_added user_added varchar
user_changed user_changed varchar