SwimmingDDL.txt

###ADDED EMAIL ATTRIBUTE TO THE USERS TABLE AND SPLIT TIMES FOR THE EVENTS
###ALSO ADDED ORDER OF SWIM IN THE SWIMMEREVENTS TABLES TO KEEP TRACK OF THE SWIMERS IN RELAYS
###NEED TO ADD AUTO INCREMENTS AND CHANGE NAMES OF VARIABLES SO THEY ARE UNIQUE

CREATE DATABASE swimming;

CREATE TABLE Users
(
	UID int NOT NULL AUTO_INCREMENT,
	Username varchar (30),
	Password char (60),
	Email varchar (254),
	PRIMARY KEY (UID)
);

CREATE TABLE Team
(
	TeamID int NOT NULL AUTO_INCREMENT,
	Name varchar (30),
	HeadCoach int,
	CONSTRAINT HeadCoach_fk FOREIGN KEY (HeadCoach) REFERENCES Users (UID),
	PRIMARY KEY (TeamID)
);

##############################################Swimmers
CREATE TABLE Swimmers
(
	SNID int NOT NULL AUTO_INCREMENT,
	SFName varchar (30),
	SLName varchar (30),
	age int,
	year varchar(20),
	PRIMARY KEY (SNID)
);

CREATE TABLE SwimmerTeams
(
	STTeamID int,
	STSNID int,
	CONSTRAINT STTeamID_fk FOREIGN KEY (STTeamID) REFERENCES Team (TeamID),
	CONSTRAINT STSNID_fk FOREIGN KEY (STSNID) REFERENCES Swimmers (SNID),
	Primary Key (STTeamID, STSNID)
);

##############################################Meets
CREATE TABLE Meets
(
	MeetID int NOT NULL AUTO_INCREMENT,
	Date date,
	MName varchar (30),
	PRIMARY KEY (MeetID)
);

##PROBLEM WAS HERE BEFORE CHANGING THE NAMES OF VARIABLES
##PROBLEM SEEMS TO BE FIXED AFTER CHANGEING NAMES 7/28/16
CREATE TABLE TeamMeets
(
	TMTeamID int,
	TMMeetID int,
	CONSTRAINT TMTeamID_fk FOREIGN KEY (TMTeamID) REFERENCES Team (TeamID),
	CONSTRAINT TMMeetID_fk FOREIGN KEY (TMMeetID) REFERENCES Meets (MeetID),
	Primary Key (TMTeamID, TMMeetID)
);

##############################################Highschool Events
CREATE TABLE 50Free
(
	50FreeEventID int NOT NULL AUTO_INCREMENT,
	Time int,
	DQ boolean,
	Reason varchar (100),
	Lane int,
	Comment varchar (100),
	Name varchar (20),
	PRIMARY KEY (50FreeEventID)
);

CREATE TABLE 100Free
(
	100FreeEventID int NOT NULL AUTO_INCREMENT,
	Time int,
	SplitTime50 int,
	SplitTime100 int,
	DQ boolean,
	Reason varchar (100),
	Lane int,
	Comment varchar (100),
	Name varchar (20),
	PRIMARY KEY (100FreeEventID)
);

CREATE TABLE 200Free
(
	200FreeEventID int NOT NULL AUTO_INCREMENT,
	Time int,
	SplitTime50 int,
	SplitTime100 int,
	SplitTime150 int,
	SplitTime200 int,
	DQ boolean,
	Reason varchar (100),
	Lane int,
	Comment varchar (100),
	Name varchar (20),
	Primary Key (200FreeEventID)
);

CREATE TABLE 500Free
(
	500FreeEventID int NOT NULL AUTO_INCREMENT,
	Time int,
	SplitTime50 int,
	SplitTime100 int,
	SplitTime150 int,
	SplitTime200 int,
	SplitTime250 int,
	SplitTime300 int,
	SplitTime350 int,
	SplitTime400 int,
	SpiitTime450 int,
	SplitTime500 int,
	DQ boolean,
	Reason varchar (100),
	Lane int,
	Comment varchar (100),
	Name varchar (20),
	PRIMARY KEY (500FreeEventID)
);

