le_transporteur - Laravel Schema Designer

chauffeurs

id increments
type_chauffeur_id bigInteger
mon_bedou_id bigInteger
photo string (255)
nom_chauffeur text
prenom_chauffeur text
lieu_habitation string
contact_chauffeur string
permis string
cni string (100)
password string
latittude float (8,12)
longitude float (8,12)
softDeletes softDeletes
timestamps timestamps

clients

id increments
nom_client string
prenom_client string
contact string (12)
email string (255)
password string
latittude float (8,12)
longitude float (8,12)
softDeletes softDeletes
timestamps timestamps

vehicules

id increments
modele_id bigInteger
chauffeur_id bigInteger
type_vehicule_id integer
immatriculation string
couleur string
numero_vente_technique string
date_delivrance date
date_expiration date
softDeletes softDeletes
timestamps timestamps

type_vehicules

id increments
libelle string
softDeletes softDeletes
timestamps timestamps

type_chauffeurs

id increments
libelle string
softDeletes softDeletes
timestamps timestamps

offres

id increments
libelle string
softDeletes softDeletes
timestamps timestamps

commandes

id increments
client_id integer
trajet_id bigInteger
tarif_id integer
payement_id bigInteger
montant integer
statut boolean
montant_commission integer
softDeletes softDeletes
timestamps timestamps

code_promos

id increments
client_id bigInteger
code string
pourcentage float
statut boolean
date_debut datetimeTz
date_expiration datetimeTz
softDeletes softDeletes
timestamps timestamps

trajets

id increments
commission_id bigInteger
type_trajet_id integer
client_id integer
vehicule_id integer
tarif_id integer
libelle string
point_depart string
point_arrive string
softDeletes softDeletes
timestamps timestamps

type_trajets

libelle string
id increments
softDeletes softDeletes
timestamps timestamps

notations

id increments
chauffeur_id bigInteger
trajet_id integer
libelle string
nbr_etoile tinyInteger
softDeletes softDeletes
timestamps timestamps

mon_bedous

id increments
etat_bedou boolean
softDeletes softDeletes
timestamps timestamps

zone_specifiques

id increments
libelle string
latitude float (8,12)
longitute float (8,12)
rayon double (5,2)
softDeletes softDeletes
timestamps timestamps

notification_chauffeurs

id increments
chauffeur_id bigInteger
message text
read boolean
softDeletes softDeletes
timestamps timestamps

payements

id increments
type_paiement_id integer
trajet_id integer
statut boolean
softDeletes softDeletes
timestamps timestamps

type_payements

id increments
libelle string
softDeletes softDeletes
timestamps timestamps

bonus_chauffeurs

id increments
chauffeur_id integer
libelle string
pourcentage_reduction float
softDeletes softDeletes
timestamps timestamps

tarifs

id increments
unite string
montant float
type_vehicule_id integer
softDeletes softDeletes
timestamps timestamps

modeles

id increments
marque_id bigInteger
libelle string
softDeletes softDeletes
timestamps timestamps

marques

id increments
libelle string
softDeletes softDeletes
timestamps timestamps

vehicule_offres

id increments
vehicule_id bigInteger
offre_id bigInteger
softDeletes softDeletes
timestamps timestamps

prise_en_charges

id increments
timestamps timestamps
softDeletes softDeletes

vehicule_zones

id increments
vehicule_id bigInteger
zone_specifique_id bigInteger
softDeletes softDeletes
timestamps timestamps

parametres

id increments
pourc_commission smallInteger
softDeletes softDeletes
timestamps timestamps

notification_clients

id increments
client_id bigInteger
message text
read boolean
softDeletes softDeletes
timestamps timestamps