create table guest (
    id serial PRIMARY KEY,
    first_name varchar(64),
    last_name varchar(64),
    attendance varchar(8) DEFAULT 'no' NOT NULL,
    email varchar(64),
    message varchar(128),
    party_size integer
);

create table party (
    guest_id integer NOT NULL references guest(id) ON DELETE CASCADE,
    first_name varchar(64),
    last_name varchar(64)
);