CREATE TABLE 100Fly
(
	100FlyEventID int NOT NULL AUTO_INCREMENT,
	Time int,
	SplitTime50 int,
	SplitTime100 int,
	DQ boolean,
	Reason varchar (100),
	Lane int,
	Comment varchar (100),
	Name varchar (20),
	PRIMARY KEY (100FlyEventID)
);

CREATE TABLE 100Breast
(
	100BreastEventID int NOT NULL AUTO_INCREMENT,
	Time int,
	SplitTime50 int,
	SplitTime100 int,
	DQ boolean,
	Reason varchar (100),
	Lane int,
	Comment varchar (100),
	Name varchar (20),
	PRIMARY KEY (100BreastEventID)
);

CREATE TABLE 100Back
(
	100BackEventID int NOT NULL AUTO_INCREMENT,
	Time int,
	SplitTime50 int,
	SplitTime100 int,
	DQ boolean,
	Reason varchar (100),
	Lane int,
	Comment varchar (100),
	Name varchar (20),
	PRIMARY KEY (100BackEventID)
);

CREATE TABLE 200FreeRelay
(
	200FreeRelayEventID int NOT NULL AUTO_INCREMENT,
	Time int,
	FirstPersonTime50 int,
	SecondPersonTime100 int,
	ThirdTime150 int,
	FourthTime200 int,
	DQ boolean,
	Reason varchar (100),
	Lane int,
	Comment varchar (100),
	Name varchar (20),
	PRIMARY KEY (200FreeRelayEventID)
);

CREATE TABLE 400FreeRelay
(
	400FreeRelayEventID int NOT NULL AUTO_INCREMENT,
	Time int,
	FirstPersonTime50 int,
	FirstPersonTime100 int,
	SecondTime150 int,
	SecondTime200 int,
	ThirdTime250 int,
	ThirdTime300 int,
	FourthTime350 int,
	FourthTime400 int,
	DQ boolean,
	Reason varchar (100),
	Lane int,
	Comment varchar (100),
	Name varchar (20),
	PRIMARY KEY (400FreeRelayEventID)
);

CREATE TABLE 200IM
(
	200IMEventID int NOT NULL AUTO_INCREMENT,
	Time int,
	ButterTime int,
	BackTime int,
	BrestTime int,
	FreeTime int,
	DQ boolean,
	Reason varchar (100),
	Lane int,
	Comment varchar (100),
	Name varchar (20),
	PRIMARY KEY (200IMEventID)
);

CREATE TABLE 200IMRelay
(
	200IMRelayEventID int NOT NULL AUTO_INCREMENT,
	Time int,
	ButterTime int,
	BackTime int,
	BrestTime int,
	FreeTime int,
	DQ boolean,
	Reason varchar (100),
	Lane int,
	Comment varchar (100),
	Name varchar (20),
	PRIMARY KEY (200IMRelayEventID)
);

##############################################RecEvents

CREATE TABLE 25Free
(
	25FreeEventID int NOT NULL AUTO_INCREMENT,
	Time int,
	DQ boolean,
	Reason varchar (100),
	Lane int,
	Comment varchar (100),
	Name varchar (20),
	PRIMARY KEY (25FreeEventID)
);

CREATE TABLE 25Fly
(
	25FlyEventID int NOT NULL AUTO_INCREMENT,
	Time int,
	DQ boolean,
	Reason varchar (100),
	Lane int,
	Comment varchar (100),
	Name varchar (20),
	PRIMARY KEY (25FlyEventID)
);

CREATE TABLE 25Back
(
	25BackEventID int NOT NULL AUTO_INCREMENT,
	Time int,
	DQ boolean,
	Reason varchar (100),
	Lane int,
	Comment varchar (100),
	Name varchar (20),
	PRIMARY KEY (25BackEventID)
);

CREATE TABLE 25Breast
(
	25BreastEventID int NOT NULL AUTO_INCREMENT,
	Time int,
	DQ boolean,
	Reason varchar (100),
	Lane int,
	Comment varchar (100),
	Name varchar (20),
	PRIMARY KEY (25BreastEventID)
);

