Home
adpv
Fork
Export all
Schema
Model
Controller
Seeding
Form
Laravel 4.2
Add to favorites
Comments (0)
users
id
increments
UUID
string
timestamps
timestamps
softDeletes
softDeletes
email
string
password
string
image_id
FK
integer
roles
id
increments
name
string
description
string
permissions
id
increments
metadata_id
FK
integer
users_roles
id
increments
timestamps
timestamps
user_id
FK
integer
rol_id
FK
integer
roles_permissions
id
increments
role_id
FK
integer
permission_id
FK
integer
categories
id
increments
timestamps
timestamps
parent_category_id
FK
integer
metadata_id
FK
integer
alerts
id
increments
timestamps
timestamps
softDeletes
softDeletes
primary_color
string
secondary_color
string
priority
integer
metadata_id
FK
integer
layout_id
FK
integer
notifications_users
id
increments
timestamps
timestamps
softDeletes
softDeletes
notification_id
FK
integer
user_id
FK
integer
metadata_custom
FK
integer
view
boolean
user_appdata
id
increments
timestamps
timestamps
validate
boolean
imported
boolean
confirmation_code
string
user_id
FK
integer
level_id
FK
integer
newsletter
boolean
interests
id
increments
softDeletes
softDeletes
metadata_id
FK
integer
formats
id
increments
timestamps
timestamps
parent_format_id
FK
integer
metadata_id
FK
integer
countries
id
increments
metadata_id
FK
integer
states
id
increments
metadata_id
FK
integer
cities
id
increments
metadata_id
FK
integer
supports
id
increments
timestamps
timestamps
softDeletes
softDeletes
category_id
FK
integer
language_id
FK
integer
billing_data_id
FK
integer
image_id
FK
integer
metadata_id
FK
integer
categories_formats
category_id
integer
format_id
integer
languages
id
increments
metadata_id
FK
integer
fields_formats
format_id
string
field_id
FK
integer
required
string
zones
id
increments
metadata_id
FK
integer
users_logins
id
increments
timestamps
timestamps
ip
string
referrer
string
user_id
FK
integer
banners
id
increments
timestamps
timestamps
img_id
FK
integer
metadata_id
FK
integer
sessions
id
increments
timestamps
timestamps
offers
id
increments
timestamps
timestamps
softDeletes
softDeletes
date_start
datetime
date_end
datetime
date_text
string
stock
integer
support_id
FK
integer
format_id
FK
integer
image_id
FK
integer
contracttype_id
FK
integer
metadata_id
FK
integer
price_id
FK
integer
fields
id
increments
type
string
metadata_id
FK
integer
demographics_index
id
increments
timestamps
timestamps
softDeletes
softDeletes
budgets
id
increments
timestamps
timestamps
softDeletes
softDeletes
user_id
FK
integer
tags
id
increments
metadata_id
FK
integer
support_tags
support_id
FK
integer
tag_id
FK
integer
support_contacts
id
increments
timestamps
timestamps
softDeletes
softDeletes
contacts
id
increments
timestamps
timestamps
softDeletes
softDeletes
name
string
surname
string
position
string
country_id
string
state_id
string
city_id
string
address
string
postal_code
string
email
string
web
string
billing_datas
id
increments
timestamps
timestamps
softDeletes
softDeletes
registered_name
string
email
string
phone
string
country_id
FK
integer
state_id
FK
integer
address
string
postal_code
string
identification_number
string
payment_method_id
FK
integer
ages
id
increments
softDeletes
softDeletes
metadata_id
FK
integer
conditions
id
increments
softDeletes
softDeletes
metadata_id
FK
integer
offers_tags
offer_id
FK
integer
softDeletes
softDeletes
tag_id
FK
integer
audiences
id
increments
timestamps
timestamps
metadata_id
FK
integer
files
id
increments
timestamps
timestamps
path
string
extension
string
image
boolean
contract
boolean
invoice
boolean
equipment
boolean
metadata_id
FK
integer
user_id
FK
integer
sepa
boolean
images_supports
id
increments
image_id
FK
integer
support_id
FK
integer
cover
boolean
offer_status
id
increments
timestamps
timestamps
softDeletes
softDeletes
offer_id
FK
integer
status_id
FK
integer
status
id
increments
metadata_id
FK
integer
settings
id
increments
timestamps
timestamps
softDeletes
softDeletes
commission
string
due_date
string
price_id
FK
integer
alert_time
string
current_users_alert
integer
maintenance
boolean
default_invoice_type_id
FK
integer
user_adevertiser_config
id
increments
timestamps
timestamps
user_id
FK
integer
commission
string
due_date
string
discount_id
FK
integer
price_id
FK
integer
comments
text
events
timestamps
timestamps
id
increments
event_type
FK
integer
user_id
FK
integer
stages
id
increments
metadata_id
FK
integer
stage_supports
timestamps
timestamps
support_id
FK
integer
stage_id
FK
integer
payment_methods
id
increments
metadata_id
FK
integer
contact_phones
id
increments
timestamps
timestamps
softDeletes
softDeletes
contact_id
FK
integer
phone
string
services
id
increments
timestamps
timestamps
softDeletes
softDeletes
metadata_id
FK
integer
price_id
FK
integer
format_id
FK
integer
metadata_values
id
increments
timestamps
timestamps
softDeletes
softDeletes
metadata_id
FK
integer
locale_id
FK
integer
title
string
description
text
text
text
label
string
value
string
alt
string
name
string
price
id
increments
auto_currency
boolean
default_discount
FK
integer
default_price_value
FK
integer
discounts
id
increments
discount
decimal
(8,2)
lastminute
decimal
(8,2)
premium
decimal
(8,2)
active
string
price_id
FK
integer
locales
id
increments
metadata_id
FK
integer
metadata
id
increments
code
string
internal_note
text
default_value
FK
integer
active
boolean
private
boolean
slug
string
offer_stages
id
increments
timestamps
timestamps
stage_id
FK
integer
offer_id
FK
integer
user_movements
id
increments
timestamps
timestamps
user_id
FK
integer
amount
decimal
(14,4)
spending
boolean
entry
boolean
price_values
id
increments
price
decimal
(12,4)
premium
decimal
(12,4)
lastminute
decimal
(12,4)
price_id
FK
integer
currency_id
FK
integer
offer_audiences
offer_id
FK
integer
audience_id
FK
integer
support_audience
support_id
FK
integer
audience_id
FK
integer
currencies
id
increments
metdata_id
FK
integer
searches
id
increments
timestamps
timestamps
text
string
category_id
FK
integer
date_start
datetime
date_end
datetime
format_id
FK
integer
session_id
FK
integer
user_id
FK
integer
pages
id
increments
timestamps
timestamps
softDeletes
softDeletes
metadata_id
FK
integer
cms_category_id
FK
integer
page_type_id
FK
integer
layouts
id
increments
timestamps
timestamps
metadata_id
FK
integer
template
string
mail
boolean
page
boolean
alert
boolean
contract
boolean
invoice
boolean
content_blocks
id
increments
timestamps
timestamps
metadata_id
FK
integer
content_block_layouts
content_block_id
FK
integer
layout_id
FK
integer
cms_categories
id
increments
timestamps
timestamps
metadata_id
FK
integer
page_id
FK
integer
email_type
id
increments
timestamps
timestamps
softDeletes
softDeletes
metadata_id
FK
integer
layout_id
FK
integer
levels
id
increments
metadata_id
FK
integer
reservations
id
increments
timestamps
timestamps
offer_id
FK
integer
reservation_date
date
contract_id
FK
integer
offer_paymentstypes_id
FK
integer
user_billings
id
increments
softDeletes
softDeletes
user_id
FK
integer
billing_data_id
FK
integer
event_types
id
increments
metadata_id
FK
integer
user_contacts
id
increments
timestamps
timestamps
softDeletes
softDeletes
user_id
FK
integer
contact_id
FK
integer
notifications
id
increments
metadata_id
FK
integer
alert_id
FK
integer
mail_id
FK
integer
message_id
FK
integer
subscribers
id
increments
metadata_id
FK
integer
notifications_subscribers
notification_id
FK
integer
subscribers_id
FK
integer
messages
id
increments
timestamps
timestamps
metadata_id
FK
integer
format_data
offer_id
FK
integer
field_id
FK
integer
value
text
event_type_notifications
timestamps
timestamps
event_type_id
FK
integer
notification_id
FK
integer
invoices
id
increments
timestamps
timestamps
softDeletes
softDeletes
invoicefile_id
FK
integer
payment_method
FK
integer
invoice_type_id
FK
integer
metadata_id
FK
integer
budgets_offers
budget_id
FK
integer
offer_id
FK
integer
conditions_offers
offer_id
FK
integer
condition_id
FK
integer
softDeletes
softDeletes
offers_prices
id
increments
offer_id
FK
integer
date_start
datetime
date_end
datetime
price_id
FK
integer
pages_types
id
increments
metadata_id
FK
integer
equipments
id
increments
metadata_id
FK
integer
equipments_offers
id
increments
equipment_id
FK
integer
offer_id
FK
integer
metadata_id
FK
integer
data_reservations
id
increments
timestamps
timestamps
offer_id
FK
integer
metadata_id
FK
integer
invoice_stages
id
increments
timestamps
timestamps
stage_id
FK
integer
invoice_reservations
id
increments
timestamps
timestamps
invoice_id
FK
integer
price
decimal
(14,4)
metadata_id
FK
integer
reservation_id
FK
integer
qty
decimal
(8,2)
discount
decimal
(14,4)
tax
decimal
(8,2)
budgets_services
budget_id
FK
integer
service_id
FK
integer
invoice_services
id
increments
timestamps
timestamps
service_id
FK
integer
metadata_id
FK
integer
price
decimal
(14,4)
discount
decimal
(8,2)
tax
decimal
(8,2)
contracts_types
id
increments
timestamps
timestamps
metadata_id
FK
integer
layout_id
FK
integer
invoices_types
id
increments
timestamps
timestamps
metadata_id
FK
integer
layout_id
FK
integer
contractstypes_formats
id
increments
contracttype_id
FK
integer
format_id
FK
integer
paymentstypes
id
increments
timestamps
timestamps
metadata_id
FK
integer
offers_paymenttypes
id
increments
paymentstypes_id
FK
integer
fixed_value
decimal
(14,4)
variable_value
decimal
(14,4)
expiration_date
datetime
metadata_id
FK
integer
Laravel Schema Designer v0.7.1
follow me on twitter
@okyn01