Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| note_id | int8 | 19 | null |
|
|
||||||
| nottyp_id | int8 | 19 | √ | null |
|
|
|||||
| opdtid | timestamp | 22 | √ | null |
|
|
|||||
| opdinit | varchar | 30 | √ | null |
|
|
|||||
| intern | varchar | 1 | √ | null |
|
|
|||||
| udskrives_pa_bevis | varchar | 1 | √ | null |
|
|
|||||
| datering | timestamp | 22 | √ | null |
|
|
|||||
| amkr_id | int8 | 19 | √ | null |
|
|
|||||
| elev_id | int8 | 19 | √ | null |
|
|
|||||
| pers_id | int8 | 19 | √ | null |
|
|
|||||
| ivku_id | int8 | 19 | √ | null |
|
|
|||||
| relevans | varchar | 2 | √ | null |
|
|
|||||
| tekst | varchar | 2000 | √ | null |
|
|
|||||
| opdmod | varchar | 4 | √ | null |
|
|
|||||
| kommunebrev | varchar | 1 | √ | null |
|
|
|||||
| elevplannote | varchar | 1 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| note_pk | Primary key | Asc | note_id |
| note_amkr_fk_i | Performance | Asc | amkr_id |
| note_elev_fk_i | Performance | Asc | elev_id |
| note_ivku_fk_i | Performance | Asc | ivku_id |
| note_note1_uk | Must be unique | Asc/Asc/Asc/Asc/Asc/Asc | datering + nottyp_id + amkr_id + elev_id + pers_id + ivku_id |
| note_nottyp_fk_i | Performance | Asc | nottyp_id |
| note_pers_fk_i | Performance | Asc | pers_id |
| note_pers_id_idx | Performance | Asc | pers_id |
| note_udskrives_pa_bevis_idx | Performance | Asc | udskrives_pa_bevis |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| noter_check | (('DATERING' IS NOT NULL)) |
| noter_check7 | (('OPDMOD' IS NOT NULL)) |
| noter_check1 | (('ELEVPLANNOTE' IS NOT NULL)) |
| noter_intern_check | (((intern)::text = ANY ((ARRAY['I'::character varying, 'E'::character varying])::text[]))) |
| noter_kommunebrev_check | (((kommunebrev)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| noter_check6 | (('OPDINIT' IS NOT NULL)) |
| noter_udskrives_pa_bevis_check | (((udskrives_pa_bevis)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| noter_check3 | (('KOMMUNEBREV' IS NOT NULL)) |
| noter_check2 | (('INTERN' IS NOT NULL)) |
| noter_elevplannote_check | (((elevplannote)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| noter_relevans_check | (((relevans)::text = ANY ((ARRAY['B'::character varying, 'F1'::character varying, 'F2'::character varying, 'F3'::character varying, 'S'::character varying])::text[]))) |
| noter_check4 | (('NOTE_ID' IS NOT NULL)) |
| noter_check9 | (('UDSKRIVES_PA_BEVIS' IS NOT NULL)) |
| noter_check5 | (('NOTTYP_ID' IS NOT NULL)) |
| noter_check8 | (('OPDTID' IS NOT NULL)) |