CREATE TABLE 100FreeRelay
(
	100FreeRelayEventID int NOT NULL AUTO_INCREMENT,
	Time int,
	FirstPersonTime25 int,
	SecondPersonTime50 int,
	ThirdPersonTime75 int,
	FourthPersonTime100 int,
	DQ boolean,
	Reason varchar (100),
	Lane int,
	Comment varchar (100),
	Name varchar (20),
	PRIMARY KEY (100FreeRelayEventID)

);

CREATE TABLE 100IM
(
	100IMEventID int NOT NULL AUTO_INCREMENT,
	Time int,
	ButterTime int,
	BackTime int,
	BrestTime int,
	FreeTime int,
	DQ boolean,
	Reason varchar (100),
	Lane int,
	Comment varchar (100),
	Name varchar (20),
	PRIMARY KEY (100IMEventID)
);

##############################################SwimmerEvents
##FIX THIS CANT CREATE TABLE BECAUSE FROEIGN KEY INCORRECTLY FORMED
##NEED TO CHANGE Swimmer to Swimmers (add s)

CREATE TABLE 50FreeSwimmers
(
	50FreeSID int,
	50FreeSwims int,
	Primary Key (50FreeSID, 50FreeSwims),
	CONSTRAINT 50FreeSID_fk FOREIGN KEY (50FreeSID) REFERENCES Swimmers (SNID),
	CONSTRAINT 50FreeSwims_fk FOREIGN KEY (50FreeSwims) REFERENCES 50Free (50FreeEventID)
);

CREATE TABLE 100FreeSwimmers
(
	100FreeSID int,
	100FreeSwims int,
	Primary Key (100FreeSID, 100FreeSwims),
	CONSTRAINT 100FreeSID_fk FOREIGN KEY (100FreeSID) REFERENCES Swimmers (SNID),
	CONSTRAINT 100FreeSwims_fk FOREIGN KEY (100FreeSwims) REFERENCES 100Free (100FreeEventID)
);

CREATE TABLE 200FreeSwimmers
(
	200FreeSID int,
	200FreeSwims int,
	Primary Key (200FreeSID, 200FreeSwims),
	CONSTRAINT 200FreeSID_fk FOREIGN KEY (200FreeSID) REFERENCES Swimmers (SNID),
	CONSTRAINT 200FreeSwims_fk FOREIGN KEY (200FreeSwims) REFERENCES 200Free (200FreeEventID)
);

CREATE TABLE 500FreeSwimmers
(
	500FreeSID int,
	500FreeSwims int,
	Primary Key (500FreeSID, 500FreeSwims),
	CONSTRAINT 500FreeSID_fk FOREIGN KEY (500FreeSID) REFERENCES Swimmers (SNID),
	CONSTRAINT 500FreeSwims_fk FOREIGN KEY (500FreeSwims) REFERENCES 500Free (500FreeEventID)
);

CREATE TABLE 100FlySwimmers
(
	100FlySID int,
	100FlySwims int,
	Primary Key (100FlySID, 100FlySwims),
	CONSTRAINT 100FlySID_fk FOREIGN KEY (100FlySID) REFERENCES Swimmers (SNID),
	CONSTRAINT 100FlySwims_fk FOREIGN KEY (100FlySwims) REFERENCES 100Fly (100FlyEventID)
);

CREATE TABLE 100BreastSwimmers
(
	100BreastSID int,
	100BreastSwims int,
	Primary Key (100BreastSID, 100BreastSwims),
	CONSTRAINT 100BreastSID_fk FOREIGN KEY (100BreastSID) REFERENCES Swimmers (SNID),
	CONSTRAINT 100BreastSwims_fk FOREIGN KEY (100BreastSwims) REFERENCES 100Breast (100BreastEventID)
);

CREATE TABLE 100BackSwimmers
(
	100BackSID int,
	100BackSwims int,
	Primary Key (100BackSID, 100BackSwims),
	CONSTRAINT 100BackSID_fk FOREIGN KEY (100BackSID) REFERENCES Swimmers (SNID),
	CONSTRAINT 100BackSwims_fk FOREIGN KEY (100BackSwims) REFERENCES 100Back (100BackEventID)
);

