urenregistratie - Laravel Schema Designer

project

id increments
client_id ^FK integer
user_id ^FK integer
name string (254)
timestamps timestamps
type integer
transfer string (254)
price string (30)
hour_price integer
support_hours smallInteger
support_frequency smallInteger
move_to string (254)
mail smallInteger
appendix string (254)
description text
process smallInteger
status tinyInteger
total_hours integer

component

id increments
name string (254)
timestamps timestamps
default tinyInteger

client

id increments
name string (254)
timestamps timestamps

component_project

id increments
project_id ^FK integer
component_id ^FK integer
minutes integer

log

id increments
client_id ^FK integer
project_id ^FK integer
component_id ^FK integer
user_id ^FK integer
date datetime
minutes integer
description text
timestamps timestamps

support

id increments
client_id ^FK integer
user_id ^FK integer
started_user_id ^FK integer
url string (254)
invoice smallInteger
message smallInteger
file string (254)
immediate tinyInteger
description text
timestamps timestamps

user

id increments
forename string (254)
surname string (254)
username string (254)
password string (256)
email string (254)
rememberToken rememberToken
timestamps timestamps

role

id increments
name string (254)
alias string (254)
timestamps timestamps

role_user

id increments
user_id ^FK integer
role_id ^FK integer

support_user

id increments
user_id ^FK integer
support_id ^FK integer
created_at timestamp
updated_at timestamp

project_link

id increments
project_id ^FK integer
domain string (254)
invision string (254)
todo string (254)

project_deadline

id increments
project_id ^FK integer
startdate date
deadline date
hard_deadline tinyInteger

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