create table users
(
    email        nchar(999) not null,
    f_name nchar(999) not null,
    l_name nchar(999) not null,
    age number not null,
    height nchar(999) not null,
    date_created date        not null,
    primary key (email)
);

create table weight_records
(
    id number not null,
    timestamp timestamp   not null,
    u_email     nchar(999) not null,
    weight number not null,
    primary key (id),
    foreign key (u_email) references users (email)
);


create table workout_records
(
    id number not null,
    name nchar(999) not null,
    weight_lifted number,
    timestamp timestamp   not null,
    u_email     nchar(999) not null,
    type nchar(999) not null,
    primary key (id),
    foreign key (u_email) references users (email)
);