CREATE TABLE 200FreeRelaySwimmers
(
	First200FreeRelaySID int,
	Second200FreeRelaySID int,
	Third200FreeRelaySID int,
	Fourth200FreeRelaySID int,
	200FreeRelaySwims int,
	SwimmerOrder int,
	Primary Key (First200FreeRelaySID, Second200FreeRelaySID, Third200FreeRelaySID, Fourth200FreeRelaySID, 200FreeRelaySwims),
	CONSTRAINT First200FreeRelaySID_fk FOREIGN KEY (First200FreeRelaySID) REFERENCES Swimmers (SNID),
	CONSTRAINT Second200FreeRelaySID_fk FOREIGN KEY (Second200FreeRelaySID) REFERENCES Swimmers (SNID),
	CONSTRAINT Third200FreeRelaySID_fk FOREIGN KEY (Third200FreeRelaySID) REFERENCES Swimmers (SNID),
	CONSTRAINT Fourth200FreeRelaySID_fk FOREIGN KEY (Fourth200FreeRelaySID) REFERENCES Swimmers (SNID),
	CONSTRAINT 200FreeRelaySwims_fk FOREIGN KEY (200FreeRelaySwims) REFERENCES 200FreeRelay (200FreeRelayEventID)
);

CREATE TABLE 400FreeRelaySwimmers
(
	First400FreeRelaySID int,
	Second400FreeRelaySID int,
	Third400FreeRelaySID int,
	Fourth400FreeRelaySID int,
	400FreeRelaySwims int,
	SwimmerOrder int,
	Primary Key (First400FreeRelaySID, Second400FreeRelaySID, Third400FreeRelaySID, Fourth400FreeRelaySID, 400FreeRelaySwims),
	CONSTRAINT First400FreeRelaySID_fk FOREIGN KEY (First400FreeRelaySID) REFERENCES Swimmers (SNID),
	CONSTRAINT Second400FreeRelaySID_fk FOREIGN KEY (Second400FreeRelaySID) REFERENCES Swimmers (SNID),
	CONSTRAINT Third400FreeRelaySID_fk FOREIGN KEY (Third400FreeRelaySID) REFERENCES Swimmers (SNID),
	CONSTRAINT Fourth400FreeRelaySID_fk FOREIGN KEY (Fourth400FreeRelaySID) REFERENCES Swimmers (SNID),
	CONSTRAINT 400FreeRelaySwims_fk FOREIGN KEY (400FreeRelaySwims) REFERENCES 400FreeRelay (400FreeRelayEventID)
);

CREATE TABLE 200IMSwimmers
(
	200IMSID int,
	200IMSwims int,
	Primary Key (200IMSID, 200IMSwims),
	CONSTRAINT 200IMSID_fk FOREIGN KEY (200IMSID) REFERENCES Swimmers (SNID),
	CONSTRAINT 200IMSwims_fk FOREIGN KEY (200IMSwims) REFERENCES 200IM (200IMEventID)
);

CREATE TABLE 200IMRelaySwimmers
(
	First200IMRelaySID int,
	Second200IMRelaySID int,
	Third200IMRelaySID int,
	Fourth200IMRelaySID int,
	200IMRelaySwims int,
	SwimmerOrder int,
	Primary Key (First200IMRelaySID, Second200IMRelaySID, Third200IMRelaySID, Fourth200IMRelaySID, 200IMRelaySwims),
	CONSTRAINT First200IMRelaySID_fk FOREIGN KEY (First200IMRelaySID) REFERENCES Swimmers (SNID),
	CONSTRAINT Second200IMRelaySID_fk FOREIGN KEY (Second200IMRelaySID) REFERENCES Swimmers (SNID),
	CONSTRAINT Third200IMRelaySID_fk FOREIGN KEY (Third200IMRelaySID) REFERENCES Swimmers (SNID),
	CONSTRAINT Fourth200IMRelaySID_fk FOREIGN KEY (Fourth200IMRelaySID) REFERENCES Swimmers (SNID),
	CONSTRAINT 200IMRelaySwims_fk FOREIGN KEY (200IMRelaySwims) REFERENCES 200IMRelay (200IMRelayEventID)
);

