$1.$ user file:

$-$ user$\_$id $($primary key$)$

$-$ name

$-$ email

$-$ phone$\_$number

$-$ password

$-$ user$\_$type $($Client$/$Admin$)$

$2.$ Appointments file:

$-$ appointment$\_$id $($primary key$)$

$-$ user$\_$id $($foreign key$)//$need to match with those in the user file

$-$ service$\_$type $($manicure$,$ pedicure, hair, beauty treatment$)$

$-$ appointment$\_$date

$-$ appointment$\_$time

$3.$ Services file:

$-$ service$\_$id $($primary key$)$

$-$ service$\_$name

$-$ service$\_$type $($manicure$,$ pedicure, hair, beauty treatment$)$

$-$ price

$4.$ Notifications table:

$-$ notification$\_$id $($primary key$)$

$-$ notification$\_$type $($e$.$g$.,$ upcoming appointment$)$

$-$ notification$\_$message

$-$ notification$\_$date

$-$ is$\_$read

note: please provide the following number of each:

$-25+$ users $(5$ must have the user$\_$type$=$"Admin"$)$

$-10+$ appointments

$-10+$ servises for each servide$\_$type

$-30+$ notifications to users

$-15+$ notifications to admins

$*$can you please have this done by latest tuesday night$*$