Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| rsr_id | int8 | 19 | null |
|
|
|||
| skfa_skolefag | varchar | 5 | √ | null |
|
|
||
| skfa_niveau | varchar | 1 | √ | null |
|
|
||
| evalueringsform | varchar | 3 | √ | null |
|
|
||
| karaktertype | varchar | 3 | √ | null |
|
|
||
| karakterskala | varchar | 5 | √ | null |
|
|
||
| skfa_vfm_startmaned | varchar | 8 | √ | null |
|
|
||
| skfa_vfm_slutmaned | varchar | 8 | √ | null |
|
|
||
| uvfa_uvm_fag | varchar | 5 | √ | null |
|
|
||
| uvfa_niveau | varchar | 1 | √ | null |
|
|
||
| uvfa_vfm_startmaned | varchar | 8 | √ | null |
|
|
||
| uvfa_vfm_slutmaned | varchar | 8 | √ | null |
|
|
||
| opropdmod | varchar | 4 | √ | null |
|
|
||
| opropdinit | varchar | 30 | √ | null |
|
|
||
| opropdtid | timestamp | 22 | √ | null |
|
|
||
| operation | varchar | 1 | √ | null |
|
|
||
| opdmod | varchar | 4 | √ | null |
|
|
||
| opdinit | varchar | 30 | √ | null |
|
|
||
| opdtid | timestamp | 22 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| rsr_pk | Primary key | Asc | rsr_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| resform_skolefag_revisionsspor_check5 | (('OPDTID' IS NOT NULL)) |
| resform_skolefag_revisionsspor_check9 | (('OPROPDTID' IS NOT NULL)) |
| resform_skolefag_revisionsspor_check11 | (('SKFA_NIVEAU' IS NOT NULL)) |
| resform_skolefag_revisionsspor_check12 | (('SKFA_SKOLEFAG' IS NOT NULL)) |
| resform_skolefag_revisionsspor_check13 | (('SKFA_VFM_STARTMANED' IS NOT NULL)) |
| resform_skolefag_revisionsspor_operation_check | (((operation)::text = ANY ((ARRAY['-'::character varying, 'D'::character varying, 'I'::character varying, 'U'::character varying])::text[]))) |
| resform_skolefag_revisionsspor_check10 | (('RSR_ID' IS NOT NULL)) |
| resform_skolefag_revisionsspor_check8 | (('OPROPDMOD' IS NOT NULL)) |
| resform_skolefag_revisionsspor_check2 | (('KARAKTERTYPE' IS NOT NULL)) |
| resform_skolefag_revisionsspor_check | (('EVALUERINGSFORM' IS NOT NULL)) |
| resform_skolefag_revisionsspor_check4 | (('OPDMOD' IS NOT NULL)) |
| resform_skolefag_revisionsspor_check3 | (('OPDINIT' IS NOT NULL)) |
| resform_skolefag_revisionsspor_check6 | (('OPERATION' IS NOT NULL)) |
| resform_skolefag_revisionsspor_check1 | (('KARAKTERSKALA' IS NOT NULL)) |
| resform_skolefag_revisionsspor_check7 | (('OPROPDINIT' IS NOT NULL)) |