user.tail04d718.ts.net / 127.0.0.1 / bagisto

There are no favourite tables.

New
alnaqeeb_charity
bagisto
biotimedb
charity
- charity
- charity_test
delivery_db
- delivery_db
- delivery_db_new
ecommerce_db
emp_track_db
enjazi_db
enjaz_workflow
enterprise_workflow
goal_tracker
hr_complaint_app
icehrm_db
ims
information_schema
inventory_management
invoice_db
jobapplications
kalkun
mysql
opencart_db
performance_schema
phpmyadmin
sales
- sales_inventory_db
- sales_management
supermarket_app
test
the_old_database
ticket_app_db
- ticket_app_db
- ticket_app_db_test
velstore
warehouse
workflow
zk_attendance

Customise appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favourite tables Maximum number of favourite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customise the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

No bookmarks

Label: Target database: Share this bookmark

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Untitled *

v		bagisto 1addresses
id : int(10) unsigned
address_type : varchar(255)
parent_address_id : int(10) unsigned
customer_id : int(10) unsigned
cart_id : int(10) unsigned
order_id : int(10) unsigned
first_name : varchar(255)
last_name : varchar(255)
gender : varchar(255)
company_name : varchar(255)
address : varchar(255)
city : varchar(255)
state : varchar(255)
country : varchar(255)
postcode : varchar(255)
email : varchar(255)
phone : varchar(255)
vat_id : varchar(255)
default_address : tinyint(1)
use_for_shipping : tinyint(1)
additional : longtext
created_at : timestamp
updated_at : timestamp

v		bagisto 1admins
id : int(10) unsigned
name : varchar(255)
email : varchar(255)
password : varchar(255)
api_token : varchar(80)
status : tinyint(1)
role_id : int(10) unsigned
image : varchar(255)
remember_token : varchar(100)
created_at : timestamp
updated_at : timestamp

v		bagisto 1admin_password_resets
email : varchar(255)
token : varchar(255)
created_at : timestamp

v		bagisto 1attributes
id : int(10) unsigned
code : varchar(255)
admin_name : varchar(255)
type : varchar(255)
swatch_type : varchar(255)
validation : varchar(255)
regex : varchar(255)
position : int(11)
is_required : tinyint(1)
is_unique : tinyint(1)
is_filterable : tinyint(1)
is_comparable : tinyint(1)
is_configurable : tinyint(1)
is_user_defined : tinyint(1)
is_visible_on_front : tinyint(1)
value_per_locale : tinyint(1)
value_per_channel : tinyint(1)
default_value : int(11)
enable_wysiwyg : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		bagisto 1attribute_families
id : int(10) unsigned
code : varchar(255)
name : varchar(255)
status : tinyint(1)
is_user_defined : tinyint(1)

v		bagisto 1attribute_groups
id : int(10) unsigned
code : varchar(255)
attribute_family_id : int(10) unsigned
name : varchar(255)
column : int(11)
position : int(11)
is_user_defined : tinyint(1)

v		bagisto 1attribute_group_mappings
attribute_id : int(10) unsigned
attribute_group_id : int(10) unsigned
position : int(11)

v		bagisto 1attribute_options
id : int(10) unsigned
attribute_id : int(10) unsigned
admin_name : varchar(255)
sort_order : int(11)
swatch_value : varchar(255)

v		bagisto 1attribute_option_translations
id : int(10) unsigned
attribute_option_id : int(10) unsigned
locale : varchar(255)
label : text

v		bagisto 1attribute_translations
id : int(10) unsigned
attribute_id : int(10) unsigned
locale : varchar(255)
name : text

v		bagisto 1bookings
id : bigint(20) unsigned
product_id : int(10) unsigned
order_item_id : int(10) unsigned
order_id : int(10) unsigned
qty : int(11)
from : int(11)
to : int(11)
booking_product_event_ticket_id : bigint(20) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1booking_products
id : int(10) unsigned
product_id : int(10) unsigned
type : varchar(255)
qty : int(11)
location : varchar(255)
show_location : tinyint(1)
available_every_week : tinyint(1)
available_from : datetime
available_to : datetime
created_at : timestamp
updated_at : timestamp

v		bagisto 1booking_product_appointment_slots
id : bigint(20) unsigned
booking_product_id : int(10) unsigned
duration : int(11)
break_time : int(11)
same_slot_all_days : tinyint(1)
slots : longtext

v		bagisto 1booking_product_default_slots
id : bigint(20) unsigned
booking_product_id : int(10) unsigned
booking_type : varchar(255)
duration : int(11)
break_time : int(11)
slots : longtext

v		bagisto 1booking_product_event_tickets
id : bigint(20) unsigned
booking_product_id : int(10) unsigned
price : decimal(12,4)
qty : int(11)
special_price : decimal(12,4)
special_price_from : datetime
special_price_to : datetime

v		bagisto 1booking_product_event_ticket_translations
id : bigint(20) unsigned
booking_product_event_ticket_id : bigint(20) unsigned
locale : varchar(255)
name : text
description : text

