localhost:8080 / 127.0.0.1 / pv_pasteleria_ivonne_sierra_spa

No existen tablas favoritas.

Nueva
central_db
information_schema
mysql
performance_schema
phpmyadmin
pos_moderno
puntoventa
- puntoventa
- puntoventa_registry
pv
- demo
  - pv_demo
  - pv_demo_test
- pv_fgaete
- pv_genesis
- pv_paola
- pv_pasteleria_ivonne_sierra_spa
- pv_tienda_010814
- pv_web_011204
test

Cambiar la apariencia del panel de navegación.

Panel de navegación

Mostrar las bases de datos navegación como árbol En el panel de navegación, reemplaza el árbol de base de datos con un selector
Enlace al panel principal Enlace con el panel principal resaltando la base de datos o tabla actual.
Mostrar el logo Mostrar el logo en el panel de navegación.
URL para enlace del logo URL a la que apuntará el logo en el panel de navegación.
Logo destino del enlace Abrir la página enlazada en la ventana principal (`principal`) o en una nueva (`nueva`).
Permitir destacar Resaltar servidor bajo el cursor.
Cantidad máxima de elementos en el primer nivel El número de elementos que pueden ser mostrados en cada página en el primer nivel del árbol de navegación.
Número mínimo de elementos para mostrar la caja de filtro Define el número mínimo de elementos (tablas, vistas, rutinas y eventos) para mostrar un cuadro de filtro.
Tablas recientemente utilizadas Número máximo de tablas recientemente utilizadas; 0 para desactivar.
Tablas favoritas Cantidad máxima de tablas favoritas; 0 para desactivar.
Anchura del panel de navegación Asignar 0 para ocular el panel de navegación.

Personalizar el árbol de navegación.

Árbol de navegación

Cantidad máxima de elementos en una rama El número de elementos que pueden ser mostrados en cada página del árbol de navegación.
Agrupar elementos en el árbol Agrupar elementos en el árbol de navegación (determinado por el separador definido abajo en las pestañas superiores de Bases de datos y Tablas).
Activar la expansión del árbol de navegación Si tendrá la posibilidad de expandir el árbol en el panel de navegación.
Mostrar tablas en árbol Si se muestran las tablas bajo base de datos en el árbol de navegación
Mostrar vistas en árbol Si se muestran vistas bajo base de datos en el árbol de navegación
Mostrar funciones en árbol Si se muestran las funciones bajo la base de datos en el árbol de navegación
Mostrar procedimientos en árbol Si se muestran los procedimientos bajo la base de datos en el árbol de navegación
Mostrar eventos en árbol Si se muestran eventos bajo la base de datos en el árbol de navegación
Expandir la base de datos única Si se debe desglosar automáticamente una base de datos individual en el árbol de navegación.

Opciones para visualizar los servidores.

Servidores

Mostrar la selección de servidores Mostrar la elección de servidor en la parte superior del panel de navegación.
Mostrar los servidores en una lista Mostrar los servidores en una lista en lugar de una caja desplegable.

Opciones para visualizar las bases de datos.

Bases de datos

Número mínimo de bases de datos a mostrar en la ventana de filtro de bases de datos
Separador de árbol de base de datos Cadena que separa bases de datos en diferentes niveles de árbol.

Opciones para visualizar las tablas.

Tablas

Destino para el icono de acceso rápido
Objetivo para el segundo icono de acceso rápido
Separador de árbol de tablas Cadena que separa tablas en diferentes niveles de árbol.
Profundidad máxima del árbol de tablas

Suelte aquí los archivos

Carga SQL ( 0 ) x -

Pulse en la barra para deslizarse al tope de la página

Presione Ctrl+Enter para ejecutar la consulta

Colapsar Expandir Mostrar rastro Ocultar rastro Tiempo necesario :

Ningún favorito

Etiqueta: Base de datos de destino: Compartir favorito

Siempre expandir mensajes de consultas
Mostrar histórico de consultas al iniciar
Mostrar consulta de navegación actual
Ejecute consultas en Enter e inserte una nueva línea con Shift+Enter. Para que esto sea permanente, consulte la configuración.
Cambiar al tema oscuro

Colapsar Expandir Reconsultar Editar Explicar Perfilando Agregar a favoritos Falló la consulta Base de datos : Fecha y hora la consulta :

Sin título *

