CREATE DOMAIN dbis_cms.TLehrangebot VARCHAR(30) (
  Default 'Vorlesung',
  CHECK (VALUE IN ('Kursvorlesung','Praktikum','Seminar','Oberseminar'))
);