nxbPM - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
firstname string (10)
lastname string (10)
username string (10)
email string (50)
employeeID integer
password string (255)
confirmation_code string
remember_token string
status enum

projects

id increments
timestamps timestamps
softDeletes softDeletes
name string (20)
url string (100)
repositories_id ^FK integer
startdate date
enddate string

repositories

id increments
timestamps timestamps
softDeletes softDeletes
url string (200)
username string (15)
password string (25)
project_id ^FK integer
type string

sprints

id increments
timestamps timestamps
softDeletes softDeletes
name string (10)
startdate date
enddate date
project_id ^FK integer

tasks

id increments
timestamps timestamps
softDeletes softDeletes
parent_id integer
predecessor_id integer
successor_id integer
name string (20)
description string
startdate date
enddate date
priority enum
stauts enum
tag ^FK integer
duedate date
createddate date
sprint_id ^FK integer
project_id ^FK integer

tags

id increments
timestamps timestamps
softDeletes softDeletes
name string

comments

id increments
timestamps timestamps
softDeletes softDeletes
task_id ^FK integer
description text
user_id ^FK integer

attachments

id increments
timestamps timestamps
softDeletes softDeletes
description string
file string
task_id ^FK integer
user_id ^FK integer

task_history

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
task_id ^FK integer
description string

wiki

id increments
timestamps timestamps
softDeletes softDeletes
project_id ^FK integer
attachment string
revision string
user_id ^FK integer
description text

roles

id increments
timestamps timestamps
softDeletes softDeletes
name string

users_projects

id increments
timestamps timestamps
softDeletes softDeletes
user_id ^FK integer
project_id ^FK integer

assigned_roles

id increments
timestamps timestamps
softDeletes softDeletes
role_id ^FK integer
user_id ^FK integer

permissions

id increments
timestamps timestamps
softDeletes softDeletes
name string
description string

permission_role

id increments
timestamps timestamps
softDeletes softDeletes
role_id ^FK integer
permission_id ^FK integer

password_reminders

id increments
timestamps timestamps
softDeletes softDeletes
email string
token string

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