 	FOREIGN KEY(swipeStatusTypeId) REFERENCES statusType(statusTypeId)
 );
 
-CREATE TABLE application(
-	applicationId INT UNSIGNED AUTO_INCREMENT NOT NULL,
-	applicationFirstName VARCHAR(40) NOT NULL,
-	applicationLastName VARCHAR(40) NOT NULL,
-	applicationEmail VARCHAR(100) NOT NULL,
-	applicationPhoneNumber VARCHAR(30) NOT NULL,
-	applicationSource VARCHAR(200) NOT NULL,
-	applicationCohortId INT UNSIGNED NOT NULL,
-	applicationAboutYou VARCHAR(2000) NOT NULL,
-	applicationHopeToAccomplish VARCHAR(2000) NOT NULL,
-	applicationExperience VARCHAR(2000) NOT NULL,
-	applicationDateTime TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
-	applicationUtmCampaign VARCHAR(500) NOT NULL,
-	applicationUtmMedium VARCHAR(500) NOT NULL,
-	applicationUtmSource VARCHAR(500) NOT NULL,
-	INDEX (applicationId),
-	PRIMARY KEY(applicationId),
-	FOREIGN KEY(applicationCohortId) REFERENCES cohort (cohortId)
-);
-
 CREATE TABLE applicationCohort(
 	applicationCohortId INT UNSIGNED AUTO_INCREMENT NOT NULL,
 	applicationCohortApplicationId INT UNSIGNED NOT NULL,

	FOREIGN KEY(studentPermitPlacardId) REFERENCES placard(placardId)
);

CREATE TABLE prospect(
	prospectId INT UNSIGNED AUTO_INCREMENT NOT NULL,
	prospectFirstName VARCHAR(40) NOT NULL,
	prospectLastName VARCHAR(40) NOT NULL,
	prospectEmail VARCHAR(100) NOT NULL,
	prospectPhoneNumber VARCHAR(30) NOT NULL,
	prospectCohortId INT UNSIGNED NOT NULL,
	INDEX (prospectId),
	PRIMARY KEY(prospectId),
	FOREIGN KEY(prospectCohortId) REFERENCES cohort(cohortId)
);

CREATE TABLE prospectCohort(
	prospectCohortId INT UNSIGNED AUTO_INCREMENT NOT NULL,
	prospectCohortApplicationId INT UNSIGNED NOT NULL,
	prospectCohortCohortId INT UNSIGNED NOT NULL,
	INDEX (prospectCohortId),
	PRIMARY KEY (prospectCohortId),
	FOREIGN KEY(prospectCohortApplicationId) REFERENCES prospect(prospectId),
	FOREIGN KEY(prospectCohortCohortId) REFERENCES cohort(cohortId)
);

CREATE TABLE note(

	PRIMARY KEY (applicationCohortId),
	FOREIGN KEY(applicationCohortApplicationId) REFERENCES application(applicationId),
	FOREIGN KEY(applicationCohortCohortId) REFERENCES cohort(cohortId)
);

CREATE TABLE application(
applicationId INT UNSIGNED AUTO_INCREMENT NOT NULL,
applicationFirstName VARCHAR(40) NOT NULL,
applicationLastName VARCHAR(40) NOT NULL,
applicationEmail VARCHAR(100) NOT NULL,
applicationPhoneNumber VARCHAR(30) NOT NULL,
applicationSource VARCHAR(200) NOT NULL,
applicationCohortId INT UNSIGNED NOT NULL,
applicationAboutYou VARCHAR(2000) NOT NULL,
applicationHopeToAccomplish VARCHAR(2000) NOT NULL,
applicationExperience VARCHAR(2000) NOT NULL,
applicationDateTime TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
applicationUtmCampaign VARCHAR(500) NOT NULL,
applicationUtmMedium VARCHAR(500) NOT NULL,
applicationUtmSource VARCHAR(500) NOT NULL,
INDEX (applicationId),
PRIMARY KEY(applicationId),
FOREIGN KEY(applicationCohortId) REFERENCES applicationCohort (applicationCohortCohortId)
);

CREATE TABLE studentPermit(
