ZEDchantelle - Laravel Schema Designer

ouvriers

id increments
timestamps timestamps
matricule integer
nom string (100)
prenom string (100)
section string (20)

gammes

id increments
refGamme string (100)
nomGamme string (150)
dateGamme date
agentGamme string (100)
agentData string (100)
imageGamme binary
nbPaquet integer
idEtude ^FK integer

familles

id increments
timestamps timestamps
numFamille integer
designFamille string (250)

sousFamille

id increments
timestamps timestamps
numSsFamille integer
designSsFamille string (250)
numFamille ^FK integer

operations

id increments
timestamps timestamps
numOperation integer
tempsOperation string
designOperation string (250)
imageOperation binary
numSsFamille ^FK integer
typeOpt string
sys string

competances

id increments
timestamps timestamps
numOperation ^FK integer
competanceOuvrier string (1)
idOuvrier ^FK integer

optsGammes

id increments
idGamme ^FK integer
idOpts ^FK integer

Collections

idCollection increments
timestamps timestamps
refCollection string (100)
dateCollection string (50)

Lignes

idLigne increments
timestamps timestamps
refLigne string (100)
nomLigne string (100)
dateLigne string (50)
numCollection ^FK integer

SousLignes

idSsLigne increments
timestamps timestamps
refSsLigne string (100)
idLigne ^FK integer

Etudes

idEtude increments
timestamps timestamps
numEtude integer
dateEtude string (50)
idSsLigne ^FK integer

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