Hi there,
I am used to model my data before creating it and I saw there is a code view.
It seems like I cannot edit it but can I import some schema some way ?
For exemple, I have this dbdiagram (you can try it in dbdiagram.io - Database Relationship Diagrams Design Tool):
Table Benevoles {
id int [primary key]
Nom text
Email text
Telephone text
}
Table Disponibilites {
id int [primary key]
Benevole_id int [ref: > Benevoles.id]
Heure_debut datetime
Heure_fin datetime
}
Table Encadrants {
id int [primary key]
Nom text
Email text
Telephone text
}
Table Lieux {
id int [primary key]
Nom text
Adresse text
Capacite int
Responsable_id int [ref: > Encadrants.id]
Disponibilite enum("Disponible", "Réservé", "Indisponible")
Notes text
}
Table Activites {
id int [primary key]
Nom text
Responsable_id int [ref: > Encadrants.id]
Lieu_id int [ref: > Lieux.id]
}
Table Creneaux {
id int [primary key]
Activite_id int [ref: > Activites.id]
Date date
Heure_debut datetime
Heure_fin datetime
Benevoles_requis int
}
Table InscriptionBenevoles {
id int [primary key]
Benevole_id int [ref: > Benevoles.id]
Creneau_id int [ref: > Creneaux.id]
Statut enum("Confirmé", "En attente", "Annulé")
}
Table Taches {
id int [primary key]
Nom text
Activite_id int [ref: > Activites.id]
Responsable_id int [ref: > Encadrants.id]
Deadline datetime
Statut enum("À faire", "En cours", "Terminé")
}
Table Materiel {
id int [primary key]
Nom text
Quantite_disponible int
Activite_id int [ref: > Activites.id]
Lieu_de_stockage text
}
Table Feedback {
id int [primary key]
Benevole_id int [ref: > Benevoles.id]
Activite_id int [ref: > Activites.id]
Commentaire text
Note int
}
which I can translate easily to the code.
If I cannot, is there any workaround like importing fake data, idk ?
Thanks
For curiousity it is to manage volunteers in my association.
Regards