Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| id | int8 | 19 | null |
|
|
||||||||||||||||||
| version | int8 | 19 | null |
|
|
||||||||||||||||||
| template_id | int8 | 19 | null |
|
|
||||||||||||||||||
| aikaleima | timestamp | 29,6 | √ | null |
|
|
|||||||||||||||||
| oid_tallentaja | varchar | 255 | √ | null |
|
|
|||||||||||||||||
| oid_organisaatio | varchar | 255 | √ | null |
|
|
|||||||||||||||||
| kielikoodi | varchar | 5 | √ | null |
|
|
|||||||||||||||||
| template_name | varchar | 255 | √ | null |
|
|
|||||||||||||||||
| hakukohde | varchar | 255 | √ | null |
|
|
|||||||||||||||||
| tunniste | varchar | 255 | √ | null |
|
|
|||||||||||||||||
| haku | varchar | 255 | √ | null |
|
|
|||||||||||||||||
| kasittely_aloitettu | timestamp | 29,6 | √ | null |
|
|
|||||||||||||||||
| kasittely_valmis | timestamp | 29,6 | √ | null |
|
|
|||||||||||||||||
| email_kasittely_aloitettu | timestamp | 29,6 | √ | null |
|
|
|||||||||||||||||
| email_kasittely_valmis | timestamp | 29,6 | √ | null |
|
|
|||||||||||||||||
| kasittelyn_tila | varchar | 64 | 'created'::character varying |
|
|
||||||||||||||||||
| iposti | bool | 1 | false |
|
|
||||||||||||||||||
| ipost_kasittely_aloitettu | timestamp | 29,6 | √ | null |
|
|
|||||||||||||||||
| ipost_kasittely_valmis | timestamp | 29,6 | √ | null |
|
|
|||||||||||||||||
| ohita_dokumenttipalvelu | bool | 1 | false |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| kirjelahetys_pk | Primary key | Asc | id |
| kirjeet_kirjelahetys_aikaleima_index | Performance | Asc | aikaleima |
| kirjeet_kirjelahetys_haku_index | Performance | Asc | haku |
| kirjeet_kirjelahetys_hakuehdot_ja_aikaleima_index | Performance | Asc/Asc/Asc/Asc/Asc | haku + hakukohde + template_name + kasittelyn_tila + aikaleima |
| kirjeet_kirjelahetys_hakukohde_index | Performance | Asc | hakukohde |
| kirjeet_kirjelahetys_kirjepohja_index | Performance | Asc | template_name |
| kirjeet_kirjelahetys_tunniste_index | Performance | Asc | tunniste |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| kasittelyn_tilat | (((kasittelyn_tila)::text = ANY (ARRAY[('created'::character varying)::text, ('processing'::character varying)::text, ('waiting_for_ipost_processing'::character varying)::text, ('processing_ipost'::character varying)::text, ('ready'::character varying)::text, ('error'::character varying)::text]))) |
Relationships
Close relationships within degrees of separation
