lokale_bevislinjer


Columns

Column Type Size Nulls Auto Default Children Parents Comments
lobe_id int8 19 null
bevisformat varchar 2 √ null
startdato timestamp 22 √ null
nr int4 10 √ null
bevislinje varchar 240 √ null
opdinit varchar 30 √ null
opdmod varchar 4 √ null
opdtid timestamp 22 √ null
skfa_id int8 19 √ null
skolefag.skfa_id lb_skfa_fk R

Indexes

Constraint Name Type Sort Column(s)
lb_pk Primary key Asc lobe_id
lb_skfa_fk_i Performance Asc skfa_id
lb_uk Must be unique Asc/Asc/Asc/Asc skfa_id + bevisformat + startdato + nr

Check Constraints

Constraint Name Constraint
lokale_bevislinjer_check5 (('OPDMOD' IS NOT NULL))
lokale_bevislinjer_check2 (('LOBE_ID' IS NOT NULL))
lokale_bevislinjer_check1 (('BEVISLINJE' IS NOT NULL))
lokale_bevislinjer_check7 (('SKFA_ID' IS NOT NULL))
lokale_bevislinjer_check8 (('STARTDATO' IS NOT NULL))
lokale_bevislinjer_bevisformat_check (((bevisformat)::text = ANY ((ARRAY['A4'::character varying, 'A6'::character varying])::text[])))
lokale_bevislinjer_check3 (('NR' IS NOT NULL))
lokale_bevislinjer_check (('BEVISFORMAT' IS NOT NULL))
lokale_bevislinjer_check4 (('OPDINIT' IS NOT NULL))
lokale_bevislinjer_check6 (('OPDTID' IS NOT NULL))

Relationships

Close relationships within degrees of separation