Home
asset
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
asset_categorys
id
increments
name
string
(100)
short_name
string
(20)
status
integer
routine_interval
integer
timestamps
timestamps
asset_items
id
increments
name
string
(100)
short_name
string
(20)
category_id
FK
integer
status
integer
timestamps
timestamps
assets
id
increments
team_id
FK
integer
category_id
FK
integer
item_id
FK
integer
building_id
FK
integer
floor_id
FK
integer
room_id
FK
integer
identifier
string
(100)
code
string
(15)
name
string
(100)
model
string
(100)
picture
string
(200)
price
integer
qty
integer
status
integer
description
text
timestamps
timestamps
buildings
id
increments
team_id
FK
integer
code
string
(15)
name
string
(100)
description
text
status
integer
timestamps
timestamps
floors
id
increments
building_id
FK
integer
code
string
(10)
name
string
(15)
status
integer
timestamps
timestamps
rooms
id
increments
code
string
(15)
floor_id
FK
integer
name
string
(50)
status
integer
description
text
timestamps
timestamps
teams
city
string
(50)
id
increments
name
string
(100)
legal_name
string
(30)
agreement_no
string
(20)
agreement_start_date
date
agreement_end_date
date
status
integer
address
text
country
string
(50)
state
string
(50)
zipcode
integer
timestamps
timestamps
services
id
increments
team_id
FK
integer
code
string
(15)
name
string
(50)
pic_name
string
(50)
pic_phone
string
(20)
pic_email
string
(30)
description
text
status
integer
timestamps
timestamps
channels
id
increments
team_id
FK
integer
code
string
(50)
name
string
(50)
pic_name
string
(50)
pic_phone
string
(20)
pic_email
string
(30)
description
text
status
integer
timestamps
timestamps
users
id
increments
channel_id
FK
integer
name
string
(50)
email
string
(30)
email_is_verified
integer
email_verification_code
string
(15)
msisdn
string
(20)
birthdate
date
gender
integer
regist_token
string
(250)
code
string
(15)
role_id
FK
integer
status
integer
photo
string
(150)
etc
text
password
string
(200)
login_type
integer
timestamps
timestamps
agents
id
increments
service_id
FK
integer
timestamps
timestamps
admins
id
increments
team_id
FK
integer
username
string
(50)
password
string
(200)
email
string
(30)
status_admin
integer
role_id
integer
status
integer
timestamps
timestamps
roles
id
increments
name
string
(100)
status
integer
role_group_id
FK
integer
uri
string
(50)
is_public
integer
read
integer
create
integer
update
integer
delete
integer
timestamps
timestamps
work_orders
id
increments
title
string
(100)
priority
string
(10)
asset_id
FK
integer
user_id
FK
integer
description
text
status_order
integer
status
integer
due_date
date
timestamps
timestamps
task_work_orders
id
increments
work_order_id
FK
integer
name
string
(100)
description
text
status_task
integer
status
integer
photo
string
(100)
timestamps
timestamps
parts
id
increments
name
string
(100)
description
text
price
integer
code
string
(50)
status
integer
type
string
(55)
qty
integer
asset_id
FK
integer
photo
string
(100)
model
string
(10)
timestamps
timestamps
modules
id
increments
name
string
(50)
short_name
string
status
integer
timestamps
timestamps
role_groups
id
increments
name
string
(50)
short_name
string
(10)
status
integer
timestamps
timestamps
user_modules
id
increments
timestamps
timestamps
user_id
FK
integer
module_id
FK
integer
role_group_id
FK
integer
task_parts
id
increments
part_id
FK
integer
task_work_id
FK
integer
qty
integer
status_part
integer
status
integer
timestamps
timestamps
comment_wos
id
increments
work_order_id
FK
integer
user_id
FK
integer
description
text
status
integer
photo
string
(100)
is_read
integer
timestamps
timestamps
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01