Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| itace_id | int8 | 19 | null |
|
|
||||||
| hold | varchar | 12 | √ | null |
|
|
|||||
| cpr_nr | varchar | 11 | √ | null |
|
|
|||||
| startdato | timestamp | 22 | √ | null |
|
|
|||||
| slutdato | timestamp | 22 | √ | null |
|
|
|||||
| skolefag | varchar | 5 | √ | null |
|
|
|||||
| niveau | varchar | 1 | √ | null |
|
|
|||||
| holdident | varchar | 8 | √ | null |
|
|
|||||
| alternativ_betaler | varchar | 1 | √ | null |
|
|
|||||
| tvunget_bidrag | varchar | 1 | √ | null |
|
|
|||||
| bidrag | numeric | 12,5 | √ | null |
|
|
|||||
| itae_id | int8 | 19 | √ | null |
|
|
|||||
| ae_rekvirent | varchar | 4 | √ | null |
|
|
|||||
| ae_rekvirent_type | varchar | 5 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| itace_pk | Primary key | Asc | itace_id |
| itace_cpr_nr_idx | Performance | Asc | cpr_nr |
| itace_hold_idx | Performance | Asc | hold |
| itace_itace_uk | Must be unique | Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc | cpr_nr + startdato + hold + skolefag + niveau + itae_id + ae_rekvirent + ae_rekvirent_type |
| itace_itae_fk_i | Performance | Asc | itae_id |
| itace_itae_id_idx | Performance | Asc | itae_id |
| itace_x3_idx | Performance | Asc/Asc/Asc | cpr_nr + hold + itae_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| inb_tilskud_au_cpr_end_check1 | (('AE_REKVIRENT_TYPE' IS NOT NULL)) |
| inb_tilskud_au_cpr_end_tvunget_bidrag_check | (((tvunget_bidrag)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| inb_tilskud_au_cpr_end_check3 | (('BIDRAG' IS NOT NULL)) |
| inb_tilskud_au_cpr_end_check5 | (('HOLD' IS NOT NULL)) |
| inb_tilskud_au_cpr_end_check2 | (('ALTERNATIV_BETALER' IS NOT NULL)) |
| inb_tilskud_au_cpr_end_check12 | (('TVUNGET_BIDRAG' IS NOT NULL)) |
| inb_tilskud_au_cpr_end_check7 | (('ITAE_ID' IS NOT NULL)) |
| inb_tilskud_au_cpr_end_check11 | (('STARTDATO' IS NOT NULL)) |
| inb_tilskud_au_cpr_end_check9 | (('SKOLEFAG' IS NOT NULL)) |
| inb_tilskud_au_cpr_end_check10 | (('SLUTDATO' IS NOT NULL)) |
| inb_tilskud_au_cpr_end_check6 | (('ITACE_ID' IS NOT NULL)) |
| inb_tilskud_au_cpr_end_check | (('AE_REKVIRENT' IS NOT NULL)) |
| inb_tilskud_au_cpr_end_check4 | (('CPR_NR' IS NOT NULL)) |
| inb_tilskud_au_cpr_end_alternativ_betaler_check | (((alternativ_betaler)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| inb_tilskud_au_cpr_end_check8 | (('NIVEAU' IS NOT NULL)) |