mapper - Laravel Schema Designer

users

id increments
timestamps timestamps
softDeletes softDeletes
employee_id string (100)
first_name string (255)
last_name string (255)
password string (255)
status tinyInteger
date_of_birth date
personal_email string (100)
contact string (20)
resume string (255)
address text
token string (255)
date_of_joining date
remember_token string (100)
head integer

locations

id increments
timestamps timestamps
softDeletes softDeletes
locations string (255)
status tinyInteger
alias_name string (255)

applications

id increments
timestamps timestamps
softDeletes softDeletes
application_name string (255)
moduleid integer
status tinyInteger
route string (255)
icon string (255)

permissions

id increments
timestamps timestamps
softDeletes softDeletes
userid ^FK integer
locationid ^FK integer
applicationid ^FK integer

modules

id increments
timestamps timestamps
module string (255)
status tinyInteger
icon string (100)
softDeletes softDeletes

metrics

id increments
timestamps timestamps
softDeletes softDeletes
metric_name string (255)
alias string (100)
status tinyInteger

Equipment

id increments
timestamps timestamps
softDeletes softDeletes
equipment_name string (255)
alias string (255)
metricid integer
status tinyInteger

equipmentModels

id increments
timestamps timestamps
equipmentid integer
equipment_model_name string (255)
alias string
spec_path string (255)
status tinyInteger
softDeletes softDeletes
capacity float
manufacturer integer

vendors

id increments
timestamps timestamps
softDeletes softDeletes
company_name string (255)
category string (255)
contact_person string (255)
address text
phone string (100)
fax string (100)
email string (100)
location string (255)
tin_no string (255)
status tinyInteger

assets

id increments
timestamps timestamps
softDeletes softDeletes
location integer
model integer
model_supplier integer
asset_code string
alias string
deployment_date date
commisioning_date date
status tinyInteger

tranferAssets

id increments
timestamps timestamps
softDeletes softDeletes
locationid integer
modelid integer
userid integer
status tinyInteger

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