v		pv_pasteleria_ivonne_sierra_spa bank_accounts
id : int(10)
account_name : varchar(255)
account_details : text
initial_balance : decimal(25,4)
account_no : varchar(255)
contact_person : varchar(255)
phone_number : varchar(14)
opening_date : datetime
url : text
total_deposit : decimal(25,4)
total_withdraw : decimal(25,4)
total_transfer_from_other : decimal(25,4)
total_transfer_to_other : decimal(25,4)
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa bank_account_to_store
ba2s : int(10) unsigned
store_id : int(10) unsigned
account_id : int(10) unsigned
deposit : decimal(25,4)
withdraw : decimal(25,4)
transfer_from_other : decimal(25,4)
transfer_to_other : decimal(25,4)
status : tinyint(1) unsigned
sort_order : int(10)

v		pv_pasteleria_ivonne_sierra_spa bank_transaction_info
info_id : int(10) unsigned
store_id : int(10) unsigned
transaction_type : text
is_substract : tinyint(1)
is_hide : tinyint(1)
account_id : int(10) unsigned
source_id : int(10)
exp_category_id : int(10)
ref_no : varchar(100)
invoice_id : varchar(100)
title : varchar(250)
details : text
from_account_id : int(10) unsigned
status : tinyint(1) unsigned
image : text
created_by : int(10) unsigned
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa bank_transaction_price
price_id : int(10)
store_id : int(10) unsigned
info_id : int(11)
ref_no : varchar(100)
amount : decimal(25,4)

v		pv_pasteleria_ivonne_sierra_spa boxes
box_id : int(10) unsigned
box_name : varchar(100)
code_name : varchar(55)
box_details : text

v		pv_pasteleria_ivonne_sierra_spa box_to_store
id : int(11)
box_id : int(11)
store_id : int(11)
status : tinyint(1) unsigned
sort_order : int(10)

v		pv_pasteleria_ivonne_sierra_spa brands
brand_id : int(10) unsigned
brand_name : varchar(100)
code_name : varchar(100)
brand_details : longtext
brand_image : varchar(250)
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa brand_to_store
b2s_id : int(10)
brand_id : int(11)
store_id : int(11)
status : tinyint(1)
sort_order : int(10)

v		pv_pasteleria_ivonne_sierra_spa cash_register_arqueo_lines
id : int(10) unsigned
session_id : int(10) unsigned
phase : enum('open','close')
line_kind : enum('denomination','pmethod')
pmethod_id : int(10) unsigned
label : varchar(120)
unit_value : decimal(25,4)
quantity : decimal(25,4)
amount : decimal(25,4)

v		pv_pasteleria_ivonne_sierra_spa cash_register_movements
id : int(10) unsigned
session_id : int(10) unsigned
direction : enum('in','out')
reason : varchar(50)
amount : decimal(25,4)
note : varchar(255)
created_by : int(10)
created_at : datetime

v		pv_pasteleria_ivonne_sierra_spa cash_register_sessions
id : int(10) unsigned
store_id : int(10) unsigned
ref_no : varchar(32)
status : enum('open','closed')
opened_by : int(10)
closed_by : int(10)
opened_at : datetime
closed_at : datetime
opening_cash : decimal(25,4)
opening_note : text
expected_cash : decimal(25,4)
expected_total : decimal(25,4)
counted_cash : decimal(25,4)
counted_total : decimal(25,4)
difference_amount : decimal(25,4)
closing_note : text
summary_snapshot : longtext
created_at : datetime
updated_at : datetime

v		pv_pasteleria_ivonne_sierra_spa categorys
category_id : int(10) unsigned
category_name : varchar(60)
category_slug : varchar(60)
parent_id : int(10)
category_details : text
category_image : varchar(250)
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa category_to_store
c2s_id : int(10)
ccategory_id : int(11)
store_id : int(11)
status : tinyint(1) unsigned
sort_order : int(10)

v		pv_pasteleria_ivonne_sierra_spa city
id : int(11)
id_department : varchar(5)
name : varchar(100)
code : varchar(5)

v		pv_pasteleria_ivonne_sierra_spa currency
currency_id : int(11)
title : varchar(32)
code : varchar(3)
symbol_left : varchar(12)
symbol_right : varchar(12)
decimal_place : char(1)
value : decimal(25,4)
created_at : datetime

v		pv_pasteleria_ivonne_sierra_spa currency_to_store
ca2s_id : int(11)
currency_id : int(11)
store_id : int(11)
status : tinyint(1)
sort_order : int(10)

