nwakeb - Laravel Schema Designer

users

id increments
role_id string
name string (50)
inform boolean
timestamps timestamps
is_logged_in boolean
softDeletes softDeletes

categories

id increments
name string (100)
timestamps timestamps
softDeletes softDeletes
name_en string (255)

types

id increments
category_id ^FK integer
name string (255)
name_en string (255)
timestamps timestamps
softDeletes softDeletes

priorities

id increments
name string (40)
timestamps timestamps
softDeletes softDeletes
name_en string (20)
color string (20)

notes

id increments
user_id ^FK integer
area_id ^FK integer
type_id ^FK integer
priority_id ^FK integer
violation_code string (50)
longitude string (255)
latitude string (255)
comment text
timestamps timestamps
softDeletes softDeletes
direction_id ^FK integer
cause string (150)
status enum
redirect boolean

areas

id increments
responsible string (150)
responsible_en string (150)
start_from string (50)
start_from_en string (50)
ends_at string (50)
ends_at_en string (50)
timestamps timestamps
softDeletes softDeletes
responsible_email string (150)

attachments

id increments
note_id ^FK integer
attachment_type_id integer
path string (255)
timestamps timestamps
softDeletes softDeletes

attachment_types

id increments
name string (15)
name_en string
timestamps timestamps
softDeletes softDeletes

resolved_notes

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

resolved_attachments

id increments
resolved_note_id ^FK integer
attachment_type_id ^FK integer
path string (255)
timestamps timestamps
softDeletes softDeletes

recommendations

id increments
user_id ^FK integer
responsible string (100)
longitude string (255)
latitude string (255)
comment text
timestamps timestamps
softDeletes softDeletes

recommendation_attachments

id increments
timestamps timestamps
softDeletes softDeletes
attachment_type_id ^FK integer
path string (150)
recommendation_id ^FK integer

directions

id increments
timestamps timestamps
softDeletes softDeletes
name string (50)
name_en string (50)

notes_log

id increments
user_id ^FK integer
note_id ^FK integer
timestamps timestamps
softDeletes softDeletes
status enum
due_date timestamp

login_logs

id increments
timestamps timestamps
user_id ^FK integer

months

id increments
timestamps timestamps
name string (50)
name_en string (50)
start_from string (50)
ends_at string (50)

weeks

id increments
timestamps timestamps
name string (50)
name_en string (50)
start_from string (50)
ends_at string (50)
month_id ^FK integer

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