DROP TABLE IF EXISTS eltern CASCADE;

CREATE TABLE eltern
( kind  VARCHAR NOT NULL,
  elter VARCHAR NOT NULL,

  PRIMARY KEY (kind, elter)
);


DELETE FROM eltern;

INSERT INTO eltern(kind, elter)
VALUES
('Ja', 'Si'), ('Ol', 'Si'),  ('Li', 'So'), ('La', 'So'),
('Si', 'Ma'), ('So', 'Ma'),  ('Ve', 'Ma'),
('Si', 'Wo'), ('So', 'Wo'),  ('Ve', 'Wo'),
('Ma', 'Fr'), ('Ma', 'JaS'), 
('Fr', 'Th'),
('Wo','Il'), ('Wo','Ka'),
('Il','Ro'), ('Ka', 'Cä')
;


DELETE FROM eltern;

INSERT INTO eltern(kind, elter)
VALUES
('Ol', 'Si'), ('Li', 'So'),
('Si', 'Ma'), ('So', 'Ma'), 
('Ma', 'Fr'),
('Fr', 'Th')
;