Table bety.public.runs |
Legend:
Primary key columns
Indexed columns
Column | Type | Size | Nulls | Auto | Default | References | Comments |
---|---|---|---|---|---|---|---|
id | serial | 10 | χ | √ | nextval('runs_id_seq'::regclass) | ||
model_id | int4 | 10 | √ | χ | null | models.id | |
site_id | int4 | 10 | √ | χ | null | sites.id | |
start_time | timestamp | 29,6 | √ | χ | null | ||
finish_time | timestamp | 29,6 | √ | χ | null | ||
outdir | varchar | 255 | √ | χ | null | ||
outprefix | varchar | 255 | √ | χ | null | ||
setting | varchar | 255 | √ | χ | null | ||
parameter_list | text | 2147483647 | √ | χ | null | ||
created_at | timestamp | 29,6 | √ | χ | null | ||
updated_at | timestamp | 29,6 | √ | χ | null | ||
started_at | timestamp | 29,6 | √ | χ | null | ||
finished_at | timestamp | 29,6 | √ | χ | null | ||
ensemble_id | int4 | 10 | √ | χ | null | ensembles.id | |
start_date | varchar | 255 | √ | χ | null | ||
end_date | varchar | 255 | √ | χ | null |
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 |