Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| frir_id | int8 | 19 | null |
|
|
|||
| frit_id | int8 | 19 | √ | null |
|
|
||
| elev_cpr_nr | varchar | 11 | √ | null |
|
|
||
| cosa_formal | varchar | 4 | √ | null |
|
|
||
| versionsnummer | varchar | 4 | √ | null |
|
|
||
| skolefag | varchar | 5 | √ | null |
|
|
||
| niveau | varchar | 1 | √ | null |
|
|
||
| undervisning | varchar | 1 | √ | null |
|
|
||
| eksamen | varchar | 1 | √ | null |
|
|
||
| bevistekst | varchar | 50 | √ | null |
|
|
||
| godk_medarbejder_cpr_nr | varchar | 11 | √ | null |
|
|
||
| opr_opdattid | timestamp | 22 | √ | null |
|
|
||
| opr_opdatinit | varchar | 30 | √ | null |
|
|
||
| opr_opdmod | varchar | 4 | √ | null |
|
|
||
| opdinit | varchar | 30 | √ | null |
|
|
||
| opdtid | timestamp | 22 | √ | null |
|
|
||
| opdmod | varchar | 4 | √ | null |
|
|
||
| operation | varchar | 1 | √ | null |
|
|
||
| godskrivningstekst | varchar | 100 | √ | null |
|
|
||
| initialer | varchar | 5 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| frir_pk | Primary key | Asc | frir_id |
| frir_elev_cpr_nr_cosa_formal_idx | Performance | Asc/Asc | elev_cpr_nr + cosa_formal |
| frir_elev_cpr_nr_idx | Performance | Asc | elev_cpr_nr |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| fritagelse_revisionsspor_check8 | (('OPERATION' IS NOT NULL)) |
| fritagelse_revisionsspor_eksamen_check | (((eksamen)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| fritagelse_revisionsspor_check2 | (('ELEV_CPR_NR' IS NOT NULL)) |
| fritagelse_revisionsspor_check4 | (('NIVEAU' IS NOT NULL)) |
| fritagelse_revisionsspor_operation_check | (((operation)::text = ANY ((ARRAY['-'::character varying, 'D'::character varying, 'I'::character varying, 'U'::character varying])::text[]))) |
| fritagelse_revisionsspor_bevistekst_check | (((bevistekst)::text = ANY ((ARRAY['Fritaget'::character varying, 'Godskrivning'::character varying, 'Merit uden karakteroverførsel'::character varying, 'Merit'::character varying])::text[]))) |
| fritagelse_revisionsspor_check | (('COSA_FORMAL' IS NOT NULL)) |
| fritagelse_revisionsspor_check12 | (('UNDERVISNING' IS NOT NULL)) |
| fritagelse_revisionsspor_check11 | (('SKOLEFAG' IS NOT NULL)) |
| fritagelse_revisionsspor_check3 | (('FRIR_ID' IS NOT NULL)) |
| fritagelse_revisionsspor_check7 | (('OPDTID' IS NOT NULL)) |
| fritagelse_revisionsspor_check13 | (('VERSIONSNUMMER' IS NOT NULL)) |
| fritagelse_revisionsspor_undervisning_check | (((undervisning)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[]))) |
| fritagelse_revisionsspor_check5 | (('OPDINIT' IS NOT NULL)) |
| fritagelse_revisionsspor_check1 | (('EKSAMEN' IS NOT NULL)) |
| fritagelse_revisionsspor_check10 | (('OPR_OPDATTID' IS NOT NULL)) |
| fritagelse_revisionsspor_check6 | (('OPDMOD' IS NOT NULL)) |
| fritagelse_revisionsspor_check9 | (('OPR_OPDATINIT' IS NOT NULL)) |