server/schema.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

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 guests(id) ON DELETE CASCADE,
    first_name varchar(64),
    last_name varchar(64)
);