🏨 NEXSAFAR

Export Structure de la Base de Données

205

Tables

2882

Colonnes Total

19/04/2026

Date d'Export

ℹ️ Export de la structure uniquement

Cet export contient UNIQUEMENT la structure des tables (colonnes, types, clés) sans aucune donnée.

📄 Télécharger en TXT 📝 Télécharger en MD 💾 Télécharger SQL

📋 Structure des Tables

📊 TABLE 74

10 colonne(s)
idHotel int
ville varchar(7)
hotel varchar(30)
debut varchar(11)
fin varchar(11)
chambre varchar(9)
tarifs varchar(5)
pension varchar(2)
vue varchar(2)
partenaire varchar(173)

📊 adresses

25 colonne(s)
id int [PRI] auto_increment
id_categorie int [MUL]
nom varchar(255)
slug varchar(255)
description text
ville enum('Mecque','Médine','Djeddah') [MUL]
adresse text
quartier varchar(100)
telephone varchar(50)
site_web varchar(255)
google_maps text
latitude decimal(10,8)
longitude decimal(11,8)
horaires varchar(255)
prix_moyen varchar(100)
image varchar(255)
images_supplementaires text
tags varchar(500)
note decimal(2,1)
nb_avis int
mise_en_avant tinyint(1)
ordre int
actif tinyint(1) [MUL]
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 adresses_categories

8 colonne(s)
id int [PRI] auto_increment
nom varchar(100)
slug varchar(100) [UNI]
icone varchar(50)
description varchar(255)
ordre int
actif tinyint(1)
created_at timestamp DEFAULT_GENERATED

📊 agencies

31 colonne(s)
id int [PRI] auto_increment
name varchar(255)
email varchar(255)
phone varchar(50)
latitude decimal(10,8) [MUL]
longitude decimal(11,8)
city varchar(100)
country varchar(100)
address text
specialties text
languages text
rating decimal(2,1) [MUL]
total_bookings int
is_verified tinyint(1) [MUL]
nusuk_provider tinyint(1)
nusuk_profile_url varchar(500)
is_active tinyint(1) [MUL]
profile_photo varchar(500)
cover_photo varchar(500)
description text
certifications text
website varchar(255)
whatsapp varchar(50)
facebook varchar(255)
instagram varchar(255)
years_experience int
total_clients int
available_for_chat tinyint(1)
response_time_minutes int
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 agency_reviews

22 colonne(s)
id int [PRI] auto_increment
agency_id int [MUL]
user_id int [MUL]
booking_id int
rating int [MUL]
quality_rating int
organization_rating int
guide_rating int
value_rating int
title varchar(200)
comment text
pros text
cons text
photos text
is_verified_booking tinyint(1)
is_moderated tinyint(1)
is_approved tinyint(1) [MUL]
agency_response text
agency_response_at timestamp
helpful_count int
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 agency_stats

11 colonne(s)
id int
name varchar(255)
rating decimal(2,1)
total_bookings int
total_reviews bigint
avg_review_rating decimal(14,4)
avg_quality decimal(14,4)
avg_organization decimal(14,4)
avg_guide decimal(14,4)
total_conversations bigint
unread_messages decimal(32,0)

📊 ai_recommendations

16 colonne(s)
id int [PRI] auto_increment
user_id int [MUL]
package_id int
package_type enum('omra','hajj','standard','multi_destination')
recommendation_score decimal(5,2)
recommendation_reason text
algorithm_version varchar(20)
is_shown tinyint(1)
shown_at datetime
is_clicked tinyint(1)
clicked_at datetime
click_count int
is_converted tinyint(1)
converted_at datetime
created_at timestamp DEFAULT_GENERATED
expires_at timestamp [MUL]

📊 airport

11 colonne(s)
IATACode varchar(10)
name varchar(100)
nom varchar(150)
country varchar(4)
city varchar(50)
province varchar(50)
island varchar(50)
latitude float
longitude float
elevation float
gmtOffset float

📊 article

4 colonne(s)
id int [PRI] auto_increment
libelle varchar(3000)
code_tva int
prix_ht float

📊 badges

12 colonne(s)
id int [PRI] auto_increment
code varchar(50) [UNI]
name varchar(100)
description text
icon varchar(255)
category enum('travel','social','engagement','special','elite')
points_reward int
requirement_type enum('booking_count','countries_visited','followers','likes_received','reviews','spending','referrals','special')
requirement_value int
rarity enum('common','rare','epic','legendary')
is_active tinyint(1)
created_at timestamp DEFAULT_GENERATED

📊 blog_categories

5 colonne(s)
id bigint unsigned [PRI] auto_increment
name varchar(120)
slug varchar(190) [UNI]
description varchar(255)
created_at datetime DEFAULT_GENERATED

📊 blog_posts

16 colonne(s)
id bigint unsigned [PRI] auto_increment
category_id bigint unsigned [MUL]
title varchar(255)
slug varchar(190) [UNI]
excerpt varchar(300)
content_html longtext
cover_image varchar(500)
seo_title varchar(255)
seo_description varchar(255)
canonical_url varchar(500)
robots_index tinyint(1)
robots_follow tinyint(1)
status enum('draft','review','published','archived') [MUL]
published_at datetime [MUL]
created_at datetime DEFAULT_GENERATED
updated_at datetime DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 bookingHotel

19 colonne(s)
id int [PRI] auto_increment
uid int
idHotel int
idSejour int
step_id int [MUL]
idClient int
checkin date
checkout date
status int
payment float
bookingDate date
note text
coutSejour float
reduction_parrainage decimal(10,2)
parrainage_id int
prixRevient float
montant float
restant float
groupe varchar(500)

📊 bookingRoom

5 colonne(s)
id int [PRI] auto_increment
idBookingHotel int
idRoom int
nbRoom int
occupant text

📊 bookingSejour

6 colonne(s)
id int [PRI] auto_increment
uid int
idSejour int
bookingDate date
nbPax int
payment int

📊 bookingVol

22 colonne(s)
id int [PRI] auto_increment
uid int
idVol int
idClient int
nbPax int
status int
payment float
bookingDate date
nbAdulte int
nbEnfant int
nbBebe int
depart date
retour date
villeDepartA varchar(300)
villeArriveeA varchar(300)
VilleDepartB varchar(300)
villeArriveeB varchar(300)
note text
coutSejour float
montant float
restant float
groupe varchar(500)

📊 booking_chambres

6 colonne(s)
id int [PRI] auto_increment
id_itineraire int [MUL]
id_chambre int
nb_chambres int
tarif_total decimal(10,2)
created_at timestamp DEFAULT_GENERATED

📊 booking_hotels

12 colonne(s)
id int [PRI] auto_increment
booking_id int [MUL]
step_id int [MUL]
id_hotel int [MUL]
checkin date [MUL]
checkout date
nb_nuits int STORED GENERATED
status enum('pending','confirmed','cancelled')
booking_date date
uid int
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 booking_itineraires

11 colonne(s)
id int [PRI] auto_increment
id_booking int [MUL]
ordre int
id_destination int [MUL]
date_arrivee date
date_depart date
nb_nuits int
id_hotel int
statut enum('pending','confirmed','cancelled')
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 booking_options

6 colonne(s)
id int [PRI] auto_increment
booking_id int [MUL]
option_type varchar(100) [MUL]
option_value text
prix decimal(10,2)
created_at timestamp DEFAULT_GENERATED

📊 booking_rooms

7 colonne(s)
id int [PRI] auto_increment
booking_hotel_id int [MUL]
id_room int [MUL]
nb_room int
prix_unitaire decimal(10,2)
prix_total decimal(10,2)
created_at timestamp DEFAULT_GENERATED

📊 booking_steps

11 colonne(s)
id int [PRI] auto_increment
booking_id int [MUL]
step_order int
step_type enum('hotel','transfert','options')
ville varchar(100) [MUL]
date_debut date
date_fin date
nb_nuits int STORED GENERATED
is_completed tinyint(1)
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 booking_transferts

8 colonne(s)
id int [PRI] auto_increment
id_booking int [MUL]
id_route int [MUL]
id_vehicule int
nb_vehicules int
date_transfert date
tarif_total decimal(10,2)
created_at timestamp DEFAULT_GENERATED

📊 bookings

38 colonne(s)
id int [PRI] auto_increment
uid int [MUL]
bookingDate text
payment int
status int
villeDepartA varchar(200)
villeArriveeA varchar(200)
villeDepartB varchar(200)
villeArriveeB varchar(200)
dateA varchar(15)
dateB varchar(15)
nbAdulte int
nbEnfant int
nbBebe int
idHotelMedine int
idHotelMakkah int
nbQuadMedine int
nbTripleMedine int
nbDoubleMedine int
nbQuadMakkah int
nbTripleMakkah int
nbDoubleMakkah int
bus tinyint
sac tinyint
badge tinyint
guideMedine tinyint
guideMakkah tinyint
visa tinyint
vol tinyint
hotel tinyint
nbNuitsMedine int
nbNuitsMakkah int
idCompagnieTarifs int
idTransfertTarifs int
etapes_multidest text
total_price decimal(10,2)
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 boutique_categories

10 colonne(s)
id int [PRI] auto_increment
nom varchar(100)
slug varchar(100) [UNI]
description varchar(255)
icone varchar(50)
image varchar(255)
ordre int
actif tinyint(1)
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 boutique_codes_promo

12 colonne(s)
id int [PRI] auto_increment
code varchar(50) [UNI]
description varchar(255)
type_reduction enum('pourcentage','montant')
valeur decimal(10,2)
minimum_commande decimal(10,2)
usage_max int
usage_count int
date_debut date
date_fin date
actif tinyint(1)
created_at timestamp DEFAULT_GENERATED

📊 boutique_commandes