v		pv_pasteleria_ivonne_sierra_spa customers
customer_id : int(10) unsigned
customer_name : varchar(100)
customer_email : varchar(100)
customer_mobile : varchar(14)
customer_address : text
dob : date
customer_sex : tinyint(1)
customer_age : int(10) unsigned
gtin : varchar(100)
customer_city : varchar(100)
customer_state : varchar(100)
customer_country : varchar(100)
is_giftcard : tinyint(1)
password : varchar(100)
raw_password : varchar(100)
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa customer_to_store
c2s_id : int(10) unsigned
customer_id : int(11)
store_id : int(11)
balance : decimal(25,4) unsigned
due : decimal(25,4) unsigned
status : tinyint(1)
sort_order : int(10)

v		pv_pasteleria_ivonne_sierra_spa customer_transactions
id : int(10) unsigned
type : enum('purchase','add_balance','substract_balance','due_paid','others')
reference_no : varchar(55)
ref_invoice_id : varchar(55)
customer_id : int(10) unsigned
store_id : int(10) unsigned
pmethod_id : int(10) unsigned
notes : text
amount : decimal(25,4)
balance : decimal(25,4)
created_by : int(10) unsigned
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa expenses
id : int(10) unsigned
store_id : int(10) unsigned
reference_no : varchar(100)
category_id : int(10) unsigned
title : varchar(255)
amount : decimal(25,4)
returnable : enum('no','yes')
note : longtext
attachment : varchar(100)
status : tinyint(1)
created_by : int(10)
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa expense_categorys
category_id : int(10) unsigned
category_name : varchar(60)
category_slug : varchar(60)
parent_id : int(10) unsigned
category_details : longtext
sell_return : tinyint(1)
sell_delete : tinyint(1)
loan_delete : tinyint(1)
loan_payment : tinyint(1)
giftcard_sell_delete : tinyint(1)
topup_delete : tinyint(1)
product_purchase : tinyint(1)
stock_transfer : tinyint(1)
due_paid : tinyint(1)
status : tinyint(1)
is_hide : tinyint(1)
sort_order : int(10)
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa gift_cards
id : int(11)
date : datetime
card_no : varchar(20)
value : decimal(25,4)
customer_id : int(11)
customer : varchar(255)
balance : decimal(25,4)
expiry : date
created_by : varchar(55)

v		pv_pasteleria_ivonne_sierra_spa gift_card_topups
id : int(11)
date : datetime
card_id : varchar(20)
amount : decimal(15,4)
created_by : int(11)

v		pv_pasteleria_ivonne_sierra_spa holding_info
info_id : int(10)
store_id : int(10) unsigned
order_title : varchar(255)
ref_no : varchar(100)
customer_id : int(10) unsigned
customer_mobile : varchar(20)
invoice_note : text
total_items : smallint(6)
created_by : int(10)
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa holding_item
id : int(10)
ref_no : varchar(100)
store_id : int(10) unsigned
item_id : int(10) unsigned
category_id : int(10) unsigned
brand_id : int(10)
sup_id : int(10)
item_name : varchar(100)
item_price : decimal(25,4)
item_discount : decimal(25,4)
item_tax : decimal(25,4)
tax_method : enum('inclusive','exclusive')
taxrate_id : int(10) unsigned
tax : varchar(20)
gst : varchar(20)
cgst : decimal(25,4)
sgst : decimal(25,4)
igst : decimal(25,4)
item_quantity : int(10) unsigned
item_total : decimal(25,4)
created_at : datetime

v		pv_pasteleria_ivonne_sierra_spa holding_price
price_id : int(10)
ref_no : varchar(100)
store_id : int(10) unsigned
subtotal : decimal(25,4)
discount_type : enum('plain','percentage')
discount_amount : decimal(25,4)
item_tax : decimal(25,4)
order_tax : decimal(25,4)
cgst : decimal(25,4)
sgst : decimal(25,4)
igst : decimal(25,4)
shipping_type : enum('plain','percentage')
shipping_amount : decimal(25,4)
others_charge : decimal(25,4)
payable_amount : decimal(25,4)

