| 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 | χ | χ | models.id | ||
| site_id | int8 | 19 | χ | χ | sites.id | ||
| 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 | χ | χ | ensembles.id |
Indexes:
| 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 |
|