24 colonne(s)
id int [PRI] auto_increment
numero_commande varchar(50) [UNI]
id_client int
email varchar(255) [MUL]
telephone varchar(20)
nom varchar(100)
prenom varchar(100)
adresse text
code_postal varchar(10)
ville varchar(100)
pays varchar(100)
sous_total decimal(10,2)
frais_livraison decimal(10,2)
code_promo varchar(50)
reduction decimal(10,2)
total decimal(10,2)
mode_paiement enum('carte','paypal','virement')
statut_paiement enum('en_attente','paye','echoue','rembourse')
statut_commande enum('nouvelle','confirmee','en_preparation','expediee','livree','annulee') [MUL]
numero_suivi varchar(100)
notes text
ip_client varchar(45)
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 boutique_commandes_items

8 colonne(s)
id int [PRI] auto_increment
id_commande int [MUL]
id_produit int [MUL]
nom_produit varchar(255)
sku varchar(50)
prix_unitaire decimal(10,2)
quantite int
total_ligne decimal(10,2)

📊 boutique_parametres

4 colonne(s)
id int [PRI] auto_increment
cle varchar(100) [UNI]
valeur text
description varchar(255)

📊 boutique_produits

22 colonne(s)
id int [PRI] auto_increment
id_categorie int [MUL]
nom varchar(255)
slug varchar(255) [UNI]
description text
description_courte varchar(500)
prix decimal(10,2)
prix_promo decimal(10,2)
image varchar(255)
images_supplementaires text
stock int
sku varchar(50)
poids decimal(8,2)
badge enum('','promo','new','bestseller') [MUL]
note tinyint(1)
nb_avis int
nb_ventes int
ordre int
actif tinyint(1) [MUL]
mis_en_avant tinyint(1)
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 cache_stats

7 colonne(s)
id int [PRI] auto_increment
page_type varchar(50) [MUL]
slug varchar(100)
hits int [MUL]
last_generated timestamp
last_hit timestamp
created_at timestamp DEFAULT_GENERATED

📊 cat2k5_commentmeta

4 colonne(s)
meta_id bigint unsigned [PRI] auto_increment
comment_id bigint unsigned [MUL]
meta_key varchar(255) [MUL]
meta_value longtext

📊 cat2k5_comments

15 colonne(s)
comment_ID bigint unsigned [PRI] auto_increment
comment_post_ID bigint unsigned [MUL]
comment_author tinytext
comment_author_email varchar(100) [MUL]
comment_author_url varchar(200)
comment_author_IP varchar(100)
comment_date datetime
comment_date_gmt datetime [MUL]
comment_content text
comment_karma int
comment_approved varchar(20) [MUL]
comment_agent varchar(255)
comment_type varchar(20)
comment_parent bigint unsigned [MUL]
user_id bigint unsigned

📊 cat2k5_e_events

3 colonne(s)
id bigint unsigned [PRI] auto_increment
event_data text
created_at datetime [MUL]

📊 cat2k5_links

13 colonne(s)
link_id bigint unsigned [PRI] auto_increment
link_url varchar(255)
link_name varchar(255)
link_image varchar(255)
link_target varchar(25)
link_description varchar(255)
link_visible varchar(20) [MUL]
link_owner bigint unsigned
link_rating int
link_updated datetime
link_rel varchar(255)
link_notes mediumtext
link_rss varchar(255)

📊 cat2k5_options

4 colonne(s)
option_id bigint unsigned [PRI] auto_increment
option_name varchar(191) [UNI]
option_value longtext
autoload varchar(20) [MUL]

📊 cat2k5_postmeta

4 colonne(s)
meta_id bigint unsigned [PRI] auto_increment
post_id bigint unsigned [MUL]
meta_key varchar(255) [MUL]
meta_value longtext

📊 cat2k5_posts

23 colonne(s)
ID bigint unsigned [PRI] auto_increment
post_author bigint unsigned [MUL]
post_date datetime
post_date_gmt datetime
post_content longtext
post_title text
post_excerpt text
post_status varchar(20)
comment_status varchar(20)
ping_status varchar(20)
post_password varchar(255)
post_name varchar(200) [MUL]
to_ping text
pinged text
post_modified datetime
post_modified_gmt datetime
post_content_filtered longtext
post_parent bigint unsigned [MUL]
guid varchar(255)
menu_order int
post_type varchar(20) [MUL]
post_mime_type varchar(100)
comment_count bigint

📊 cat2k5_term_relationships

3 colonne(s)
object_id bigint unsigned [PRI]
term_taxonomy_id bigint unsigned [PRI]
term_order int

📊 cat2k5_term_taxonomy

6 colonne(s)
term_taxonomy_id bigint unsigned [PRI] auto_increment
term_id bigint unsigned [MUL]
taxonomy varchar(32) [MUL]
description longtext
parent bigint unsigned
count bigint

📊 cat2k5_termmeta

4 colonne(s)
meta_id bigint unsigned [PRI] auto_increment
term_id bigint unsigned [MUL]
meta_key varchar(255) [MUL]
meta_value longtext

📊 cat2k5_terms

4 colonne(s)
term_id bigint unsigned [PRI] auto_increment
name varchar(200) [MUL]
slug varchar(200) [MUL]
term_group bigint

📊 cat2k5_usermeta

4 colonne(s)
umeta_id bigint unsigned [PRI] auto_increment
user_id bigint unsigned [MUL]
meta_key varchar(255) [MUL]
meta_value longtext

📊 cat2k5_users

10 colonne(s)
ID bigint unsigned [PRI] auto_increment
user_login varchar(60) [MUL]
user_pass varchar(255)
user_nicename varchar(50) [MUL]
user_email varchar(100) [MUL]
user_url varchar(100)
user_registered datetime
user_activation_key varchar(255)
user_status int
display_name varchar(250)

📊 chambre_type

5 colonne(s)
id int [PRI] auto_increment
libelle varchar(500)
nbAdulte int
nbEnfant int
description text

📊 chambres

20 colonne(s)
idChambre int [PRI] auto_increment
idHotel int
idSejour int
nbPlace int
placeDisponible int
type tinyint
remarque text
libelle varchar(50)
sexe smallint
rangeAge tinyint
origine varchar(100)
climatisation varchar(10)
groupe varchar(100)
chefs1 int
chefs2 int
chefs3 int
chefs4 int
chefsBus int
prix float
idSejour2 int

📊 chambres_attributs

6 colonne(s)
id int [PRI] auto_increment
idChambre int [MUL]
nom varchar(255)
valeur text
ordre int
date_creation timestamp DEFAULT_GENERATED

📊 chat_conversations

9 colonne(s)
id int [PRI] auto_increment
user_id int [MUL]
agency_id int [MUL]
last_message text
last_message_at timestamp [MUL]
unread_count_user int
unread_count_agency int
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 chat_messages

7 colonne(s)
id int [PRI] auto_increment
conversation_id int [MUL]
sender_type enum('user','agency')
sender_id int
message text
is_read tinyint(1) [MUL]
created_at timestamp [MUL] DEFAULT_GENERATED

📊 city

9 colonne(s)
id int [PRI] auto_increment
name varchar(50)
nom varchar(100)
country varchar(4)
province varchar(50)
population int
latitude float
longitude float
elevation float

📊 client

14 colonne(s)
id int [PRI] auto_increment
uid int
nom varchar(500)
prenom varchar(500)
adresse1 varchar(1000)
adresse2 varchar(1000)
ville varchar(200)
code_postal varchar(100)
pays varchar(100)
tel_mobile varchar(50)
tel_urgence varchar(50)
email varchar(200)
date_adhesion date
confirm int

📊 community_purchases

8 colonne(s)
id int [PRI] auto_increment
user_id int [MUL]
booking_id int [MUL]
package_name varchar(255)
package_type enum('omra','hajj','standard','multi_destination')
destination_cities text
is_public tinyint(1)
purchase_date timestamp DEFAULT_GENERATED

📊 compagnie

7 colonne(s)
id int [PRI] auto_increment
libelle varchar(100)
logo varchar(100)
remarque text
telephone varchar(20)
email varchar(200)
contact varchar(500)

📊 compagnie_tarifs

30 colonne(s)
id int [PRI] auto_increment
idCompagnie int
uid int
dateDebut date
dateFin date
gadult float
gchild float
gbebe float
iadult float
ichild float
ibebe float
tarifs float
reducEnfant float
reducBebe float
tarifsIndividuel float
depart datetime
retour datetime
allerDepart varchar(200)
allerArrivee varchar(200)
retourDepart varchar(200)
retourArrivee varchar(200)
nbPax int
statut int
request int
donnee int
taxeAeroport float
allerEscale varchar(500)
retourEscale varchar(500)
dureeEscaleAller varchar(50)
dureeEscaleRetour varchar(50)

📊 country

8 colonne(s)
id int [PRI] auto_increment
name varchar(50)
nom varchar(200)
code varchar(4)
capital varchar(50)
province varchar(50)
area int
population int

📊 countrylocalname

2 colonne(s)
country varchar(4) [PRI]
localname varchar(120)

📊 currency_cache

5 colonne(s)
id int [PRI] auto_increment
base varchar(3)
currency varchar(3) [UNI]
rate decimal(10,6)
updated_at datetime DEFAULT_GENERATED

📊 destinations

11 colonne(s)
id int [PRI] auto_increment
code varchar(10) [UNI]
nom varchar(100)
nom_en varchar(100)
pays varchar(50)
latitude decimal(10,8)
longitude decimal(11,8)
timezone varchar(50)
actif tinyint(1)
ordre int
created_at timestamp DEFAULT_GENERATED

📊 devise

7 colonne(s)
id int [PRI] auto_increment
libelle varchar(100)
taux_euro float
code varchar(100)
signe varchar(3)
ordre int
ipCountry varchar(30)

📊 document_categories

17 colonne(s)
id int [PRI] auto_increment
nom varchar(100)
nom_en varchar(100)
nom_ar varchar(100)
nom_de varchar(100)
nom_tr varchar(100)
description text
description_en text
description_ar text
description_de text
description_tr text
icone varchar(50)
couleur varchar(7)
ordre int [MUL]
actif tinyint(1) [MUL]
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 document_favoris

4 colonne(s)
id int [PRI] auto_increment
user_id int [MUL]
document_id int [MUL]
created_at timestamp DEFAULT_GENERATED

