  playerHeight INT,
  playerHomeTown VARCHAR(64),
  playerLastName VARCHAR (32),
- playerPosition VARCHAR (32),
- playerThrowingHand VARCHAR(16),
+ playerPosition VARCHAR (8),
+ playerThrowingHand VARCHAR(2),
  playerUpdate VARCHAR (32),
  INDEX(playerUserId),
- FOREIGN KEY(playerUserId) REFERENCES playerUser(playerUserId),
+ FOREIGN KEY(playerUserId) REFERENCES player(playerUserId),
  PRIMARY KEY(playerId)
 );
 
 CREATE TABLE schedule (
  scheduleId INT  AUTO_INCREMENT NOT NULL,
- scheduleTeamId INT UNSIGNED NOT NULL,
- scheduleDate DATETIME NOT NULL
- schedulelocation VARCHAR(64)
- scheduleStartingPosition VARCHAR(32)
- scheduleTime VARCHAR(32)
+ scheduleTeamId INT  ,
+ scheduleLocation VARCHAR(64),
+ scheduleStartingPosition VARCHAR(32),
+ scheduleTime DATETIME,
  INDEX(scheduleTeamId),
- FOREIGN KEY(scheduleTeamId) REFERENCES scheduleTeam(scheduleTeamId),
+ FOREIGN KEY(scheduleTeamId) REFERENCES schedule(scheduleTeamId),
  PRIMARY KEY(scheduleId)
 );
 
-CREATE TABLE apiCall(
+CREATE TABLE ApiCall(
 apiCallId INT UNSIGNED AUTO_INCREMENT NOT NULL,
-apiCallUserId UNSIGNED NOT NULL,
+apiCallUserId  INT,
 apiCallDatetime DATETIME NOT NULL,
 apiCallQueryString VARCHAR(2000),
 apiCallURL VARCHAR(32),

	userPassword VARCHAR(64) NOT NULL,
	userPhoneNumber INT NOT NULL,
	userSalt INT,
	userUpdate VARCHAR UNSIGNED,
	UNIQUE (userEmail),
	INDEX(userId),
	FOREIGN KEY (userApiCall) REFERENCES ApiCall(userApiCall),
	FOREIGN KEY (userAccessLevel) REFERENCES AccessLevel(userAccessLevel)
	PRIMARY KEY(userId)
);

CREATE TABLE player (

teamId INT UNSIGNED AUTO_INCREMENT NOT NULL,
teamType VARCHAR(32) NOT NULL,
teamName VARCHAR (64) NOT NULL,
teamStarters VARCHAR(64),
INDEX(teamId),
UNIQUE (teamId),
PRIMARY KEY (teamId)