v		pv_pasteleria_ivonne_sierra_spa income_sources
source_id : int(10) unsigned
source_name : varchar(60)
type : enum('credit','debit')
source_slug : varchar(60)
parent_id : int(10) unsigned
source_details : longtext
for_sell : tinyint(1)
for_purchase_return : tinyint(1)
for_due_collection : tinyint(1)
for_loan : tinyint(1)
for_giftcard_sell : tinyint(1)
for_topup : tinyint(1)
for_stock_transfer : tinyint(1)
for_purchase_delete : tinyint(1)
for_expense_delete : tinyint(1)
profitable : enum('yes','no')
show_in_income : enum('yes','no')
status : tinyint(1)
is_hide : tinyint(1)
sort_order : int(10)
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa installment_orders
id : int(11)
store_id : int(11)
invoice_id : varchar(100)
purchase_invoice_id : varchar(100)
duration : int(11)
interval_count : int(11)
installment_count : int(11)
interest_percentage : decimal(25,4)
interest_amount : decimal(25,2)
initial_amount : decimal(25,4)
payment_status : enum('paid','due')
last_installment_date : datetime
installment_end_date : datetime
created_at : datetime

v		pv_pasteleria_ivonne_sierra_spa installment_payments
id : int(11)
store_id : int(11)
invoice_id : varchar(100)
payment_date : datetime
pmethod_id : int(11)
created_by : int(11)
note : text
capital : decimal(25,4)
interest : decimal(25,4)
payable : decimal(25,4)
paid : decimal(25,4)
due : decimal(25,4)
payment_status : enum('paid','due','pending','cancel')

v		pv_pasteleria_ivonne_sierra_spa languages
id : int(10) unsigned
name : varchar(100)
slug : varchar(50)
code : varchar(10)

v		pv_pasteleria_ivonne_sierra_spa language_translations
id : int(10)
lang_id : int(10)
lang_key : varchar(100)
key_type : enum('specific','default')
lang_value : text

v		pv_pasteleria_ivonne_sierra_spa loans
loan_id : int(10) unsigned
ref_no : varchar(50)
loan_from : varchar(100)
title : varchar(250)
amount : decimal(25,4) unsigned
interest : decimal(25,4)
payable : decimal(25,4) unsigned
paid : decimal(25,4) unsigned
due : decimal(25,4) unsigned
details : longtext
attachment : text
status : tinyint(1)
sort_order : int(11)
created_by : int(10) unsigned
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa loan_payments
id : int(11) unsigned
lloan_id : int(11) unsigned
ref_no : varchar(50)
paid : decimal(25,4)
note : text
created_by : int(11) unsigned
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa login_logs
id : int(10) unsigned
user_id : int(10) unsigned
username : varchar(100)
ip : varchar(50)
status : enum('success','error')
created_at : datetime

v		pv_pasteleria_ivonne_sierra_spa mail_sms_tag
tag_id : int(11) unsigned
type : varchar(50)
tagname : varchar(128)
created_at : datetime

v		pv_pasteleria_ivonne_sierra_spa payments
id : int(11)
type : varchar(20)
is_profit : tinyint(1)
is_hide : tinyint(1)
store_id : int(10) unsigned
invoice_id : varchar(100)
reference_no : varchar(100)
pmethod_id : int(10) unsigned
transaction_id : varchar(50)
capital : decimal(25,4)
amount : decimal(25,4)
details : text
attachment : text
note : text
total_paid : decimal(25,4)
pos_balance : decimal(25,4)
created_by : int(11)
created_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa pmethods
pmethod_id : int(10) unsigned
name : varchar(100)
code_name : varchar(50)
details : text
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa pmethod_to_store
p2s_id : int(11)
ppmethod_id : int(11)
store_id : int(11)
status : tinyint(1)
sort_order : int(10)

v		pv_pasteleria_ivonne_sierra_spa pos_register
id : int(11)
store_id : int(11)
opening_balance : decimal(25,4)
closing_balance : decimal(25,4)
note : text
status : tinyint(1)
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa pos_templates
template_id : int(10)
template_name : varchar(100)
template_content : longtext
template_css : longtext
created_at : datetime
updated_at : timestamp
created_by : int(10) unsigned

v		pv_pasteleria_ivonne_sierra_spa pos_template_to_store
pt2s : int(10)
store_id : int(10)
ttemplate_id : int(10)
is_active : tinyint(1)
status : tinyint(1)
sort_order : int(10)

v		pv_pasteleria_ivonne_sierra_spa printers
printer_id : int(11)
title : varchar(55)
type : varchar(25)
profile : varchar(25)
char_per_line : tinyint(3) unsigned
created_at : datetime

