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

Step 3: Definisci le Relazioni

Seleziona una tabella dal pannello a sinistra per visualizzarne le colonne. Per ogni colonna puoi definire se è collegata a un'altra tabella specificando la tabella e la colonna di destinazione e il tipo di relazione.

Relazioni auto-rilevate dal SQL
56 trovate
Verifica ogni relazione: accettala se corretta o rifiutala se errata. Le relazioni rifiutate verranno rimosse.
USERS.tenants_id → belongsTo → TENANTS.id
CATEGORIES.tenants_id → belongsTo → TENANTS.id
BIKES.tenants_id → belongsTo → TENANTS.id
CONTRACTS.tenants_id → belongsTo → TENANTS.id
ACCESSORIES.tenants_id → belongsTo → TENANTS.id
DELIVERIES.tenants_id → belongsTo → TENANTS.id
DELIVERY_ZONES.tenants_id → belongsTo → TENANTS.id
TENANT_FEATURES.tenants_id → belongsTo → TENANTS.id
TENANT_PAYMENT_GATEWAYS.tenants_id → belongsTo → TENANTS.id
TENANT_COMMISSION_SETTINGS.tenants_id → belongsTo → TENANTS.id
TENANT_THEME.tenants_id → belongsTo → TENANTS.id
PRICE_DELIVERY.tenants_id → belongsTo → TENANTS.id
BIKE_SIZES.tenants_id → belongsTo → TENANTS.id
CART_SUMMARIES.tenants_id → belongsTo → TENANTS.id
ACTIVITY_LOGS.tenants_id → belongsTo → TENANTS.id
TENANT_PARTNERSHIPS.tenants_id → belongsTo → TENANTS.id
TENANT_PARTNERSHIPS.tenants_id → belongsTo → TENANTS.id
BIKE_ASSIGNMENTS.tenants_id → belongsTo → TENANTS.id
BIKE_ASSIGNMENTS.tenants_id → belongsTo → TENANTS.id
BIKE_ASSIGNMENTS.tenants_id → belongsTo → TENANTS.id
ACCESSORY_ASSIGNMENTS.tenants_id → belongsTo → TENANTS.id
ACCESSORY_ASSIGNMENTS.tenants_id → belongsTo → TENANTS.id
DELIVERY_ASSIGNMENTS.tenants_id → belongsTo → TENANTS.id
DELIVERY_ASSIGNMENTS.tenants_id → belongsTo → TENANTS.id
COMMISSION_TRANSACTIONS.tenants_id → belongsTo → TENANTS.id
COMMISSION_TRANSACTIONS.tenants_id → belongsTo → TENANTS.id
COMMISSION_TRANSACTIONS.tenants_id → belongsTo → TENANTS.id
BIKES.categories_id → belongsTo → CATEGORIES.id
CATEGORIES.deliveries_id → belongsTo → DELIVERIES.id
CATEGORIES.tenants_id → belongsTo → TENANTS.id
BIKES.categories_id → belongsTo → CATEGORIES.id
BIKES.deliveries_id → belongsTo → DELIVERIES.id
BIKES.tenants_id → belongsTo → TENANTS.id
BIKES.tenants_id → belongsTo → TENANTS.id
PHOTOS.bikes_id → belongsTo → BIKES.id
BIKE_CONTRACT.bikes_id → belongsTo → BIKES.id
BIKE_CONTRACT.contracts_id → belongsTo → CONTRACTS.id
BIKE_CONTRACT2.bikes_id → belongsTo → BIKES.id
BIKE_CONTRACT2.contracts_id → belongsTo → CONTRACTS.id
ACCESSORY_CONTRACTS.contracts_id → belongsTo → CONTRACTS.id
ACCESSORY_CONTRACTS.accessories_id → belongsTo → ACCESSORIES.id
CONTRACTS.deliveries_id → belongsTo → DELIVERIES.id
CONTRACTS.tenants_id → belongsTo → TENANTS.id
BIKE_ASSIGNMENTS.bikes_id → belongsTo → BIKES.id
BIKE_ASSIGNMENTS.categories_id → belongsTo → CATEGORIES.id
ACCESSORY_ASSIGNMENTS.accessories_id → belongsTo → ACCESSORIES.id
DELIVERY_ASSIGNMENTS.deliveries_id → belongsTo → DELIVERIES.id
COMMISSION_TRANSACTIONS.contracts_id → belongsTo → CONTRACTS.id
COMMISSION_TRANSACTIONS.bikes_id → belongsTo → BIKES.id
TENANT_COMMISSION_SETTINGS.categories_id → belongsTo → CATEGORIES.id
CARTS.categories_id → belongsTo → CATEGORIES.id
CART_ACCESSORIES.accessories_id → belongsTo → ACCESSORIES.id
BIKES.deliveries_id → belongsTo → DELIVERIES.id
CATEGORIES.deliveries_id → belongsTo → DELIVERIES.id
ACTIVITY_LOGS.users_id → belongsTo → USERS.id
USER_MANUAL_ARTICLES.user_manual_categories_id → belongsTo → USER_MANUAL_CATEGORIES.id
Tabelle del Database
Seleziona una tabella

Clicca su una tabella nel pannello a sinistra per visualizzarne le colonne e definire le relazioni.

Colonne di
Colonna Tipo Nullable Relazione
Riepilogo Relazioni Manuali
0 relazioni
Tabella Sorgente Colonna Tipo Tabella Target Colonna Target Pivot Lookup
Nessuna relazione manuale definita ancora.
← Torna all'Analisi
Auto-save attivo