qg_jeunes_db_shema - Laravel Schema Designer

users

user_id string
prenom string
nom string
statut string
adresse string
telephone string
timestamps timestamps
softDeletes softDeletes
email string
password string

articles

article_id string
titre string
resume string
image string
contenu longText
tag_id string
categorie_id string
thematique_id string
author_id string
timestamps timestamps
softDeletes softDeletes

categories

categorie_id string
libelle string
timestamps timestamps
softDeletes softDeletes

thematiques

thematique_id string
contenu longText
timestamps timestamps
softDeletes softDeletes

specialites

specialite_id string
libelle string
timestamps timestamps
softDeletes softDeletes

quiz

quiz_id string
titre string
description longText
timestamps timestamps
softDeletes softDeletes
thematique_id string

questions

question_id string
libelle string
quiz_id string
timestamps timestamps
softDeletes softDeletes

reponses

reponse_id string
libelle string
statut boolean
question_id string
timestamps timestamps
softDeletes softDeletes

podcasts

podcast_id string
titre string
description string
url string
image string
thematique_id string
timestamps timestamps
softDeletes softDeletes

medias

media_id string
titre string
url string
image string
video string
thematique_id string
categorie_id string
timestamps timestamps
softDeletes softDeletes

praticiens

praticien_id string
prenom string
nom string
titre string
adresse string
specialite_id string
timestamps timestamps
softDeletes softDeletes

disponibilites

disponibilite_id string
adresse_geolocalise string
horaire_ouverture string
horaire_fermeture string
date_presence string
lieu string
clinique_id string
latitude string
longitude string
timestamps timestamps
softDeletes softDeletes

cliniques

clinique_id string
nom_etablissement string
telephone string
email string
url_site string
ville string
timestamps timestamps
softDeletes softDeletes

evenements

evenement_id string
nom string
date string
heure string
adresse string
timestamps timestamps
softDeletes softDeletes

dictionnaires

dictionnaire_id string
mots string
definition longText
timestamps timestamps
softDeletes softDeletes

tag_article

id increments
tag_id string
article_id string
timestamps timestamps
softDeletes softDeletes

page_categories

page_categorie_id string
page_categorie_name string
is_active boolean
timestamps timestamps
softDeletes softDeletes

page_subcategories

page_subcategorie_id string
page_subcategorie_description string
hashtage string
page_cover_image string
has_multiple_page boolean
has_video boolean
has_emty_page boolean
timestamps timestamps
softDeletes softDeletes

pages

page_id string
position string
page_name string
page_content string
page_images string
page_menu_icon string
page_categorie_id string
page_subcategorie_id string
page_video_url string
is_active boolean
timestamps timestamps
softDeletes softDeletes

categorie_quiz

categorie_quiz_id string
libelle string
timestamps timestamps
softDeletes softDeletes

niveau_quiz

niveau_quiz_id string
libelle string
timestamps timestamps
softDeletes softDeletes

testimonials

testimonial_id string
titre string
image_testimonial string
description string
timestamps timestamps
softDeletes softDeletes

user_response_questions

user_response_question_id string
quiz_id string
question_id string
reponse_id string
user_id string
timestamps timestamps
softDeletes softDeletes

newsletter_subscribers

newsletter_subscriber_id string
email string
is_active boolean
timestamps timestamps
softDeletes softDeletes

newsletters

newsletter_id string
message longText
subject string
admin_id string
timestamps timestamps
softDeletes softDeletes

bande_dessinees

bande_dessinee_id string
titre string
image_bd string
description string
pdf_bd string
thematique_id string
categorie_id string
timestamps timestamps
softDeletes softDeletes

playlistes

playliste_id string
titre string
description string
image string
nombre_episode string
timestamps timestamps
softDeletes softDeletes