alferp - Laravel Schema Designer

users

id increments
created_at timestamp
updated_at timestamp

projects

id increments
created_at timestamp
updated_at timestamp
name string
description longText
owner_id ^FK integer
task_rate integer
budget_hours integer
created_by ^FK integer
updated_by ^FK integer
status_id ^FK integer

tasks

id increments
created_at timestamp
updated_at timestamp
name string
description longText
responsible_id ^FK integer
created_by ^FK integer
updated_by ^FK integer
ticket_id ^FK integer
project_id ^FK integer
count_hours float
status_id ^FK integer

receipts

id increments
created_at timestamp
updated_at timestamp
created_by ^FK integer
updated_by ^FK integer
name string
description longText
total double
is_paid boolean
task_id ^FK integer

project_assigns

assign_to ^FK integer
project_id ^FK integer

tickets

id increments
created_at timestamp
updated_at timestamp
read boolean
project_id ^FK integer
created_by ^FK integer
updated_by ^FK integer
status_id ^FK integer

tracking_tasks

id increments
create_at datetime
update_at datetime
create_by ^FK integer
update_by ^FK integer
task_id ^FK integer
start_date datetime
end_date datetime
count_time float

status

id increments
created_at timestamp
updated_at timestamp
updated_by ^FK integer
created_by ^FK integer
name string
description longText
main boolean

categories

id increments
created_at timestamp
updated_at timestamp
created_by ^FK integer
updated_by ^FK integer
name string
description longText

topics

id increments
created_at timestamp
updated_at timestamp
created_by ^FK integer
updated_by ^FK integer
name string
description longText
category_id ^FK integer

files

id increments
topic_id ^FK integer
created_at timestamp
updated_at timestamp
name string
created_by ^FK integer
description longText
updated_by ^FK integer

metadata

id increments
created_at timestamp
updated_at timestamp
created_by ^FK integer
updated_by ^FK integer
position longText
title longText
social_status string
birth_date date
hiring_date date
education_level string
faculty string
military_status string
gender string
user_id ^FK integer

phones

id increments
created_at timestamp
updated_at timestamp
created_by ^FK integer
updated_by ^FK integer
phone string
description longText

addresses

id increments
created_at timestamp
updated_at timestamp
created_by ^FK integer
updated_by ^FK integer
address string
description longText

user_attributes

user_id ^FK integer
attribute_id ^FK integer
value string

workflows

id increments
created_at timestamp
updated_at timestamp
created_by ^FK integer
updated_by ^FK integer
name string
description longText
from_date date
to_date date
at_time time
how_many integer
every_number integer
every_type string

user_workflows

user_id ^FK integer
workflow_id ^FK integer

attendances

id increments
created_at timestamp
updated_at timestamp
created_by ^FK integer
updated_by ^FK integer
checkin timestamp
comment longText
checkout timestamp
user_id ^FK integer

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