Able to delete a person and their associated data by their id.

backend/config/database/schema.sql

@@ -79,7 +79,7 @@ CREATE TABLE IF NOT EXISTS peopleDegree (
     degreeCollege VARCHAR(50),
     degreeYear VARCHAR(16),
     degreeDescription VARCHAR(255),
-    FOREIGN KEY (peopleId) REFERENCES people(peopleId),
+    FOREIGN KEY (peopleId) REFERENCES people(peopleId) ON DELETE CASCADE,
     FOREIGN KEY (degreeTypeId) REFERENCES degreeTypeLookup(degreeTypeId)
 );
 
@@ -92,7 +92,7 @@ CREATE TABLE IF NOT EXISTS peopleXAddress (
     peopleId INT PRIMARY KEY,
     addressId INT UNIQUE,
     preferredAddress VARCHAR(255) NOT NULL,
-    FOREIGN KEY (peopleId) REFERENCES people(peopleId),
+    FOREIGN KEY (peopleId) REFERENCES people(peopleId) ON DELETE CASCADE,
     FOREIGN KEY (addressId) REFERENCES address(addressId)
 );
 
@@ -102,7 +102,7 @@ CREATE TABLE IF NOT EXISTS peopleContact (
     contactNumber VARCHAR(255) NOT NULL,
     contactType VARCHAR(50) NOT NULL, 
     preferredContact BOOLEAN NOT NULL DEFAULT FALSE,
-    FOREIGN KEY (peopleId) REFERENCES people(peopleId)
+    FOREIGN KEY (peopleId) REFERENCES people(peopleId) ON DELETE CASCADE
 );
 
 CREATE TABLE IF NOT EXISTS involvementLookup (
@@ -115,7 +115,7 @@ CREATE TABLE IF NOT EXISTS peopleXInvolvement (
     peopleId INT,
     involvementId INT,
     PRIMARY KEY (peopleId, involvementId),
-    FOREIGN KEY (peopleId) REFERENCES people(peopleId),
+    FOREIGN KEY (peopleId) REFERENCES people(peopleId) ON DELETE CASCADE,
     FOREIGN KEY (involvementId) REFERENCES involvementLookup(involvementId)
 );