GMarche - Laravel Schema Designer

Contrats

id increments
timestamps timestamps
softDeletes softDeletes
date_debut date
date_fin date
Total float
designation string (250)
Referance string (250)
Notes string (250)

commands

id increments
timestamps timestamps
softDeletes softDeletes
id_contract ^FK bigInteger
date_debut date
date_fin date
Total float
designation string (250)
fichiers string (250)
Referance string (250)
status enum

Operations

id increments
timestamps timestamps
softDeletes softDeletes
date_debut date
command_id ^FK bigInteger
date_fin date
status enum
team_id ^FK bigInteger
secture_id ^FK bigInteger
type enum
Position string (250)

Teams

id increments
timestamps timestamps
softDeletes softDeletes
name string (250)

secteures

id increments
timestamps timestamps
softDeletes softDeletes
color string (250)
notes string (250)
Positions string (250)

sous_operations

id increments
timestamps timestamps
softDeletes softDeletes
date_realisation date
Notes string (250)
opertaion_id ^FK bigInteger

Type_Poste

id increments
timestamps timestamps
softDeletes softDeletes
Label string (250)

Workers

id increments
timestamps timestamps
softDeletes softDeletes
email string (250)
phone string (250)
photo string
fichiers string
team_id ^FK bigInteger
type_poste_id ^FK bigInteger

Produits

id increments
timestamps timestamps
softDeletes softDeletes
Referance string (250)
nom string (250)
Description string (250)
Unite string (250)
Prix float
Qte integer
category_id ^FK bigInteger

Produits_categories

id increments
timestamps timestamps
softDeletes softDeletes
Label string (250)

sous_operation_produits

id increments
timestamps timestamps
softDeletes softDeletes
id_produit ^FK bigInteger
sous_operation_id ^FK bigInteger

StockOperations

id increments
timestamps timestamps
softDeletes softDeletes
type enum
Label string (250)
Referance string (250)
Source_destination string (250)
user_id ^FK bigInteger

users

id bigIncrements
timestamps timestamps
username string (30)
email string (100)
password string (100)
salt string (30)
register_ip string (15)
forget_token string (100)
active_token string (100)
boomt_id tinyInteger

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