Tables

users
user_details

days
user_detail_day
documents
user_document
reviews
cities

contracts
user_detail_contract
-----------

(OK) Campi aggiuntivi multiple
(OK) Review suddivisa in categorie
(OK) Database città 





-----

(OK) Campo sitoweb verificare
Verifica sezioni vuote nel profilo

(OK) Feedback su campo errore import


-----------

Email all'inserimento della review all'admin
Email all'approvazione delle review al professionista

Aggiungere link al profilo del professionista loggato

(OK) Sostituire valutazoine numerica con stelline

(OK) Ricerca nella provincia e il comune fa da ORDER BY
(OK) Import automaticamente attivi 



Modifica Utente - Tab Condizioni con cui lavora. Non associa l'utente alle condizioni e per farlo devi cliccare su update (errore name not null) - Problema associazione Condizioni all'utente

Lato Admin manca la gestione delle Figure Professionali


(OK) Guide box con immagine di copertina

(OK) al login undefined index_city logincontroller 53


ssh -L 3307:127.0.0.1:3306 root@platform.linkabili.it
C_4_z_l_L_20_18_m

npx prisma migrate diff --from-url "mysql://root:12345@localhost:3306/linkabili_prod" --to-url "mysql://root:12345@localhost:3306/linkabili" --script > diff.sql

s
(OK) inserire link diretto a cassetto fiscale da user menu 



npx prisma migrate diff --from-url "mysql://root:linkabilimvp@localhost:3307/linkabili_staging" --to-url "mysql://root:12345@localhost:3306/linkabili" --script > diff.sql

professionista 2133



Aggiungere altre province tipo utente profess
Validazione update utenti backoffice





## DELETE IMPORT
delete from user_certification where user_id in (select id from users where imported = 1);
delete from registers where user_id in (select id from users where imported = 1);
delete from user_referenze where user_id in (select id from users where imported = 1);
delete from contact_caregivers_professionist where caregiver_id in (select id from users where imported = 1) or professionist_id in (select id from users where imported = 1);
delete from partnerships where user_id in (select id from users where imported = 1);
delete from user_pathology where user_id in (select id from users where imported = 1);
delete from user_profession where user_id in (select id from users where imported = 1);
delete from user_service where user_id in (select id from users where imported = 1);
delete from user_state where user_id in (select id from users where imported = 1);
delete from user_professionalstudy where user_id in (select id from users where imported = 1);
delete from user_professionspecialization where user_id in (select id from users where imported = 1);
delete from other_study where user_id in (select id from users where imported = 1);
delete from users where imported = 1
####