trimme_oplysninger


Columns

Column Type Size Nulls Auto Default Children Parents Comments
trim_id int8 19 null
trimmeoplysning varchar 40 √ null
central_lokal varchar 1 √ null
trim_type varchar 15 √ null
beskrivelse varchar 2000 √ null
verdi varchar 200 √ null
defaultverdi varchar 200 √ null
taba_id int8 19 √ null
eksamensresultater_ea.id Implied Constraint R
opdmod varchar 4 √ null
opdinit varchar 30 √ null
opdtid timestamp 22 √ null
tredjepart varchar 30 √ null
trim_precision int2 5 √ null
max_lengde int2 5 √ null

Indexes

Constraint Name Type Sort Column(s)
trim_pk Primary key Asc trim_id
trim_tab_1 Performance Asc taba_id
trim_trim1_uk Must be unique Asc trimmeoplysning
trimme_oplysninger_idx Performance Asc trimmeoplysning
trimme_oplysninger_inst_id_idx Performance Asc trimmeoplysning

Check Constraints

Constraint Name Constraint
trimme_oplysninger_check7 (('TRIMMEOPLYSNING' IS NOT NULL))
trimme_oplysninger_check8 (('TRIM_ID' IS NOT NULL))
trimme_oplysninger_check10 (('VERDI' IS NOT NULL))
trimme_oplysninger_check6 (('OPDTID' IS NOT NULL))
trimme_oplysninger_central_lokal_check (((central_lokal)::text = ANY ((ARRAY['C'::character varying, 'L'::character varying, 'T'::character varying])::text[])))
trimme_oplysninger_check5 (('OPDMOD' IS NOT NULL))
trimme_oplysninger_check2 (('DEFAULTVERDI' IS NOT NULL))
trimme_oplysninger_check3 (('MAX_LENGDE' IS NOT NULL))
trimme_oplysninger_check9 (('TRIM_TYPE' IS NOT NULL))
trimme_oplysninger_check (('BESKRIVELSE' IS NOT NULL))
trimme_oplysninger_check1 (('CENTRAL_LOKAL' IS NOT NULL))
trimme_oplysninger_check4 (('OPDINIT' IS NOT NULL))
trimme_oplysninger_trim_type_check (((trim_type)::text = ANY ((ARRAY['NUMBER'::character varying, 'CHAR'::character varying, 'INTEGER'::character varying, 'DATE'::character varying, 'JANEJ'::character varying, 'TABEL VÆRDI'::character varying])::text[])))

Relationships

Close relationships within degrees of separation