v		bagisto 1booking_product_rental_slots
id : bigint(20) unsigned
booking_product_id : int(10) unsigned
renting_type : varchar(255)
daily_price : decimal(12,4)
hourly_price : decimal(12,4)
same_slot_all_days : tinyint(1)
slots : longtext

v		bagisto 1booking_product_table_slots
id : bigint(20) unsigned
booking_product_id : int(10) unsigned
price_type : varchar(255)
guest_limit : int(11)
duration : int(11)
break_time : int(11)
prevent_scheduling_before : int(11)
same_slot_all_days : tinyint(1)
slots : longtext
created_at : timestamp
updated_at : timestamp

v		bagisto 1cart
id : int(10) unsigned
customer_email : varchar(255)
customer_first_name : varchar(255)
customer_last_name : varchar(255)
shipping_method : varchar(255)
coupon_code : varchar(255)
is_gift : tinyint(1)
items_count : int(11)
items_qty : decimal(12,4)
exchange_rate : decimal(12,4)
global_currency_code : varchar(255)
base_currency_code : varchar(255)
channel_currency_code : varchar(255)
cart_currency_code : varchar(255)
grand_total : decimal(12,4)
base_grand_total : decimal(12,4)
sub_total : decimal(12,4)
base_sub_total : decimal(12,4)
tax_total : decimal(12,4)
base_tax_total : decimal(12,4)
discount_amount : decimal(12,4)
base_discount_amount : decimal(12,4)
shipping_amount : decimal(12,4)
base_shipping_amount : decimal(12,4)
shipping_amount_incl_tax : decimal(12,4)
base_shipping_amount_incl_tax : decimal(12,4)
sub_total_incl_tax : decimal(12,4)
base_sub_total_incl_tax : decimal(12,4)
checkout_method : varchar(255)
is_guest : tinyint(1)
is_active : tinyint(1)
applied_cart_rule_ids : varchar(255)
customer_id : int(10) unsigned
channel_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1cart_items
id : int(10) unsigned
quantity : int(10) unsigned
sku : varchar(255)
type : varchar(255)
name : varchar(255)
coupon_code : varchar(255)
weight : decimal(12,4)
total_weight : decimal(12,4)
base_total_weight : decimal(12,4)
price : decimal(12,4)
base_price : decimal(12,4)
custom_price : decimal(12,4)
total : decimal(12,4)
base_total : decimal(12,4)
tax_percent : decimal(12,4)
tax_amount : decimal(12,4)
base_tax_amount : decimal(12,4)
discount_percent : decimal(12,4)
discount_amount : decimal(12,4)
base_discount_amount : decimal(12,4)
price_incl_tax : decimal(12,4)
base_price_incl_tax : decimal(12,4)
total_incl_tax : decimal(12,4)
base_total_incl_tax : decimal(12,4)
applied_tax_rate : varchar(255)
parent_id : int(10) unsigned
product_id : int(10) unsigned
cart_id : int(10) unsigned
tax_category_id : int(10) unsigned
applied_cart_rule_ids : varchar(255)
additional : longtext
created_at : timestamp
updated_at : timestamp

v		bagisto 1cart_item_inventories
id : int(10) unsigned
qty : int(10) unsigned
inventory_source_id : int(10) unsigned
cart_item_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1cart_payment
id : int(10) unsigned
method : varchar(255)
method_title : varchar(255)
cart_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1cart_rules
id : int(10) unsigned
name : varchar(255)
description : varchar(255)
starts_from : datetime
ends_till : datetime
status : tinyint(1)
coupon_type : int(11)
use_auto_generation : tinyint(1)
usage_per_customer : int(11)
uses_per_coupon : int(11)
times_used : int(10) unsigned
condition_type : tinyint(1)
conditions : longtext
end_other_rules : tinyint(1)
uses_attribute_conditions : tinyint(1)
action_type : varchar(255)
discount_amount : decimal(12,4)
discount_quantity : int(11)
discount_step : varchar(255)
apply_to_shipping : tinyint(1)
free_shipping : tinyint(1)
sort_order : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1cart_rule_channels
cart_rule_id : int(10) unsigned
channel_id : int(10) unsigned

v		bagisto 1cart_rule_coupons
id : int(10) unsigned
code : varchar(255)
usage_limit : int(10) unsigned
usage_per_customer : int(10) unsigned
times_used : int(10) unsigned
type : int(10) unsigned
is_primary : tinyint(1)
expired_at : date
cart_rule_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1cart_rule_coupon_usage
id : int(10) unsigned
times_used : int(11)
cart_rule_coupon_id : int(10) unsigned
customer_id : int(10) unsigned

v		bagisto 1cart_rule_customers
id : int(10) unsigned
times_used : bigint(20) unsigned
customer_id : int(10) unsigned
cart_rule_id : int(10) unsigned

v		bagisto 1cart_rule_customer_groups
cart_rule_id : int(10) unsigned
customer_group_id : int(10) unsigned

v		bagisto 1cart_rule_translations
id : int(10) unsigned
locale : varchar(255)
label : text
cart_rule_id : int(10) unsigned