v		pv_pasteleria_ivonne_sierra_spa printer_to_store
p2s_id : int(10)
pprinter_id : int(11)
store_id : int(11)
path : varchar(255)
ip_address : varchar(45)
port : varchar(10)
status : tinyint(1) unsigned
sort_order : int(10)

v		pv_pasteleria_ivonne_sierra_spa products
p_id : int(10) unsigned
p_type : enum('standard','service','weighted')
p_code : varchar(50)
hsn_code : varchar(100)
barcode_symbology : varchar(50)
p_name : varchar(100)
category_id : int(10) unsigned
unit_id : int(10) unsigned
p_image : varchar(250)
description : longtext

v		pv_pasteleria_ivonne_sierra_spa product_images
image_id : int(11)
product_id : int(11)
url : varchar(255)
sort_order : int(11)

v		pv_pasteleria_ivonne_sierra_spa product_price_history
id : int(10) unsigned
store_id : int(10) unsigned
product_id : int(10) unsigned
purchase_price : decimal(25,4)
sell_price : decimal(25,4)
effective_from : datetime
effective_to : datetime
period_type : enum('manual','day','week','month','stock_intake')
source : enum('maintainer','purchase','stock_move_in','product_form','system')
source_ref : varchar(100)
note : text
created_by : int(10)
created_at : datetime

v		pv_pasteleria_ivonne_sierra_spa product_to_store
id : int(10) unsigned
product_id : int(11)
store_id : int(11)
purchase_price : decimal(25,4)
sell_price : decimal(25,4)
quantity_in_stock : decimal(25,4)
alert_quantity : decimal(25,4)
sup_id : int(10) unsigned
brand_id : int(10)
box_id : int(10) unsigned
taxrate_id : int(10) unsigned
tax_method : varchar(55)
preference : longtext
e_date : date
p_date : date
status : tinyint(1)
sort_order : int(10)

v		pv_pasteleria_ivonne_sierra_spa purchase_info
info_id : int(10) unsigned
invoice_id : varchar(100)
inv_type : varchar(32)
store_id : int(10) unsigned
sup_id : int(10) unsigned
total_item : decimal(25,4)
status : enum('stock','active','sold')
total_sell : decimal(25,4)
purchase_note : text
attachment : text
is_visible : tinyint(1) unsigned
payment_status : varchar(20)
checkout_status : tinyint(1)
shipping_status : enum('received','pending','ordered')
created_by : int(10)
purchase_date : datetime
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa purchase_item
id : int(10)
invoice_id : varchar(100)
store_id : int(10) unsigned
item_id : int(10) unsigned
category_id : int(10)
brand_id : int(10)
item_name : varchar(100)
item_purchase_price : decimal(25,4)
item_selling_price : decimal(25,4)
item_quantity : decimal(25,4)
total_sell : decimal(25,4)
status : enum('stock','active','sold')
item_total : decimal(25,4)
item_tax : decimal(25,4)
tax_method : enum('exclusive','inclusive')
tax : varchar(20)
gst : varchar(20)
cgst : decimal(25,4)
sgst : decimal(25,4)
igst : decimal(25,4)
return_quantity : decimal(25,4)
installment_quantity : int(11)

v		pv_pasteleria_ivonne_sierra_spa purchase_logs
id : int(10) unsigned
sup_id : int(10) unsigned
reference_no : varchar(55)
ref_invoice_id : varchar(55)
type : varchar(55)
pmethod_id : int(11)
description : text
amount : decimal(25,4)
store_id : int(10) unsigned
created_by : int(10) unsigned
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa purchase_payments
id : int(11)
type : varchar(20)
is_hide : tinyint(1)
store_id : int(10) unsigned
invoice_id : varchar(100)
reference_no : varchar(100)
pmethod_id : int(10) unsigned
transaction_id : varchar(50)
details : text
attachment : text
note : text
amount : decimal(25,4)
total_paid : decimal(25,4)
balance : decimal(25,4)
created_by : int(11)
created_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa purchase_price
price_id : int(10)
invoice_id : varchar(100)
store_id : int(10) unsigned
subtotal : decimal(25,4)
discount_type : enum('percentage','plain')
discount_amount : decimal(25,4)
shipping_type : enum('plain','percentage')
shipping_amount : decimal(25,4)
others_charge : decimal(25,4)
item_tax : decimal(25,4)
order_tax : decimal(25,4)
cgst : decimal(25,4)
sgst : decimal(25,4)
igst : decimal(25,4)
payable_amount : decimal(25,4)
paid_amount : decimal(25,4)
due_paid : decimal(25,4)
due : decimal(25,4)
return_amount : decimal(25,4) unsigned
balance : decimal(25,4)

