 	AnimalID INT PRIMARY KEY IDENTITY
 	, FunFact VARCHAR(250)
 	, Shiny BIT NOT NULL --1 means it is shiny
-	, SoundID INT REFERENCES Sounds (SoundID)
-	, ImageID INT REFERENCES Images (ImageID));
+	, SoundID INT REFERENCES Sounds (SoundID) NOT NULL
+	, ImageID INT REFERENCES Images (ImageID) NOT NULL);
 
 CREATE TABLE Users (
 	UserID INT PRIMARY KEY IDENTITY


CREATE TABLE MiniGameMedia (
	MediaID INT PRIMARY KEY IDENTITY
	, MiniGameID INT REFERENCES Minigames (MiniGameID)
	, Difficulty INT default NULL	--nulled if media is used for every instance of that game
	, MiniGameMedia VARBINARY(max) NOT NULL);

CREATE TABLE ProfileProgressHistory (
	ProgressID INT PRIMARY KEY IDENTITY
	, ProfileID INT REFERENCES Profiles (ProfileID)
	, MiniGameID INT REFERENCES Minigames (MiniGameID));

CREATE TABLE Profiles (
	ProfileID INT PRIMARY KEY IDENTITY
	, UserID INT REFERENCES Users (UserID) NOT NULL
	, AvatarID INT REFERENCES Images (ImageID) NOT NULL
	, ProfileName NVARCHAR(30) NOT NULL
	, ToggleSound BIT NOT NULL default 1 --0 = sound off, 1 = sound on, defualted to sound on
	, ToggleMusic BIT NOT NULL default 1