v		bagisto 1cart_shipping_rates
id : int(10) unsigned
carrier : varchar(255)
carrier_title : varchar(255)
method : varchar(255)
method_title : varchar(255)
method_description : varchar(255)
price : double
base_price : double
discount_amount : decimal(12,4)
base_discount_amount : decimal(12,4)
tax_percent : decimal(12,4)
tax_amount : decimal(12,4)
base_tax_amount : decimal(12,4)
price_incl_tax : decimal(12,4)
base_price_incl_tax : decimal(12,4)
applied_tax_rate : varchar(255)
is_calculate_tax : tinyint(1)
cart_address_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp
cart_id : int(10) unsigned

v		bagisto 1catalog_rules
id : int(10) unsigned
name : varchar(255)
description : varchar(255)
starts_from : date
ends_till : date
status : tinyint(1)
condition_type : tinyint(1)
conditions : longtext
end_other_rules : tinyint(1)
action_type : varchar(255)
discount_amount : decimal(12,4)
sort_order : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1catalog_rule_channels
catalog_rule_id : int(10) unsigned
channel_id : int(10) unsigned

v		bagisto 1catalog_rule_customer_groups
catalog_rule_id : int(10) unsigned
customer_group_id : int(10) unsigned

v		bagisto 1catalog_rule_products
id : int(10) unsigned
starts_from : datetime
ends_till : datetime
end_other_rules : tinyint(1)
action_type : varchar(255)
discount_amount : decimal(12,4)
sort_order : int(10) unsigned
product_id : int(10) unsigned
customer_group_id : int(10) unsigned
catalog_rule_id : int(10) unsigned
channel_id : int(10) unsigned

v		bagisto 1catalog_rule_product_prices
id : int(10) unsigned
price : decimal(12,4)
rule_date : date
starts_from : datetime
ends_till : datetime
product_id : int(10) unsigned
customer_group_id : int(10) unsigned
catalog_rule_id : int(10) unsigned
channel_id : int(10) unsigned

v		bagisto 1categories
id : int(10) unsigned
position : int(11)
logo_path : text
status : tinyint(1)
display_mode : varchar(255)
_lft : int(10) unsigned
_rgt : int(10) unsigned
parent_id : int(10) unsigned
additional : longtext
banner_path : text
created_at : timestamp
updated_at : timestamp

v		bagisto 1category_filterable_attributes
category_id : int(10) unsigned
attribute_id : int(10) unsigned

v		bagisto 1category_translations
id : int(10) unsigned
category_id : int(10) unsigned
name : text
slug : varchar(255)
url_path : varchar(2048)
description : text
meta_title : text
meta_description : text
meta_keywords : text
locale_id : int(10) unsigned
locale : varchar(255)

v		bagisto 1channels
id : int(10) unsigned
code : varchar(255)
timezone : varchar(255)
theme : varchar(255)
hostname : varchar(255)
logo : varchar(255)
favicon : varchar(255)
home_seo : longtext
is_maintenance_on : tinyint(1)
allowed_ips : text
root_category_id : int(10) unsigned
default_locale_id : int(10) unsigned
base_currency_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1channel_currencies
channel_id : int(10) unsigned
currency_id : int(10) unsigned

v		bagisto 1channel_inventory_sources
channel_id : int(10) unsigned
inventory_source_id : int(10) unsigned

v		bagisto 1channel_locales
channel_id : int(10) unsigned
locale_id : int(10) unsigned

v		bagisto 1channel_translations
id : bigint(20) unsigned
channel_id : int(10) unsigned
locale : varchar(255)
name : varchar(255)
description : text
maintenance_mode_text : text
home_seo : longtext
created_at : timestamp
updated_at : timestamp

v		bagisto 1cms_pages
id : int(10) unsigned
layout : varchar(255)
created_at : timestamp
updated_at : timestamp

v		bagisto 1cms_page_channels
cms_page_id : int(10) unsigned
channel_id : int(10) unsigned

v		bagisto 1cms_page_translations
id : int(10) unsigned
page_title : varchar(255)
url_key : varchar(255)
html_content : longtext
meta_title : text
meta_description : text
meta_keywords : text
locale : varchar(255)
cms_page_id : int(10) unsigned

v		bagisto 1compare_items
id : int(10) unsigned
product_id : int(10) unsigned
customer_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1core_config
id : int(10) unsigned
code : varchar(255)
value : text
channel_code : varchar(255)
locale_code : varchar(255)
created_at : timestamp
updated_at : timestamp

v		bagisto 1countries
id : int(10) unsigned
code : varchar(255)
name : varchar(255)

v		bagisto 1country_states
id : int(10) unsigned
country_id : int(10) unsigned
country_code : varchar(255)
code : varchar(255)
default_name : varchar(255)

v		bagisto 1country_state_translations
id : int(10) unsigned
country_state_id : int(10) unsigned
locale : varchar(255)
default_name : text

v		bagisto 1country_translations
id : int(10) unsigned
country_id : int(10) unsigned
locale : varchar(255)
name : text

v		bagisto 1currencies
id : int(10) unsigned
code : varchar(255)
name : varchar(255)
symbol : varchar(255)
decimal : int(10) unsigned
group_separator : varchar(255)
decimal_separator : varchar(255)
currency_position : varchar(255)
created_at : timestamp
updated_at : timestamp