v		pv_pasteleria_ivonne_sierra_spa purchase_returns
id : int(11)
store_id : int(10)
reference_no : varchar(55)
invoice_id : varchar(100)
sup_id : int(10)
note : varchar(1000)
total_item : int(10)
total_quantity : decimal(25,4)
subtotal : decimal(25,4)
total_amount : decimal(25,4)
item_tax : decimal(25,4)
cgst : decimal(25,4)
sgst : decimal(25,4)
igst : decimal(25,4)
attachment : varchar(55)
created_by : varchar(255)
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa purchase_return_items
id : int(11)
store_id : int(10)
invoice_id : varchar(100)
item_id : int(11)
item_name : varchar(255)
item_quantity : decimal(15,4)
item_price : decimal(25,4)
item_tax : decimal(25,4)
cgst : decimal(25,4)
sgst : decimal(25,4)
igst : decimal(25,4)
item_total : decimal(25,4)
created_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa quotation_info
info_id : int(10)
reference_no : varchar(100)
invoice_id : varchar(100)
store_id : int(10) unsigned
customer_id : int(10) unsigned
customer_mobile : varchar(20)
status : enum('sent','pending','complete','canceled')
payment_status : varchar(50)
quotation_note : text
is_installment : tinyint(1)
is_order : tinyint(1)
total_items : int(10)
address : text
pmethod_details : text
created_by : int(10) unsigned
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa quotation_item
id : int(10)
reference_no : varchar(100)
store_id : int(10) unsigned
sup_id : int(10) unsigned
category_id : int(10) unsigned
brand_id : int(10)
item_id : int(10) unsigned
item_name : varchar(100)
item_price : decimal(25,4)
item_discount : decimal(25,4)
item_tax : decimal(25,4)
tax_method : enum('exclusive','inclusive')
taxrate_id : int(10) unsigned
tax : varchar(55)
gst : varchar(20)
cgst : decimal(25,4)
sgst : decimal(25,4)
igst : decimal(25,4)
item_quantity : decimal(25,4)
item_purchase_price : decimal(25,4)
item_total : decimal(25,4)
purchase_invoice_id : varchar(100)

v		pv_pasteleria_ivonne_sierra_spa quotation_price
price_id : int(10)
reference_no : varchar(100)
store_id : int(10) unsigned
subtotal : decimal(25,4)
discount_type : enum('plain','percentage')
discount_amount : decimal(25,4)
interest_amount : decimal(25,4)
interest_percentage : int(10)
item_tax : decimal(25,4)
order_tax : decimal(25,4)
cgst : decimal(25,4)
sgst : decimal(25,4)
igst : decimal(25,4)
total_purchase_price : decimal(25,4)
shipping_type : enum('plain','percentage')
shipping_amount : decimal(25,4)
others_charge : decimal(25,4)
payable_amount : decimal(25,4)

