diploma
| id | diploma_name | city |
|---|---|---|
| 1 | Radiologie | Paris |
| 2 | Infirmerie | Toulouse |
| 3 | Cardiologie | Strasbourg |
| 4 | Chirurgie | Lile |
| 5 | Orthopédie | Paris |
| 6 | Urgentisme | Paris |
doctor
| id | surname | firstname | job | efficiency |
|---|---|---|---|---|
| 1 | MAMADOU | Momo | radiologue | random (0-10) |
| 2 | LAMARK | Fred | urgentiste | random (0-10) |
| 3 | CAMUS | Albert | chirurgien | random (0-10) |
| 4 | LAUBERGE | Claude | orthopédiste | random (0-10) |
patient
| id | surname | firstname | dolor | entry_date |
|---|---|---|---|---|
| 1 | ZEMOUR | Eric | random (0-10) | now() |
| 2 | COLOMBO | Zizou | random (0-10) | now() |
| 3 | LAPERUCHE | Zaz | random (0-10) | now() |
| 4 | CIRAIL | Canelle | random (0-10) | now() |
skills
| id | iddoctor | iddiploma |
|---|---|---|
| 1 | 1 | 1 |
| 2 | 1 | 6 |
| 3 | 2 | 6 |
| 4 | 2 | 3 |
| 5 | 3 | 4 |
| 6 | 4 | 5 |
folders
| id | iddoctor | idpatient |
|---|---|---|
| 1 | 1 | 1 |
| 2 | 1 | 2 |
| 3 | 2 | 2 |
| 4 | 3 | 3 |
| 5 | 4 | 4 |