Upload SQL
2
Analisi Tabelle
3
Relazioni
4
Mapping Nomi
5
Genera Output

Step 2: Analisi del Database

33 tabelle trovate

Ecco le tabelle e colonne trovate nel file easybike. Verifica che l'analisi sia corretta prima di procedere.

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