CREATE TABLE "Parents" (
	"id" int PRIMARY KEY,
	"cheerldrid" int CONSTRAINT cheerleader_id REFERENCES cheerleader(id),
	"firstname" varchar(255),
	"lastname" varchar(255),
	"email" varchar(255),
	"address1" varchar(255),
	"address2" varchar(255),
	"state" varchar(255),
	"city" varchar(255),
	"zipcode" varchar(255)
);
CREATE TABLE "cheerleader" (
	"id" int PRIMARY KEY,
	"firstname" varchar(255),
	"lastname" varchar(255)
);
CREATE TABLE "team" (
	"name" varchar(255) PRIMARY KEY,
	"season" varchar(255) PRIMARY KEY,
	"color" varchar(255)
);
CREATE TABLE "teamMembers" (
	"teamName" varchar(255) PRIMARY KEY CONSTRAINT team_name REFERENCES team(name),
	"cheerleader" int PRIMARY KEY CONSTRAINT cheerleader_id REFERENCES cheerleader(id)
);