cQfiLxBg

1DROP TABLE IF EXISTS volunteer;
2DROP TABLE IF EXISTS person;
3DROP TABLE IF EXISTS activity;
4
5
6CREATE TABLE volunteer (
7        id INT(100) NOT NULL UNIQUE,
8        area_id INT(100) NOT NULL,
9        first_name VARCHAR(100) NOT NULL,
10        last_name VARCHAR(100) NOT NULL,
11        phone_number INT(100) NOT NULL UNIQUE,
12        preferred_activity VARCHAR(100) NOT NULL,
13        time_available TIMESTAMP NOT NULL,
14
15        PRIMARY KEY (id),
16        FOREIGN KEY(area_id) REFERENCES area(id)
17        ON UPDATE CASCADE ON DELETE CASCADE
18);
19
20CREATE TABLE person (
21        id INT(100) NOT NULL UNIQUE,
22        first_name VARCHAR(100) NOT NULL,
23        last_name VARCHAR(100) NOT NULL,
24        phone_number INT(100) NOT NULL UNIQUE,
25        help_needed VARCHAR(100) NOT NULL,
26
27        PRIMARY KEY (id)
28);
29
30CREATE TABLE volunteer_activity (
31        activity_id INT(100) NOT NULL,
32        volunteer_id INT(100) NOT NULL,
33);
34
35CREATE TABLE activity (
36        id INT(100) NOT NULL UNIQUE,
37        volunteer_id INT(100) NOT NULL,
38        area_id INT(100) NOT NULL,
39        last_name VARCHAR(100) NOT NULL,
40        phone_number INT(100) NOT NULL UNIQUE,
41        preferred_activity VARCHAR(100) NOT NULL,
42
43        PRIMARY KEY (id)
44);
45
46CREATE TABLE area (
47        id INT(100) NOT NULL UNIQUE AUTO_INCREMENT,
48        area_name VARCHAR(100) NOT NULL,
49
50        PRIMARY KEY(id)
51);