CREATE TABLE 25FreeSwimmers
(
	25FreeSID int,
	25FreeSwims int,
	Primary Key (25FreeSID, 25FreeSwims),
	CONSTRAINT 25FreeSID_fk FOREIGN KEY (25FreeSID) REFERENCES Swimmers (SNID),
	CONSTRAINT 25FreeSwims_fk FOREIGN KEY (25FreeSwims) REFERENCES 25Free (25FreeEventID)
);

CREATE TABLE 25BackSwimmers
(
	25BackSID int,
	25BackSwims int,
	Primary Key (25BackSID, 25BackSwims),
	CONSTRAINT 25BackSID_fk FOREIGN KEY (25BackSID) REFERENCES Swimmers (SNID),
	CONSTRAINT 25BackSwims_fk FOREIGN KEY (25BackSwims) REFERENCES 25Back (25BackEventID)
);

CREATE TABLE 25BreastSwimmers
(
	25BreastSID int,
	25BreastSwims int,
	Primary Key (25BreastSID, 25BreastSwims),
	CONSTRAINT 25BreastSID_fk FOREIGN KEY (25BreastSID) REFERENCES Swimmers (SNID),
	CONSTRAINT 25BreastSwims_fk FOREIGN KEY (25BreastSwims) REFERENCES 25Breast (25BreastEventID)
);

CREATE TABLE 25FlySwimmers
(
	25FlySID int,
	25FlySwims int,
	Primary Key (25FlySID, 25FlySwims),
	CONSTRAINT 25FlySID_fk FOREIGN KEY (25FlySID) REFERENCES Swimmers (SNID),
	CONSTRAINT 25FlySwims_fk FOREIGN KEY (25FlySwims) REFERENCES 25Fly (25FlyEventID)
);

CREATE TABLE 100FreeRelaySwimmers
(
	First100FreeRelaySID int,
	Second100FreeRelaySID int,
	Third100FreeRelaySID int,
	Fourth100FreeRelaySID int,
	100FreeRelaySwims int,
	SwimmerOrder int,
	Primary Key (First100FreeRelaySID, Second100FreeRelaySID, Third100FreeRelaySID, Fourth100FreeRelaySID, 100FreeRelaySwims),
	CONSTRAINT First100FreeRelaySID_fk FOREIGN KEY (First100FreeRelaySID) REFERENCES Swimmers (SNID),
	CONSTRAINT Second100FreeRelaySID_fk FOREIGN KEY (Second100FreeRelaySID) REFERENCES Swimmers (SNID),
	CONSTRAINT Third100FreeRelaySID_fk FOREIGN KEY (Third100FreeRelaySID) REFERENCES Swimmers (SNID),
	CONSTRAINT Fourth100FreeRelaySID_fk FOREIGN KEY (Fourth100FreeRelaySID) REFERENCES Swimmers (SNID),
	CONSTRAINT 100FreeRelaySwims_fk FOREIGN KEY (100FreeRelaySwims) REFERENCES 100FreeRelay (100FreeRelayEventID)
);

CREATE TABLE 100IMSwimmers
(
	First100IMSID int,
	Second100IMSID int,
	Third100IMSID int,
	Fourth100IMSID int,
	100IMSwims int,
	Primary Key (First100IMSID, Second100IMSID, Third100IMSID, Fourth100IMSID, 100IMSwims),
	CONSTRAINT First100IMSID_fk FOREIGN KEY (First100IMSID) REFERENCES Swimmers (SNID),
	CONSTRAINT Second100IMSID_fk FOREIGN KEY (Second100IMSID) REFERENCES Swimmers (SNID),
	CONSTRAINT Third100IMSID_fk FOREIGN KEY (Third100IMSID) REFERENCES Swimmers (SNID),
	CONSTRAINT Fourth100IMSID_fk FOREIGN KEY (Fourth100IMSID) REFERENCES Swimmers (SNID),
	CONSTRAINT 100IMSwims_fk FOREIGN KEY (100IMSwims) REFERENCES 100IM (100IMEventID)
);

##############################################EventMeets

