CREATE TABLE "Parents" (
	"id" int PRIMARY KEY,
	"cheerldrid" int,
	"firstname" varchar(255),
	"lastname" varchar(255),
	"email" varchar(255),
	"address1" varchar(255),
	"address2" varchar(255),
	"state" varchar(255),
	"city" varchar(255),
	"zipcode" varchar(255),
	FOREIGN KEY("cheerldrid") REFERENCES "cheerleader" ("id")
);
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,
	"cheerleader" int PRIMARY KEY,
	FOREIGN KEY("teamName") REFERENCES "team" ("name"),
	FOREIGN KEY("cheerleader") REFERENCES "cheerleader" ("id")
);