test_chiffre - Laravel Schema Designer

customers

id increments
timestamps timestamps
name string (250)
phone string (13)
mail string (250)
img string (255)

projects

id increments
timestamps timestamps
name string (250)
description string (250)
customer_id ^FK integer

tasks

id increments
timestamps timestamps
name string (250)
description text
state_id ^FK integer
project_id ^FK integer

states

id increments
timestamps timestamps
name string (250)

assignements

id increments
timestamps timestamps
task_id ^FK integer
employee_id ^FK integer

reports

id increments
timestamps timestamps
description text
duration float
task_id ^FK integer
employee_id ^FK integer

employees

id increments
timestamps timestamps
lastname string (250)
firstname string (250)
mail string (250)
service_id ^FK integer
img string (255)
phone string (30)

services

id increments
timestamps timestamps
name string (250)
description text
img string (255)

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