Suelte aquí los archivos

Carga SQL ( 0 ) x -

Ajustes de página relacionada Pulse en la barra para deslizarse al tope de la página
Presione Ctrl+Enter para ejecutar la consulta Presione Enter para ejecutar la consulta
ascendente
descendente
Orden:
Depuración SQL
Cantidad
Orden de ejecución
Tiempo necesario
Ordenar por:
Consultas grupales
Desagrupar las consultas
Colapsar Expandir Mostrar rastro Ocultar rastro Cantidad : Tiempo necesario :
Favoritos
Actualizar
Agregar
Ningún favorito
Agregar favorito
Opciones
Definir predeterminado





Colapsar Expandir Reconsultar Editar Explicar Perfilando Agregar a favoritos Falló la consulta Base de datos : Fecha y hora la consulta :
Sin título *
v Mostrar/Ocultar lista de tablas Ver en pantalla completa Añadir tablas de otras bases de datos Nueva página Abrir página Guardar página Guardar página como Borrar páginas Crear tabla Crear relación Elegir la columna a mostrar Cargar nuevamente Ayuda Enlaces angulares / Enlaces directos Cuadrícula magnética v Pequeño/grande todos Alterne entre pequeño y grande Alternar líneas de relación Exportar estructura > Mover el Menú > Fijar texto
Número de tablas: 0
v areneli_db audit_logs
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* action : varchar(100)
* entity : varchar(80)
* entity_id : bigint(20) unsigned
* details : text
* created_at : timestamp
v areneli_db benefit_usages
* id : bigint(20) unsigned
* period_id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* benefit : varchar(40)
* used_at : timestamp
v areneli_db categories
* id : int(10) unsigned
* name : varchar(100)
* sort_order : int(11)
* active : tinyint(1)
v areneli_db customer_addresses
* id : bigint(20) unsigned
* customer_id : bigint(20) unsigned
* label : varchar(70)
* street : varchar(255)
* neighborhood : varchar(140)
* reference : text
* active : tinyint(1)
v areneli_db customer_profiles
* id : bigint(20) unsigned
* user_id : bigint(20) unsigned
* phone : varchar(25)
* notes : text
* created_at : timestamp
v areneli_db deliveries
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* assigned_user_id : bigint(20) unsigned
* status : enum('pending','assigned','out_for_delivery','delivered','cancelled')
* delivered_at : datetime
v areneli_db delivery_zones
* id : int(10) unsigned
* name : varchar(100)
* delivery_fee : decimal(12,2)
* estimated_cost : decimal(12,2)
* active : tinyint(1)
v areneli_db idempotency_keys
* id : bigint(20) unsigned
* token : varchar(100)
* action : varchar(100)
* actor_id : bigint(20) unsigned
* created_at : timestamp
v areneli_db login_attempts
* id : bigint(20) unsigned
* email_hash : char(64)
* ip_hash : char(64)
* attempted_at : datetime
v areneli_db memberships
* id : bigint(20) unsigned
* customer_id : bigint(20) unsigned
* plan_id : bigint(20) unsigned
* renewal_mode : enum('manual','auto')
* status : enum('active','paused','cancelled')
* created_at : timestamp
v areneli_db membership_periods
* id : bigint(20) unsigned
* membership_id : bigint(20) unsigned
* start_at : datetime
* end_at : datetime
* source : enum('initial','manual','auto_simulation')
* payment_id : bigint(20) unsigned
* created_at : timestamp
v areneli_db orders
* id : bigint(20) unsigned
* customer_id : bigint(20) unsigned
* address_id : bigint(20) unsigned
* zone_id : int(10) unsigned
* period_id : bigint(20) unsigned
* scheduled_for : datetime
* status : enum('placed','preparing','ready','out_for_delivery','delivered','cancelled')
* subtotal : decimal(12,2)
* delivery_fee : decimal(12,2)
* delivery_cost : decimal(12,2)
* total : decimal(12,2)
* delivery_included : tinyint(1)
* notes : varchar(500)
* created_at : timestamp
v areneli_db order_items
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* product_id : bigint(20) unsigned
* product_name : varchar(140)
* quantity : int(10) unsigned
* unit_price : decimal(12,2)
* unit_cost : decimal(12,2)
* line_total : decimal(12,2)
v areneli_db order_status_history
* id : bigint(20) unsigned
* order_id : bigint(20) unsigned
* old_status : varchar(40)
* new_status : varchar(40)
* actor_id : bigint(20) unsigned
* created_at : timestamp
v areneli_db payment_events
* id : bigint(20) unsigned
* payment_id : bigint(20) unsigned
* old_status : varchar(30)
* new_status : varchar(30)
* actor_id : bigint(20) unsigned
* created_at : timestamp
v areneli_db payment_records
* id : bigint(20) unsigned
* customer_id : bigint(20) unsigned
* plan_id : bigint(20) unsigned
* amount : decimal(12,2)
* method : enum('cash','transfer','test')
* status : enum('pending','confirmed','rejected')
* payment_type : enum('wallet_topup','membership')
* reference : varchar(120)
* confirmed_at : datetime
* confirmed_by : bigint(20) unsigned
* created_at : timestamp
v areneli_db permissions
* id : int(10) unsigned
* slug : varchar(90)
v areneli_db plans
* id : bigint(20) unsigned
* name : varchar(120)
* price : decimal(12,2)
* wallet_credit : decimal(12,2)
* duration_days : int(11)
* deliveries_included : int(11)
* active : tinyint(1)
v areneli_db products
* id : bigint(20) unsigned
* category_id : int(10) unsigned
* name : varchar(140)
* description : varchar(500)
* price : decimal(12,2)
* cost : decimal(12,2)
* active : tinyint(1)
* created_at : timestamp
v areneli_db renewal_authorizations
* id : bigint(20) unsigned
* membership_id : bigint(20) unsigned
* authorized_by : bigint(20) unsigned
* consent_at : datetime
* revoked_at : datetime
* terms_version : varchar(30)
v areneli_db roles
* id : int(10) unsigned
* slug : varchar(40)
* label : varchar(80)
v areneli_db role_permissions
* role_id : int(10) unsigned
* permission_id : int(10) unsigned
v areneli_db settings
* key : varchar(100)
* value : text
v areneli_db users
* id : bigint(20) unsigned
* name : varchar(120)
* email : varchar(190)
* password_hash : varchar(255)
* active : tinyint(1)
* created_at : timestamp
v areneli_db user_roles
* user_id : bigint(20) unsigned
* role_id : int(10) unsigned
v areneli_db wallets
* id : bigint(20) unsigned
* customer_id : bigint(20) unsigned
* balance : decimal(12,2)
* created_at : timestamp
v areneli_db wallet_transactions
* id : bigint(20) unsigned
* wallet_id : bigint(20) unsigned
* kind : enum('credit','debit','refund','adjustment')
* amount : decimal(12,2)
* balance_after : decimal(12,2)
* reference : varchar(120)
* note : varchar(255)
* actor_id : bigint(20) unsigned
* created_at : timestamp
Crear relación
FOREIGN KEY
on delete
on update
Eliminar la relación