Home
jetRoom
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
users
id
increments
first_name
string
(191)
last_name
string
(191)
email
string
(191)
email_verified_at
timestamp
country_code
string
(191)
phone
string
(191)
phone_verified_at
timestamp
password
string
(191)
image
string
(191)
is_active
tinyInteger
register_from
string
(191)
provider
string
provider_id
string
countries_id
json
languages
json
intersts
json
job_title
string
(191)
birthday
date
gender
enum
country_id
FK
bigInteger
city_id
FK
bigInteger
address
string
(191)
nickname
string
(191)
total_wallets
decimal
total_rates
float
total_points
decimal
timestamps
timestamps
softDeletes
softDeletes
phone_verifications
id
increments
phone
string
(191)
code
string
(6)
timestamps
timestamps
pages
id
increments
name
string
(191)
name_ar
string
(191)
description
text
description_ar
text
image
string
(191)
type
tinyInteger
is_active
boolean
timestamps
timestamps
softDeletes
softDeletes
questations
id
increments
question
string
(191)
question_ar
string
(191)
answer
text
answer_ar
text
is_active
boolean
timestamps
timestamps
softDeletes
softDeletes
articles
id
increments
title
string
(191)
title_ar
string
(191)
description
text
description_ar
text
image
string
(191)
timestamps
timestamps
contacts
id
increments
name
string
(191)
email
string
(191)
phone
string
(191)
subject
string
(191)
message
text
timestamps
timestamps
careers
id
increments
name
string
(191)
name_ar
string
(191)
description
text
description_ar
text
is_active
boolean
timestamps
timestamps
softDeletes
softDeletes
career_requests
id
increments
career_id
FK
bigInteger
country_id
bigInteger
first_name
string
(191)
last_name
string
(191)
email
string
(191)
phone
string
(191)
country_code
string
(191)
file
string
(191)
timestamps
timestamps
softDeletes
softDeletes
files
id
increments
name
string
(191)
path
string
(191)
fileable_id
bigInteger
fileable_type
string
(191)
is_active
boolean
periority
tinyInteger
timestamps
timestamps
softDeletes
softDeletes
countries
id
increments
name
string
(191)
name_ar
string
(191)
code
string
(5)
icon
string
(191)
is_active
boolean
timestamps
timestamps
softDeletes
softDeletes
favourites
id
increments
user_id
bigInteger
property_id
FK
bigInteger
timestamps
timestamps
softDeletes
softDeletes
cities
id
increments
name
string
(50)
name_ar
string
(191)
country_id
FK
bigInteger
is_active
boolean
timestamps
timestamps
softDeletes
softDeletes
settings
id
increments
name
string
(191)
name_ar
string
(191)
nav_logo
string
(191)
footer_logo
string
(191)
favicon
string
(191)
timestamps
timestamps
softDeletes
softDeletes
bookings
id
increments
user_id
FK
integer
property_id
FK
integer
reservation_id
FK
integer
invoice_id
FK
integer
remain
mediumInteger
pay_type
enum
total_price
decimal
timestamps
timestamps
softDeletes
softDeletes
notifications
id
increments
message
text
data
json
type
enum
timestamps
timestamps
softDeletes
softDeletes
notification_user
id
increments
user_id
FK
bigInteger
notification_id
FK
bigInteger
read_at
timestamp
timestamps
timestamps
points
id
increments
user_id
FK
bigInteger
booking_id
FK
bigInteger
amount
integer
timestamps
timestamps
softDeletes
softDeletes
wallets
id
increments
user_id
FK
bigInteger
point_id
FK
bigInteger
amount
decimal
timestamps
timestamps
softDeletes
softDeletes
rates
id
increments
user_id
FK
bigInteger
rateable_id
bigInteger
rateable_type
string
(191)
rate
tinyInteger
comment
text
type
string
(191)
is_active
boolean
timestamps
timestamps
softDeletes
softDeletes
features
id
increments
name
string
(191)
name_ar
string
(191)
type
string
(191)
is_active
boolean
timestamps
timestamps
softDeletes
softDeletes
properties
id
increments
name
string
(191)
type_id
FK
bigInteger
advantages_id
json
facilities_id
json
location
json
kitchen_details
json
rooms_details
json
bathroom_details
json
place_rules_ids
json
is_included
json
country_id
FK
integer
city_id
FK
integer
district_id
FK
bigInteger
area
float
tenant_count
tinyInteger
tenant_gender
enum
description_ar
text
description
text
jetroom_type
enum
is_updated
boolean
timestamps
timestamps
softDeletes
softDeletes
districts
id
increments
name
string
(191)
name_ar
string
(191)
city_id
FK
bigInteger
is_active
boolean
timestamps
timestamps
softDeletes
softDeletes
invoices
id
increments
reservation_id
FK
integer
property_id
FK
integer
price
decimal
total_price
decimal
tax
decimal
cleanup_fees
decimal
service_fees
decimal
hostable_fees
decimal
sale_code
decimal
points
mediumInteger
timestamps
timestamps
softDeletes
softDeletes
reservations
id
increments
number_of_guests
smallInteger
check_in_date
datetime
check_out_date
datetime
check_in_hours
smallInteger
check_out_hours
smallInteger
timestamps
timestamps
softDeletes
softDeletes
prices
id
increments
property_id
FK
bigInteger
type
enum
price
decimal
mid_week
decimal
end_week
decimal
cleaning_fees
decimal
service_visitor_fees
decimal
our_service_fees
decimal
deposit_fees
decimal
times
json
timestamps
timestamps
softDeletes
softDeletes
booking_terms
id
increments
property_id
FK
bigInteger
name
string
(191)
name_ar
string
(191)
timestamps
timestamps
softDeletes
softDeletes
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01