spartanLabour - Laravel Schema Designer

users

id increments
name string (255)
login string (50)
email string (255)
password string (255)
country_subdivision_code string (50)
city string (50)
postalCode string (50)
role_id ^FK integer
address string (50)
phone string (50)
timestamps timestamps

roles

id increments
libelle string (50)
permissions string (20)
timestamps timestamps

clients

id increments
nature string (30)
account_number string (50)
tax_number string (50)
contact_person string (50)
description text
user_id ^FK integer
timestamps timestamps

jobs

id increments
nature string (50)
tags string (50)
package_id ^FK integer
timestamps timestamps

events

id increments
job_id ^FK integer
name string (50)
description string (50)
schedule_event_id bigInteger
jobcode_id bigInteger
date_start date
date_end date
client_id ^FK integer
duration integer
timestamps timestamps

employes

id increments
hourly_rate decimal (8,2)
account_number string (50)
social_security_number string (50)
description text
user_id ^FK integer
timestamps timestamps

invoices

id increments
client_id ^FK integer
sum_value decimal (8,2)
statut string (20)
date date
currency decimal (8,2)
timestamps timestamps

event_employe

id increments
event_id ^FK integer
employe_id ^FK integer
timestamps timestamps

packages

id increments
libelle string (50)
description text
rate decimal (8,2)
employe_required integer
timestamps timestamps

invoicejobs

id increments
invoice_id ^FK integer
jobcode_id bigInteger
timestamps timestamps

payslips

id increments
jobcode_name string (50)
statut boolean
date date
sum_value decimal (8,2)
currency decimal (8,2)
employe_id ^FK integer
timestamps timestamps

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