Home
nxbPM
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
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