David Roman ⋅ Raleigh, NC U.S. Army National Guard, Specialist ⋅ 3 years served

I'm aiming to create an app to track one's exercises, reps, sets, and weight used. Right now, I'm building out my tables, but would like feedback (I'm particularly concerned about the Session table).

--the table(s) have pre-made information on the app directly (aka lookup tables)

Create Table AppExercises (
AppExerciseID int Primary Key,
AppExerciseName varchar(50) Not Null,
Description varchar(MAX) Not Null,
CreatedOn datetime Not Null Default (getdate()),
LastModified datetime Default (getdate())
);

--tables below require user input

Create Table CustomExercises (
CustomExerciseID int Primary Key,
CustomExerciseName varchar(50) Not Null,
Description varchar(MAX),
CreatedBy int Foreign Key References Users (UserID),
CreatedOn datetime Not Null Default (getdate()),
LastModified datetime Default (getdate())
);

Create Table Users (
UserID int Primary Key,
FirstName varchar(50) Not Null,
LastName varchar(50) Not Null,
BirthDate date,
Sex varchar(50),
Email varchar(50) Not Null,
CreatedOn datetime Not Null Default (getdate()),
LastModified datetime Default (getdate()),
);

----------------------------------------------------------------------

--the Session table

Create Table Session (
SessionID int Not Null,
Date datetime Not Null,
DoneBy int Foreign Key References Users (UserID),
AppExercise int Foreign Key References AppExercises (AppExerciseID),
CustomExercise int Foreign Key References CustomExercises (CustomExerciseID),
Sets int Not Null,
Reps int Not Null,
Weight int Not Null,
CreatedOn datetime Not Null Default (getdate()),
LastModified datetime Default (getdate()),
primary key (SessionID, Date)
);