Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | null |
|
|
||||||
| version | int8 | 19 | 0 |
|
|
||||||
| luotu | timestamp | 29,6 | now() |
|
|
||||||
| tila | varchar | 64 | 'CREATED'::character varying |
|
|
||||||
| viimeksi_kasitelty | timestamp | 29,6 | √ | null |
|
|
|||||
| suoritettu | timestamp | 29,6 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| lahetysjono_pkey | Primary key | Asc | id |
| lahetysjono_tila_luotu_id_idx | Performance | Asc/Asc/Asc | tila + luotu + id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| lahetysjono_tila_constraint | (((tila)::text = ANY (ARRAY[('CREATED'::character varying)::text, ('WAITING_FOR_HANDLER'::character varying)::text, ('PROCESSING'::character varying)::text, ('FAILED'::character varying)::text, ('READY'::character varying)::text]))) |
Relationships
Close relationships within degrees of separation
