   Description VARCHAR(1000) NOT NULL, 
   Abstract VARCHAR(1000) NOT NULL, 
   PRIMARY KEY(Id), 
-  FOREIGN KEY (status_id) REFERENCES status(Id)
-);
-
-
-CREATE TABLE forms ( 
-  Id INT NOT NULL AUTO_INCREMENT, 
-  Name VARCHAR(250) NOT NULL, 
-  FormPath VARCHAR(1000) NOT NULL, 
-  PRIMARY KEY(Id)
-);
-
-CREATE TABLE status ( 
-  Id INT NOT NULL AUTO_INCREMENT, 
-  Name VARCHAR(100) NOT NULL, 
-  Description VARCHAR(250), 
-  PRIMARY KEY(Id)
+  FOREIGN KEY (status_id) REFERENCES statuses(Id)
 );
 
 CREATE TABLE categories (

CREATE DATABASE MSEF;
USE MSEF;

CREATE TABLE users (
	Id INT NOT NULL AUTO_INCREMENT,
	FirstName VARCHAR(255) NOT NULL,
	LastName VARCHAR(255) NOT NULL,
	PhoneNumber VARCHAR(11) NOT NULL,
	school_id INT NOT NULL,
	Grade VARCHAR(200) NULL,
	ParentFirstName VARCHAR(255) NULL,
	ParentLastName VARCHAR(255) NULL,
	ParentPhoneNumber VARCHAR(255) NULL,
	ParentEmail VARCHAR(500) NULL,
	securityType_id INT NOT NULL,
	Email VARCHAR(500) NOT NULL,
	Password VARCHAR(100) NOT NULL,
	AltPhoneNumber VARCHAR(11) NULL,
	Position VARCHAR(255) NULL,
	City VARCHAR(255) NULL,
	State VARCHAR(255) NULL,
	Address1 VARCHAR(255) NULL,
	Address2 VARCHAR(255) NULL,
	Zip VARCHAR(11) NULL,
	PRIMARY KEY(Id),
	FOREIGN KEY (school_id) REFERENCES schools(Id),
	FOREIGN KEY (securityType_id) REFERENCES securityTypes(Id)
);

CREATE TABLE projects (

  Id INT NOT NULL AUTO_INCREMENT,
  Keyword VARCHAR(250) NOT NULL,
  PRIMARY KEY(Id)
);

CREATE TABLE formKeywords (
