Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| saec_id | int8 | 19 | null |
|
|
||||||
| cpr_nr | varchar | 11 | √ | null |
|
|
|||||
| uddannelse | varchar | 4 | √ | null |
|
|
|||||
| version | varchar | 4 | √ | null |
|
|
|||||
| speciale | varchar | 2 | √ | null |
|
|
|||||
| skoleperiode | varchar | 4 | √ | null |
|
|
|||||
| kombination | varchar | 5 | √ | null |
|
|
|||||
| bidrag | numeric | 9,5 | √ | null |
|
|
|||||
| booking_startdato | timestamp | 22 | √ | null |
|
|
|||||
| booking_slutdato | timestamp | 22 | √ | null |
|
|
|||||
| startdato | timestamp | 22 | √ | null |
|
|
|||||
| slutdato | timestamp | 22 | √ | null |
|
|
|||||
| uddannelsesaftale | varchar | 1 | √ | null |
|
|
|||||
| sae_id | int8 | 19 | √ | null |
|
|
|||||
| opdmod | varchar | 4 | √ | null |
|
|
|||||
| opdinit | varchar | 30 | √ | null |
|
|
|||||
| opdtid | timestamp | 22 | √ | null |
|
|
|||||
| skoleforlob | varchar | 12 | √ | null |
|
|
|||||
| ae_rekvirent | varchar | 4 | √ | null |
|
|
|||||
| afgangsdato | timestamp | 22 | √ | null |
|
|
|||||
| afgangsarsag | varchar | 5 | √ | null |
|
|
|||||
| holdident | varchar | 8 | √ | null |
|
|
|||||
| alt_startdato | timestamp | 22 | √ | null |
|
|
|||||
| alt_slutdato | timestamp | 22 | √ | null |
|
|
|||||
| antal_tirsdage | int4 | 10 | √ | null |
|
|
|||||
| ae_rekvirent_type | varchar | 5 | √ | null |
|
|
|||||
| elevtype | varchar | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| saec_pk | Primary key | Asc | saec_id |
| saec_i | Performance | Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc | uddannelse + version + speciale + skoleperiode + booking_startdato + booking_slutdato + kombination + cpr_nr + sae_id |
| saec_sae_fk_i | Performance | Asc | sae_id |
| saec_saec1_uk | Must be unique | Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc | ae_rekvirent_type + cpr_nr + uddannelse + version + speciale + skoleperiode + kombination + elevtype + booking_startdato + booking_slutdato + ae_rekvirent + saec_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| sae_cpr_check11 | (('SKOLEPERIODE' IS NOT NULL)) |
| sae_cpr_uddannelsesaftale_check | (((uddannelsesaftale)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| sae_cpr_check12 | (('SLUTDATO' IS NOT NULL)) |
| sae_cpr_check16 | (('VERSION' IS NOT NULL)) |
| sae_cpr_check3 | (('BOOKING_SLUTDATO' IS NOT NULL)) |
| sae_cpr_check6 | (('KOMBINATION' IS NOT NULL)) |
| sae_cpr_check4 | (('BOOKING_STARTDATO' IS NOT NULL)) |
| sae_cpr_check1 | (('AE_REKVIRENT_TYPE' IS NOT NULL)) |
| sae_cpr_check10 | (('SAEC_ID' IS NOT NULL)) |
| sae_cpr_check7 | (('OPDINIT' IS NOT NULL)) |
| sae_cpr_check8 | (('OPDMOD' IS NOT NULL)) |
| sae_cpr_check9 | (('OPDTID' IS NOT NULL)) |
| sae_cpr_check | (('AE_REKVIRENT' IS NOT NULL)) |
| sae_cpr_check2 | (('BIDRAG' IS NOT NULL)) |
| sae_cpr_check15 | (('UDDANNELSESAFTALE' IS NOT NULL)) |
| sae_cpr_check14 | (('UDDANNELSE' IS NOT NULL)) |
| sae_cpr_check13 | (('STARTDATO' IS NOT NULL)) |
| sae_cpr_check5 | (('CPR_NR' IS NOT NULL)) |