CREATE TABLE 50FreeMeets
(
	50FreeEID int,
	50FreeMID int,
	OrderInMeet int,
	Primary Key (50FreeEID, 50FreeMID),
	CONSTRAINT 50FreeEID_fk FOREIGN KEY (50FreeEID) REFERENCES 50Free (50FreeEventID),
	CONSTRAINT 50FreeMID_fk FOREIGN KEY (50FreeMID) REFERENCES Meets (MeetID)
);
##USE TOP AS EXAMPLE

CREATE TABLE 100FreeMeets
(
	100FreeEID int,
	100FreeMID int,
	OrderInMeet int,
	Primary Key (100FreeEID, 100FreeMID),
	CONSTRAINT 100FreeEID_fk FOREIGN KEY (100FreeEID) REFERENCES 100Free (100FreeEventID),
	CONSTRAINT 100FreeMID_fk FOREIGN KEY (100FreeMID) REFERENCES Meets (MeetID)
);

CREATE TABLE 200FreeMeets
(
	200FreeEID int,
	200FreeMID int,
	OrderInMeet int,
	Primary Key (200FreeEID, 200FreeMID),
	CONSTRAINT 200FreeEID_fk FOREIGN KEY (200FreeEID) REFERENCES 200Free (200FreeEventID),
	CONSTRAINT 200FreeMID_fk FOREIGN KEY (200FreeMID) REFERENCES Meets (MeetID)
);

CREATE TABLE 500FreeMeets
(
	500FreeEID int,
	500FreeMID int,
	OrderInMeet int,
	Primary Key (500FreeEID, 500FreeMID),
	CONSTRAINT 500FreeEID_fk FOREIGN KEY (500FreeEID) REFERENCES 500Free (500FreeEventID),
	CONSTRAINT 500FreeMID_fk FOREIGN KEY (500FreeMID) REFERENCES Meets (MeetID)
);

CREATE TABLE 100FlyMeets
(
	100FlyEID int,
	100FlyMID int,
	OrderInMeet int,
	Primary Key (100FlyEID, 100FlyMID),
	CONSTRAINT 100FlyEID_fk FOREIGN KEY (100FlyEID) REFERENCES 100Fly (100FlyEventID),
	CONSTRAINT 100FlyMID_fk FOREIGN KEY (100FlyMID) REFERENCES Meets (MeetID)
);

CREATE TABLE 100BackMeets
(
	100BackEID int,
	100BackMID int,
	OrderInMeet int,
	Primary Key (100BackEID, 100BackMID),
	CONSTRAINT 100BackEID_fk FOREIGN KEY (100BackEID) REFERENCES 100Back (100BackEventID),
	CONSTRAINT 100BackMID_fk FOREIGN KEY (100BackMID) REFERENCES Meets (MeetID)
);

CREATE TABLE 100BreastMeets
(
	100BreastEID int,
	100BreastMID int,
	OrderInMeet int,
	Primary Key (100BreastEID, 100BreastMID),
	CONSTRAINT 100BreastEID_fk FOREIGN KEY (100BreastEID) REFERENCES 100Breast (100BreastEventID),
	CONSTRAINT 100BreastMID_fk FOREIGN KEY (100BreastMID) REFERENCES Meets (MeetID)
);

CREATE TABLE 200FreeRelayMeets
(
	200FreeRelayEID int,
	200FreeRelayMID int,
	OrderInMeet int,
	Primary Key (200FreeRelayEID, 200FreeRelayMID),
	CONSTRAINT 200FreeRelayEID_fk FOREIGN KEY (200FreeRelayEID) REFERENCES 200FreeRelay (200FreeRelayEventID),
	CONSTRAINT 200FreeRelayMID_fk FOREIGN KEY (200FreeRelayMID) REFERENCES Meets (MeetID)
);

CREATE TABLE 400FreeRelayMeets
(
	400FreeRelayEID int,
	400FreeRelayMID int,
	OrderInMeet int,
	Primary Key (400FreeRelayEID, 400FreeRelayMID),
	CONSTRAINT 400FreeRelayEID_fk FOREIGN KEY (400FreeRelayEID) REFERENCES 400FreeRelay (400FreeRelayEventID),
	CONSTRAINT 400FreeRelayMID_fk FOREIGN KEY (400FreeRelayMID) REFERENCES Meets (MeetID)
);

