Home
main
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
users
id
increments
name
string
(255)
phone
string
(255)
email
string
(255)
password
string
(255)
timestamps
timestamps
softDeletes
softDeletes
role_user
id
increments
user_id
integer
role_id
integer
timestamps
timestamps
softDeletes
softDeletes
roles
id
increments
name
string
(255)
display_name
string
(255)
description
string
(255)
timestamps
timestamps
softDeletes
softDeletes
user_id
integer
Contracts
id
increments
name
string
(255)
client_id
integer
emp
string
(255)
emp_national_id
string
(100)
notes
text
user_id
integer
timestamps
timestamps
softDeletes
softDeletes
Contract_sections
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
(255)
body
text
user_id
integer
visits
id
increments
city_id
integer
area_id
integer
address
string
(100)
contract_id
integer
Building_type
string
(100)
Building_owner_phone
string
(150)
client_id
integer
user_id
integer
timestamps
timestamps
softDeletes
softDeletes
visit_types
id
increments
name
string
(255)
description
text
timestamps
timestamps
softDeletes
softDeletes
user_id
integer
Clients
id
increments
name
string
(255)
address
string
(255)
city_id
integer
phone
string
(100)
email
string
(255)
commercial_id
string
(100)
defence_id
string
(100)
timestamps
timestamps
softDeletes
softDeletes
user_id
integer
area_id
integer
cities
id
increments
name
string
(255)
name_en
string
(255)
timestamps
timestamps
softDeletes
softDeletes
user_id
integer
settings
id
increments
name
string
(255)
phone1
string
(50)
phone2
string
(50)
Commercial_no
string
(100)
timestamps
timestamps
softDeletes
softDeletes
user_id
integer
Areas
id
increments
name
string
(255)
city_id
integer
note
string
(255)
timestamps
timestamps
softDeletes
softDeletes
user_id
integer
items
id
increments
name
string
(255)
purchasing_price
string
(50)
sell_price
string
(50)
picture
string
(255)
category_id
integer
timestamps
timestamps
softDeletes
softDeletes
user_id
integer
categories
id
increments
name
string
(255)
name_en
string
(255)
timestamps
timestamps
softDeletes
softDeletes
user_id
integer
bills
id
increments
client_id
integer
total
string
(20)
timestamps
timestamps
softDeletes
softDeletes
user_id
integer
bills_details
id
increments
bill_id
integer
item_id
integer
quantity
string
(10)
price
decimal
total
decimal
user_id
integer
timestamps
timestamps
softDeletes
softDeletes
log_system
id
increments
event
string
(255)
user_id
integer
timestamps
timestamps
softDeletes
softDeletes
Expenses
id
increments
timestamps
timestamps
softDeletes
softDeletes
expense_id
integer
amount
string
(10)
user_id
string
Expense_sections
id
increments
name
string
(255)
user_id
integer
timestamps
timestamps
softDeletes
softDeletes
devices
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
(255)
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01