v		pv_pasteleria_ivonne_sierra_spa returns
id : int(11)
store_id : int(10)
reference_no : varchar(55)
invoice_id : varchar(100)
purchase_invoice_id : varchar(100)
customer_id : int(10)
note : varchar(1000)
total_item : decimal(25,4)
total_quantity : decimal(25,4)
subtotal : decimal(25,4)
total_amount : decimal(25,4)
item_tax : decimal(25,4)
cgst : decimal(25,4)
sgst : decimal(25,4)
igst : decimal(25,4)
total_purchase_price : decimal(25,4)
profit : decimal(25,4) unsigned
attachment : varchar(55)
created_by : varchar(255)
created_at : timestamp
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa return_items
id : int(11)
store_id : int(10)
reference_no : varchar(100)
item_id : int(11)
item_name : varchar(255)
item_quantity : decimal(25,4)
item_purchase_price : decimal(25,4)
item_price : decimal(25,4)
item_tax : decimal(25,4)
cgst : decimal(25,4)
sgst : decimal(25,4)
igst : decimal(25,4)
item_total : decimal(25,4)
created_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa selling_info
info_id : int(10)
invoice_id : varchar(100)
edit_counter : int(10) unsigned
inv_type : enum('sell')
store_id : int(10) unsigned
customer_id : int(10) unsigned
customer_mobile : varchar(20)
ref_invoice_id : varchar(100)
ref_user_id : int(10) unsigned
invoice_note : text
total_items : smallint(6)
is_installment : tinyint(1)
status : tinyint(1) unsigned
pmethod_id : int(10)
payment_status : varchar(20)
checkout_status : tinyint(1)
created_by : int(10) unsigned
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa selling_item
id : int(10)
invoice_id : varchar(100)
category_id : int(10) unsigned
brand_id : int(10)
sup_id : int(10) unsigned
store_id : int(10) unsigned
item_id : int(10) unsigned
item_name : varchar(100)
item_price : decimal(25,4)
item_discount : decimal(25,4)
item_tax : decimal(25,4)
tax_method : enum('inclusive','exclusive')
taxrate_id : int(10) unsigned
tax : varchar(55)
gst : varchar(20)
cgst : decimal(25,4)
sgst : decimal(25,4)
igst : decimal(25,4)
item_quantity : decimal(25,4)
item_purchase_price : decimal(25,4)
item_total : decimal(25,4)
purchase_invoice_id : varchar(100)
print_counter : int(10) unsigned
print_counter_time : datetime
printed_by : int(10)
return_quantity : decimal(25,4)
installment_quantity : int(11)
created_at : datetime

v		pv_pasteleria_ivonne_sierra_spa selling_price
price_id : int(10)
invoice_id : varchar(100)
store_id : int(10) unsigned
subtotal : decimal(25,4)
discount_type : enum('plain','percentage')
discount_amount : decimal(25,4)
interest_amount : decimal(25,4)
interest_percentage : int(10)
item_tax : decimal(25,4)
order_tax : decimal(25,4)
cgst : decimal(25,4)
sgst : decimal(25,4)
igst : decimal(25,4)
total_purchase_price : decimal(25,4)
shipping_type : enum('plain','percentage')
shipping_amount : decimal(25,4)
others_charge : decimal(25,4)
payable_amount : decimal(25,4)
paid_amount : decimal(25,4)
due : decimal(25,4) unsigned
due_paid : decimal(25,4)
return_amount : decimal(25,4) unsigned
balance : decimal(25,4)
profit : decimal(25,4)
previous_due : decimal(25,4)
prev_due_paid : decimal(25,4)

v		pv_pasteleria_ivonne_sierra_spa sell_logs
id : int(10) unsigned
customer_id : int(10) unsigned
reference_no : varchar(55)
ref_invoice_id : varchar(55)
type : varchar(55)
pmethod_id : int(11)
description : text
amount : decimal(25,4)
store_id : int(10) unsigned
created_by : int(10) unsigned
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa settings
id : int(10)
version : varchar(10)
is_update_available : tinyint(1)
update_version : varchar(100)
update_link : text
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa shortcut_links
id : int(11)
type : varchar(100)
href : text
target : varchar(100)
title : varchar(255)
icon : varchar(50)
thumbnail : text
permission_slug : varchar(50)
status : tinyint(1)
sort_order : int(10)
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa sms_schedule
id : int(11) unsigned
schedule_datetime : datetime
store_id : int(10) unsigned
people_type : varchar(100)
people_sms_type : varchar(50)
mobile_number : varchar(20)
people_name : varchar(100)
sms_text : text
sms_type : varchar(50)
campaign_name : varchar(100)
process_status : tinyint(1) unsigned
total_try : int(11)
response_text : varchar(250)
delivery_status : varchar(50)
created_at : datetime

v		pv_pasteleria_ivonne_sierra_spa sms_setting
id : int(11)
type : varchar(50)
api_id : varchar(100)
auth_key : varchar(100)
sender_id : varchar(100)
contact : text
username : varchar(150)
password : varchar(150)
maskname : varchar(100)
campaignname : varchar(100)
unicode : varchar(20)
country_code : varchar(20)
url : varchar(150)
status : tinyint(1)
sort_order : int(10)
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa stock_movements
id : int(10) unsigned
store_id : int(10) unsigned
ref_no : varchar(50)
direction : enum('in','out')
reason : varchar(50)
note : text
total_cost_value : decimal(25,4)
total_sell_value : decimal(25,4)
purchase_invoice_id : varchar(100)
created_by : int(10)
created_at : datetime

