Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ur_id | int8 | 19 | null |
|
|
||||||
| ugod_id | int8 | 19 | √ | null |
|
|
|||||
| operation | varchar | 1 | √ | null |
|
|
|||||
| skolenr | varchar | 4 | √ | null |
|
|
|||||
| uddannelse | varchar | 4 | √ | null |
|
|
|||||
| version | varchar | 4 | √ | null |
|
|
|||||
| uvm_fag | varchar | 5 | √ | null |
|
|
|||||
| niveau | varchar | 1 | √ | null |
|
|
|||||
| startdato | timestamp | 22 | √ | null |
|
|
|||||
| slutdato | timestamp | 22 | √ | null |
|
|
|||||
| opropdinit | varchar | 30 | √ | null |
|
|
|||||
| opropdmod | varchar | 4 | √ | null |
|
|
|||||
| opropdtid | timestamp | 22 | √ | null |
|
|
|||||
| opdinit | varchar | 30 | √ | null |
|
|
|||||
| opdmod | varchar | 4 | √ | null |
|
|
|||||
| opdtid | timestamp | 22 | √ | null |
|
|
|||||
| godk_type | varchar | 5 | √ | null |
|
|
|||||
| udstedt_af_skole | varchar | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ur_pk | Primary key | Asc | ur_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| udbudsgodkendelser_revspor_check6 | (('UGOD_ID' IS NOT NULL)) |
| udbudsgodkendelser_revspor_check3 | (('OPERATION' IS NOT NULL)) |
| udbudsgodkendelser_revspor_operation_check | (((operation)::text = ANY ((ARRAY['-'::character varying, 'D'::character varying, 'I'::character varying, 'U'::character varying])::text[]))) |
| udbudsgodkendelser_revspor_check1 | (('OPDMOD' IS NOT NULL)) |
| udbudsgodkendelser_revspor_check4 | (('SKOLENR' IS NOT NULL)) |
| udbudsgodkendelser_revspor_check7 | (('UR_ID' IS NOT NULL)) |
| udbudsgodkendelser_revspor_check | (('OPDINIT' IS NOT NULL)) |
| udbudsgodkendelser_revspor_check2 | (('OPDTID' IS NOT NULL)) |
| udbudsgodkendelser_revspor_check5 | (('STARTDATO' IS NOT NULL)) |