devaza - Laravel Schema Designer

fournisseurs

id increments
timestamps timestamps
softDeletes softDeletes
Nom string (50)
Tele string (50)
Ice string (50)
Email string (100)
Adresse string (200)

vehicules

id increments
timestamps timestamps
softDeletes softDeletes
Matricule string (20)
Ref string (20)
nbPlace string
type string (50)

employes

id increments
timestamps timestamps
softDeletes softDeletes
Phone string (15)
Cnss string (50)
type_employment string (50)
cne string
gender string (20)

charge_vehicules

id increments
timestamps timestamps
softDeletes softDeletes
Vehicule_id ^FK bigInteger
Description text
Prix decimal (6,2)
payment_type string (50)

services

id increments
timestamps timestamps
softDeletes softDeletes
Type_service_id ^FK bigInteger
ville_depart string
ville_arriver string
fornisseur_id ^FK bigInteger
note string (300)
prix float
is_paid boolean
designation string
description text

services_types

id increments
timestamps timestamps
softDeletes softDeletes
Nom string

vehicule_employes

id increments
timestamps timestamps
employe_id ^FK bigInteger
vehecule_id ^FK bigInteger

service_vehicules

id increments
timestamps timestamps
vehicule_id ^FK bigInteger
service_id ^FK bigInteger
date_debut datetime
date_fin datetime

factures

id increments
timestamps timestamps
idService ^FK bigInteger
isPrinted boolean
company_id bigInteger

companies

id increments
timestamps timestamps
softDeletes softDeletes
nom string (30)
user_id bigInteger
logo string (250)
ice string (15)
pack_id ^FK bigInteger
is_suspended ^FK bigInteger

packs

id increments
nom string (15)
prix decimal (8,2)
timestamps timestamps
softDeletes softDeletes

suspended_accounts

id increments
company_id ^FK bigInteger
timestamps timestamps
softDeletes softDeletes

Laravel Schema Designer v0.7.1 follow me on twitter @okyn01