Upload SQL
Analisi Tabelle
Relazioni
Mapping Nomi
5
Genera Output

Step 5: Genera File Laravel

Tutto è pronto! Ecco un riepilogo di cosa verrà generato. Clicca "Scarica ZIP" per ottenere i file.

33

Migration

33

Model

33

Factory

0

Seeder

Relazioni (56)
Sorgente Colonna Tipo Target Colonna Target Origine
u_s_e_r_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
c_a_t_e_g_o_r_i_e_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
b_i_k_e_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
c_o_n_t_r_a_c_t_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
a_c_c_e_s_s_o_r_i_e_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
d_e_l_i_v_e_r_i_e_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
d_e_l_i_v_e_r_y__z_o_n_e_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
t_e_n_a_n_t__f_e_a_t_u_r_e_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
t_e_n_a_n_t__p_a_y_m_e_n_t__g_a_t_e_w_a_y_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
t_e_n_a_n_t__c_o_m_m_i_s_s_i_o_n__s_e_t_t_i_n_g_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
t_e_n_a_n_t__t_h_e_m_es tenants_id belongsTo t_e_n_a_n_t_s id SQL
p_r_i_c_e__d_e_l_i_v_e_r_ies tenants_id belongsTo t_e_n_a_n_t_s id SQL
b_i_k_e__s_i_z_e_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
c_a_r_t__s_u_m_m_a_r_i_e_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
a_c_t_i_v_i_t_y__l_o_g_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
t_e_n_a_n_t__p_a_r_t_n_e_r_s_h_i_p_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
t_e_n_a_n_t__p_a_r_t_n_e_r_s_h_i_p_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
b_i_k_e__a_s_s_i_g_n_m_e_n_t_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
b_i_k_e__a_s_s_i_g_n_m_e_n_t_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
b_i_k_e__a_s_s_i_g_n_m_e_n_t_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
a_c_c_e_s_s_o_r_y__a_s_s_i_g_n_m_e_n_t_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
a_c_c_e_s_s_o_r_y__a_s_s_i_g_n_m_e_n_t_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
d_e_l_i_v_e_r_y__a_s_s_i_g_n_m_e_n_t_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
d_e_l_i_v_e_r_y__a_s_s_i_g_n_m_e_n_t_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
c_o_m_m_i_s_s_i_o_n__t_r_a_n_s_a_c_t_i_o_n_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
c_o_m_m_i_s_s_i_o_n__t_r_a_n_s_a_c_t_i_o_n_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
c_o_m_m_i_s_s_i_o_n__t_r_a_n_s_a_c_t_i_o_n_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
b_i_k_e_s categories_id belongsTo c_a_t_e_g_o_r_i_e_s id SQL
c_a_t_e_g_o_r_i_e_s deliveries_id belongsTo d_e_l_i_v_e_r_i_e_s id SQL
c_a_t_e_g_o_r_i_e_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
b_i_k_e_s categories_id belongsTo c_a_t_e_g_o_r_i_e_s id SQL
b_i_k_e_s deliveries_id belongsTo d_e_l_i_v_e_r_i_e_s id SQL
b_i_k_e_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
b_i_k_e_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
p_h_o_t_o_s bikes_id belongsTo b_i_k_e_s id SQL
b_i_k_e__c_o_n_t_r_a_c_ts bikes_id belongsTo b_i_k_e_s id SQL
b_i_k_e__c_o_n_t_r_a_c_ts contracts_id belongsTo c_o_n_t_r_a_c_t_s id SQL
b_i_k_e__c_o_n_t_r_a_c_t2s bikes_id belongsTo b_i_k_e_s id SQL
b_i_k_e__c_o_n_t_r_a_c_t2s contracts_id belongsTo c_o_n_t_r_a_c_t_s id SQL
a_c_c_e_s_s_o_r_y__c_o_n_t_r_a_c_t_s contracts_id belongsTo c_o_n_t_r_a_c_t_s id SQL
a_c_c_e_s_s_o_r_y__c_o_n_t_r_a_c_t_s accessories_id belongsTo a_c_c_e_s_s_o_r_i_e_s id SQL
c_o_n_t_r_a_c_t_s deliveries_id belongsTo d_e_l_i_v_e_r_i_e_s id SQL
c_o_n_t_r_a_c_t_s tenants_id belongsTo t_e_n_a_n_t_s id SQL
b_i_k_e__a_s_s_i_g_n_m_e_n_t_s bikes_id belongsTo b_i_k_e_s id SQL
b_i_k_e__a_s_s_i_g_n_m_e_n_t_s categories_id belongsTo c_a_t_e_g_o_r_i_e_s id SQL
a_c_c_e_s_s_o_r_y__a_s_s_i_g_n_m_e_n_t_s accessories_id belongsTo a_c_c_e_s_s_o_r_i_e_s id SQL
d_e_l_i_v_e_r_y__a_s_s_i_g_n_m_e_n_t_s deliveries_id belongsTo d_e_l_i_v_e_r_i_e_s id SQL
c_o_m_m_i_s_s_i_o_n__t_r_a_n_s_a_c_t_i_o_n_s contracts_id belongsTo c_o_n_t_r_a_c_t_s id SQL
c_o_m_m_i_s_s_i_o_n__t_r_a_n_s_a_c_t_i_o_n_s bikes_id belongsTo b_i_k_e_s id SQL
t_e_n_a_n_t__c_o_m_m_i_s_s_i_o_n__s_e_t_t_i_n_g_s categories_id belongsTo c_a_t_e_g_o_r_i_e_s id SQL
c_a_r_t_s categories_id belongsTo c_a_t_e_g_o_r_i_e_s id SQL
c_a_r_t__a_c_c_e_s_s_o_r_i_e_s accessories_id belongsTo a_c_c_e_s_s_o_r_i_e_s id SQL
b_i_k_e_s deliveries_id belongsTo d_e_l_i_v_e_r_i_e_s id SQL
c_a_t_e_g_o_r_i_e_s deliveries_id belongsTo d_e_l_i_v_e_r_i_e_s id SQL
a_c_t_i_v_i_t_y__l_o_g_s users_id belongsTo u_s_e_r_s id SQL
u_s_e_r__m_a_n_u_a_l__a_r_t_i_c_l_e_s user_manual_categories_id belongsTo u_s_e_r__m_a_n_u_a_l__c_a_t_e_g_o_r_i_e_s id SQL
Diagramma ER del Database
100% Trascina per navigare • Scroll per zoom
t_e_n_a_n_t_s (Tenant) da: TENANTS
114 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
code string nullable
slug string nullable unique
custom_domain string nullable
store_enabled boolean nullable
theme string nullable
name string nullable
company_name string nullable
email string nullable
phone string nullable
address string nullable
vat_number string nullable
external_partner_id string nullable
logo_url string nullable
primary_color string nullable
secondary_color string nullable
accent_color string nullable
currency string nullable
timezone string nullable
date_format string nullable
is_active boolean nullable
is_master boolean nullable
commission_rate decimal nullable
trial_ends_at dateTime nullable
subscription_ends_at dateTime nullable
company_description string nullable
company_email string nullable
company_phone string nullable
company_address string nullable
company_city string nullable
company_province string nullable
company_zip string nullable
company_country string nullable
latitude decimal nullable
longitude decimal nullable
depot_latitude decimal nullable
depot_longitude decimal nullable
depot_address string nullable
center_latitude decimal nullable
center_longitude decimal nullable
center_radius_km decimal nullable
center_delivery_enabled boolean nullable
center_base_cost decimal nullable
center_base_cost_max_bikes integer nullable
center_cost_per_bike decimal nullable
center_free_delivery_days integer nullable
default_price_per_km decimal nullable
default_fixed_cost decimal nullable
facebook_url string nullable
instagram_url string nullable
whatsapp_number string nullable
website_url string nullable
logo_light string nullable
logo_dark string nullable
logo_footer string nullable
favicon string nullable
hero_title string nullable
hero_subtitle string nullable
hero_image string nullable
hero_cta_text string nullable
hero_cta_url string nullable
about_title string nullable
about_content text nullable
about_image string nullable
services json nullable
gallery_images json nullable
testimonials json nullable
meta_title string nullable
meta_description string nullable
meta_keywords string nullable
og_image string nullable
og_title string nullable
og_description string nullable
og_type string nullable
og_locale string nullable
twitter_card string nullable
twitter_site string nullable
twitter_title string nullable
twitter_description string nullable
twitter_image string nullable
business_type string nullable
opening_hours json nullable
price_range string nullable
geo_region string nullable
geo_placename string nullable
geo_country string nullable
canonical_url string nullable
robots_meta string nullable
sitemap_priority decimal nullable
sitemap_changefreq string nullable
default_language string nullable
alternate_languages json nullable
business_email string nullable
business_phone string nullable
business_address string nullable
business_postal_code string nullable
business_city string nullable
same_as string nullable
bike_seo_title_template string nullable
bike_seo_description_template string nullable
bike_og_title_template string nullable
bike_og_description_template string nullable
booking_intro_text text nullable
booking_terms text nullable
privacy_policy text nullable
font_family string nullable
button_style string nullable
custom_css text nullable
custom_js text nullable
custom_navbar_links json nullable
google_analytics_id string nullable
facebook_pixel_id string nullable
head_scripts text nullable
body_scripts text nullable
u_s_e_r_s (User) da: USERS
11 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
tenant_id bigInteger nullable
name string nullable
email string nullable unique
email_verified_at dateTime nullable
password string nullable
remember_token string nullable
admin integer nullable
is_super_admin boolean nullable
colore_agenzia string nullable
tenants_id unsignedBigInteger
c_a_t_e_g_o_r_i_e_s (Category) da: CATEGORIES
20 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
tenant_id bigInteger nullable
managed_by_tenant_id bigInteger nullable
delivery_id bigInteger nullable
type string nullable
base decimal nullable
two_day decimal nullable
three_day decimal nullable
four_day decimal nullable
five_day decimal nullable
six_day decimal nullable
seven_day decimal nullable
overprice decimal nullable
cover_image string nullable
caratteristiche text nullable
caratteristiche_en text nullable
is_active boolean nullable
bloccata_sito boolean nullable
tenants_id unsignedBigInteger
deliveries_id unsignedBigInteger
b_i_k_e_s (Bike) da: BIKES
34 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
tenant_id bigInteger nullable
owner_tenant_id bigInteger nullable
managed_by_tenant_id bigInteger nullable
category_id bigInteger nullable
punto_ritiro_id bigInteger nullable
name string nullable
slug string nullable unique
seo_title string nullable
seo_description string nullable
seo_keywords string nullable
og_title string nullable
og_description string nullable
og_image string nullable
long_description text nullable
specifications json nullable
features json nullable
recommended_for string nullable
is_public boolean nullable
valore_acquisto decimal nullable
valore_vendita decimal nullable
taglia string nullable
taglia_dettaglio string nullable
manutenzione boolean nullable
manutenzione_started_at dateTime nullable
cover_photo string nullable
bloccata boolean nullable
bloccata_esc boolean nullable
bloccata_sito boolean nullable
unlock_code string nullable
unlock_code_updated_at dateTime nullable
tenants_id unsignedBigInteger
categories_id unsignedBigInteger
deliveries_id unsignedBigInteger
c_o_n_t_r_a_c_t_s (Contract) da: CONTRACTS
46 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
tenant_id bigInteger nullable
from_storefront boolean nullable
seller_tenant_id bigInteger nullable
rack_id bigInteger nullable
name string nullable
surname string nullable
tel string nullable
mail string nullable
nato_a string nullable
nato_il date nullable
comune_residenza string nullable
via_residenza string nullable
n_documento string nullable
data_documento date nullable
ente_documento string nullable
residenza_temp string nullable
data_inizio date nullable
data_fine date nullable
costo decimal nullable
importo_incassato decimal nullable
acconto_lasciato decimal nullable
esito string nullable
online boolean nullable
temporanei boolean nullable
address_consegna string nullable
address_riconsegna string nullable
notes_client string nullable
path string nullable
sign string nullable
user string nullable
escursione_id bigInteger nullable
deposit_amount decimal nullable
deposit_status string nullable
deposit_paid_at dateTime nullable
deposit_refunded_at dateTime nullable
deposit_refund_method string nullable
deposit_transaction_id string nullable
deposit_refund_transaction_id string nullable
deposit_payment_token string nullable
deposit_link_sent_at dateTime nullable
unlock_code_sent boolean nullable
unlock_code_sent_at dateTime nullable
is_rack_rental boolean nullable
tenants_id unsignedBigInteger
deliveries_id unsignedBigInteger
a_c_c_e_s_s_o_r_i_e_s (Accessory) da: ACCESSORIES
15 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
tenant_id bigInteger nullable
name string nullable
image string nullable
price decimal nullable
two_day decimal nullable
three_day decimal nullable
four_day decimal nullable
five_day decimal nullable
six_day decimal nullable
seven_day decimal nullable
overprice decimal nullable
is_default boolean nullable
quantity integer nullable
tenants_id unsignedBigInteger
d_e_l_i_v_e_r_i_e_s (Delivery) da: DELIVERIES
13 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
tenant_id bigInteger nullable
address_consegna string nullable
latitude decimal nullable
longitude decimal nullable
is_warehouse boolean nullable
is_rack boolean nullable
rack_capacity integer nullable
hotel_name string nullable
hotel_contact_email string nullable
hotel_contact_phone string nullable
zone string nullable
tenants_id unsignedBigInteger
d_e_l_i_v_e_r_y__z_o_n_e_s (DeliveryZone) da: DELIVERY_ZONES
17 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
tenant_id bigInteger nullable
name string nullable
is_active boolean nullable
latitude decimal nullable
longitude decimal nullable
address string nullable
radius_km decimal nullable
applies_to string nullable
pricing_type string nullable
fixed_cost decimal nullable
base_cost decimal nullable
max_bikes_base_cost integer nullable
cost_per_bike decimal nullable
free_delivery_days integer nullable
sort_order integer nullable
tenants_id unsignedBigInteger
t_e_n_a_n_t__p_a_r_t_n_e_r_s_h_i_p_s (TenantPartnership) da: TENANT_PARTNERSHIPS
13 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
tenant_a_id bigInteger nullable
tenant_b_id bigInteger nullable
status string nullable
requested_by_tenant_id bigInteger nullable
can_share_bikes boolean nullable
can_share_warehouses boolean nullable
can_cross_sell boolean nullable
notes text nullable
approved_at dateTime nullable
suspended_at dateTime nullable
revoked_at dateTime nullable
tenants_id unsignedBigInteger
b_i_k_e__a_s_s_i_g_n_m_e_n_t_s (BikeAssignment) da: BIKE_ASSIGNMENTS
13 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
owner_tenant_id bigInteger nullable
assigned_tenant_id bigInteger nullable
managed_by_tenant_id bigInteger nullable
assignment_type string nullable
bike_id bigInteger nullable
category_id bigInteger nullable
is_active boolean nullable
assigned_at dateTime nullable
revoked_at dateTime nullable
tenants_id unsignedBigInteger
bikes_id unsignedBigInteger
categories_id unsignedBigInteger
a_c_c_e_s_s_o_r_y__a_s_s_i_g_n_m_e_n_t_s (AccessoryAssignment) da: ACCESSORY_ASSIGNMENTS
11 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
owner_tenant_id bigInteger nullable
assigned_tenant_id bigInteger nullable
managed_by_tenant_id bigInteger nullable
assignment_type string nullable
accessory_id bigInteger nullable
is_active boolean nullable
assigned_at dateTime nullable
revoked_at dateTime nullable
tenants_id unsignedBigInteger
accessories_id unsignedBigInteger
d_e_l_i_v_e_r_y__a_s_s_i_g_n_m_e_n_t_s (DeliveryAssignment) da: DELIVERY_ASSIGNMENTS
11 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
owner_tenant_id bigInteger nullable
assigned_tenant_id bigInteger nullable
delivery_id bigInteger nullable
permission_level string nullable
is_active boolean nullable
assigned_at dateTime nullable
revoked_at dateTime nullable
notes text nullable
tenants_id unsignedBigInteger
deliveries_id unsignedBigInteger
c_o_m_m_i_s_s_i_o_n__t_r_a_n_s_a_c_t_i_o_n_s (CommissionTransaction) da: COMMISSION_TRANSACTIONS
28 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
contract_id bigInteger nullable
contract_detail_id bigInteger nullable
seller_tenant_id bigInteger nullable
owner_tenant_id bigInteger nullable
managed_by_tenant_id bigInteger nullable
bike_id bigInteger nullable
rental_amount decimal nullable
commission_type string nullable
commission_rate decimal nullable
super_admin_commission_rate decimal nullable
partner_commission_rate decimal nullable
platform_commission_rate decimal nullable
owner_commission_rate decimal nullable
seller_commission_rate decimal nullable
is_p2p_transaction boolean nullable
commission_amount decimal nullable
owner_amount decimal nullable
seller_amount decimal nullable
partner_amount decimal nullable
platform_fee decimal nullable
platform_amount decimal nullable
status string nullable
paid_at dateTime nullable
notes text nullable
tenants_id unsignedBigInteger
contracts_id unsignedBigInteger
bikes_id unsignedBigInteger
c_o_m_m_i_s_s_i_o_n__r_u_l_e_s (CommissionRule) da: COMMISSION_RULES
14 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
rule_key string nullable unique
description string nullable
owner_type string nullable
seller_type string nullable
manager_type string nullable
super_admin_percentage decimal nullable
partner_percentage decimal nullable
platform_percentage decimal nullable
owner_percentage decimal nullable
seller_percentage decimal nullable
is_p2p_rule boolean nullable
is_active boolean nullable
sort_order integer nullable
t_e_n_a_n_t__c_o_m_m_i_s_s_i_o_n__s_e_t_t_i_n_g_s (TenantCommissionSetting) da: TENANT_COMMISSION_SETTINGS
10 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
tenant_id bigInteger nullable
commission_type string nullable
commission_value decimal nullable
applies_to string nullable
category_id bigInteger nullable
is_active boolean nullable
notes text nullable
tenants_id unsignedBigInteger
categories_id unsignedBigInteger
t_e_n_a_n_t__f_e_a_t_u_r_e_s (TenantFeature) da: TENANT_FEATURES
6 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
tenant_id bigInteger nullable
feature_code string nullable
is_licensed boolean nullable
is_enabled boolean nullable
tenants_id unsignedBigInteger
t_e_n_a_n_t__p_a_y_m_e_n_t__g_a_t_e_w_a_y_s (TenantPaymentGateway) da: TENANT_PAYMENT_GATEWAYS
9 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
tenant_id bigInteger nullable
gateway_type string nullable
is_active boolean nullable
is_default boolean nullable
credentials text nullable
settings json nullable
test_mode boolean nullable
tenants_id unsignedBigInteger
t_e_n_a_n_t__t_h_e_m_es (TenantTheme) da: TENANT_THEME
5 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
tenant_id bigInteger nullable
theme_key string nullable
is_active boolean nullable
tenants_id unsignedBigInteger
p_h_o_t_o_s (Photo) da: PHOTOS
5 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
path string nullable
bike_id bigInteger nullable
contract_id bigInteger nullable
bikes_id unsignedBigInteger
b_i_k_e__c_o_n_t_r_a_c_ts (BikeContract) da: BIKE_CONTRACT
5 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
contract_id bigInteger nullable
bike_id bigInteger nullable
bikes_id unsignedBigInteger
contracts_id unsignedBigInteger
b_i_k_e__c_o_n_t_r_a_c_t2s (BikeContract2) da: BIKE_CONTRACT2
5 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
contract_id bigInteger nullable
bike_id bigInteger nullable
bikes_id unsignedBigInteger
contracts_id unsignedBigInteger
a_c_c_e_s_s_o_r_y__c_o_n_t_r_a_c_t_s (AccessoryContract) da: ACCESSORY_CONTRACTS
6 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
accessory_id bigInteger nullable
contract_id bigInteger nullable
qty integer nullable
contracts_id unsignedBigInteger
accessories_id unsignedBigInteger
c_a_r_t_s (Cart) da: CARTS
12 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
bike bigInteger nullable
price decimal nullable
giorni_noleggio integer nullable
path_photo string nullable
sessione string nullable
category_id bigInteger nullable
misura string nullable
price_consegna decimal nullable
address_selezionato string nullable
address_category string nullable
categories_id unsignedBigInteger
c_a_r_t__s_u_m_m_a_r_i_e_s (CartSummary) da: CART_SUMMARIES
14 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
sessione string nullable
email string nullable
abandoned_email_sent boolean nullable
tenant_id bigInteger nullable
price_total decimal nullable
address_consegna string nullable
pickup_latitude decimal nullable
pickup_longitude decimal nullable
address_riconsegna string nullable
return_latitude decimal nullable
return_longitude decimal nullable
delivery_cost decimal nullable
tenants_id unsignedBigInteger
c_a_r_t__a_c_c_e_s_s_o_r_i_e_s (CartAccessory) da: CART_ACCESSORIES
6 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
sessione string nullable
accessory_id bigInteger nullable
qty integer nullable
price_per_day decimal nullable
accessories_id unsignedBigInteger
p_r_i_c_e__d_e_l_i_v_e_r_ies (PriceDelivery) da: PRICE_DELIVERY
7 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
tenant_id bigInteger nullable
price_km decimal nullable
costo_fisso decimal nullable
qta_minima integer nullable
qta_massima integer nullable
tenants_id unsignedBigInteger
b_i_k_e__s_i_z_e_s (BikeSize) da: BIKE_SIZES
5 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
name string nullable
details string nullable
tenant_id bigInteger nullable
tenants_id unsignedBigInteger
r_i_f_e_r_i_m_e_n_t_o__m_i_s_u_r_e_s (RiferimentoMisure) da: RIFERIMENTO_MISURES
4 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
min integer nullable
max integer nullable
misura_riferimento string nullable
p_u_n_t_i__r_i_t_i_r_o_s (PuntiRitiro) da: PUNTI_RITIROS
2 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
zona string nullable
a_c_t_i_v_i_t_y__l_o_g_s (ActivityLog) da: ACTIVITY_LOGS
13 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
tenant_id bigInteger nullable
user_id bigInteger nullable
user_name string nullable
action string nullable
entity_type string nullable
entity_id bigInteger nullable
description text nullable
metadata json nullable
ip_address string nullable
level string nullable
tenants_id unsignedBigInteger
users_id unsignedBigInteger
n_a_t_i_o_n_a_l__p_r_e_f_i_x_e_s (NationalPrefixe) da: NATIONAL_PREFIXES
3 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
country string nullable
prefisso string nullable
u_s_e_r__m_a_n_u_a_l__c_a_t_e_g_o_r_i_e_s (UserManualCategory) da: USER_MANUAL_CATEGORIES
8 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
name string nullable
slug string nullable unique
icon string nullable
description string nullable
order integer nullable
is_active boolean nullable
roles json nullable
u_s_e_r__m_a_n_u_a_l__a_r_t_i_c_l_e_s (UserManualArticle) da: USER_MANUAL_ARTICLES
13 colonne
Colonna Tipo Laravel Attributi
id bigInteger PK
category_id bigInteger nullable
title string nullable
slug string nullable unique
excerpt string nullable
content text nullable
tags json nullable
roles json nullable
order integer nullable
is_active boolean nullable
is_faq boolean nullable
views integer nullable
user_manual_categories_id unsignedBigInteger
← Torna al Mapping