v		bagisto 1currency_exchange_rates
id : int(10) unsigned
rate : decimal(24,12)
target_currency : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1customers
id : int(10) unsigned
first_name : varchar(255)
last_name : varchar(255)
gender : varchar(50)
date_of_birth : date
email : varchar(255)
phone : varchar(255)
image : varchar(255)
status : tinyint(4)
password : varchar(255)
api_token : varchar(80)
customer_group_id : int(10) unsigned
channel_id : int(10) unsigned
subscribed_to_news_letter : tinyint(1)
is_verified : tinyint(1)
is_suspended : tinyint(3) unsigned
token : varchar(255)
remember_token : varchar(100)
created_at : timestamp
updated_at : timestamp

v		bagisto 1customer_groups
id : int(10) unsigned
code : varchar(255)
name : varchar(255)
is_user_defined : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		bagisto 1customer_notes
id : bigint(20) unsigned
customer_id : int(10) unsigned
note : text
customer_notified : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		bagisto 1customer_password_resets
email : varchar(255)
token : varchar(255)
created_at : timestamp

v		bagisto 1customer_social_accounts
id : int(10) unsigned
customer_id : int(10) unsigned
provider_name : varchar(255)
provider_id : varchar(255)
created_at : timestamp
updated_at : timestamp

v		bagisto 1datagrid_saved_filters
id : bigint(20) unsigned
user_id : int(10) unsigned
name : varchar(255)
src : varchar(255)
applied : longtext
created_at : timestamp
updated_at : timestamp

v		bagisto 1downloadable_link_purchased
id : int(10) unsigned
product_name : varchar(255)
name : varchar(255)
url : varchar(255)
file : varchar(255)
file_name : varchar(255)
type : varchar(255)
download_bought : int(11)
download_used : int(11)
status : varchar(255)
customer_id : int(10) unsigned
order_id : int(10) unsigned
order_item_id : int(10) unsigned
download_canceled : int(11)
created_at : timestamp
updated_at : timestamp

v		bagisto 1failed_jobs
id : bigint(20) unsigned
uuid : varchar(255)
connection : text
queue : text
payload : longtext
exception : longtext
failed_at : timestamp

v		bagisto 1gdpr_data_request
id : int(10) unsigned
customer_id : int(10) unsigned
email : varchar(255)
status : varchar(255)
type : varchar(255)
message : varchar(500)
revoked_at : timestamp
created_at : timestamp
updated_at : timestamp

v		bagisto 1imports
id : int(10) unsigned
state : varchar(255)
process_in_queue : tinyint(1)
type : varchar(255)
action : varchar(255)
validation_strategy : varchar(255)
allowed_errors : int(11)
processed_rows_count : int(11)
invalid_rows_count : int(11)
errors_count : int(11)
errors : longtext
field_separator : varchar(255)
file_path : varchar(255)
images_directory_path : varchar(255)
error_file_path : varchar(255)
summary : longtext
started_at : datetime
completed_at : datetime
created_at : timestamp
updated_at : timestamp

v		bagisto 1import_batches
id : int(10) unsigned
state : varchar(255)
data : longtext
summary : longtext
import_id : int(10) unsigned

v		bagisto 1inventory_sources
id : int(10) unsigned
code : varchar(255)
name : varchar(255)
description : text
contact_name : varchar(255)
contact_email : varchar(255)
contact_number : varchar(255)
contact_fax : varchar(255)
country : varchar(255)
state : varchar(255)
city : varchar(255)
street : varchar(255)
postcode : varchar(255)
priority : int(11)
latitude : decimal(10,5)
longitude : decimal(10,5)
status : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		bagisto 1invoices
id : int(10) unsigned
increment_id : varchar(255)
state : varchar(255)
email_sent : tinyint(1)
total_qty : int(11)
base_currency_code : varchar(255)
channel_currency_code : varchar(255)
order_currency_code : varchar(255)
sub_total : decimal(12,4)
base_sub_total : decimal(12,4)
grand_total : decimal(12,4)
base_grand_total : decimal(12,4)
shipping_amount : decimal(12,4)
base_shipping_amount : decimal(12,4)
tax_amount : decimal(12,4)
base_tax_amount : decimal(12,4)
discount_amount : decimal(12,4)
base_discount_amount : decimal(12,4)
shipping_tax_amount : decimal(12,4)
base_shipping_tax_amount : decimal(12,4)
sub_total_incl_tax : decimal(12,4)
base_sub_total_incl_tax : decimal(12,4)
shipping_amount_incl_tax : decimal(12,4)
base_shipping_amount_incl_tax : decimal(12,4)
order_id : int(10) unsigned
transaction_id : varchar(255)
reminders : int(11)
next_reminder_at : timestamp
created_at : timestamp
updated_at : timestamp

