dev manager - Laravel Schema Designer

team_members

id increments
timestamps timestamps
softDeletes softDeletes
user_id string
is_customer integer

projects

id increments
timestamps timestamps
name string (255)
customer_name string (255)
description longText

projects_milestones

id increments
timestamps timestamps
name string (255)
description longText
allocated_time string (255)

projects_jobs

id increments
timestamps timestamps
project_id integer
milestone_id integer
from_inquiries tinyInteger

allocated_ressources

id increments
by integer
timestamps timestamps
project_id integer
team_member_id integer
milestone_id integer
job_id string

project_inquiries

id increments
by integer
timestamps timestamps
project_id string
query longText
milestone_id integer
classifed tinyInteger

actions

id increments
timestamps timestamps
project_id integer
milestone_id integer
job_id integer
by integer
timespent float (16,2)
description longText

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