saiberman - Laravel Schema Designer

projects

id increments
timestamps timestamps
identifier string (255)
name string (255)
start_date datetime
end_date datetime
created_by_user_id string
status_id string
description longText
closed_date datetime
status_reason string (255)
note longText
project_type_id integer
tracker_issues tinyInteger
tracker_support tinyInteger
gitlab tinyInteger
customer_id string
priority_id integer

project_status

id increments
timestamps timestamps
name string
icon string
color string

project_documents

id increments
timestamps timestamps
filename string (512)
file_type string (255)
file_size bigInteger
created_by_user_id string
task_id integer
project_id integer

project_tasks

id increments
timestamps timestamps
short_title string (512)
description longText
progress float
pinned_note longText
created_by_user_id integer
task_to_user_id integer
status_id integer
parent_of integer
child_of integer
priority_id integer

tasks_status

id increments
timestamps timestamps
name string (255)
icon string
color string

actions

id increments
timestamps timestamps
task_id integer
time_spent float (16,2)
action_type_id integer
billable tinyInteger
created_by_user_id integer
description longText
action_date datetime

action_types

id increments
timestamps timestamps
name string (255)
icon string
color string

project_ts_tickets

id increments
timestamps timestamps
project_id integer
ticket_number string (255)

reminders

id increments
timestamps timestamps
task_id integer
project_id integer
sent tinyInteger
recipient_user_id string
created_by_user_id integer
description longText

external_members

id increments
timestamps timestamps
email string
name string (255)
password string (255)
role longText
phone1 string
phone2 string
project_id integer

project_types

id increments
timestamps timestamps
name string
icon string

priority_levels

id increments
timestamps timestamps
name string (255)
forecolor string
background_color string

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