23 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| sisalto_kirjepohja_id_fkey |
|
|
Restrict delete | ||
| sisalto_korvauskentta_rakenne_fkey |
|
|
Restrict delete | ||
| kirjepohja_haku_kirjepohja_fkey |
|
|
Restrict delete | ||
| vastaanottajaemail_vastaanottaja_id |
|
|
Restrict delete | ||
| kirjelahetysvirhe_vastaanottaja_id_fkey |
|
|
Restrict delete | ||
| kirjelahetysvirhe_kirjelahetys_id_fkey |
|
|
Restrict delete | ||
| lahetyskorvauskentat_kirjelahetys_id_fkey |
|
|
Restrict delete | ||
| vastaanottajaosoite_vastaanottaja_id |
|
|
Restrict delete | ||
| vastaanottajakorvauskentat_vastaanottaja_id_fkey |
|
|
Restrict delete | ||
| korvauskentat_luonnos_id_fkey |
|
|
Restrict delete | ||
| vastaanottaja_kirjelahetys_id_fkey |
|
|
Restrict delete | ||
| vastaanottaja_iposti_fkey |
|
|
Restrict delete | ||
| vastaanottajakirje_vastaanottaja_id_fkey |
|
|
Restrict delete | ||
| sisalto_rakenne_tyyli_fkey |
|
|
Restrict delete | ||
| sisalto_rakenne_rakenne_fkey |
|
|
Restrict delete | ||
| kirjepohja_id_fkey |
|
|
Restrict delete | ||
| kirjelahetys_id_fkey |
|
|
Restrict delete | ||
| kirjepohja_rakenne_fkey |
|
|
Restrict delete | ||
| korvauskentat_kirjepohja_id_fkey |
|
|
Restrict delete | ||
| vastaanottajakirje_liite_vastaanottajakirje_fkey |
|
|
Cascade on delete | ||
| iposti_kirjelahetys_id_key |
|
|
Restrict delete | ||
| sisalto_rakenne_sisalto_sisalto_rakenne_fkey |
|
|
Restrict delete | ||
| sisalto_rakenne_sisalto_sisalto_fkey |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| sisalto_korvauskentta | sisalto_korvauskentta_tyyppi | (((tyyppi)::text = ANY (ARRAY[('plain'::character varying)::text, ('html'::character varying)::text]))) |
| kirjelahetysvirhe | iposti_order_number_null | (((((tyyppi)::text = 'IPOSTI'::text) AND (iposti_order_number IS NOT NULL)) OR (((tyyppi)::text <> 'IPOSTI'::text) AND (iposti_order_number IS NULL)))) |
| kirjelahetysvirhe | vastaanottaja_id_null | (((((tyyppi)::text = 'LETTER'::text) AND (vastaanottaja_id IS NOT NULL)) OR (((tyyppi)::text <> 'LETTER'::text) AND (vastaanottaja_id IS NULL)))) |
| kirjelahetysvirhe | virhe_tyyppi | (((tyyppi)::text = ANY (ARRAY[('LETTER'::character varying)::text, ('IPOSTI'::character varying)::text, ('EMAIL'::character varying)::text, ('GENERAL'::character varying)::text]))) |
| sisalto_rakenne | sisalto_rakenne_tyyppi | (((tyyppi)::text = ANY (ARRAY[('email'::character varying)::text, ('letter'::character varying)::text, ('asiointitili'::character varying)::text, ('accessibleHtml'::character varying)::text]))) |
| kirjelahetys | 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]))) |
| kirjepohja | kirjepohja_tila_check | (((tila)::text = ANY (ARRAY[('suljettu'::character varying)::text, ('julkaistu'::character varying)::text, ('luonnos'::character varying)::text]))) |
| rakenne_sisalto | sisalto_tyyppi | (((tyyppi)::text = ANY (ARRAY[('plain'::character varying)::text, ('html'::character varying)::text]))) |
| sisalto_rakenne_sisalto | sisalto_rakenne_sisalto_rooli | (((rooli)::text = ANY (ARRAY[('header'::character varying)::text, ('body'::character varying)::text, ('sms'::character varying)::text, ('attachment'::character varying)::text]))) |