📊 document_vues

6 colonne(s)
id int [PRI] auto_increment
document_id int [MUL]
user_id int [MUL]
type_action enum('vue','telechargement','ecoute')
ip_address varchar(45)
created_at timestamp DEFAULT_GENERATED

📊 documents

31 colonne(s)
id int [PRI] auto_increment
categorie_id int [MUL]
titre varchar(255)
titre_en varchar(255)
titre_ar varchar(255)
titre_de varchar(255)
titre_tr varchar(255)
description text
description_en text
description_ar text
description_de text
description_tr text
type_fichier enum('pdf','doc','docx','video','audio','lien','image') [MUL]
type_pelerinage enum('hajj','omra','les_deux','autre') [MUL]
fichier_path varchar(500)
lien_externe varchar(500)
duree varchar(20)
taille_fichier int
miniature varchar(500)
icone varchar(50)
couleur_badge varchar(7)
acces_type enum('public','clients','clients_actifs','vip') [MUL]
vues int
telechargements int
ecoutes int
actif tinyint(1) [MUL]
ordre int
featured tinyint(1) [MUL]
nouveau tinyint(1)
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 facture

71 colonne(s)
id int [PRI] auto_increment
uid int
numero varchar(50)
nom varchar(200)
prenom varchar(300)
adresse varchar(500)
ville varchar(200)
codepostal varchar(10)
pays varchar(100)
telephone varchar(50)
email varchar(290)
titre varchar(500)
villedepart varchar(200)
periode varchar(500)
nbadulte tinyint
nbenfant tinyint
nbbebe tinyint
tarifsadulte float
tarifsenfant float
tarifsbebe float
nbetudiant int
tarifsetudiant float
idsejour int
chambresejour varchar(5)
hotel1 varchar(100)
nuit1 varchar(200)
hotel2 varchar(200)
nuit2 varchar(200)
hotel3 varchar(200)
nuit3 varchar(200)
accompagnateur float
transfert float
vol float
pension float
tarifsglobal float
visa float
marge float
datedocument date
typedocument varchar(100)
fichier varchar(500)
paiement float
paiementType varchar(50)
single tinyint
reducEnfant int
etat tinyint
agence tinyint
mois tinyint
annee int
date_relance date
note text
datedepart date
dateretour date
vue tinyint
delai tinyint
nbEnfantSanslit tinyint
tarifsenfantSansLit float
service1 varchar(5000)
service2 varchar(5000)
service3 varchar(5000)
service4 varchar(5000)
service5 varchar(5000)
notes2 text
participant1 varchar(5000)
participant2 varchar(5000)
participant3 varchar(5000)
participant4 varchar(5000)
participant5 varchar(5000)
ramadan tinyint
contact tinyint
creerpar varchar(100)
modifierpar varchar(100)

📊 fichier

12 colonne(s)
id int [PRI] auto_increment
libelle varchar(255)
fichier varchar(255)
idClient int
idPelerin int
idSejour int
idBilan int
typeBilan tinyint
typeDoc varchar(10)
idReservationHotel int
idReservationVol int
uid int

📊 generalSettings

18 colonne(s)
id int [PRI] auto_increment
title text
description text
keywords text
trackingCode text
rootpath varchar(200)
contactName text
contactEmail text
contactMobile text
businessLocation text
logo varchar(100)
favicon varchar(100)
grSiteKey text
grSecretKey text
grContact int
grSignup int
grSignin int
googleMapKey text

📊 guide_assignments

8 colonne(s)
id int [PRI] auto_increment
guide_user_id int [MUL]
guide_email varchar(255) [MUL]
module varchar(50) [MUL]
group_id int
actif tinyint(1) [MUL]
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 guide_categories

10 colonne(s)
id int [PRI] auto_increment
nom varchar(255)
slug varchar(255) [UNI]
description text
icone varchar(10)
couleur varchar(20)
ordre int [MUL]
actif tinyint(1) [MUL]
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 guide_sejours

6 colonne(s)
id int [PRI] auto_increment
guide_id int [MUL]
sejour_id int [MUL]
sort_order int
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 guide_videos

18 colonne(s)
id int [PRI] auto_increment
id_categorie int [MUL]
youtube_id varchar(50) [UNI]
youtube_url varchar(255)
titre varchar(255) [MUL]
slug varchar(255) [UNI]
description_courte text
description_longue text
youtube_titre_original varchar(255)
youtube_description text
youtube_duree varchar(20)
youtube_thumbnail varchar(500)
ordre int [MUL]
vues int
actif tinyint(1) [MUL]
featured tinyint(1) [MUL]
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 guides

30 colonne(s)
id int unsigned [PRI] auto_increment
user_id int [MUL]
slug varchar(140) [UNI]
full_name varchar(180)
role_title varchar(255)
bio text
description_courte varchar(500)
biographie text
photo_url varchar(500)
photo_hero varchar(500)
youtube_id varchar(255)
languages varchar(120)
experience_years int
specialites varchar(255)
message_perso text
methode_accompagnement text
whatsapp varchar(40)
phone varchar(40)
email varchar(160)
is_active tinyint(1) [MUL]
sort_order int
meta_title varchar(160)
meta_description varchar(300)
created_at datetime DEFAULT_GENERATED
updated_at datetime DEFAULT_GENERATED on update CURRENT_TIMESTAMP
total_pilgrims int
rating decimal(2,1)
review_count int
availability_status enum('available','limited','full')
next_departures text

📊 guides_locations

6 colonne(s)
id int unsigned [PRI] auto_increment
guide_id int unsigned [MUL]
country_code char(2)
ville_normalise varchar(120)
city_key varchar(140) [MUL]
is_active tinyint(1)

📊 guides_tarifs

13 colonne(s)
id int [PRI] auto_increment
ville varchar(100)
ville_normalise varchar(100)
tarif_guide decimal(10,2)
description varchar(255)
nb_pelerins_min int
nb_pelerins_max int
actif tinyint(1)
ordre int
created_at datetime DEFAULT_GENERATED
updated_at datetime DEFAULT_GENERATED on update CURRENT_TIMESTAMP
country_code char(2)
city_key varchar(140) [MUL]

📊 guides_villes_alias

5 colonne(s)
id int [PRI] auto_increment
alias varchar(100)
ville_normalise varchar(100)
country_code char(2) [MUL]
city_key varchar(140)

📊 hajj_chambres_historique

9 colonne(s)
id int [PRI] auto_increment
pelerin_id int [MUL]
groupe_id int [MUL]
num_chambre_avant varchar(20)
num_chambre_apres varchar(20)
modifie_par_user_id int
modifie_par_email varchar(255)
source enum('manuel','auto') [MUL]
created_at datetime [MUL] DEFAULT_GENERATED

📊 hajj_chat_messages

6 colonne(s)
id int [PRI] auto_increment
groupe_id int [MUL]
user_id int
user_email varchar(255) [MUL]
message text
created_at datetime

📊 hajj_countries

22 colonne(s)
id int [PRI] auto_increment
country_code varchar(10) [UNI]
country_name_fr varchar(100) [MUL]
country_name_en varchar(100)
slug varchar(100) [UNI]
meta_title varchar(200)
meta_description text
h1_title varchar(200)
intro_text text
why_choose_title varchar(200)
why_choose_content text
packages_intro text
testimonials_content text
faq_content text
contact_info text
phone varchar(50)
email varchar(100)
flag_emoji varchar(10)
is_active tinyint(1) [MUL]
display_order int [MUL]
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 hajj_formation_lecons

12 colonne(s)
id int [PRI] auto_increment
formation_id int [MUL]
titre varchar(255)
titre_en varchar(255)
titre_ar varchar(255)
description text
type_contenu enum('video','audio','texte','pdf')
contenu_url varchar(500)
duree varchar(50)
ordre int [MUL]
actif tinyint(1)
created_at timestamp DEFAULT_GENERATED

📊 hajj_formation_progression

7 colonne(s)
id int [PRI] auto_increment
user_id int [MUL]
formation_id int [MUL]
lecon_id int [MUL]
progression_pct int
completee tinyint(1)
derniere_activite timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 hajj_formations

18 colonne(s)
id int [PRI] auto_increment
titre varchar(255)
titre_en varchar(255)
titre_ar varchar(255)
description text
description_en text
description_ar text
categorie varchar(50) [MUL]
difficulte enum('debutant','intermediaire','avance') [MUL]
duree_estimee varchar(50)
nombre_lecons int
langue varchar(10)
image_url varchar(255)
ordre int [MUL]
actif tinyint(1) [MUL]
featured tinyint(1)
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 hajj_groupes

44 colonne(s)
id int [PRI] auto_increment
nom varchar(255)
numero_bus varchar(50)
guide_nom varchar(255)
guide_tel varchar(50)
hotel_makkah varchar(255)
hotel_medine varchar(255)
depart_ville varchar(255)
depart_date date
retour_date date
nb_max_pelerins int
actif tinyint(1) [MUL]
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP
nom_ar varchar(255)
package_no varchar(50) [MUL]
category varchar(50) [MUL]
vol_groupe_aller_numero varchar(20)
vol_groupe_aller_compagnie varchar(100)
vol_groupe_aller_depart_heure time
vol_groupe_aller_arrivee_heure time
vol_groupe_aller2_numero varchar(20)
vol_groupe_retour_numero varchar(20)
vol_groupe_retour_compagnie varchar(100)
vol_groupe_retour_depart_heure time
vol_groupe_retour_arrivee_heure time
vol_groupe_retour2_numero varchar(20)
arrival_city varchar(100) [MUL]
arrival_date date [MUL]
transfer_date date
capacity int
nb_beds_dbl int
nb_beds_trl int
nb_beds_quad int
price_dbl decimal(10,2)
price_trl decimal(10,2)
price_quad decimal(10,2)
group_flights text
vol_groupe_aller2_compagnie varchar(100)
vol_groupe_aller2_depart_heure time
vol_groupe_aller2_arrivee_heure time
vol_groupe_retour2_compagnie varchar(100)
vol_groupe_retour2_depart_heure time
vol_groupe_retour2_arrivee_heure time