v		bagisto 1invoice_items
id : int(10) unsigned
parent_id : int(10) unsigned
name : varchar(255)
description : varchar(255)
sku : varchar(255)
qty : int(11)
price : decimal(12,4)
base_price : decimal(12,4)
total : decimal(12,4)
base_total : decimal(12,4)
tax_amount : decimal(12,4)
base_tax_amount : decimal(12,4)
discount_percent : decimal(12,4)
discount_amount : decimal(12,4)
base_discount_amount : decimal(12,4)
price_incl_tax : decimal(12,4)
base_price_incl_tax : decimal(12,4)
total_incl_tax : decimal(12,4)
base_total_incl_tax : decimal(12,4)
product_id : int(10) unsigned
product_type : varchar(255)
order_item_id : int(10) unsigned
invoice_id : int(10) unsigned
additional : longtext
created_at : timestamp
updated_at : timestamp

v		bagisto 1jobs
id : bigint(20) unsigned
queue : varchar(255)
payload : longtext
attempts : tinyint(3) unsigned
reserved_at : int(10) unsigned
available_at : int(10) unsigned
created_at : int(10) unsigned

v		bagisto 1job_batches
id : varchar(255)
name : varchar(255)
total_jobs : int(11)
pending_jobs : int(11)
failed_jobs : int(11)
failed_job_ids : text
options : mediumtext
cancelled_at : int(11)
created_at : int(11)
finished_at : int(11)

v		bagisto 1locales
id : int(10) unsigned
code : varchar(255)
name : varchar(255)
direction : enum('ltr','rtl')
logo_path : varchar(255)
created_at : timestamp
updated_at : timestamp

v		bagisto 1marketing_campaigns
id : int(10) unsigned
name : varchar(255)
subject : varchar(255)
status : tinyint(1)
type : varchar(255)
mail_to : varchar(255)
spooling : varchar(255)
channel_id : int(10) unsigned
customer_group_id : int(10) unsigned
marketing_template_id : int(10) unsigned
marketing_event_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1marketing_events
id : int(10) unsigned
name : varchar(255)
description : text
date : date
created_at : timestamp
updated_at : timestamp

v		bagisto 1marketing_templates
id : int(10) unsigned
name : varchar(255)
status : varchar(255)
content : text
created_at : timestamp
updated_at : timestamp

v		bagisto 1migrations
id : int(10) unsigned
migration : varchar(255)
batch : int(11)

v		bagisto 1notifications
id : int(10) unsigned
type : varchar(255)
read : tinyint(1)
order_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1orders
id : int(10) unsigned
increment_id : varchar(255)
status : varchar(255)
channel_name : varchar(255)
is_guest : tinyint(1)
customer_email : varchar(255)
customer_first_name : varchar(255)
customer_last_name : varchar(255)
shipping_method : varchar(255)
shipping_title : varchar(255)
shipping_description : varchar(255)
coupon_code : varchar(255)
is_gift : tinyint(1)
total_item_count : int(11)
total_qty_ordered : int(11)
base_currency_code : varchar(255)
channel_currency_code : varchar(255)
order_currency_code : varchar(255)
grand_total : decimal(12,4)
base_grand_total : decimal(12,4)
grand_total_invoiced : decimal(12,4)
base_grand_total_invoiced : decimal(12,4)
grand_total_refunded : decimal(12,4)
base_grand_total_refunded : decimal(12,4)
sub_total : decimal(12,4)
base_sub_total : decimal(12,4)
sub_total_invoiced : decimal(12,4)
base_sub_total_invoiced : decimal(12,4)
sub_total_refunded : decimal(12,4)
base_sub_total_refunded : decimal(12,4)
discount_percent : decimal(12,4)
discount_amount : decimal(12,4)
base_discount_amount : decimal(12,4)
discount_invoiced : decimal(12,4)
base_discount_invoiced : decimal(12,4)
discount_refunded : decimal(12,4)
base_discount_refunded : decimal(12,4)
tax_amount : decimal(12,4)
base_tax_amount : decimal(12,4)
tax_amount_invoiced : decimal(12,4)
base_tax_amount_invoiced : decimal(12,4)
tax_amount_refunded : decimal(12,4)
base_tax_amount_refunded : decimal(12,4)
shipping_amount : decimal(12,4)
base_shipping_amount : decimal(12,4)
shipping_invoiced : decimal(12,4)
base_shipping_invoiced : decimal(12,4)
shipping_refunded : decimal(12,4)
base_shipping_refunded : decimal(12,4)
shipping_discount_amount : decimal(12,4)
base_shipping_discount_amount : decimal(12,4)
shipping_tax_amount : decimal(12,4)
base_shipping_tax_amount : decimal(12,4)
shipping_tax_refunded : decimal(12,4)
base_shipping_tax_refunded : decimal(12,4)
sub_total_incl_tax : decimal(12,4)
base_sub_total_incl_tax : decimal(12,4)
shipping_amount_incl_tax : decimal(12,4)
base_shipping_amount_incl_tax : decimal(12,4)
customer_id : int(10) unsigned
customer_type : varchar(255)
channel_id : int(10) unsigned
channel_type : varchar(255)
cart_id : int(11)
applied_cart_rule_ids : varchar(255)
created_at : timestamp
updated_at : timestamp

v		bagisto 1order_comments
id : int(10) unsigned
order_id : int(10) unsigned
comment : text
customer_notified : tinyint(1)
created_at : timestamp
updated_at : timestamp

