Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| handelses_id | int4 | 10 | null |
|
|
|||
| cpr_nr | varchar | 11 | √ | null |
|
|
||
| cosa_formal | varchar | 4 | √ | null |
|
|
||
| ds_afdeling_nr | varchar | 10 | √ | null |
|
|
||
| pabegyndt_uudd | varchar | 50 | √ | null |
|
|
||
| handelses_id_ref | int4 | 10 | √ | null |
|
|
||
| inst_udd_kode | varchar | 10 | √ | null |
|
|
||
| operations_type | varchar | 20 | √ | null |
|
|
||
| studie_start_date | timestamp | 22 | √ | null |
|
|
||
| pabegyndt_fort_uudd | varchar | 1 | √ | null |
|
|
||
| uudd_ophor_kode | numeric | 0 | √ | null |
|
|
||
| uudd_slut_eksamen | timestamp | 22 | √ | null |
|
|
||
| uudd_ophor_exbevis_arsag | int2 | 5 | √ | null |
|
|
||
| uudd_slet_kode | int2 | 5 | √ | null |
|
|
||
| status | varchar | 20 | √ | null |
|
|
||
| ej_indberet | varchar | 50 | √ | null |
|
|
||
| opdinit | varchar | 30 | √ | null |
|
|
||
| opdtid | timestamp | 22 | √ | null |
|
|
||
| opdmod | varchar | 4 | √ | null |
|
|
||
| elis_id | numeric | 0 | √ | null |
|
|
||
| fiktivt_cosa_formal | varchar | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| rpud_pk | Primary key | Asc | handelses_id |
| rpud_cosa_formal_idx | Performance | Asc | cosa_formal |
| rpud_cpr_nr_idx | Performance | Asc | cpr_nr |
| rpud_datacorr | Performance | Asc/Asc/Asc/Asc | opdmod + pabegyndt_fort_uudd + operations_type + status |
| rpud_r102 | Performance | Asc | status |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| reg_pabegyndte_uudd_check9 | (('PABEGYNDT_FORT_UUDD' IS NOT NULL)) |
| reg_pabegyndte_uudd_check | (('COSA_FORMAL' IS NOT NULL)) |
| reg_pabegyndte_uudd_check1 | (('CPR_NR' IS NOT NULL)) |
| reg_pabegyndte_uudd_check6 | (('OPDMOD' IS NOT NULL)) |
| reg_pabegyndte_uudd_check4 | (('HANDELSES_ID_REF' IS NOT NULL)) |
| reg_pabegyndte_uudd_check8 | (('OPERATIONS_TYPE' IS NOT NULL)) |
| reg_pabegyndte_uudd_check3 | (('HANDELSES_ID' IS NOT NULL)) |
| reg_pabegyndte_uudd_check10 | (('STUDIE_START_DATE' IS NOT NULL)) |
| reg_pabegyndte_uudd_check2 | (('DS_AFDELING_NR' IS NOT NULL)) |
| reg_pabegyndte_uudd_check5 | (('OPDINIT' IS NOT NULL)) |
| reg_pabegyndte_uudd_check7 | (('OPDTID' IS NOT NULL)) |