test.sql

DROP TABLE cars;
DROP TABLE people;

CREATE TABLE people (
    id serial PRIMARY KEY,
    fname       varchar(80),
    lname       varchar(80),
    address     varchar(80),
    postcode    varchar(80),
    city        varchar(80),
    phone       varchar(80),
    email       varchar(80),
    UNIQUE(phone)
);

CREATE TABLE cars (
    so_id   int4 NOT NULL,
    make    varchar(80),
    model   varchar(80),
    PRIMARY KEY (so_id),
    FOREIGN KEY (so_id) REFERENCES people(id)
);

INSERT INTO PEOPLE (fname, lname, address, postcode, city, phone, email) VALUES ('Bo', 'Karlsson', 'Furuv. 8', '12388', 'Goteborg', '01055223', '[email protected]');
INSERT INTO cars (so_id, make, model) VALUES ((SELECT id FROM people WHERE phone='01055223'), 'Ferarri', 'F40');