CREATE TABLE 200IMMeets
(
	200IMEID int,
	200IMMID int,
	OrderInMeet int,
	Primary Key (200IMEID, 200IMMID),
	CONSTRAINT 200IMEID_fk FOREIGN KEY (200IMEID) REFERENCES 200IM (200IMEventID),
	CONSTRAINT 200IMMID_fk FOREIGN KEY (200IMMID) REFERENCES Meets (MeetID)
);

CREATE TABLE 200IMRelayMeets
(
	200IMRelayEID int,
	200IMRelayMID int,
	OrderInMeet int,
	Primary Key (200IMRelayEID, 200IMRelayMID),
	CONSTRAINT 200IMRelayEID_fk FOREIGN KEY (200IMRelayEID) REFERENCES 200IMRelay (200IMRelayEventID),
	CONSTRAINT 200IMRelayMID_fk FOREIGN KEY (200IMRelayMID) REFERENCES Meets (MeetID)
);

CREATE TABLE 25FreeMeets
(
	25FreeEID int,
	25FreeMID int,
	OrderInMeet int,
	Primary Key (25FreeEID, 25FreeMID),
	CONSTRAINT 25FreeEID_fk FOREIGN KEY (25FreeEID) REFERENCES 25Free (25FreeEventID),
	CONSTRAINT 25FreeMID_fk FOREIGN KEY (25FreeMID) REFERENCES Meets (MeetID)
);

CREATE TABLE 25BackMeets
(
	25BackEID int,
	25BackMID int,
	OrderInMeet int,
	Primary Key (25BackEID, 25BackMID),
	CONSTRAINT 25BackEID_fk FOREIGN KEY (25BackEID) REFERENCES 25Back (25BackEventID),
	CONSTRAINT 25BackMID_fk FOREIGN KEY (25BackMID) REFERENCES Meets (MeetID)
);

CREATE TABLE 25BreastMeets
(
	25BreastEID int,
	25BreastMID int,
	OrderInMeet int,
	Primary Key (25BreastEID, 25BreastMID),
	CONSTRAINT 25BreastEID_fk FOREIGN KEY (25BreastEID) REFERENCES 25Breast (25BreastEventID),
	CONSTRAINT 25BreastMID_fk FOREIGN KEY (25BreastMID) REFERENCES Meets (MeetID)
);

CREATE TABLE 25FlyMeets
(
	25FlyEID int,
	25FlyMID int,
	OrderInMeet int,
	Primary Key (25FlyEID, 25FlyMID),
	CONSTRAINT 25FlyEID_fk FOREIGN KEY (25FlyEID) REFERENCES 25Fly (25FlyEventID),
	CONSTRAINT 25FlyMID_fk FOREIGN KEY (25FlyMID) REFERENCES Meets (MeetID)
);

CREATE TABLE 100FreeRelayMeets
(
	100FreeRelayEID int,
	100FreeRelayMID int,
	OrderInMeet int,
	Primary Key (100FreeRelayEID, 100FreeRelayMID),
	CONSTRAINT 100FreeRelayEID_fk FOREIGN KEY (100FreeRelayEID) REFERENCES 100FreeRelay (100FreeRelayEventID),
	CONSTRAINT 100FreeRelayMID_fk FOREIGN KEY (100FreeRelayMID) REFERENCES Meets (MeetID)
);

CREATE TABLE 100IMMeets
(
	100IMEID int,
	100IMMID int,
	OrderInMeet int,
	Primary Key (100IMEID, 100IMMID),
	CONSTRAINT 100IMEID_fk FOREIGN KEY (100IMEID) REFERENCES 100IM (100IMEventID),
	CONSTRAINT 100IMMID_fk FOREIGN KEY (100IMMID) REFERENCES Meets (MeetID)
);

##Table for MeetEvents
CREATE TABLE MeetEvents
(
	MEMeetID int,
	MEEventName varchar (20),
	Primary Key (MEMeetID, MEEventName),
	CONSTRAINT MEMeetID_fk FOREIGN KEY (MEMeetID) REFERENCES Meets (MeetID)
);