| Table: workflows |
Legend:
Primary key columns
Indexed columns
| Column | Type | Size | Nulls | Auto | Default | References | Comments |
|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | χ | √ | nextval('workflows_id_seq'::regclass) | ||
| folder | varchar | 255 | χ | χ | |||
| started_at | timestamp | 29,6 | √ | χ | null | ||
| finished_at | timestamp | 29,6 | √ | χ | null | ||
| created_at | timestamp | 29,6 | √ | χ | utc_now() | ||
| updated_at | timestamp | 29,6 | √ | χ | utc_now() | ||
| site_id | int8 | 19 | √ | χ | null | sites.id | |
| model_id | int8 | 19 | χ | χ | models.id | ||
| hostname | varchar | 255 | χ | χ | |||
| params | text | 2147483647 | χ | χ | ''::text | ||
| advanced_edit | bool | 1 | χ | χ | false | ||
| start_date | timestamp | 29,6 | √ | χ | null | ||
| end_date | timestamp | 29,6 | √ | χ | null | ||
| notes | text | 2147483647 | √ | χ | null | ||
| user_id | int8 | 19 | √ | χ | null | users.id |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| id | Primary key | Asc | workflows_pkey |
|
