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)
)
|