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`)
);