📊 hajj_inscriptions

53 colonne(s)
id int [PRI] auto_increment
groupe_id int [MUL]
nom varchar(100)
prenom varchar(100)
genre enum('homme','femme')
date_naissance date
nationalite varchar(100)
num_passeport varchar(50)
date_expiration date
telephone varchar(20) [MUL]
email varchar(150) [MUL]
adresse text
code_postal varchar(20)
ville varchar(100)
package_code varchar(10)
package_nom varchar(255)
ville_depart varchar(50)
duree_sejour enum('court','moyen','long')
categorie_forfait enum('standard','premium','luxury')
type_chambre varchar(50)
num_chambre varchar(10)
camp_mina varchar(50)
prix_package decimal(10,2)
nombre_adultes int
nombre_enfants int
compte_cree enum('oui','non')
compte_valide enum('oui','non','attente')
ewallet_credite enum('oui','non')
commentaires text
passeport_file varchar(255)
photo_file varchar(255)
carte_sejour_file varchar(255)
certificat_vaccination_file varchar(255)
vol_personnalise tinyint(1)
vol_perso_aller_numero varchar(20)
vol_perso_aller_compagnie varchar(100)
vol_perso_aller_depart_heure time
vol_perso_aller_arrivee_heure time
vol_perso_aller2_numero varchar(50)
vol_perso_aller2_compagnie varchar(100)
vol_perso_aller2_depart_heure time
vol_perso_aller2_arrivee_heure time
vol_perso_retour_numero varchar(20)
vol_perso_retour_compagnie varchar(100)
vol_perso_retour_depart_heure time
vol_perso_retour_arrivee_heure time
vol_perso_retour2_numero varchar(50)
vol_perso_retour2_compagnie varchar(100)
vol_perso_retour2_depart_heure time
vol_perso_retour2_arrivee_heure time
statut enum('nouveau','en_cours','valide','refuse') [MUL]
date_inscription datetime [MUL]
date_modification datetime

📊 hajj_journal

8 colonne(s)
id int [PRI] auto_increment
user_id int [MUL]
date_entree date [MUL]
humeur varchar(10)
contenu text
moderation enum('en_attente','approuve','rejete') [MUL]
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 hajj_meteo

10 colonne(s)
id int [PRI] auto_increment
ville varchar(100)
temperature int
temperature_min int
temperature_max int
humidite int
vent int
description varchar(255)
icone varchar(10)
date_maj timestamp DEFAULT_GENERATED

📊 hajj_packages

18 colonne(s)
id int [PRI] auto_increment
title varchar(200) [MUL]
description text
price decimal(10,2) [MUL]
duration int
features text
country_codes varchar(255)
category enum('economy','standard','premium','luxury') [MUL]
departure_dates text
max_capacity int
current_bookings int
hotel_mecca varchar(200)
hotel_medina varchar(200)
image_url varchar(255)
is_active tinyint(1) [MUL]
display_order int
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 hajj_pelerins

34 colonne(s)
id int [PRI] auto_increment
user_id int [MUL]
groupe_id int [MUL]
nom varchar(255)
prenom varchar(255)
sexe enum('homme','femme')
email varchar(255) [MUL]
telephone varchar(50)
ville varchar(255)
adresse text
code_postal varchar(10)
ville_depart varchar(100)
duree_sejour varchar(50)
categorie_forfait varchar(50)
type_chambre varchar(50)
nombre_adultes int
nombre_enfants int
compte_cree enum('oui','non')
compte_valide enum('oui','non')
ewallet_credite enum('oui','non')
date_naissance date
nationalite varchar(100)
numero_passeport varchar(100)
date_expiration_passeport date
photo_identite varchar(255)
photo_passeport varchar(255)
carte_sejour varchar(255)
certificat_vaccination varchar(255)
statut_inscription enum('en_attente','validee','refusee') [MUL]
montant_verse decimal(10,2)
commentaire_admin text
notes text
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 historique

8 colonne(s)
id int [PRI] auto_increment
uid int
date_heure datetime
ip tinytext
pelerin int [MUL]
description text
url varchar(1000)
user varchar(100)

📊 hotel_images

6 colonne(s)
himg_id int [PRI] auto_increment
himg_hotel_id int
himg_type varchar(20)
himg_image varchar(100)
himg_order int
himg_approved tinyint

📊 hotel_pelerin

19 colonne(s)
id int
uid int
idBookingHotel int
idPelerin int
montant float
restant float
typePaiement varchar(100)
groupe varchar(10)
chambre tinyint
remiseEuros float
remisePercent float
prix float
confirm tinyint
dateCheckin date
dateCheckout date
creerpar varchar(100)
modifierpar varchar(100)
dateinscription date
note text

📊 hotels

62 colonne(s)
id int [PRI] auto_increment
libelle varchar(500)
hotelier varchar(1000)
adresse varchar(500)
ville varchar(500)
id_destination int [MUL]
idVille int
zip varchar(100)
telephone varchar(20)
fax varchar(20)
email varchar(100)
contact varchar(500)
description text
remarque text
equipement text
amenities text
family text
internet text
room text
dining text
accessibility text
childBeds text
checkin text
checkOut text
latitude float
longitude float
stars float
position varchar(1000)
uid int
distance varchar(300)
topAmenities text
Situation text
Services text
Chambres text
languages text
parking text
chambre text
policies text
structure varchar(500)
supBB float
supDejeuner float
supDiner float
devise varchar(10)
roomandrate text
description_fr text
description_en text
description_ar text
distance_haram int
distance_masjid int
temps_marche int
type_hotel varchar(50)
checkin_time time
checkout_time time
annulation_gratuite tinyint(1)
paiement_hotel tinyint(1)
google_rating decimal(2,1)
google_reviews_count int
google_maps_url varchar(500)
booking_rating decimal(3,1)
booking_reviews_count int
booking_level varchar(50)
booking_url varchar(500)

📊 hotels_attributs

6 colonne(s)
id int [PRI] auto_increment
idHotel int [MUL]
nom varchar(255)
valeur text
ordre int
date_creation timestamp DEFAULT_GENERATED

📊 hotels_chambres

10 colonne(s)
id int [PRI] auto_increment
idHotel int
chambre varchar(300)
nbAdulte int
nbEnfant int
room varchar(500)
description text
amenities text
lit varchar(600)
idold int

📊 hotels_image

5 colonne(s)
id int [PRI] auto_increment
idHotel int
image varchar(500)
order int
idRoom int

📊 hotels_img

8 colonne(s)
id int [PRI] auto_increment
idHotel int
image varchar(1000)
position int
description varchar(1000)
une int
idH int
new int

📊 hotels_param

7 colonne(s)
id tinyint [PRI] auto_increment
accompagnateur float
transfert float
vol float
marge float
pension float
visa float

📊 hotels_room_img

5 colonne(s)
id int [PRI] auto_increment
idRoom int
img varchar(1000)
imgL varchar(1000)
imgT varchar(1000)

📊 hotels_tarifs

20 colonne(s)
id int [PRI] auto_increment
idHotel int
idChambre int
chambre varchar(1000)
info varchar(1000)
tarifs float
forfait int
debut date
fin date
plus text
partenaire text
pension varchar(1000)
vue varchar(1000)
BB int
HB int
FB int
AI int
RO int
sohor int
iftar int

📊 hotels_tarifs_2

20 colonne(s)
id int [PRI] auto_increment
idHotel int
idChambre int
chambre varchar(1000)
info varchar(1000)
tarifs float
forfait int
debut date
fin date
plus text
partenaire text
pension varchar(1000)
vue varchar(1000)
BB int
HB int
FB int
AI int
RO int
sohor int
iftar int

📊 hotels_villes_backup

3 colonne(s)
id int
ville_originale varchar(500)
libelle varchar(500)

📊 internal_links

7 colonne(s)
id bigint unsigned [PRI] auto_increment
from_page_id bigint unsigned [MUL]
to_page_id bigint unsigned [MUL]
anchor_text varchar(255)
position enum('nav_silo','body','faq','footer')
is_auto tinyint(1)
created_at datetime DEFAULT_GENERATED

📊 languages

9 colonne(s)
lang_code varchar(5) [PRI]
name varchar(50)
name_native varchar(50)
flag_code varchar(5)
is_active tinyint(1)
is_default tinyint(1)
direction enum('ltr','rtl')
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 mailSettings

10 colonne(s)
isSMTP int
host text
username text
password text
SMTPSecure text
port text
subject int
name int
email int
phone int

📊 messaging

7 colonne(s)
id int [PRI] auto_increment
toEmail text
fromEmail text
subject text
message text
attachments text
sentDate text

📊 migration_log

8 colonne(s)
id int [PRI] auto_increment
idClient int [MUL]
idSejourOld int [MUL]
idSejourNew int [MUL]
idSejourDate int
dateMigration datetime [MUL]
user varchar(100)
idChambre int

📊 migrations

3 colonne(s)
id int unsigned [PRI] auto_increment
migration varchar(255)
batch int

📊 multi_chambres

13 colonne(s)
id int [PRI] auto_increment
id_sejour int [MUL]
id_sejour_date int
numero_chambre varchar(20) [MUL]
type_chambre enum('single','double','triple','quad')
capacite_max int
sexe_autorise tinyint
id_client_famille int
nb_occupants int
statut enum('disponible','partielle','complete','fermee') [MUL]
notes text
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 multi_chambres_affectations

6 colonne(s)
id int [PRI] auto_increment
id_chambre int [MUL]
id_pelerin int [UNI]
date_affectation timestamp DEFAULT_GENERATED
affecte_par varchar(100)
notes text

📊 multi_client

