adpv - Laravel Schema Designer

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

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