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
v v
Número de tablas: 0
v restobar_db cash_sessions
* id : int(11)
* user_id : int(11)
* opening_balance : decimal(10,2)
* opening_time : timestamp
* closing_time : timestamp
* status : enum('open','closed')
* expected_closing_balance : decimal(10,2)
* actual_closing_balance : decimal(10,2)
* difference : decimal(10,2)
* note : text
* base_amount : decimal(10,2)
* closing_amount : decimal(10,2)
* notes : text
* opened_by : int(11)
* closed_by : int(11)
v restobar_db categories
* id : int(11)
* name : varchar(50)
* icon : varchar(50)
* sort_order : int(11)
* exclude_from_commission : tinyint(1)
* charge_disposable : tinyint(1)
v restobar_db clients
* id : int(11)
* name : varchar(100)
* phone : varchar(20)
* address : text
* created_at : timestamp
* identification : varchar(50)
* email : varchar(100)
v restobar_db courtesies
* id : int(11)
* beneficiary : varchar(100)
* reason : text
* user_id : int(11)
* created_at : timestamp
v restobar_db courtesy_items
* id : int(11)
* courtesy_id : int(11)
* product_id : int(11)
* quantity : int(11)
v restobar_db daily_supplies
* id : int(11)
* name : varchar(100)
* note : text
* last_updated_by : int(11)
* updated_at : timestamp
* created_at : timestamp
v restobar_db deleted_items_history
* id : int(11)
* order_id : int(11)
* product_name : varchar(255)
* quantity : int(11)
* motive : text
* user_id : int(11)
* deleted_at : timestamp
v restobar_db delivery_drivers
* id : int(11)
* name : varchar(100)
* active : tinyint(1)
v restobar_db delivery_zones
* id : int(11)
* comuna : varchar(50)
* name : varchar(100)
* price : decimal(10,2)
* active : tinyint(1)
v restobar_db electronic_invoices
* id : int(11)
* order_id : int(11)
* alegra_invoice_id : varchar(50)
* alegra_status : varchar(50)
* pdf_url : varchar(255)
* xml_url : varchar(255)
* created_at : timestamp
* customer_name : varchar(150)
* customer_identification : varchar(50)
* customer_email : varchar(150)
* dian_message : text
* consecutive_number : bigint(20)
* cufe : varchar(255)
* qr_code : text
* payload : text
* alegra_id : varchar(50)
* cash_session_id : int(11)
v restobar_db employees
* id : int(11)
* name : varchar(100)
* document_id : varchar(20)
* phone : varchar(20)
* position : varchar(50)
* salary_base : decimal(12,2)
* active : tinyint(1)
* created_at : timestamp
* address : varchar(255)
* city_code : varchar(20)
* email : varchar(100)
v restobar_db employee_loans
* id : int(11)
* employee_id : int(11)
* user_id : int(11)
* cash_session_id : int(11)
* expense_id : int(11)
* amount : decimal(12,2)
* paid_amount : decimal(12,2)
* status : enum('pending','partial','paid','cancelled')
* payment_source : enum('cash','transfer','other')
* notes : text
* created_at : timestamp
* updated_at : timestamp
v restobar_db employee_loan_payments
* id : int(11)
* loan_id : int(11)
* user_id : int(11)
* cash_session_id : int(11)
* amount : decimal(12,2)
* payment_method : enum('efectivo','transferencia','nomina_deduccion','otro')
* notes : text
* created_at : timestamp
v restobar_db expenses
* id : int(11)
* user_id : int(11)
* cash_session_id : int(11)
* amount : decimal(10,2)
* description : text
* category : varchar(50)
* created_at : timestamp
* order_id : int(11)
* expense_type : varchar(20)
* supplier_id : int(11)
* employee_id : int(11)
v restobar_db ingredients
* id : int(11)
* name : varchar(255)
* unit : varchar(20)
* stock : decimal(10,2)
* cost_price : decimal(10,2)
* selling_price : decimal(10,2)
* min_stock : decimal(10,2)
* brand : varchar(100)
* barcode : varchar(100)
* is_weighable : tinyint(1)
* price_per_pound : decimal(10,2)
* low_stock_threshold : decimal(10,2)
* units_per_package : decimal(10,2)
v restobar_db inventory_logs
* id : int(11)
* item_type : enum('product','ingredient')
* item_id : int(11)
* quantity : decimal(10,2)
* action : enum('add','remove','sale','waste','adjustment','courtesy')
* notes : text
* created_at : timestamp
* user_id : int(11)
* previous_stock : decimal(10,2)
* new_stock : decimal(10,2)
v restobar_db inventory_waste
* id : int(11)
* item_type : enum('ingredient','product')
* item_id : int(11)
* quantity : decimal(10,2)
* unit_cost : decimal(12,2)
* total_cost : decimal(12,2)
* reason : varchar(100)
* notes : text
* user_id : int(11)
* created_at : timestamp
v restobar_db manual_inventory
* id : int(11)
* item_name : varchar(100)
* stock : int(11)
* created_at : timestamp
* updated_at : timestamp
v restobar_db manual_inventory_log
* id : int(11)
* item_id : int(11)
* type : enum('in','out')
* quantity : int(11)
* user_id : int(11)
* created_at : timestamp
v restobar_db orders
* id : int(11)
* table_id : int(11)
* user_id : int(11)
* client_id : int(11)
* total : decimal(10,2)
* status : enum('draft','pending','preparing','ready','paid','cancelled')
* payment_method : varchar(30)
* payment_detail : text
* amount_paid : decimal(10,2)
* change_amount : decimal(10,2)
* order_type : enum('local','takeout','delivery')
* delivery_fee : decimal(10,2)
* client_name : varchar(100)
* client_phone : varchar(20)
* client_address : text
* created_at : timestamp
* updated_at : timestamp
* tip_amount : decimal(10,2)
* tip_percentage : int(11)
* is_hotel : tinyint(1)
* deduct_delivery : tinyint(1)
* cash_session_id : int(11)
* external_id : varchar(50)
* client_email : varchar(100)
* driver_name : varchar(100)
* web_payment_method : varchar(20)
* nequi_proof_image : varchar(255)
* web_neighborhood : varchar(100)
* discount_amount : decimal(10,2)
* discount_percentage : decimal(5,2)
* discount_scope : varchar(20)
* client_identification : varchar(50)
v restobar_db order_items
* id : int(11)
* order_id : int(11)
* product_id : int(11)
* quantity : int(11)
* price : decimal(10,2)
* subtotal : decimal(10,2)
* notes : text
* selections : longtext
* printed : tinyint(1)
* cost_price : decimal(10,2)
* discount_amount : decimal(10,2)
* discount_percent : decimal(5,2)
* kitchen_acknowledged : tinyint(1)
* created_at : timestamp
v restobar_db payments_history
* id : int(11)
* order_id : int(11)
* amount : decimal(10,2)
* payment_method : varchar(50)
* payment_note : text
* user_id : int(11)
* cash_session_id : int(11)
* created_at : timestamp
v restobar_db printers
* id : int(11)
* name : varchar(60)
* ip : varchar(45)
* port : int(11)
* type : enum('kitchen','cashier','bar')
* active : tinyint(1)
* connection_type : varchar(20)
* paper_size : varchar(10)
* categories : text
* order_types : text
* created_at : timestamp
v restobar_db print_jobs
* id : int(11)
* printer_id : int(11)
* ticket_content : longblob
* status : enum('pending','printed')
* created_at : timestamp
v restobar_db products
* id : int(11)
* category_id : int(11)
* name : varchar(255)
* description : text
* price : decimal(10,2)
* image : varchar(255)
* is_composite : tinyint(1)
* stock : int(11)
* max_selections : int(11)
* qty_per_selection : decimal(10,2)
* is_deleted : tinyint(1)
* cost_price : decimal(10,2)
* show_in_public : tinyint(1)
* min_stock : int(11)
* units_per_package : decimal(10,2)
v restobar_db product_variants
* id : int(11)
* product_id : int(11)
* name : varchar(100)
v restobar_db purchases
* id : int(11)
* supplier_name : varchar(255)
* supplier_id_number : varchar(50)
* invoice_number : varchar(50)
* purchase_date : date
* due_date : date
* payment_type : enum('contado','credito')
* payment_method : varchar(50)
* cash_session_id : int(11)
* user_id : int(11)
* subtotal : decimal(12,2)
* discount_total : decimal(12,2)
* tax_total : decimal(12,2)
* grand_total : decimal(12,2)
* notes : text
* status : enum('completed','cancelled')
* created_at : timestamp
v restobar_db purchase_items
* id : int(11)
* purchase_id : int(11)
* ingredient_id : int(11)
* description : varchar(255)
* quantity : decimal(10,2)
* price : decimal(12,2)
* selling_price : decimal(12,2)
* discount_percent : decimal(5,2)
* tax_percent : decimal(5,2)
* subtotal : decimal(12,2)
* total : decimal(12,2)
* package_units : decimal(10,2)
* package_cost : decimal(12,2)
* package_qty : decimal(10,2)
v restobar_db quotations
* id : int(11)
* quotation_number : varchar(50)
* client_name : varchar(255)
* client_phone : varchar(50)
* client_address : varchar(255)
* user_id : int(11)
* subtotal : decimal(12,2)
* discount : decimal(12,2)
* tax : decimal(12,2)
* total : decimal(12,2)
* notes : text
* status : enum('active','converted','cancelled')
* valid_until : date
* created_at : timestamp
* updated_at : timestamp
v restobar_db quotation_items
* id : int(11)
* quotation_id : int(11)
* product_id : int(11)
* ingredient_id : int(11)
* name : varchar(255)
* quantity : decimal(10,2)
* price : decimal(12,2)
* subtotal : decimal(12,2)
* notes : text
* created_at : timestamp
v restobar_db recipes
* product_id : int(11)
* ingredient_id : int(11)
* quantity : decimal(10,2)
v restobar_db suppliers
* id : int(11)
* name : varchar(150)
* identification_type : varchar(10)
* identification : varchar(20)
* dv : varchar(2)
* address : varchar(200)
* city_code : varchar(20)
* email : varchar(100)
* regime : varchar(50)
* created_at : timestamp
* phone : varchar(50)
v restobar_db system_settings
* setting_key : varchar(50)
* setting_value : text
v restobar_db tables
* id : int(11)
* table_number : varchar(10)
* status : enum('available','occupied','reserved')
* waiter_id : int(11)
v restobar_db users
* id : int(11)
* username : varchar(50)
* password : varchar(255)
* full_name : varchar(100)
* role : enum('admin','waiter','kitchen','cashier','owner')
* ip_address : varchar(45)
* created_at : timestamp
* permissions : text
* active : tinyint(1)
v restobar_db variant_recipes
* variant_id : int(11)
* ingredient_id : int(11)
* quantity : decimal(10,2)
v restobar_db wrong_products
* id : int(11)
* user_id : int(11)
* product_id : int(11)
* quantity : int(11)
* price : decimal(10,2)
* session_id : int(11)
* original_order_id : int(11)
* created_at : timestamp
* status : enum('pending','reassigned')
Crear relación
FOREIGN KEY
on delete
on update
Eliminar la relación