 
 CREATE TABLE cohort(
 	cohortId INT UNSIGNED AUTO_INCREMENT NOT NULL,
-	cohortName VARCHAR(30) NOT NULL,
+	cohortName VARCHAR(30) NOT NULL UNIQUE,
 	INDEX (cohortId),
 	PRIMARY KEY(cohortId)
 );


CREATE TABLE statusType(
	statusTypeId INT UNSIGNED AUTO_INCREMENT NOT NULL,
	statusTypeName INT UNSIGNED NOT NULL,
	INDEX (statusTypeId),
	PRIMARY KEY (statusTypeId)
);

CREATE TABLE placard(
	placardId INT UNSIGNED AUTO_INCREMENT NOT NULL,
	placardNumber INT UNSIGNED NOT NULL,
	placardStatusTypeId INT UNSIGNED NOT NULL,
	INDEX (placardId),
	INDEX (placardStatusTypeId),


CREATE TABLE swipe(
	swipeId INT UNSIGNED AUTO_INCREMENT NOT NULL,
	swipeNumber INT UNSIGNED NOT NULL UNIQUE,
	swipeStatusTypeId INT UNSIGNED NOT NULL,
	INDEX (swipeId),
	INDEX (swipeStatusTypeId),