67 colonne(s)
id int [PRI] auto_increment
uid int [MUL]
dateCommande date
idClientOriginal int [MUL]
idClient int
prenom varchar(100)
prenomArabe varchar(250)
date_naissance date
rangeAge int
sexe int
nationalite varchar(190)
passeport varchar(190)
passeportDateEmission date
passeportDateExpiration date
passeportType varchar(200)
passeportPays varchar(200)
passeportVille varchar(200)
mrz varchar(2000)
mahram varchar(300)
pays_naissance varchar(200)
ville_naissance varchar(200)
pays_residence varchar(200)
ville_residence varchar(200)
situation varchar(300)
emploi varchar(300)
sante varchar(300)
etude varchar(300)
nom varchar(100) [MUL]
nomArabe varchar(250)
email varchar(200) [MUL]
telephone varchar(50)
telephone_urgence varchar(50)
adresse varchar(255)
code_postal varchar(20)
ville varchar(100)
pays varchar(100)
idSejour int [MUL]
idSejourDate int [MUL]
idTypeVoyage int
id_hotel int
typeSejour enum('multi_sejours','sejours')
libelleVoyage varchar(255)
dateDepart date [MUL]
dateRetour date
dateFin date
idVol int
idVisa int
idMahram int
civilite varchar(4)
photo varchar(300)
villeDepart varchar(100)
villeRetour varchar(190)
nbPelerins int
coutTotal decimal(10,2)
commission decimal(10,2)
prixRevient decimal(10,2)
montantPaye decimal(10,2)
restant decimal(10,2)
listOptions text
groupe varchar(100)
note text
confirm tinyint [MUL]
statut enum('en_attente','confirme','annule','termine') [MUL]
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP
id_chambre int
chambre int

📊 multi_client_backup_20260106

66 colonne(s)
id int [PRI] auto_increment
uid int [MUL]
dateCommande date
idClientOriginal int [MUL]
idClient int
prenom varchar(100)
prenomArabe varchar(250)
date_naissance date
rangeBagaz int
sexe int
nationalite varchar(190)
passeport varchar(190)
passeportDateEmission date
passeportDateExpiration date
wrance varchar(200)
passeportPays varchar(200)
passeportVille varchar(200)
mrz varchar(2000)
mahram varchar(300)
pays_naissance varchar(200)
ville_naissance varchar(200)
pays_residence varchar(200)
ville_residence varchar(200)
situation varchar(300)
emploi varchar(300)
sante varchar(300)
etude varchar(300)
nom varchar(100) [MUL]
nomArabe varchar(250)
email varchar(200) [MUL]
telephone varchar(50)
telephone_urgence varchar(50)
adresse varchar(255)
code_postal varchar(20)
ville varchar(100)
pays varchar(100)
idSejour int [MUL]
idSejourDate int [MUL]
id_hotel int
typeSejour enum('multi_sejours','sejours')
libelleVoyage varchar(255)
dateDepart date [MUL]
dateRetour date
dateFin date
idVol int
idVolca int
idMakam int
civilite varchar(4)
photo varchar(300)
villeDepart varchar(100)
villeRetour varchar(190)
nbPelerins int
coutTotal decimal(10,2)
commission decimal(10,2)
prixRevient decimal(10,2)
montantPaye decimal(10,2)
restant decimal(10,2)
listOptions text
groupe varchar(100)
note text
confirm tinyint [MUL]
statut enum('en_attente','confirme','annule','termine') [MUL]
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP
id_chambre int
chambre int

📊 multi_destinations

14 colonne(s)
id int [PRI] auto_increment
nom varchar(100)
nom_normalise varchar(100) [UNI]
pays varchar(100) [MUL]
code_pays varchar(3)
latitude float
longitude float
fuseau_horaire varchar(50)
description text
image varchar(255)
actif tinyint(1) [MUL]
ordre_affichage int
created_at datetime DEFAULT_GENERATED
updated_at datetime DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 multi_destinations_alias

3 colonne(s)
id int [PRI] auto_increment
id_destination int [MUL]
alias varchar(100) [UNI]

📊 multi_sejours

87 colonne(s)
id int [PRI] auto_increment
uid int [MUL]
guide_id int [MUL]
reference varchar(50) [UNI]
titre varchar(255)
image_sejour varchar(255)
libelle varchar(255)
type varchar(50)
idPays int
idVille int
id_pays int [MUL]
id_ville int [MUL]
pays varchar(100)
ville_sejour varchar(100)
devise varchar(10)
nb_adultes int
nb_enfants int
nb_bebes int
note text
places_disponibles int
places_restantes int
nb_jours int
nb_nuits int
ville_depart varchar(100)
ville_retour varchar(100)
type_depart varchar(50)
pension varchar(50)
responsable_nom varchar(255)
responsable_tel varchar(20)
agence_saoudienne varchar(255) [MUL]
id_agency int [MUL]
description_generale text
forfait_comprend text
forfait_ne_comprend_pas text
date_depart date [MUL]
date_retour date
id_compagnie_tarifs int
id_transfert_tarifs int
nb_transferts int
option_visa tinyint(1)
option_badge tinyint(1)
option_sac tinyint(1)
option_livre tinyint(1)
option_tenue_ihram tinyint(1)
option_bus tinyint(1)
cout_vols decimal(10,2)
cout_hotels decimal(10,2)
cout_guides decimal(10,2)
cout_transferts decimal(10,2)
cout_options decimal(10,2)
badge tinyint(1)
sac tinyint(1)
livre tinyint(1)
visa tinyint(1)
cout_visas decimal(10,2)
frais_dossier decimal(10,2)
cout_total decimal(10,2)
prix_base decimal(10,2)
commission decimal(5,2)
reduction_enfant decimal(5,2)
prix_enfant_sans_lit_agence decimal(10,2)
prix_enfant_sans_lit decimal(10,2)
prix_bebe_agence decimal(10,2)
prix_single decimal(10,2)
prix_double decimal(10,2)
prix_triple decimal(10,2)
prix_quad decimal(10,2)
prix_enfant decimal(10,2)
prix_bebe decimal(10,2)
statut enum('brouillon','en_cours','confirme','annule','termine') [MUL]
publication tinyint(1)
mise_en_avant tinyint(1)
etape_courante int
nb_etapes_total int
message text
notes_internes text
created_at datetime [MUL] DEFAULT_GENERATED
updated_at datetime DEFAULT_GENERATED on update CURRENT_TIMESTAMP
date_confirmation datetime
confirmed_at datetime
synced_at datetime
id_sejour_classique int
programme text
ville_programme varchar(255)
hotel_programme varchar(255)
image_programme varchar(500)
user_type enum('B2B','B2C') [MUL]

📊 multi_sejours_chambres

6 colonne(s)
id int [PRI] auto_increment
id_sejour_hotel int [MUL]
id_chambre int
nb_chambres int
tarif_unitaire decimal(10,2)
tarif_total decimal(10,2)

📊 multi_sejours_documents

9 colonne(s)
id int [PRI] auto_increment
id_sejour int [MUL]
type varchar(50) [MUL]
titre varchar(255)
fichier_url varchar(500)
taille int
mime_type varchar(100)
uploaded_at timestamp DEFAULT_GENERATED
uploaded_by int [MUL]

📊 multi_sejours_etapes

24 colonne(s)
id int [PRI] auto_increment
id_sejour int [MUL]
id_destination int [MUL]
ville_nom varchar(100)
ville varchar(300)
id_ville int
ordre int
date_arrivee date
date_depart date
nb_nuits int
id_hotel int [MUL]
hotel_nom_manuel varchar(255)
hotel varchar(300)
programme text
cout_hotel decimal(10,2)
nb_guides int
cout_guides decimal(10,2)
tarif_guide_jour decimal(10,2)
statut enum('a_faire','en_cours','complete')
created_at datetime DEFAULT_GENERATED
updated_at datetime DEFAULT_GENERATED on update CURRENT_TIMESTAMP
cout_transferts decimal(10,2)
guide varchar(100)
cout_guide decimal(10,2)

📊 multi_sejours_history

9 colonne(s)
id int [PRI] auto_increment
id_sejour int [MUL]
action varchar(50) [MUL]
old_value longtext
new_value longtext
user_id int [MUL]
ip_address varchar(45)
user_agent text
created_at timestamp [MUL] DEFAULT_GENERATED

📊 multi_sejours_hotels

11 colonne(s)
id int [PRI] auto_increment
id_sejour int [MUL]
id_etape int [MUL]
id_hotel int [MUL]
uid int
checkin date
checkout date
nb_nuits int
cout_total decimal(10,2)
statut tinyint(1)
created_at datetime DEFAULT_GENERATED

📊 multi_sejours_hotels_programme

9 colonne(s)
id int [PRI] auto_increment
id_sejour int [MUL]
ville varchar(255)
nom_hotel varchar(255)
nb_nuits int
infos_hotel text
ordre int
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 multi_sejours_inclusions

6 colonne(s)
id int [PRI] auto_increment
id_sejour int [MUL]
type enum('inclus','non_inclus') [MUL]
item varchar(255)
ordre int
created_at timestamp DEFAULT_GENERATED

📊 multi_sejours_infos

6 colonne(s)
id int [PRI] auto_increment
idSejour int [MUL]
titre varchar(255)
description text
ordre int
created_at timestamp DEFAULT_GENERATED

📊 multi_sejours_options

6 colonne(s)
id int [PRI] auto_increment
id_sejour int [MUL]
nom varchar(255)
description text
prix decimal(10,2)
created_at timestamp DEFAULT_GENERATED

📊 multi_sejours_paiements

12 colonne(s)
id int [PRI] auto_increment
id_sejour int [MUL]
montant decimal(10,2)
mode_paiement varchar(50)
statut varchar(20) [MUL]
reference_transaction varchar(100)
date_paiement timestamp [MUL]
notes text
recu_url varchar(500)
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP
created_by int [MUL]

📊 multi_sejours_photos

7 colonne(s)
id int [PRI] auto_increment
id_sejour int [MUL]
image varchar(255)
legende varchar(255)
is_principale tinyint(1)
ordre int [MUL]
created_at datetime DEFAULT_GENERATED

📊 multi_sejours_programme

8 colonne(s)
id int [PRI] auto_increment
id_sejour int [MUL]
ville varchar(255)
hotel varchar(255)
image varchar(500)
programme text
ordre int [MUL]
created_at timestamp DEFAULT_GENERATED

