Someone

CREATE DOMAIN dbis_cms.LehrangbT VARCHAR(30)
  DEFAULT "Sonstige"
  CHECK ( VALUE IN ("Kursvorlesung","Praktikum","Seminar","Oberseminar","Projekt","Proseminar","Spezialvorlesung","Sonstige")
);