v		bagisto 1order_items
id : int(10) unsigned
sku : varchar(255)
type : varchar(255)
name : varchar(255)
coupon_code : varchar(255)
weight : decimal(12,4)
total_weight : decimal(12,4)
qty_ordered : int(11)
qty_shipped : int(11)
qty_invoiced : int(11)
qty_canceled : int(11)
qty_refunded : int(11)
price : decimal(12,4)
base_price : decimal(12,4)
total : decimal(12,4)
base_total : decimal(12,4)
total_invoiced : decimal(12,4)
base_total_invoiced : decimal(12,4)
amount_refunded : decimal(12,4)
base_amount_refunded : decimal(12,4)
discount_percent : decimal(12,4)
discount_amount : decimal(12,4)
base_discount_amount : decimal(12,4)
discount_invoiced : decimal(12,4)
base_discount_invoiced : decimal(12,4)
discount_refunded : decimal(12,4)
base_discount_refunded : decimal(12,4)
tax_percent : decimal(12,4)
tax_amount : decimal(12,4)
base_tax_amount : decimal(12,4)
tax_amount_invoiced : decimal(12,4)
base_tax_amount_invoiced : decimal(12,4)
tax_amount_refunded : decimal(12,4)
base_tax_amount_refunded : decimal(12,4)
price_incl_tax : decimal(12,4)
base_price_incl_tax : decimal(12,4)
total_incl_tax : decimal(12,4)
base_total_incl_tax : decimal(12,4)
product_id : int(10) unsigned
product_type : varchar(255)
order_id : int(10) unsigned
tax_category_id : int(10) unsigned
parent_id : int(10) unsigned
additional : longtext
created_at : timestamp
updated_at : timestamp

v		bagisto 1order_payment
id : int(10) unsigned
order_id : int(10) unsigned
method : varchar(255)
method_title : varchar(255)
additional : longtext
created_at : timestamp
updated_at : timestamp

v		bagisto 1order_transactions
id : int(10) unsigned
transaction_id : varchar(255)
status : varchar(255)
type : varchar(255)
amount : decimal(12,4)
payment_method : varchar(255)
data : longtext
invoice_id : int(10) unsigned
order_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1password_resets
email : varchar(255)
token : varchar(255)
created_at : timestamp

v		bagisto 1personal_access_tokens
id : bigint(20) unsigned
tokenable_type : varchar(255)
tokenable_id : bigint(20) unsigned
name : varchar(255)
token : varchar(64)
abilities : text
last_used_at : timestamp
expires_at : timestamp
created_at : timestamp
updated_at : timestamp

v		bagisto 1products
id : int(10) unsigned
sku : varchar(255)
type : varchar(255)
parent_id : int(10) unsigned
attribute_family_id : int(10) unsigned
additional : longtext
created_at : timestamp
updated_at : timestamp

v		bagisto 1product_attribute_values
id : int(10) unsigned
locale : varchar(255)
channel : varchar(255)
text_value : text
boolean_value : tinyint(1)
integer_value : int(11)
float_value : decimal(12,4)
datetime_value : datetime
date_value : date
json_value : longtext
product_id : int(10) unsigned
attribute_id : int(10) unsigned
unique_id : varchar(255)

v		bagisto 1product_bundle_options
id : int(10) unsigned
product_id : int(10) unsigned
type : varchar(255)
is_required : tinyint(1)
sort_order : int(11)

v		bagisto 1product_bundle_option_products
id : int(10) unsigned
product_id : int(10) unsigned
product_bundle_option_id : int(10) unsigned
qty : int(11)
is_user_defined : tinyint(1)
is_default : tinyint(1)
sort_order : int(11)

v		bagisto 1product_bundle_option_translations
id : int(10) unsigned
locale : varchar(255)
label : varchar(255)
product_bundle_option_id : int(10) unsigned

v		bagisto 1product_categories
product_id : int(10) unsigned
category_id : int(10) unsigned

v		bagisto 1product_channels
product_id : int(10) unsigned
channel_id : int(10) unsigned

v		bagisto 1product_cross_sells
parent_id : int(10) unsigned
child_id : int(10) unsigned

v		bagisto 1product_customer_group_prices
id : bigint(20) unsigned
qty : int(11)
value_type : varchar(255)
value : decimal(12,4)
product_id : int(10) unsigned
customer_group_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp
unique_id : varchar(255)

v		bagisto 1product_customizable_options
id : int(10) unsigned
product_id : int(10) unsigned
type : varchar(255)
is_required : tinyint(1)
max_characters : text
supported_file_extensions : text
sort_order : int(11)

v		bagisto 1product_customizable_option_prices
id : int(10) unsigned
label : text
price : decimal(12,4)
product_customizable_option_id : int(10) unsigned
sort_order : int(11)

v		bagisto 1product_customizable_option_translations
id : int(10) unsigned
locale : varchar(255)
label : text
product_customizable_option_id : int(10) unsigned

v		bagisto 1product_downloadable_links
id : int(10) unsigned
product_id : int(10) unsigned
url : varchar(255)
file : varchar(255)
file_name : varchar(255)
type : varchar(255)
price : decimal(12,4)
sample_url : varchar(255)
sample_file : varchar(255)
sample_file_name : varchar(255)
sample_type : varchar(255)
downloads : int(11)
sort_order : int(11)
created_at : timestamp
updated_at : timestamp