📊 multi_sejours_tarifs

9 colonne(s)
id int [PRI] auto_increment
id_sejour int [MUL]
date_debut date [MUL]
date_fin date
nb_places int
id_chambre_type int [MUL]
prix decimal(10,2)
ordre int
created_at timestamp DEFAULT_GENERATED

📊 multi_sejours_tarifs_chambres

5 colonne(s)
id int [PRI] auto_increment
id_tarif int [MUL]
type_chambre varchar(50)
prix decimal(10,2)
capacite int

📊 newsletters

5 colonne(s)
id int [PRI] auto_increment
name text
subject text
message text
attachments text

📊 notes

7 colonne(s)
id int [PRI] auto_increment
uid int
contact varchar(100)
memo text
etat int
dateNote date
titre varchar(1000)

📊 notifications

12 colonne(s)
id int [PRI] auto_increment
user_id int [MUL]
type enum('follow','like','purchase','recommendation','badge','level_up','comment','system')
title varchar(255)
message text
link varchar(255)
icon varchar(50)
is_read tinyint(1)
related_user_id int
related_item_id int
related_item_type varchar(50)
created_at timestamp [MUL] DEFAULT_GENERATED

📊 package_likes

5 colonne(s)
id int [PRI] auto_increment
user_id int [MUL]
package_id int [MUL]
package_type enum('omra','hajj','standard','multi_destination')
created_at timestamp DEFAULT_GENERATED

📊 package_reviews

13 colonne(s)
id int [PRI] auto_increment
user_id int [MUL]
package_id int [MUL]
package_type enum('omra','hajj','standard','multi_destination')
booking_id int
rating tinyint [MUL]
title varchar(255)
comment text
is_verified_purchase tinyint(1)
helpful_count int
is_approved tinyint(1)
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 page_templates

7 colonne(s)
id bigint unsigned [PRI] auto_increment
silo enum('omra','hajj','ksa','b2b') [MUL]
level enum('N1','N2','N3')
name varchar(120)
default_h2_json json
default_blocks_json json
created_at datetime DEFAULT_GENERATED

📊 pages

7 colonne(s)
id int [PRI] auto_increment
title text
permalink text
description text
keywords text
contents text
status int

📊 paiement

19 colonne(s)
id int [PRI] auto_increment
uid int
idPelerin int
idClient int
idAgence int
idSejour int
idVisa int
idBookingVol int
idBookingHotel int
montant float
restant float
typePaiement varchar(50)
datePaiement datetime
prix float
numcheque varchar(200)
banque varchar(200)
check int
note varchar(1000)
user varchar(100)

📊 paiementold

14 colonne(s)
id int [PRI] auto_increment
idPelerin int
idPartenaire int
idSejour int
montant float
restant float
typePaiement varchar(50)
datePaiement datetime
prix float
numcheque varchar(200)
banque varchar(200)
check int
note varchar(1000)
user varchar(100)

📊 parametres

6 colonne(s)
id int [PRI] auto_increment
uid int
nom tinytext
nom_variable tinytext
description tinytext
valeur tinytext

📊 parrainages

19 colonne(s)
id int [PRI] auto_increment
parrain_user_id int [MUL]
parrain_email varchar(255)
code_parrainage varchar(20) [MUL]
filleul_email varchar(255)
filleul_user_id int [MUL]
filleul_nom varchar(100)
filleul_prenom varchar(100)
statut enum('en_attente','inscrit','valide','utilise') [MUL]
reservation_id int
reservation_type enum('hotel','sejour')
montant_reservation decimal(10,2)
montant_reduction decimal(10,2)
reduction_utilisee tinyint(1)
reduction_utilisee_le datetime
reduction_reservation_id int
created_at datetime DEFAULT_GENERATED
filleul_inscrit_le datetime
valide_le datetime

📊 password_reset_tokens

5 colonne(s)
id int [PRI] auto_increment
user_id int [UNI]
token varchar(64)
expires_at datetime
created_at timestamp DEFAULT_GENERATED

📊 pays

6 colonne(s)
id int [PRI] auto_increment
nom varchar(100)
code varchar(10) [UNI]
flag_emoji varchar(10)
actif tinyint(1)
ordre int

📊 pelerins

42 colonne(s)
id int [PRI] auto_increment
uid int
dateDemande date
confirm int
idClient int
idSejour int
idSejourDate int
chambre int
id_chambre int
villeDepart varchar(100)
villeRetour varchar(100)
dateDebut date
dateFin date
idVol int
idVisa int
idMahram int
civilite varchar(4)
photo varchar(300)
prenom tinytext
nom tinytext
nomArabe varchar(500)
prenomArabe varchar(50)
date_naissance date
rangeAge int
sexe int
nationalite varchar(100)
passeport varchar(100)
passeportDateEmission date
passeportDateExpiration date
passeportPaysDelivrance varchar(200)
passeportType varchar(200)
passeportVille varchar(200)
mrz varchar(2000)
mahram varchar(300)
pays_naissance varchar(200)
ville_naissance varchar(200)
pays_residence varchar(200)
ville_residence varchar(200)
situation varchar(300)
emploi varchar(300)
sante varchar(300)
etude varchar(300)

📊 pelerins_backup_20250105

41 colonne(s)
id int
uid int
dateDemande date
confirm int
idClient int
idSejour int
idSejourDate int
chambre int
villeDepart varchar(100)
villeRetour varchar(100)
dateDebut date
dateFin date
idVol int
idVisa int
idMahram int
civilite varchar(4)
photo varchar(300)
prenom tinytext
nom tinytext
nomArabe varchar(500)
prenomArabe varchar(50)
date_naissance date
rangeAge int
sexe int
nationalite varchar(100)
passeport varchar(100)
passeportDateEmission date
passeportDateExpiration date
passeportPaysDelivrance varchar(200)
passeportType varchar(200)
passeportVille varchar(200)
mrz varchar(2000)
mahram varchar(300)
pays_naissance varchar(200)
ville_naissance varchar(200)
pays_residence varchar(200)
ville_residence varchar(200)
situation varchar(300)
emploi varchar(300)
sante varchar(300)
etude varchar(300)

📊 pilgrim_followers

4 colonne(s)
id int [PRI] auto_increment
follower_id int [MUL]
following_id int [MUL]
created_at timestamp DEFAULT_GENERATED

📊 prestation

23 colonne(s)
id int [PRI] auto_increment
uid int
nom varchar(1000)
adresse varchar(500)
dateligne date
adulte int
enfant int
bebe int
visa int
assurance int
cb float
cheque float
chequevacance float
espece float
total float
acompte float
solde float
email varchar(200)
telephone varchar(100)
creerpar varchar(200)
modifierpar varchar(200)
fichier varchar(1000)
idfichier varchar(100)

📊 prestation_details

6 colonne(s)
id int [PRI] auto_increment
idPrestation int
libelle varchar(1000)
numeroBillet varchar(500)
montant float
ordre int

📊 proprietes_catalogue

11 colonne(s)
id int [PRI] auto_increment
nom varchar(100) [UNI]
label_fr varchar(100)
label_en varchar(100)
label_ar varchar(100)
type enum('text','number','boolean','textarea','select')
categorie varchar(50)
icone varchar(50)
ordre int
actif tinyint(1)
afficher_front tinyint(1)

📊 questions_voyageurs

19 colonne(s)
id int [PRI] auto_increment
nom varchar(100)
prenom varchar(100)
email varchar(150)
telephone varchar(20)
type_voyage enum('hajj','omra','ethical_stay','autre')
numero_reservation varchar(50)
saison varchar(20)
question text
fichier_joint varchar(255)
statut enum('nouvelle','transmise','repondue','publiee','archivee')
reponse text
repondu_par varchar(100)
publier_faq tinyint(1)
categorie_faq varchar(100)
created_at datetime DEFAULT_GENERATED
updated_at datetime DEFAULT_GENERATED on update CURRENT_TIMESTAMP
date_transmission datetime
date_reponse datetime

📊 redirects_301

4 colonne(s)
id bigint unsigned [PRI] auto_increment
from_path varchar(500) [UNI]
to_path varchar(500)
created_at datetime DEFAULT_GENERATED

📊 reservations

43 colonne(s)
id int [PRI] auto_increment
idSejour int
idSejourDate int
idPelerin int
libelle varchar(500)
prenom varchar(500)
nom varchar(500)
pax int
villeDepart varchar(500)
villeRetour varchar(500)
aerogareDepart varchar(1000)
aerogareRetour varchar(1000)
dateDepart date
dateRetour date
etat varchar(11)
compagnie varchar(500)
tarifs float
pnr varchar(50)
billet text
montant float
acompte float
volaller1 varchar(10)
volaller2 varchar(10)
volretour1 varchar(10)
volretour2 varchar(10)
escalealler varchar(50)
escaleretour varchar(50)
dureeescalealler varchar(10)
dureeescaleretour varchar(10)
allerdepart varchar(10)
allerarrivee varchar(10)
retourdepart varchar(10)
retourarrivee varchar(10)
villeretourdepart varchar(100)
villeretourarrivee varchar(100)
villeallerarrivee varchar(100)
checkVol tinyint
groupeGeneral varchar(1000)
modifierpar varchar(1000)
volaller2decollage varchar(20)
volretour2decollage varchar(20)
volaller1arrivee varchar(20)
volretour1arrivee varchar(20)

📊 reservationsHotels

35 colonne(s)
id int [PRI] auto_increment
idSejour int
idPelerin int
prenom varchar(500)
nom varchar(500)
pax int
hotelMedine varchar(500)
hotelMakkah varchar(500)
dateArriveeMedine date
dateArriveeMekkah date
dateRetour date
etat varchar(11)
tarifsMedineCDbl float
tarifsMedineCTpl float
tarifsMedineCQuad float
tarifsMedineSingle float
tarifsMakkahCDbl float
tarifsMakkahCTpl float
tarifsMakkahCQuad float
tarifsMakkahSingle float
nbNuitsMedine tinyint
nbNuitsMekkah tinyint
document varchar(500)
notes text
montant float
nbChambreDbl smallint
nbChambreTpl smallint
nbChambreQuad smallint
nbChambreDblVH smallint
nbChambreTplVH smallint
nbChambreQuadVH smallint
tarifsSupplementMedineVH float
tarifsSupplementMekkahVH float
dateSortieMedine date
dateSortieMekkah date

