 	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 Profiles (
	ProfileID INT PRIMARY KEY IDENTITY
	, UserID INT REFERENCES Users (UserID)
	, AvatarID INT REFERENCES Images (ImageID)
	, 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

CREATE TABLE Maps (
MapID INT PRIMARY KEY IDENTITY
, MapName VARCHAR(50) NOT NULL
, ImageID INT REFERENCES Images (ImageID) NOT NULL
, SoundID INT REFERENCES Sounds (SoundID) NOT NULL);

CREATE TABLE Nodes (
	MapID INT REFERENCES Maps (MapID) NOT NULL
	, NodeID INT IDENTITY
	, XCoordinate INT NOT NULL
	, YCoordinate INT NOT NULL
