tabling/init.sql at master · rschen7754/tabling · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
USE tabling;

CREATE TABLE providers (
id SERIAL PRIMARY KEY,
name VARCHAR(16),
address VARCHAR(32)
);

CREATE TABLE teams (
id SERIAL PRIMARY KEY,
name VARCHAR(16)
);

CREATE TABLE leaders (
id SERIAL PRIMARY KEY,
first VARCHAR(16),
last VARCHAR(16),
email VARCHAR(32),
cell CHAR(10),
team INTEGER REFERENCES teams(id),
provider INTEGER REFERENCES providers (id)
);

CREATE TABLE days (
id SERIAL PRIMARY KEY,
date DATE,
active BOOLEAN
);

CREATE TABLE shifts (
id SERIAL PRIMARY KEY,
time VARCHAR(20),
location VARCHAR(16),
day INTEGER REFERENCES days (id)
);

CREATE TABLE signups (
id SERIAL PRIMARY KEY,
leader INTEGER REFERENCES leaders (id),
shift INTEGER REFERENCES shifts (id)
);