summaryrefslogtreecommitdiff
path: root/server/schema.sql
blob: 44881c81572df24d9ad87a4d29d4941c8572e662 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
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)
)