create table guest (
    id uuid primary key default gen_random_uuid(),
    first_name varchar(64),
    last_name varchar(64),
    attendance varchar(8) not null,
    email varchar(64),
    message varchar(128),
    party_size integer
);

create table party (
    guest_id uuid not null references guest(id) on delete cascade,
    first_name varchar(64),
    last_name varchar(64)
);

create table admin (
    id uuid primary key default gen_random_uuid(),
    username varchar(64),
    password varchar(64)
)