v		bagisto 1product_downloadable_link_translations
id : int(10) unsigned
product_downloadable_link_id : int(10) unsigned
locale : varchar(255)
title : text

v		bagisto 1product_downloadable_samples
id : int(10) unsigned
product_id : int(10) unsigned
url : varchar(255)
file : varchar(255)
file_name : varchar(255)
type : varchar(255)
sort_order : int(11)
created_at : timestamp
updated_at : timestamp

v		bagisto 1product_downloadable_sample_translations
id : int(10) unsigned
product_downloadable_sample_id : int(10) unsigned
locale : varchar(255)
title : text

v		bagisto 1product_flat
id : int(10) unsigned
sku : varchar(255)
type : varchar(255)
product_number : varchar(255)
name : varchar(255)
short_description : text
description : text
url_key : varchar(255)
new : tinyint(1)
featured : tinyint(1)
status : tinyint(1)
meta_title : text
meta_keywords : text
meta_description : text
price : decimal(12,4)
special_price : decimal(12,4)
special_price_from : date
special_price_to : date
weight : decimal(12,4)
created_at : datetime
locale : varchar(255)
channel : varchar(255)
attribute_family_id : int(10) unsigned
product_id : int(10) unsigned
updated_at : datetime
parent_id : int(10) unsigned
visible_individually : tinyint(1)

v		bagisto 1product_grouped_products
id : int(10) unsigned
product_id : int(10) unsigned
associated_product_id : int(10) unsigned
qty : int(11)
sort_order : int(11)

v		bagisto 1product_images
id : int(10) unsigned
type : varchar(255)
path : varchar(255)
product_id : int(10) unsigned
position : int(10) unsigned

v		bagisto 1product_inventories
id : int(10) unsigned
qty : int(11)
product_id : int(10) unsigned
vendor_id : int(11)
inventory_source_id : int(10) unsigned

v		bagisto 1product_inventory_indices
id : int(10) unsigned
qty : int(11)
product_id : int(10) unsigned
channel_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1product_ordered_inventories
id : int(10) unsigned
qty : int(11)
product_id : int(10) unsigned
channel_id : int(10) unsigned

v		bagisto 1product_price_indices
id : int(10) unsigned
product_id : int(10) unsigned
customer_group_id : int(10) unsigned
channel_id : int(10) unsigned
min_price : decimal(12,4)
regular_min_price : decimal(12,4)
max_price : decimal(12,4)
regular_max_price : decimal(12,4)
created_at : timestamp
updated_at : timestamp

v		bagisto 1product_relations
parent_id : int(10) unsigned
child_id : int(10) unsigned

v		bagisto 1product_reviews
id : int(10) unsigned
name : varchar(255)
title : varchar(255)
rating : int(11)
comment : text
status : varchar(255)
product_id : int(10) unsigned
customer_id : int(11)
created_at : timestamp
updated_at : timestamp

v		bagisto 1product_review_attachments
id : int(10) unsigned
review_id : int(10) unsigned
type : varchar(255)
mime_type : varchar(255)
path : varchar(255)

v		bagisto 1product_super_attributes
product_id : int(10) unsigned
attribute_id : int(10) unsigned

v		bagisto 1product_up_sells
parent_id : int(10) unsigned
child_id : int(10) unsigned

v		bagisto 1product_videos
id : int(10) unsigned
product_id : int(10) unsigned
type : varchar(255)
path : varchar(255)
position : int(10) unsigned

v		bagisto 1refunds
id : int(10) unsigned
increment_id : varchar(255)
state : varchar(255)
email_sent : tinyint(1)
total_qty : int(11)
base_currency_code : varchar(255)
channel_currency_code : varchar(255)
order_currency_code : varchar(255)
adjustment_refund : decimal(12,4)
base_adjustment_refund : decimal(12,4)
adjustment_fee : decimal(12,4)
base_adjustment_fee : decimal(12,4)
sub_total : decimal(12,4)
base_sub_total : decimal(12,4)
grand_total : decimal(12,4)
base_grand_total : decimal(12,4)
shipping_amount : decimal(12,4)
base_shipping_amount : decimal(12,4)
tax_amount : decimal(12,4)
base_tax_amount : decimal(12,4)
discount_percent : decimal(12,4)
discount_amount : decimal(12,4)
base_discount_amount : decimal(12,4)
shipping_tax_amount : decimal(12,4)
base_shipping_tax_amount : decimal(12,4)
sub_total_incl_tax : decimal(12,4)
base_sub_total_incl_tax : decimal(12,4)
shipping_amount_incl_tax : decimal(12,4)
base_shipping_amount_incl_tax : decimal(12,4)
order_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1refund_items
id : int(10) unsigned
parent_id : int(10) unsigned
name : varchar(255)
description : varchar(255)
sku : varchar(255)
qty : int(11)
price : decimal(12,4)
base_price : decimal(12,4)
total : decimal(12,4)
base_total : decimal(12,4)
tax_amount : decimal(12,4)
base_tax_amount : decimal(12,4)
discount_percent : decimal(12,4)
discount_amount : decimal(12,4)
base_discount_amount : decimal(12,4)
price_incl_tax : decimal(12,4)
base_price_incl_tax : decimal(12,4)
total_incl_tax : decimal(12,4)
base_total_incl_tax : decimal(12,4)
product_id : int(10) unsigned
product_type : varchar(255)
order_item_id : int(10) unsigned
refund_id : int(10) unsigned
additional : longtext
created_at : timestamp
updated_at : timestamp

