unitdb - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
fname string (100)
lname string (100)
role enum
email string (255)
salt string (255)
password string (255)
company_id ^FK integer

companies

id increments
timestamps timestamps
softDeletes softDeletes
company_name string (100)
addr_line_1 string (255)
addr_line_2 string (255)
website string (255)
email string (255)
phone_no string (30)

locations

id increments
timestamps timestamps
softDeletes softDeletes
location_name string (100)
addr_line_1 string (255)
addr_line_2 string (255)
company_id ^FK integer

units

id increments
timestamps timestamps
softDeletes softDeletes
unit_name string (100)
device_code string (255)
company_id ^FK integer
location_id ^FK integer
pass_key string (255)
email string (255)
no_of_cam smallInteger

unit_logs

id increments
unit_id ^FK integer
company_id ^FK integer
location_id ^FK integer
action_type string (100)
action_text text
services string (255)
timestamps timestamps

unit_images

id increments
unit_id ^FK integer
group_id ^FK integer
image_url string (100)
softDeletes softDeletes
timestamps timestamps

unit_groups

id increments
unit_id ^FK integer
timestamps timestamps

unit_status_logs

id increments
timestamps timestamps
unit_id ^FK bigInteger

unit_error_logs

id increments
timestamps timestamps
unit_id integer
message text
unit_time datetimeTz
error_meta text

unit_schedules

id increments
timestamps timestamps
softDeletes softDeletes
unit_id ^FK integer
name string (100)
set_on string (30)
set_to string (255)

settings

id increments
timestamps timestamps
set_key string
set_value string
set_device_type string

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