 	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,

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

CREATE TABLE studentPermit(

DROP TABLE IF EXISTS note;
DROP TABLE IF EXISTS prospect;
DROP TABLE IF EXISTS prospectCohort;
DROP TABLE IF EXISTS studentPermit;
DROP TABLE IF EXISTS application;
DROP TABLE IF EXISTS applicationCohort;
DROP TABLE IF EXISTS swipe;
DROP TABLE IF EXISTS placard;
DROP TABLE IF EXISTS statusType;
