Table: runs
Legend: Primary key columns Indexed columns
Column Type Size Nulls Auto Default References Comments
id bigserial 19  χ   √  nextval('runs_id_seq'::regclass)
model_id int8 19  χ   χ
site_id int8 19  χ   χ
start_time timestamp 29,6  χ   χ  beginning of time period being simulated
finish_time timestamp 29,6  χ   χ  end of time period being simulated
outdir varchar 255  χ   χ  ''::character varying
outprefix varchar 255  χ   χ  ''::character varying
setting varchar 255  χ   χ  ''::character varying
parameter_list text 2147483647  χ   χ 
created_at timestamp 29,6  √   χ  utc_now()
updated_at timestamp 29,6  √   χ  utc_now()
started_at timestamp 29,6  √   χ  null system time when run was started
finished_at timestamp 29,6  √   χ  null system time when run ends; can be null when record is created
ensemble_id int8 19  χ   χ
Column(s) Type Sort Constraint Name
id Primary key Asc runs_pkey
ensemble_id Performance Asc index_runs_on_ensemble_id
model_id Performance Asc index_runs_on_model_id
site_id Performance Asc index_runs_on_site_id
model_id + site_id + start_time + finish_time + parameter_list + ensemble_id Must be unique Asc/Asc/Asc/Asc/Asc/Asc unique_time_interval_per_model_site_parameter_list_and_ensemble