v		pv_pasteleria_ivonne_sierra_spa stock_movement_items
id : int(10) unsigned
movement_id : int(10) unsigned
store_id : int(10) unsigned
product_id : int(10) unsigned
product_name : varchar(255)
quantity : decimal(25,4)
unit_cost : decimal(25,4)
unit_sell_price : decimal(25,4)
line_cost_total : decimal(25,4)
line_sell_total : decimal(25,4)
purchase_item_id : int(10) unsigned

v		pv_pasteleria_ivonne_sierra_spa stores
store_id : int(10)
name : varchar(100)
code_name : varchar(55)
mobile : varchar(14)
email : varchar(100)
country : varchar(50)
zip_code : varchar(50)
currency : varchar(100)
vat_reg_no : varchar(250)
cashier_id : int(10) unsigned
address : longtext
receipt_printer : varchar(100)
cash_drawer_codes : varchar(100)
char_per_line : tinyint(4)
remote_printing : tinyint(1)
printer : int(11)
order_printers : varchar(100)
auto_print : tinyint(1)
cash_drawer_enabled : tinyint(1)
local_printers : tinyint(1)
logo : text
favicon : varchar(250)
preference : longtext
sound_effect : tinyint(1) unsigned
sort_order : int(10) unsigned
feedback_status : varchar(100)
feedback_at : datetime
deposit_account_id : int(11)
thumbnail : varchar(255)
status : tinyint(1) unsigned
created_at : datetime

v		pv_pasteleria_ivonne_sierra_spa suppliers
sup_id : int(10) unsigned
sup_name : varchar(100)
code_name : varchar(55)
sup_mobile : varchar(14)
sup_email : varchar(100)
gtin : varchar(100)
sup_address : text
sup_city : varchar(100)
sup_state : varchar(55)
sup_country : varchar(100)
sup_details : longtext
created_at : datetime

v		pv_pasteleria_ivonne_sierra_spa supplier_to_store
s2s_id : int(10)
sup_id : int(11)
store_id : int(11)
balance : decimal(25,4)
status : tinyint(1)
sort_order : int(10)

v		pv_pasteleria_ivonne_sierra_spa taxrates
taxrate_id : int(11)
taxrate_name : varchar(55)
code_name : varchar(55)
taxrate : decimal(25,4)
status : tinyint(1)
sort_order : int(10)

v		pv_pasteleria_ivonne_sierra_spa transfers
id : int(11)
ref_no : varchar(55)
invoice_id : varchar(100)
ref_invoice_id : varchar(100)
from_store_id : int(11)
to_store_id : int(11)
note : varchar(1000)
total_item : decimal(25,4)
total_quantity : decimal(25,4)
created_by : varchar(255)
received_by : int(11)
cancelled_by : int(11)
status : varchar(55)
attachment : varchar(55)
created_at : datetime

v		pv_pasteleria_ivonne_sierra_spa transfer_items
id : int(11)
store_id : int(11)
transfer_id : int(11)
product_id : int(11)
product_name : varchar(255)
quantity : decimal(25,4)

v		pv_pasteleria_ivonne_sierra_spa units
unit_id : int(10)
unit_name : varchar(100)
code_name : varchar(50)
unit_details : text

v		pv_pasteleria_ivonne_sierra_spa unit_to_store
unit2s_id : int(10) unsigned
uunit_id : int(10) unsigned
store_id : int(10) unsigned
status : tinyint(1)
sort_order : int(10)

v		pv_pasteleria_ivonne_sierra_spa users
id : int(10) unsigned
group_id : int(11)
username : varchar(100)
email : varchar(100)
mobile : varchar(20)
dob : date
sex : varchar(10)
password : varchar(100)
raw_password : varchar(100)
pass_reset_code : varchar(32)
reset_code_time : datetime
login_try : tinyint(1) unsigned
last_login : datetime
ip : varchar(40)
address : text
preference : longtext
user_image : varchar(250)
created_at : datetime
updated_at : timestamp

v		pv_pasteleria_ivonne_sierra_spa user_group
group_id : int(11)
name : varchar(64)
slug : varchar(100)
sort_order : int(10)
status : tinyint(1)
permission : text

v		pv_pasteleria_ivonne_sierra_spa user_to_store
u2s_id : int(10)
user_id : int(11)
store_id : int(11)
status : tinyint(1)
sort_order : int(10)

Crear relación
FOREIGN KEY
on delete
on update