I have a sport club presence list on paper which I have to bring online.
Basically, I have everything in handle except the SQL schema architecture.

I have never designed a DataBase and I'm not sure if it's the right way. I appreciate any help!

> 
> If the person is present we make a x with a pen on paper :)
> To do to look the same like on the paper but in an app I try to develop a Java Vaadin App with Spring Data JPA-Hibernate.
> 
> 
> **On paper and in the future APP look like this:**
> 
> 
> 

[![enter image description here](https://i.stack.imgur.com/HHIXI.jpg)](https://i.stack.imgur.com/HHIXI.jpg)

> 
> And this is the MySQL schema:
> 
> 
> 

```
create table person(
id int PRIMARY KEY AUTO_INCREMENT,
first_name varchar(20)
);

create table isPresent(
id int PRIMARY KEY AUTO_INCREMENT,
isPresent boolean
);

create table persons_isPresent(
person_id int,
isPresent_id int,
FOREIGN KEY (person_id)
REFERENCES person(id),
FOREIGN KEY (isPresent_id)
REFERENCES isPresent(id)
);

create table training(
id int PRIMARY KEY AUTO_INCREMENT,
person_id int,
isPresent_id int,
training_time datetime,
FOREIGN KEY (person_id)
REFERENCES person(id),
FOREIGN KEY (isPresent_id)
REFERENCES isPresent(id)
);

```

I have never designed a DataBase and I'm not sure if it's the right way. I appreciate any help!