Postgres 9.5

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE cat_accident (
    acc_type VARCHAR(30) NOT NULL,
    acc_descrip VARCHAR(30) NOT NULL 
    CHECK(
      CASE acc_type
        WHEN 'Home accident' THEN acc_descrip IN ('Intoxication', 'burns', 'Kitchen wound')
        WHEN 'Work accident' THEN acc_descrip IN ('freezing', 'electrocution')
      END
    )
);

CREATE TABLE


INSERT INTO cat_accident VALUES 
  ('Home accident', 'Intoxication'),
  ('Home accident', 'burns'),
  ('Home accident', 'Kitchen wound'),
  ('Work accident', 'freezing'),
  ('Work accident', 'electrocution')

INSERT 0 5


INSERT INTO cat_accident VALUES 
  ('Home accident', 'freezing')

ERROR:  new row for relation "cat_accident" violates check constraint "cat_accident_check"
DETAIL:  Failing row contains (Home accident, freezing).


INSERT INTO cat_accident VALUES 
  ('Work accident', 'burns')

ERROR:  new row for relation "cat_accident" violates check constraint "cat_accident_check"
DETAIL:  Failing row contains (Work accident, burns).