localhost:8080 / 127.0.0.1 / pv_demo_test

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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test boxes
box_id : int(10) unsigned
box_name : varchar(100)
code_name : varchar(55)
box_details : text

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

v		pv_demo_test 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_demo_test brand_to_store
b2s_id : int(10)
brand_id : int(11)
store_id : int(11)
status : tinyint(1)
sort_order : int(10)

v		pv_demo_test 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_demo_test 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_demo_test city
id : int(11)
id_department : varchar(5)
name : varchar(100)
code : varchar(5)

v		pv_demo_test 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_demo_test currency_to_store
ca2s_id : int(11)
currency_id : int(11)
store_id : int(11)
status : tinyint(1)
sort_order : int(10)

v		pv_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test gift_card_topups
id : int(11)
date : datetime
card_id : varchar(20)
amount : decimal(15,4)
created_by : int(11)

v		pv_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test languages
id : int(10) unsigned
name : varchar(100)
slug : varchar(50)
code : varchar(10)

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

v		pv_demo_test 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_demo_test 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_demo_test 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_demo_test mail_sms_tag
tag_id : int(11) unsigned
type : varchar(50)
tagname : varchar(128)
created_at : datetime

v		pv_demo_test 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_demo_test pmethods
pmethod_id : int(10) unsigned
name : varchar(100)
code_name : varchar(50)
details : text
created_at : datetime
updated_at : timestamp

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

v		pv_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test products
p_id : int(10) unsigned
p_type : enum('standard','service')
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_demo_test product_images
image_id : int(11)
product_id : int(11)
url : varchar(255)
sort_order : int(11)

v		pv_demo_test 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_demo_test purchase_info
info_id : int(10) unsigned
invoice_id : varchar(100)
inv_type : enum('purchase','transfer')
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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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)
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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test 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_demo_test units
unit_id : int(10)
unit_name : varchar(100)
code_name : varchar(50)
unit_details : text

v		pv_demo_test 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_demo_test 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_demo_test user_group
group_id : int(11)
name : varchar(64)
slug : varchar(100)
sort_order : int(10)
status : tinyint(1)
permission : text

v		pv_demo_test 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