📊 room

10 colonne(s)
id int unsigned [PRI] auto_increment
created_date datetime
name varchar(255)
price_mon decimal(10,2)
price_tue decimal(10,2)
price_wed decimal(10,2)
price_thu decimal(10,2)
price_fri decimal(10,2)
price_sat decimal(10,2)
price_sun decimal(10,2)

📊 roomPelerin

4 colonne(s)
id int [PRI] auto_increment
idBookingRoom int
nom varchar(200)
prenom varchar(200)

📊 room_custom_price

5 colonne(s)
id int unsigned [PRI] auto_increment
room_id int unsigned [PRI]
created_date datetime
certain_date date
price decimal(10,2) unsigned

📊 room_unavailable

4 colonne(s)
id int unsigned [PRI] auto_increment
room_id int unsigned
created_date datetime
certain_date date

📊 scan

9 colonne(s)
id int [PRI] auto_increment
libelle varchar(600)
idSejour varchar(500)
idVol varchar(500)
etat int
dateDepart varchar(15)
dateRetour varchar(15)
villeDepart varchar(100)
villeRetour varchar(100)

📊 scan_pelerin

4 colonne(s)
id int [PRI] auto_increment
idScan int
idPelerin int
etat int

📊 sejour_client

21 colonne(s)
id int [PRI] auto_increment
uid int
idSejour int
idVol int
idClient int
note text
confirm int
coutSejour float
reduction_parrainage decimal(10,2)
parrainage_id int
prixRevient float
commissionAgence float
montant float
restant float
groupe varchar(100)
idSejourDate int
listOptions varchar(1000)
dateDepart date
dateRetour date
dateCreation date
dateModif date

📊 sejour_hotel

12 colonne(s)
id int [PRI] auto_increment
idSejour int
idHotel int
nbChambreDouble int
nbChambreTriple int
nbChambreDoubleVH int
nbChambreTripleVH int
nbChambreQuad int
nbChambreQuint int
nbChambreSuite int
type smallint
nbNuits tinyint

📊 sejour_pelerin

73 colonne(s)
id int [PRI] auto_increment
uid int
idSejour int
idPelerin int
montant float
restant float
typePaiement varchar(100)
remarque text
groupe varchar(10)
chambre tinyint
mofa varchar(100)
visa varchar(100)
boarding varchar(100)
idSejourPelerin int
remiseEuros float
remisePercent float
prix float
groupe2 varchar(100)
idFacture int
coutvol float
couttransfert float
couthotel float
coutvisa float
PNR varchar(20)
depart varchar(2000)
retour varchar(2000)
mailVol text
confirm tinyint
AllerDepart varchar(25)
AllerDepartNum varchar(10)
AllerArrivee varchar(25)
AllerArriveeNum varchar(10)
AllerCompagnie varchar(100)
RetourDepart varchar(25)
RetourDepartNum varchar(10)
RetourArrivee varchar(25)
RetourArriveeNum varchar(10)
RetourCompagnie varchar(100)
Apasseport int
AcerticatConversion int
AcarnetVaccination int
Aphoto int
AExtraitNaissance int
ALivretFamille int
Acomplet int
AacteMariage int
AcarteSejour int
AjustificatifDomicile int
datedepart date
dateretour date
villedepart varchar(200)
villeretour varchar(200)
visadelivery tinyint
dateCheckin date
dateCheckout date
etatvol tinyint
etathotel tinyint
wvisa tinyint
wvol tinyint
whotel tinyint
origine varchar(50)
creerpar varchar(100)
modifierpar varchar(100)
billet varchar(3000)
checkVol tinyint
dateinscription date
mofa2 tinyint
consulat tinyint
groupeGeneral varchar(100)
note text
groupeVisa varchar(250)
idReservation int
idSejourDate int

📊 sejour_step

9 colonne(s)
id int [PRI] auto_increment
idSejour int [MUL]
position tinyint
ville varchar(100)
checkin date [MUL]
checkout date
nights tinyint
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 sejour_transfer

9 colonne(s)
id int [PRI] auto_increment
idSejour int [MUL]
transfer_type enum('airport_arrival','intercity','airport_departure') [MUL]
step_from int [MUL]
step_to int
vehicle_type varchar(50)
price decimal(10,2)
status tinyint(1)
created_at timestamp DEFAULT_GENERATED

📊 sejours

105 colonne(s)
id int [PRI] auto_increment
booking_id int [UNI]
idParent int
isParent tinyint
uid int
idSejour int
idDossier int
type text
idPays int [MUL]
idVille int [MUL]
statut tinyint
statutVol int
statutVisa int
statutHotel int
libelle text
depart date
retour date
description text
forfait text
horsForfait text
prixCD float
prixCT float
prixCQu float
prixCDVH float
prixCTVH float
tarifs float
prixCQi float
prixSU float
prixEnfantSansLit float
prixBebe float
contrat text
prixCDE float
prixCTE float
prixCQuE float
prixCQiE float
ordre int
nbNuitsMedine tinyint
nbNuitsMakkah tinyint
aller1 text
aller2 text
retour1 text
retour2 text
coutVisa float
paiement float
note text
bus tinyint
sac tinyint
badge tinyint
livre int
tenueIhram int
guideMedine tinyint
guideMakkah tinyint
visa tinyint
vol tinyint
hotel tinyint
idHotelMedine int
idHotelMakkah int
nbAdulte int
nbEnfant int
nbBebe int
villeDepartA text
villeArriveeA text
villeDepartB text
villeArriveeB text
dateA text
dateB text
idCompagnieTarifs int
idTransfertTarifs int
nbTransfert int
nbJour int
nbNuit int
pension text
placeDispo int
placeRestante int
featured int
PNR varchar(6000)
aprixCD float
aprixCT float
aprixCQu float
aprixSU float
aprixCDE float
aprixCTE float
aprixCQuE float
aprixBebe float
aprixEnfantSansLit float
reducEnfant float
surmesure int
is_multidest tinyint(1)
public int
message text
commission float
typeDepart varchar(50)
responsable varchar(300)
telephoneResponsable varchar(20)
dateCreation date
devis varchar(10)
reference_multi varchar(50) [MUL]
uid_client int [MUL]
email_client varchar(255)
programme longtext
ville_programme varchar(255)
hotel_programme varchar(255)
image_programme varchar(500)
created_at timestamp [MUL] DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 sejours_agents

4 colonne(s)
id int [PRI] auto_increment
idSejour int
idAgent int
status int

📊 sejours_date

9 colonne(s)
id int [PRI] auto_increment
idSejourDate int
idSejour int
dateDebut date
dateFin date
nbPlace int
nbPlaceRestante int
libelle varchar(1000)
ordre int

📊 sejours_etapes

15 colonne(s)
id int [PRI] auto_increment
sejour_id int [MUL]
ordre int
ville varchar(150)
nb_nuits int
date_debut date
date_fin date
hotel varchar(255)
room_type varchar(50)
nb_adultes int
nb_enfants int
nb_bebes int
prix_total float
meta_json longtext
created_at timestamp DEFAULT_GENERATED

📊 sejours_img

6 colonne(s)
id int [PRI] auto_increment
idSejour int
image varchar(1000)
position int
description varchar(1000)
une int

📊 sejours_infos

6 colonne(s)
id int [PRI] auto_increment
idSejour int [MUL]
titre varchar(255)
description text
ordre int
created_at timestamp DEFAULT_GENERATED

📊 sejours_options

6 colonne(s)
id int [PRI] auto_increment
idSejour int
libelle varchar(1000)
description varchar(2000)
prix float
ordre int

📊 sejours_programme

11 colonne(s)
id int [PRI] auto_increment
idSejour int
idHotel int
programme text
dateDebut date
dateFin date
idVille int
ordre int
ville varchar(300)
img varchar(1000)
hotel varchar(300)

📊 sejours_tarifs

7 colonne(s)
id int [PRI] auto_increment
idSejourDate int
idSejour int
tarifs float
idChambre int
commissionAgence float
ordre int

📊 sejoursall

77 colonne(s)
id int [PRI] auto_increment
uid int
idSejour int
idDossier int
type text
statut tinyint
libelle text
depart date
retour date
description text
horsForfait text
prixCD float
prixCT float
prixCDVH float
prixCTVH float
prixCQu float
prixCQi float
prixSU float
prixEnfantSansLit float
prixBebe float
contrat text
prixCDE float
prixCTE float
prixCQuE float
prixCQiE float
ordre int
nbNuitsMedine tinyint
nbNuitsMakkah tinyint
aller1 text
aller2 text
retour1 text
retour2 text
coutVisa float
paiement float
note text
bus tinyint
sac tinyint
badge tinyint
livre int
tenueIhram int
guideMedine tinyint
guideMakkah tinyint
visa tinyint
vol tinyint
hotel tinyint
idHotelMedine int
idHotelMakkah int
nbAdulte int
nbEnfant int
nbBebe int
villeDepartA text
villeArriveeA text
villeDepartB text
villeArriveeB text
dateA text
dateB text
idCompagnieTarifs int
idTransfertTarifs int
nbTransfert int
nbJour int
nbNuit int
pension text
placeDispo int
placeRestante int
featured int
PNR varchar(6000)
aprixCD float
aprixCT float
aprixCQu float
aprixSU float
aprixCDE float
aprixCTE float
aprixCQuE float
aprixBebe float
aprixEnfantSansLit float
surmesure int
public int

📊 seo_pages

