init.sql

CREATE TABLE exercises (
    exercise_name TEXT PRIMARY KEY NOT NULL, exercise_link TEXT
);

CREATE TABLE exercise_aliases (
    exercise_alias TEXT PRIMARY KEY NOT NULL,
    exercise_name TEXT NOT NULL,
    FOREIGN KEY (exercise_name) REFERENCES exercises(exercise_name) ON DELETE CASCADE
);

CREATE TABLE users (
    user_id INTEGER PRIMARY KEY NOT NULL,
    user_name TEXT NULL,
    first_name TEXT NOT NULL, 
    last_name TEXT NULL
);

CREATE TABLE user_reps (
    user_id INTEGER NOT NULL,
    exercise_name TEXT NOT NULL,
    reps INTEGER NOT NULL,
    FOREIGN KEY (user_id) REFERENCES users(user_id) ON DELETE CASCADE,
    FOREIGN KEY (exercise_name) REFERENCES exercises(exercise_name) ON DELETE CASCADE,
    PRIMARY KEY (user_id, exercise_name)
);