44 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||||||
|---|---|---|---|---|---|---|---|---|---|
| campusutdanningsmulighet_campus_fk |
|
|
Restrict delete | ||||||
| campusutdanningsmulighet_utdanningsmulighet_fk |
|
|
Restrict delete | ||||||
| utdanningsmulighetniva_utdanningsmulighet_fk |
|
|
Restrict delete | ||||||
| utdanningsmulighetniva_utdanningsnivai_fk |
|
|
Restrict delete | ||||||
| utdanningsmulighethierarki_inngari_fk |
|
|
Restrict delete | ||||||
| utdanningsmulighethierarki_inneholder_fk |
|
|
Restrict delete | ||||||
| utdanningsniva_standard_fk |
|
|
Restrict delete | ||||||
| utdanningsinstans_utdanningsmulighet_fk |
|
|
Restrict delete | ||||||
| utdanningsinstans_campus_fk |
|
|
Restrict delete | ||||||
| utdanningsinstans_termin_til_fk |
|
|
Restrict delete | ||||||
| utdanningsinstans_sprak_fk |
|
|
Restrict delete | ||||||
| utdanningsinstans_termin_fra_fk |
|
|
Restrict delete | ||||||
| kurs_utdanningsmulighet_fk |
|
|
Restrict delete | ||||||
| utdanningsmulighetnavn_utdanningsmulighet_fk |
|
|
Restrict delete | ||||||
| utdanningsmulighetnavn_sprak_fk |
|
|
Restrict delete | ||||||
| utdanningsmulighetundervisningstype_utdanningsmulighet_fk |
|
|
Restrict delete | ||||||
| utdanningsmulighetundervisningstype_undervisningstype_fk |
|
|
Restrict delete | ||||||
| utdanningsmulighetfagomrade_utdanningsmulighet_fk |
|
|
Restrict delete | ||||||
| utdanningsmulighetfagomrade_fagomrade_fk |
|
|
Restrict delete | ||||||
| fagomrade_standard_fk |
|
|
Restrict delete | ||||||
| foretakutdanning_foretak_fk |
|
|
Restrict delete | ||||||
| foretakutdanning_utdanningsmulighet_fk |
|
|
Restrict delete | ||||||
| termin_type_fk |
|
|
Restrict delete | ||||||
| studieprogram_utdanningsmulighet_fk |
|
|
Restrict delete | ||||||
| studieprogram_soknadsbehandlertildelingsregel_fk |
|
|
Restrict delete | ||||||
| utdanningsinstanshierarki_utdanningsinstans_inngar_i_fk |
|
|
Restrict delete | ||||||
| utdanningsinstanshierarki_utdanningsinstans_inneholder_fk |
|
|
Restrict delete | ||||||
| fagomradesprak_sprak_fk |
|
|
Restrict delete | ||||||
| fagomradesprak_fagomrade_fk |
|
|
Restrict delete | ||||||
| termintype_organisasjon_fk |
|
|
Restrict delete | ||||||
| fagomradehierarki_inneholder_fk |
|
|
Restrict delete | ||||||
| fagomradehierarki_inngar_i_fk |
|
|
Restrict delete | ||||||
| undervisningsenhet_utdanningsinstans_fk |
|
|
Restrict delete | ||||||
| utdanningsmulighet_larested_fk |
|
|
Restrict delete | ||||||
| utdanningsmulighet_varighettype_fk |
|
|
Restrict delete | ||||||
| utdanningsnivasprak_sprak_fk |
|
|
Restrict delete | ||||||
| utdanningsnivasprak_utdanningsniva_fk |
|
|
Restrict delete | ||||||
| utdanningsmulighettagg_tagg_fk |
|
|
Restrict delete | ||||||
| utdanningsmulighettagg_utdanningsmulighet_fk |
|
|
Restrict delete | ||||||
| utdanningsaktivitet_utdanningsinstans_fk |
|
|
Restrict delete | ||||||
| kursinstans_utdanningsinstans_fk |
|
|
Restrict delete | ||||||
| emne_etteranmeldingstype_pamelding_fk |
|
|
Restrict delete | ||||||
| emne_utdanningsmulighet_fk |
|
|
Restrict delete | ||||||
| emne_etteranmeldingstype_fk |
|
|
Restrict delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| utdanningsinstans | utdanningsinstans_arstall_ck | ((arstall_fra <= arstall_til)) |
| utdanningsinstans | utdanningsinstans_lukket_ck | (((NOT lower_inf((dager)::daterange)) AND (NOT upper_inf((dager)::daterange)) AND (NOT lower_inf((tider)::tstzrange)) AND (NOT upper_inf((tider)::tstzrange)))) |
| utdanningsinstans | utdanningsinstans_niva_ck | ((((terminkode_fra IS NULL) AND (dager IS NULL)) OR ((terminkode_fra IS NULL) AND (tider IS NULL)) OR ((dager IS NULL) AND (tider IS NULL)))) |
| utdanningsinstans | utdanningsinstans_termin_ck | ((((terminkode_fra IS NOT NULL) AND (terminkode_til IS NOT NULL)) OR ((terminkode_fra IS NULL) AND (terminkode_til IS NULL)))) |
| utdanningsinstans | utdanningsinstans_termin_fra_ck | ((((arstall_fra IS NOT NULL) AND (terminkode_fra IS NOT NULL)) OR ((arstall_fra IS NULL) AND (terminkode_fra IS NULL)))) |
| utdanningsinstans | utdanningsinstans_termin_til_ck | ((((arstall_til IS NOT NULL) AND (terminkode_til IS NOT NULL)) OR ((arstall_til IS NULL) AND (terminkode_til IS NULL)))) |
| kurs | kurs_type_ck | ((er_etterutdanning OR er_videreutdanning)) |
| fagomrade | fagomrade_rust_ck | ((((gjelder_alle_studier IS NOT NULL) AND ((fagomrade_standard_kode)::text = 'RUST'::text)) OR ((gjelder_alle_studier IS NULL) AND ((fagomrade_standard_kode)::text <> 'RUST'::text)))) |
| fagomrade_sprak | fagomrade_sprak_ck | (((navn IS NOT NULL) OR (beskrivelse IS NOT NULL))) |
| utdanningsmulighet | utdanningsmulighet_ck | ((((varighettype_kode IS NOT NULL) AND (varighet IS NOT NULL)) OR ((varighettype_kode IS NULL) AND (varighet IS NULL)))) |
| utdanningsniva_sprak | utdanningsniva_sprak_ck | (((navn IS NOT NULL) OR (beskrivelse IS NOT NULL))) |