\c family

DROP TABLE IF EXISTS family;
DROP TABLE IF EXISTS people;

CREATE TABLE family8 (
    family_id INTEGER PRIMARY KEY,
    family_name VARCHAR(255),
    description VARCHAR(255),
    town VARCHAR(255)
);

CREATE TABLE people8 (
    person_id INTEGER PRIMARY KEY,
    family_id INTEGER,
    first_name VARCHAR(255),
    last_name VARCHAR(255),
    birth_year INTEGER,
    family_name VARCHAR(255),
    relation VARCHAR(255),
    CONSTRAINT fk_family
        FOREIGN KEY (family_id)
            REFERENCES family8 (family_id)
);