studbase=# \d persons
       Tabell «public.persons»
  Kolonne  |  Type   | Modifikatorer 
-----------+---------+---------------
 fnr       | integer | not null
 pnr       | integer | not null
 firstname | text    | not null
 surname   | text    | not null
Indekser:
    «fnrpnr» PRIMARY KEY, btree (fnr, pnr)

studbase=# \d students
        Tabell «public.students»
   Kolonne    |  Type   | Modifikatorer 
--------------+---------+---------------
 fnr          | integer | not null
 pnr          | integer | not null
 hionr        | integer | not null
 studyprogram | text    | not null
Indekser:
    «students_pkey» PRIMARY KEY, btree (fnr, pnr)
    «students_hionr_key» UNIQUE, btree (hionr)
Fremmednøkkeltvangstrøyer (constraints):
    «students_fnr_fkey» FOREIGN KEY (fnr, pnr) REFERENCES persons(fnr, pnr) ON UPDATE CASCADE ON DELETE CASCADE
    «students_studyprogram_fkey» FOREIGN KEY (studyprogram) REFERENCES studyprograms(acronym) ON UPDATE CASCADE ON DELETE CASCADE