karakter_revisionsspor


Columns

Column Type Size Nulls Auto Default Children Parents Comments
kars_id int8 19 null
termin varchar 8 √ null
elev_cpr_nr varchar 11 √ null
cosa_formal varchar 4 √ null
versionsnummer varchar 4 √ null
skolefag varchar 5 √ null
niveau varchar 1 √ null
karakterskala varchar 5 √ null
karaktertype varchar 3 √ null
proveform varchar 3 √ null
skolenr varchar 4 √ null
frigivet varchar 1 √ null
kara_id int8 19 √ null
karakterverdi varchar 2 √ null
evaluering varchar 2000 √ null
merittekst varchar 100 √ null
aktivitet varchar 12 √ null
frigiv_medarbejder_cpr_nr varchar 11 √ null
fritaget_eksamen varchar 1 √ null
fritaget_undervisning varchar 1 √ null
opr_opdatinit varchar 30 √ null
opr_opdattid timestamp 22 √ null
opr_opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
opdmod varchar 4 √ null
elevplan_karakterlistenr int8 19 √ null
operation varchar 1 √ null
oprettet_i_elevplan varchar 1 √ null
fagtilknytning varchar 1 √ null
offentliggorelsesdato timestamp 22 √ null

Indexes

Constraint Name Type Sort Column(s)
kars_pk Primary key Asc kars_id
kars_elev_cpr_nr_cosa_formal_idx Performance Asc/Asc elev_cpr_nr + cosa_formal

Check Constraints

Constraint Name Constraint
karakter_revisionsspor_fritaget_eksamen_check (((fritaget_eksamen)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
karakter_revisionsspor_check10 (('OPERATION' IS NOT NULL))
karakter_revisionsspor_check7 (('OPDINIT' IS NOT NULL))
karakter_revisionsspor_check11 (('OPR_OPDATINIT' IS NOT NULL))
karakter_revisionsspor_check17 (('VERSIONSNUMMER' IS NOT NULL))
karakter_revisionsspor_check12 (('OPR_OPDATTID' IS NOT NULL))
karakter_revisionsspor_operation_check (((operation)::text = ANY ((ARRAY['-'::character varying, 'D'::character varying, 'I'::character varying, 'U'::character varying])::text[])))
karakter_revisionsspor_fritaget_undervisning_check (((fritaget_undervisning)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
karakter_revisionsspor_check16 (('TERMIN' IS NOT NULL))
karakter_revisionsspor_check8 (('OPDMOD' IS NOT NULL))
karakter_revisionsspor_check3 (('KARAKTERSKALA' IS NOT NULL))
karakter_revisionsspor_check5 (('KARS_ID' IS NOT NULL))
karakter_revisionsspor_check14 (('SKOLEFAG' IS NOT NULL))
karakter_revisionsspor_check4 (('KARAKTERTYPE' IS NOT NULL))
karakter_revisionsspor_check2 (('FRIGIVET' IS NOT NULL))
karakter_revisionsspor_check1 (('ELEV_CPR_NR' IS NOT NULL))
karakter_revisionsspor_frigivet_check (((frigivet)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
karakter_revisionsspor_check (('COSA_FORMAL' IS NOT NULL))
karakter_revisionsspor_check15 (('SKOLENR' IS NOT NULL))
karakter_revisionsspor_fagtilknytning_check (((fagtilknytning)::text = ANY ((ARRAY['E'::character varying, 'I'::character varying, 'L'::character varying, 'O'::character varying, 'P'::character varying, 'S'::character varying, 'T'::character varying, 'V'::character varying])::text[])))
karakter_revisionsspor_check9 (('OPDTID' IS NOT NULL))
karakter_revisionsspor_oprettet_i_elevplan_check (((oprettet_i_elevplan)::text = ANY ((ARRAY['J'::character varying, 'N'::character varying])::text[])))
karakter_revisionsspor_check13 (('PROVEFORM' IS NOT NULL))
karakter_revisionsspor_check6 (('NIVEAU' IS NOT NULL))

Relationships

Close relationships within degrees of separation