v		bagisto 1roles
id : int(10) unsigned
name : varchar(255)
description : varchar(255)
permission_type : varchar(255)
permissions : longtext
created_at : timestamp
updated_at : timestamp

v		bagisto 1search_synonyms
id : int(10) unsigned
name : varchar(255)
terms : text
created_at : timestamp
updated_at : timestamp

v		bagisto 1search_terms
id : int(10) unsigned
term : varchar(255)
results : int(11)
uses : int(11)
redirect_url : varchar(255)
display_in_suggested_terms : tinyint(1)
locale : varchar(255)
channel_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1shipments
id : int(10) unsigned
status : varchar(255)
total_qty : int(11)
total_weight : decimal(12,4)
carrier_code : varchar(255)
carrier_title : varchar(255)
track_number : text
email_sent : tinyint(1)
customer_id : int(10) unsigned
customer_type : varchar(255)
order_id : int(10) unsigned
order_address_id : int(10) unsigned
inventory_source_id : int(10) unsigned
inventory_source_name : varchar(255)
created_at : timestamp
updated_at : timestamp

v		bagisto 1shipment_items
id : int(10) unsigned
name : varchar(255)
description : varchar(255)
sku : varchar(255)
qty : int(11)
weight : decimal(12,4)
price : decimal(12,4)
base_price : decimal(12,4)
total : decimal(12,4)
base_total : decimal(12,4)
price_incl_tax : decimal(12,4)
base_price_incl_tax : decimal(12,4)
product_id : int(10) unsigned
product_type : varchar(255)
order_item_id : int(10) unsigned
shipment_id : int(10) unsigned
additional : longtext
created_at : timestamp
updated_at : timestamp

v		bagisto 1sitemaps
id : int(10) unsigned
file_name : varchar(255)
path : varchar(255)
additional : longtext
generated_at : datetime
created_at : timestamp
updated_at : timestamp

v		bagisto 1subscribers_list
id : int(10) unsigned
email : varchar(255)
is_subscribed : tinyint(1)
token : varchar(255)
customer_id : int(10) unsigned
channel_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1tax_categories
id : int(10) unsigned
code : varchar(255)
name : varchar(255)
description : longtext
created_at : timestamp
updated_at : timestamp

v		bagisto 1tax_categories_tax_rates
id : int(10) unsigned
tax_category_id : int(10) unsigned
tax_rate_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1tax_rates
id : int(10) unsigned
identifier : varchar(255)
is_zip : tinyint(1)
zip_code : varchar(255)
zip_from : varchar(255)
zip_to : varchar(255)
state : varchar(255)
country : varchar(255)
tax_rate : decimal(12,4)
created_at : timestamp
updated_at : timestamp

v		bagisto 1theme_customizations
id : int(10) unsigned
theme_code : varchar(255)
type : varchar(255)
name : varchar(255)
sort_order : int(11)
status : tinyint(1)
channel_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1theme_customization_translations
id : int(10) unsigned
theme_customization_id : int(10) unsigned
locale : varchar(255)
options : longtext

v		bagisto 1url_rewrites
id : int(10) unsigned
entity_type : varchar(255)
request_path : varchar(255)
target_path : varchar(255)
redirect_type : varchar(255)
locale : varchar(255)
created_at : timestamp
updated_at : timestamp

v		bagisto 1users
id : int(10) unsigned
name : varchar(255)
email : varchar(255)
password : varchar(255)
remember_token : varchar(100)
created_at : timestamp
updated_at : timestamp

v		bagisto 1visits
id : bigint(20) unsigned
method : varchar(255)
request : mediumtext
url : mediumtext
referer : mediumtext
languages : text
useragent : text
headers : text
device : text
platform : text
browser : text
ip : varchar(45)
visitable_type : varchar(255)
visitable_id : bigint(20) unsigned
visitor_type : varchar(255)
visitor_id : bigint(20) unsigned
channel_id : int(10) unsigned
created_at : timestamp
updated_at : timestamp

v		bagisto 1wishlist
id : int(10) unsigned
channel_id : int(10) unsigned
product_id : int(10) unsigned
customer_id : int(10) unsigned
item_options : longtext
moved_to_cart : date
shared : tinyint(1)
time_of_moving : date
additional : longtext
created_at : timestamp
updated_at : timestamp

v		bagisto 1wishlist_items
id : int(10) unsigned
channel_id : int(10) unsigned
product_id : int(10) unsigned
customer_id : int(10) unsigned
additional : longtext
moved_to_cart : date
shared : tinyint(1)
created_at : timestamp
updated_at : timestamp

Create relationship
FOREIGN KEY
on delete
on update