freelance - Laravel Schema Designer

users

id increments
name string (25)
firstname string (25)
username string (50)
mail string (50)
password string (50)
address string (100)
phone integer
role string (10)
timestamps timestamps
remember_token string (255)

admin

id increments
timestamps timestamps
user_id ^FK integer

freelancer

id increments
timestamps timestamps
user_id ^FK integer
photo_url string (150)
cv_url string (255)

company

id increments
timestamps timestamps
SIRET bigInteger
denomination string (25)
pic_url string (150)
user_id ^FK integer

cdc

id increments
deadline date
timestamps timestamps
url_cdc string (20)
company_id ^FK integer

ability

id increments
descriptiton text
categorie string (20)
timestamps timestamps
id_freelancer ^FK integer

message

id increments
type string (25)
subject string (50)
content text
user_id ^FK integer
freelancer_id ^FK integer
company_id ^FK integer
project_id ^FK integer
timestamps timestamps

project

id increments
price float (8,2)
description text
timestamps timestamps
compagny_id ^FK integer
cdc_id ^FK integer
title string (100)

offre

id increments
timestamps timestamps
message text
freelancer_id ^FK integer
project_id ^FK integer

test

id increments
description text
url string (255)
timestamps timestamps
ability_id ^FK integer

result

id increments
grade integer
comment text
timestamps timestamps
test_id ^FK integer
freelancer_id ^FK integer

contrat

id increments
timestamps timestamps
freelancer_id ^FK integer
company_id ^FK integer
offre_id ^FK integer
project_id ^FK integer

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