Is it possible to import a schema?

Ask for Help
1

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 :slight_smile:

For curiousity it is to manage volunteers in my association.

Regards