CREATE DATABASE genealogie;
USE genealogie;

CREATE TABLE people(
  id INTEGER,
  firstname VARCHAR(128),
  lastname VARCHAR(128),
  birth DATE,
  death DATE,
  citation_id INTEGER,
  father_id INTEGER,
  mother_id INTEGER
);

CREATE TABLE mariage(
  husband_id INTEGER,
  wife_id INTEGER,
  mariage_date DATE
);