26 colonne(s)
id bigint unsigned [PRI] auto_increment
silo enum('omra','hajj','ksa','b2b') [MUL]
level enum('N1','N2','N3')
parent_id bigint unsigned [MUL]
url_slug varchar(190)
slug varchar(190) [UNI]
path varchar(500) [UNI]
title varchar(255)
meta_description varchar(255)
h1 varchar(255)
primary_keyword varchar(255)
secondary_keywords json
canonical_url varchar(500)
robots_index tinyint(1)
robots_follow tinyint(1)
og_title varchar(255)
og_description varchar(255)
og_image varchar(500)
content_html longtext
faq_json json
cta_label varchar(120)
cta_url varchar(500)
status enum('draft','review','published','archived') [MUL]
published_at datetime
created_at datetime DEFAULT_GENERATED
updated_at datetime DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 services_catalogue

9 colonne(s)
id int [PRI] auto_increment
nom varchar(100) [UNI]
label_fr varchar(150)
label_en varchar(150)
label_ar varchar(150)
categorie varchar(50)
icone varchar(50)
ordre int
actif tinyint(1)

📊 session

3 colonne(s)
id int [PRI] auto_increment
user int [MUL]
temps datetime

📊 social_interactions

6 colonne(s)
id int [PRI] auto_increment
user_id int [MUL]
target_type enum('photo','review','comment')
target_id int
interaction_type enum('like','helpful','share','report')
created_at timestamp DEFAULT_GENERATED

📊 suivi_clients

10 colonne(s)
id int [PRI] auto_increment
operateur varchar(200)
communication varchar(200)
memo text
date_contact date
idSejour int
idPelerin int
date_rappel date
idDevis int
action tinyint

📊 taches

6 colonne(s)
id int [PRI] auto_increment
contact varchar(100)
memo text
etat int
dateTache date
titre varchar(1000)

📊 tasking

4 colonne(s)
id int [PRI] auto_increment
idTasking int
idSejourPelerin int
groupe varchar(100)

📊 tasking_sejour

4 colonne(s)
id int
idTasking int
idSejour varchar(100)
libelle varchar(200)

📊 testimonials

16 colonne(s)
id int [PRI] auto_increment
author_name varchar(100)
location varchar(100)
country_code varchar(10) [MUL]
text text
rating tinyint(1) [MUL]
package_id int [MUL]
guide_id int [MUL]
year int
trip_date date
is_approved tinyint(1) [MUL]
is_featured tinyint(1)
is_verified tinyint(1)
display_order int
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 transfert

9 colonne(s)
id int [PRI] auto_increment
id_zone int [MUL]
compagnie text
contact text
telephone text
email text
remarque text
image text
web text

📊 transfert_tarifs

8 colonne(s)
id int [PRI] auto_increment
idTransfert int
vehicule varchar(200)
nbPax int
tarifs float
description text
trajet int
image varchar(200)

📊 transferts_routes

6 colonne(s)
id int [PRI] auto_increment
id_destination_depart int [MUL]
id_destination_arrivee int [MUL]
distance_km int
duree_minutes int
actif tinyint(1)

📊 transferts_tarifs

7 colonne(s)
id int [PRI] auto_increment
id_route int [MUL]
id_vehicule int
tarif decimal(10,2)
date_debut date [MUL]
date_fin date
actif tinyint(1)

📊 transferts_zones

8 colonne(s)
id int [PRI] auto_increment
nom varchar(100)
code varchar(10) [UNI]
description varchar(255)
actif tinyint(1)
ordre int
created_at datetime DEFAULT_GENERATED
updated_at datetime DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 transferts_zones_villes

5 colonne(s)
id int [PRI] auto_increment
id_zone int [MUL]
ville varchar(100)
ville_normalise varchar(100) [MUL]
created_at datetime DEFAULT_GENERATED

📊 translation_stats

7 colonne(s)
id int [PRI] auto_increment
language_code varchar(5) [UNI]
total_texts int
translated_texts int
pending_texts int
completion_percentage decimal(5,2)
last_updated timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 translations

16 colonne(s)
id int [PRI] auto_increment
text_key varchar(32) [UNI]
text_original text
text_en text
text_fr text
text_ar text
text_de text
text_tr text
is_html tinyint(1)
context varchar(50) [MUL]
page_url varchar(255)
status enum('pending','translated','verified') [MUL]
usage_count int
last_used datetime
created_at timestamp DEFAULT_GENERATED
updated_at timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 user_activity_log

9 colonne(s)
id int [PRI] auto_increment
user_id int [MUL]
activity_type enum('view','like','share','booking','search','filter','click')
item_type enum('package','hotel','destination','user','article')
item_id int
metadata longtext
session_id varchar(100)
ip_address varchar(45)
created_at timestamp [MUL] DEFAULT_GENERATED

📊 user_badges

5 colonne(s)
id int [PRI] auto_increment
user_id int [MUL]
badge_id int [MUL]
earned_at timestamp DEFAULT_GENERATED
is_displayed tinyint(1)

📊 user_booking_sync

7 colonne(s)
id int [PRI] auto_increment
user_id int [MUL]
booking_id int [MUL]
client_id int [MUL]
booking_type enum('hotel','sejour')
synced_at timestamp DEFAULT_GENERATED
sync_method enum('auto_registration','manual','admin')

📊 user_privacy_settings

7 colonne(s)
user_id int [PRI]
show_purchases tinyint(1)
show_liked_packages tinyint(1)
allow_search_by_email tinyint(1)
show_followers tinyint(1)
show_following tinyint(1)
allow_recommendations tinyint(1)

📊 user_travel_photos

9 colonne(s)
id int [PRI] auto_increment
user_id int [MUL]
booking_id int
destination varchar(100)
photo_url varchar(255)
caption text
likes_count int
is_public tinyint(1)
created_at timestamp DEFAULT_GENERATED

📊 user_travel_preferences

13 colonne(s)
id int [PRI] auto_increment
user_id int [UNI]
preferred_destinations longtext
preferred_months longtext
budget_range_min decimal(10,2)
budget_range_max decimal(10,2)
preferred_hotel_stars longtext
travel_style enum('luxury','comfort','budget','mixed')
group_size_preference enum('solo','couple','family','group')
interests longtext
dietary_requirements longtext
accessibility_needs longtext
last_updated timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 users

42 colonne(s)
id int [PRI] auto_increment
client_id int [MUL]
userIdentifier varchar(150) [UNI]
name text
pseudo varchar(100)
email text
email_gestion varchar(500)
password text
location text
mobile text
dp text
status int
joinDate text
agence varchar(200)
tel_agence varchar(50)
date_lastvisite date
iata varchar(100)
tva varchar(100)
prenom varchar(100)
adresse varchar(100)
ville varchar(100)
cp varchar(100)
pays varchar(100)
logo varchar(500)
droit varchar(50)
role varchar(50) [MUL]
gmap varchar(800)
paiementTotal float
factureTotal float
restant int
lang varchar(10)
lat varchar(10)
profile_picture varchar(255)
bio text
points int
level int
code_parrainage_utilise varchar(20)
parraine_par int
badge_count int
date_adhesion datetime DEFAULT_GENERATED
is_verified tinyint(1)
last_activity timestamp DEFAULT_GENERATED on update CURRENT_TIMESTAMP

📊 users_agence

7 colonne(s)
id int [PRI] auto_increment
idUsers int
email varchar(200) [UNI]
password text
pseudo varchar(200)
droit varchar(100)
status int

📊 v_bookings_with_sync_status

17 colonne(s)
booking_id int
client_id int
email varchar(200)
client_prenom varchar(500)
client_nom varchar(500)
hotel_nom varchar(500)
hotel_ville varchar(500)
checkin date
checkout date
coutSejour float
booking_status int
sync_status varchar(24)
user_id int
user_prenom varchar(100)
user_name text
sync_method enum('auto_registration','manual','admin')
synced_at timestamp DEFAULT_GENERATED

📊 v_pelerins_dates_globales

19 colonne(s)
multi_client_id int
idClient int
idSejour int
nom varchar(100)
prenom varchar(100)
civilite varchar(4)
date_naissance date
passeport varchar(190)
confirm tinyint
email varchar(200)
tel_mobile varchar(50)
agence varchar(150)
typeDepart varchar(50)
sejourLibelle varchar(255)
typeChambre varchar(50)
idAgence int
idSejourDate int
dateDebut date
dateFin date

📊 v_user_booking_stats

9 colonne(s)
user_id int
prenom varchar(100)
name text
email text
total_reservations_synced bigint
auto_synced bigint
manual_synced bigint
first_sync_date timestamp
last_sync_date timestamp

📊 ville

3 colonne(s)
id int
ville varchar(300)
idPays int

📊 ville_sejour

5 colonne(s)
id int [PRI] auto_increment
nom varchar(100)
idPays int [MUL]
actif tinyint(1)
ordre int

📊 villes_depart

6 colonne(s)
id int [PRI] auto_increment
nom varchar(100) [UNI]
pays varchar(100)
actif tinyint(1)
ordre int
created_at timestamp DEFAULT_GENERATED

📊 visa_pelerin

17 colonne(s)
id int
uid int
idVisas int
idPelerin int
montant float
restant float
typePaiement varchar(100)
remiseEuros float
remisePercent float
prix float
confirm tinyint
dateDepart date
dateRetour date
creerpar varchar(100)
modifierpar varchar(100)
dateinscription date
note text

📊 visas

21 colonne(s)
id int [PRI] auto_increment
uid int
idClient int
groupe varchar(500)
dateDepart date
dateRetour date
villeDepart varchar(500)
villeRetour varchar(500)
billet text
hotels text
contact varchar(1000)
tel varchar(100)
email varchar(100)
coutVisa float
montant float
restant float
paiement float
note text
dateDemande date
nbVisa int
statut int

📊 visas_pelerin

4 colonne(s)
id int [PRI] auto_increment
uid int
idVisa int
idPelerin int

📊 vol_pelerin

17 colonne(s)
id int
uid int
idBookingVol int
idPelerin int
montant float
restant float
typePaiement varchar(100)
remiseEuros float
remisePercent float
prix float
confirm tinyint
dateDepart date
dateRetour date
creerpar varchar(100)
modifierpar varchar(100)
dateinscription date
note text