Server : Apache System : Linux server2.corals.io 4.18.0-348.2.1.el8_5.x86_64 #1 SMP Mon Nov 15 09:17:08 EST 2021 x86_64 User : corals ( 1002) PHP Version : 7.4.33 Disable Function : exec,passthru,shell_exec,system Directory : /home/corals/cartforge.co/vendor/magento/module-sales/etc/ |
<?xml version="1.0"?>
<!--
/**
* Copyright © Magento, Inc. All rights reserved.
* See COPYING.txt for license details.
*/
-->
<schema xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:noNamespaceSchemaLocation="urn:magento:framework:Setup/Declaration/Schema/etc/schema.xsd">
<table name="sales_order" resource="sales" engine="innodb" comment="Sales Flat Order">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="Entity ID"/>
<column xsi:type="varchar" name="state" nullable="true" length="32" comment="State"/>
<column xsi:type="varchar" name="status" nullable="true" length="32" comment="Status"/>
<column xsi:type="varchar" name="coupon_code" nullable="true" length="255" comment="Coupon Code"/>
<column xsi:type="varchar" name="protect_code" nullable="true" length="255" comment="Protect Code"/>
<column xsi:type="varchar" name="shipping_description" nullable="true" length="255"
comment="Shipping Description"/>
<column xsi:type="smallint" name="is_virtual" unsigned="true" nullable="true" identity="false"
comment="Is Virtual"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="int" name="customer_id" unsigned="true" nullable="true" identity="false"
comment="Customer ID"/>
<column xsi:type="decimal" name="base_discount_amount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Discount Amount"/>
<column xsi:type="decimal" name="base_discount_canceled" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Discount Canceled"/>
<column xsi:type="decimal" name="base_discount_invoiced" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Discount Invoiced"/>
<column xsi:type="decimal" name="base_discount_refunded" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Discount Refunded"/>
<column xsi:type="decimal" name="base_grand_total" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Grand Total"/>
<column xsi:type="decimal" name="base_shipping_amount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Shipping Amount"/>
<column xsi:type="decimal" name="base_shipping_canceled" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Shipping Canceled"/>
<column xsi:type="decimal" name="base_shipping_invoiced" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Shipping Invoiced"/>
<column xsi:type="decimal" name="base_shipping_refunded" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Shipping Refunded"/>
<column xsi:type="decimal" name="base_shipping_tax_amount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Shipping Tax Amount"/>
<column xsi:type="decimal" name="base_shipping_tax_refunded" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Shipping Tax Refunded"/>
<column xsi:type="decimal" name="base_subtotal" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Subtotal"/>
<column xsi:type="decimal" name="base_subtotal_canceled" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Subtotal Canceled"/>
<column xsi:type="decimal" name="base_subtotal_invoiced" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Subtotal Invoiced"/>
<column xsi:type="decimal" name="base_subtotal_refunded" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Subtotal Refunded"/>
<column xsi:type="decimal" name="base_tax_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Tax Amount"/>
<column xsi:type="decimal" name="base_tax_canceled" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Tax Canceled"/>
<column xsi:type="decimal" name="base_tax_invoiced" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Tax Invoiced"/>
<column xsi:type="decimal" name="base_tax_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Tax Refunded"/>
<column xsi:type="decimal" name="base_to_global_rate" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base To Global Rate"/>
<column xsi:type="decimal" name="base_to_order_rate" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base To Order Rate"/>
<column xsi:type="decimal" name="base_total_canceled" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Total Canceled"/>
<column xsi:type="decimal" name="base_total_invoiced" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Total Invoiced"/>
<column xsi:type="decimal" name="base_total_invoiced_cost" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Total Invoiced Cost"/>
<column xsi:type="decimal" name="base_total_offline_refunded" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Total Offline Refunded"/>
<column xsi:type="decimal" name="base_total_online_refunded" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Total Online Refunded"/>
<column xsi:type="decimal" name="base_total_paid" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Total Paid"/>
<column xsi:type="decimal" name="base_total_qty_ordered" scale="4" precision="12" unsigned="false"
nullable="true" comment="Base Total Qty Ordered"/>
<column xsi:type="decimal" name="base_total_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Total Refunded"/>
<column xsi:type="decimal" name="discount_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Discount Amount"/>
<column xsi:type="decimal" name="discount_canceled" scale="4" precision="20" unsigned="false" nullable="true"
comment="Discount Canceled"/>
<column xsi:type="decimal" name="discount_invoiced" scale="4" precision="20" unsigned="false" nullable="true"
comment="Discount Invoiced"/>
<column xsi:type="decimal" name="discount_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Discount Refunded"/>
<column xsi:type="decimal" name="grand_total" scale="4" precision="20" unsigned="false" nullable="true"
comment="Grand Total"/>
<column xsi:type="decimal" name="shipping_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Shipping Amount"/>
<column xsi:type="decimal" name="shipping_canceled" scale="4" precision="20" unsigned="false" nullable="true"
comment="Shipping Canceled"/>
<column xsi:type="decimal" name="shipping_invoiced" scale="4" precision="20" unsigned="false" nullable="true"
comment="Shipping Invoiced"/>
<column xsi:type="decimal" name="shipping_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Shipping Refunded"/>
<column xsi:type="decimal" name="shipping_tax_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Shipping Tax Amount"/>
<column xsi:type="decimal" name="shipping_tax_refunded" scale="4" precision="20" unsigned="false"
nullable="true" comment="Shipping Tax Refunded"/>
<column xsi:type="decimal" name="store_to_base_rate" scale="4" precision="12" unsigned="false" nullable="true"
comment="Store To Base Rate"/>
<column xsi:type="decimal" name="store_to_order_rate" scale="4" precision="12" unsigned="false" nullable="true"
comment="Store To Order Rate"/>
<column xsi:type="decimal" name="subtotal" scale="4" precision="20" unsigned="false" nullable="true"
comment="Subtotal"/>
<column xsi:type="decimal" name="subtotal_canceled" scale="4" precision="20" unsigned="false" nullable="true"
comment="Subtotal Canceled"/>
<column xsi:type="decimal" name="subtotal_invoiced" scale="4" precision="20" unsigned="false" nullable="true"
comment="Subtotal Invoiced"/>
<column xsi:type="decimal" name="subtotal_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Subtotal Refunded"/>
<column xsi:type="decimal" name="tax_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Tax Amount"/>
<column xsi:type="decimal" name="tax_canceled" scale="4" precision="20" unsigned="false" nullable="true"
comment="Tax Canceled"/>
<column xsi:type="decimal" name="tax_invoiced" scale="4" precision="20" unsigned="false" nullable="true"
comment="Tax Invoiced"/>
<column xsi:type="decimal" name="tax_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Tax Refunded"/>
<column xsi:type="decimal" name="total_canceled" scale="4" precision="20" unsigned="false" nullable="true"
comment="Total Canceled"/>
<column xsi:type="decimal" name="total_invoiced" scale="4" precision="20" unsigned="false" nullable="true"
comment="Total Invoiced"/>
<column xsi:type="decimal" name="total_offline_refunded" scale="4" precision="20" unsigned="false"
nullable="true" comment="Total Offline Refunded"/>
<column xsi:type="decimal" name="total_online_refunded" scale="4" precision="20" unsigned="false"
nullable="true" comment="Total Online Refunded"/>
<column xsi:type="decimal" name="total_paid" scale="4" precision="20" unsigned="false" nullable="true"
comment="Total Paid"/>
<column xsi:type="decimal" name="total_qty_ordered" scale="4" precision="12" unsigned="false" nullable="true"
comment="Total Qty Ordered"/>
<column xsi:type="decimal" name="total_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Total Refunded"/>
<column xsi:type="smallint" name="can_ship_partially" unsigned="true" nullable="true"
identity="false" comment="Can Ship Partially"/>
<column xsi:type="smallint" name="can_ship_partially_item" unsigned="true" nullable="true"
identity="false" comment="Can Ship Partially Item"/>
<column xsi:type="smallint" name="customer_is_guest" unsigned="true" nullable="true"
identity="false" comment="Customer Is Guest"/>
<column xsi:type="smallint" name="customer_note_notify" unsigned="true" nullable="true"
identity="false" comment="Customer Note Notify"/>
<column xsi:type="int" name="billing_address_id" unsigned="false" nullable="true" identity="false"
comment="Billing Address ID"/>
<column xsi:type="int" name="customer_group_id" unsigned="false" nullable="true" identity="false"/>
<column xsi:type="int" name="edit_increment" unsigned="false" nullable="true" identity="false"
comment="Edit Increment"/>
<column xsi:type="smallint" name="email_sent" unsigned="true" nullable="true" identity="false"
comment="Email Sent"/>
<column xsi:type="smallint" name="send_email" unsigned="true" nullable="true" identity="false"
comment="Send Email"/>
<column xsi:type="smallint" name="forced_shipment_with_invoice" unsigned="true" nullable="true"
identity="false" comment="Forced Do Shipment With Invoice"/>
<column xsi:type="int" name="payment_auth_expiration" unsigned="false" nullable="true"
identity="false" comment="Payment Authorization Expiration"/>
<column xsi:type="int" name="quote_address_id" unsigned="false" nullable="true" identity="false"
comment="Quote Address ID"/>
<column xsi:type="int" name="quote_id" unsigned="false" nullable="true" identity="false"
comment="Quote ID"/>
<column xsi:type="int" name="shipping_address_id" unsigned="false" nullable="true" identity="false"
comment="Shipping Address ID"/>
<column xsi:type="decimal" name="adjustment_negative" scale="4" precision="20" unsigned="false" nullable="true"
comment="Adjustment Negative"/>
<column xsi:type="decimal" name="adjustment_positive" scale="4" precision="20" unsigned="false" nullable="true"
comment="Adjustment Positive"/>
<column xsi:type="decimal" name="base_adjustment_negative" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Adjustment Negative"/>
<column xsi:type="decimal" name="base_adjustment_positive" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Adjustment Positive"/>
<column xsi:type="decimal" name="base_shipping_discount_amount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Shipping Discount Amount"/>
<column xsi:type="decimal" name="base_subtotal_incl_tax" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Subtotal Incl Tax"/>
<column xsi:type="decimal" name="base_total_due" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Total Due"/>
<column xsi:type="decimal" name="payment_authorization_amount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Payment Authorization Amount"/>
<column xsi:type="decimal" name="shipping_discount_amount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Shipping Discount Amount"/>
<column xsi:type="decimal" name="subtotal_incl_tax" scale="4" precision="20" unsigned="false" nullable="true"
comment="Subtotal Incl Tax"/>
<column xsi:type="decimal" name="total_due" scale="4" precision="20" unsigned="false" nullable="true"
comment="Total Due"/>
<column xsi:type="decimal" name="weight" scale="4" precision="12" unsigned="false" nullable="true"
comment="Weight"/>
<column xsi:type="datetime" name="customer_dob" on_update="false" nullable="true" comment="Customer Dob"/>
<column xsi:type="varchar" name="increment_id" nullable="true" length="50" comment="Increment ID"/>
<column xsi:type="varchar" name="applied_rule_ids" nullable="true" length="128" comment="Applied Rule Ids"/>
<column xsi:type="varchar" name="base_currency_code" nullable="true" length="3" comment="Base Currency Code"/>
<column xsi:type="varchar" name="customer_email" nullable="true" length="128" comment="Customer Email"/>
<column xsi:type="varchar" name="customer_firstname" nullable="true" length="128" comment="Customer Firstname"/>
<column xsi:type="varchar" name="customer_lastname" nullable="true" length="128" comment="Customer Lastname"/>
<column xsi:type="varchar" name="customer_middlename" nullable="true" length="128"
comment="Customer Middlename"/>
<column xsi:type="varchar" name="customer_prefix" nullable="true" length="32" comment="Customer Prefix"/>
<column xsi:type="varchar" name="customer_suffix" nullable="true" length="32" comment="Customer Suffix"/>
<column xsi:type="varchar" name="customer_taxvat" nullable="true" length="32" comment="Customer Taxvat"/>
<column xsi:type="varchar" name="discount_description" nullable="true" length="255"
comment="Discount Description"/>
<column xsi:type="varchar" name="ext_customer_id" nullable="true" length="32" comment="Ext Customer ID"/>
<column xsi:type="varchar" name="ext_order_id" nullable="true" length="32" comment="Ext Order ID"/>
<column xsi:type="varchar" name="global_currency_code" nullable="true" length="3"
comment="Global Currency Code"/>
<column xsi:type="varchar" name="hold_before_state" nullable="true" length="32" comment="Hold Before State"/>
<column xsi:type="varchar" name="hold_before_status" nullable="true" length="32" comment="Hold Before Status"/>
<column xsi:type="varchar" name="order_currency_code" nullable="true" length="3" comment="Order Currency Code"/>
<column xsi:type="varchar" name="original_increment_id" nullable="true" length="50"
comment="Original Increment ID"/>
<column xsi:type="varchar" name="relation_child_id" nullable="true" length="32" comment="Relation Child ID"/>
<column xsi:type="varchar" name="relation_child_real_id" nullable="true" length="32"
comment="Relation Child Real ID"/>
<column xsi:type="varchar" name="relation_parent_id" nullable="true" length="32" comment="Relation Parent ID"/>
<column xsi:type="varchar" name="relation_parent_real_id" nullable="true" length="32"
comment="Relation Parent Real ID"/>
<column xsi:type="varchar" name="remote_ip" nullable="true" length="45" comment="Remote Ip"/>
<column xsi:type="varchar" name="shipping_method" nullable="true" length="120"/>
<column xsi:type="varchar" name="store_currency_code" nullable="true" length="3" comment="Store Currency Code"/>
<column xsi:type="varchar" name="store_name" nullable="true" length="255" comment="Store Name"/>
<column xsi:type="varchar" name="x_forwarded_for" nullable="true" length="255" comment="X Forwarded For"/>
<column xsi:type="text" name="customer_note" nullable="true" comment="Customer Note"/>
<column xsi:type="timestamp" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP"
comment="Created At"/>
<column xsi:type="timestamp" name="updated_at" on_update="true" nullable="false" default="CURRENT_TIMESTAMP"
comment="Updated At"/>
<column xsi:type="smallint" name="total_item_count" unsigned="true" nullable="false"
identity="false" default="0" comment="Total Item Count"/>
<column xsi:type="int" name="customer_gender" unsigned="false" nullable="true" identity="false"
comment="Customer Gender"/>
<column xsi:type="decimal" name="discount_tax_compensation_amount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Discount Tax Compensation Amount"/>
<column xsi:type="decimal" name="base_discount_tax_compensation_amount" scale="4" precision="20"
unsigned="false" nullable="true" comment="Base Discount Tax Compensation Amount"/>
<column xsi:type="decimal" name="shipping_discount_tax_compensation_amount" scale="4" precision="20"
unsigned="false" nullable="true" comment="Shipping Discount Tax Compensation Amount"/>
<column xsi:type="decimal" name="base_shipping_discount_tax_compensation_amnt" scale="4" precision="20"
unsigned="false" nullable="true" comment="Base Shipping Discount Tax Compensation Amount"/>
<column xsi:type="decimal" name="discount_tax_compensation_invoiced" scale="4" precision="20" unsigned="false"
nullable="true" comment="Discount Tax Compensation Invoiced"/>
<column xsi:type="decimal" name="base_discount_tax_compensation_invoiced" scale="4" precision="20"
unsigned="false" nullable="true" comment="Base Discount Tax Compensation Invoiced"/>
<column xsi:type="decimal" name="discount_tax_compensation_refunded" scale="4" precision="20" unsigned="false"
nullable="true" comment="Discount Tax Compensation Refunded"/>
<column xsi:type="decimal" name="base_discount_tax_compensation_refunded" scale="4" precision="20"
unsigned="false" nullable="true" comment="Base Discount Tax Compensation Refunded"/>
<column xsi:type="decimal" name="shipping_incl_tax" scale="4" precision="20" unsigned="false" nullable="true"
comment="Shipping Incl Tax"/>
<column xsi:type="decimal" name="base_shipping_incl_tax" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Shipping Incl Tax"/>
<column xsi:type="varchar" name="coupon_rule_name" nullable="true" length="255"
comment="Coupon Sales Rule Name"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_ORDER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID" table="sales_order"
column="customer_id" referenceTable="customer_entity" referenceColumn="entity_id"
onDelete="SET NULL"/>
<constraint xsi:type="foreign" referenceId="SALES_ORDER_STORE_ID_STORE_STORE_ID" table="sales_order" column="store_id"
referenceTable="store" referenceColumn="store_id" onDelete="SET NULL"/>
<constraint xsi:type="unique" referenceId="SALES_ORDER_INCREMENT_ID_STORE_ID">
<column name="increment_id"/>
<column name="store_id"/>
</constraint>
<index referenceId="SALES_ORDER_STATUS" indexType="btree">
<column name="status"/>
</index>
<index referenceId="SALES_ORDER_STATE" indexType="btree">
<column name="state"/>
</index>
<index referenceId="SALES_ORDER_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
<index referenceId="SALES_ORDER_CREATED_AT" indexType="btree">
<column name="created_at"/>
</index>
<index referenceId="SALES_ORDER_CUSTOMER_ID" indexType="btree">
<column name="customer_id"/>
</index>
<index referenceId="SALES_ORDER_EXT_ORDER_ID" indexType="btree">
<column name="ext_order_id"/>
</index>
<index referenceId="SALES_ORDER_QUOTE_ID" indexType="btree">
<column name="quote_id"/>
</index>
<index referenceId="SALES_ORDER_UPDATED_AT" indexType="btree">
<column name="updated_at"/>
</index>
<index referenceId="SALES_ORDER_SEND_EMAIL" indexType="btree">
<column name="send_email"/>
</index>
<index referenceId="SALES_ORDER_EMAIL_SENT" indexType="btree">
<column name="email_sent"/>
</index>
</table>
<table name="sales_order_grid" resource="sales" engine="innodb" comment="Sales Flat Order Grid">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="false"
comment="Entity ID"/>
<column xsi:type="varchar" name="status" nullable="true" length="32" comment="Status"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="varchar" name="store_name" nullable="true" length="255" comment="Store Name"/>
<column xsi:type="int" name="customer_id" unsigned="true" nullable="true" identity="false"
comment="Customer ID"/>
<column xsi:type="decimal" name="base_grand_total" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Grand Total"/>
<column xsi:type="decimal" name="base_total_paid" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Total Paid"/>
<column xsi:type="decimal" name="grand_total" scale="4" precision="20" unsigned="false" nullable="true"
comment="Grand Total"/>
<column xsi:type="decimal" name="total_paid" scale="4" precision="20" unsigned="false" nullable="true"
comment="Total Paid"/>
<column xsi:type="varchar" name="increment_id" nullable="true" length="50" comment="Increment ID"/>
<column xsi:type="varchar" name="base_currency_code" nullable="true" length="3" comment="Base Currency Code"/>
<column xsi:type="varchar" name="order_currency_code" nullable="true" length="255"
comment="Order Currency Code"/>
<column xsi:type="varchar" name="shipping_name" nullable="true" length="255" comment="Shipping Name"/>
<column xsi:type="varchar" name="billing_name" nullable="true" length="255" comment="Billing Name"/>
<column xsi:type="timestamp" name="created_at" on_update="false" nullable="true" comment="Created At"/>
<column xsi:type="timestamp" name="updated_at" on_update="false" nullable="true" comment="Updated At"/>
<column xsi:type="varchar" name="billing_address" nullable="true" length="255" comment="Billing Address"/>
<column xsi:type="varchar" name="shipping_address" nullable="true" length="255" comment="Shipping Address"/>
<column xsi:type="varchar" name="shipping_information" nullable="true" length="255"
comment="Shipping Method Name"/>
<column xsi:type="varchar" name="customer_email" nullable="true" length="255" comment="Customer Email"/>
<column xsi:type="varchar" name="customer_group" nullable="true" length="255" comment="Customer Group"/>
<column xsi:type="decimal" name="subtotal" scale="4" precision="20" unsigned="false" nullable="true"
comment="Subtotal"/>
<column xsi:type="decimal" name="shipping_and_handling" scale="4" precision="20" unsigned="false"
nullable="true" comment="Shipping and handling amount"/>
<column xsi:type="varchar" name="customer_name" nullable="true" length="255" comment="Customer Name"/>
<column xsi:type="varchar" name="payment_method" nullable="true" length="255" comment="Payment Method"/>
<column xsi:type="decimal" name="total_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Total Refunded"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="SALES_ORDER_GRID_INCREMENT_ID_STORE_ID">
<column name="increment_id"/>
<column name="store_id"/>
</constraint>
<index referenceId="SALES_ORDER_GRID_STATUS" indexType="btree">
<column name="status"/>
</index>
<index referenceId="SALES_ORDER_GRID_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
<index referenceId="SALES_ORDER_GRID_BASE_GRAND_TOTAL" indexType="btree">
<column name="base_grand_total"/>
</index>
<index referenceId="SALES_ORDER_GRID_BASE_TOTAL_PAID" indexType="btree">
<column name="base_total_paid"/>
</index>
<index referenceId="SALES_ORDER_GRID_GRAND_TOTAL" indexType="btree">
<column name="grand_total"/>
</index>
<index referenceId="SALES_ORDER_GRID_TOTAL_PAID" indexType="btree">
<column name="total_paid"/>
</index>
<index referenceId="SALES_ORDER_GRID_SHIPPING_NAME" indexType="btree">
<column name="shipping_name"/>
</index>
<index referenceId="SALES_ORDER_GRID_BILLING_NAME" indexType="btree">
<column name="billing_name"/>
</index>
<index referenceId="SALES_ORDER_GRID_CREATED_AT" indexType="btree">
<column name="created_at"/>
</index>
<index referenceId="SALES_ORDER_GRID_CUSTOMER_ID" indexType="btree">
<column name="customer_id"/>
</index>
<index referenceId="SALES_ORDER_GRID_UPDATED_AT" indexType="btree">
<column name="updated_at"/>
</index>
<index referenceId="FTI_65B9E9925EC58F0C7C2E2F6379C233E7" indexType="fulltext">
<column name="increment_id"/>
<column name="billing_name"/>
<column name="shipping_name"/>
<column name="shipping_address"/>
<column name="billing_address"/>
<column name="customer_name"/>
<column name="customer_email"/>
</index>
</table>
<table name="sales_order_address" resource="sales" engine="innodb" comment="Sales Flat Order Address">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="Entity ID"/>
<column xsi:type="int" name="parent_id" unsigned="true" nullable="true" identity="false"
comment="Parent ID"/>
<column xsi:type="int" name="customer_address_id" unsigned="false" nullable="true" identity="false"
comment="Customer Address ID"/>
<column xsi:type="int" name="quote_address_id" unsigned="false" nullable="true" identity="false"
comment="Quote Address ID"/>
<column xsi:type="int" name="region_id" unsigned="false" nullable="true" identity="false"
comment="Region ID"/>
<column xsi:type="int" name="customer_id" unsigned="false" nullable="true" identity="false"
comment="Customer ID"/>
<column xsi:type="varchar" name="fax" nullable="true" length="255" comment="Fax"/>
<column xsi:type="varchar" name="region" nullable="true" length="255" comment="Region"/>
<column xsi:type="varchar" name="postcode" nullable="true" length="255" comment="Postcode"/>
<column xsi:type="varchar" name="lastname" nullable="true" length="255" comment="Lastname"/>
<column xsi:type="varchar" name="street" nullable="true" length="255" comment="Street"/>
<column xsi:type="varchar" name="city" nullable="true" length="255" comment="City"/>
<column xsi:type="varchar" name="email" nullable="true" length="255" comment="Email"/>
<column xsi:type="varchar" name="telephone" nullable="true" length="255" comment="Phone Number"/>
<column xsi:type="varchar" name="country_id" nullable="true" length="2" comment="Country ID"/>
<column xsi:type="varchar" name="firstname" nullable="true" length="255" comment="Firstname"/>
<column xsi:type="varchar" name="address_type" nullable="true" length="255" comment="Address Type"/>
<column xsi:type="varchar" name="prefix" nullable="true" length="255" comment="Prefix"/>
<column xsi:type="varchar" name="middlename" nullable="true" length="255" comment="Middlename"/>
<column xsi:type="varchar" name="suffix" nullable="true" length="255" comment="Suffix"/>
<column xsi:type="varchar" name="company" nullable="true" length="255" comment="Company"/>
<column xsi:type="text" name="vat_id" nullable="true" comment="Vat ID"/>
<column xsi:type="smallint" name="vat_is_valid" unsigned="false" nullable="true" identity="false"
comment="Vat Is Valid"/>
<column xsi:type="text" name="vat_request_id" nullable="true" comment="Vat Request ID"/>
<column xsi:type="text" name="vat_request_date" nullable="true" comment="Vat Request Date"/>
<column xsi:type="smallint" name="vat_request_success" unsigned="false" nullable="true"
identity="false" comment="Vat Request Success"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_ORDER_ADDRESS_PARENT_ID_SALES_ORDER_ENTITY_ID"
table="sales_order_address" column="parent_id" referenceTable="sales_order"
referenceColumn="entity_id" onDelete="CASCADE"/>
<index referenceId="SALES_ORDER_ADDRESS_PARENT_ID" indexType="btree">
<column name="parent_id"/>
</index>
</table>
<table name="sales_order_status_history" resource="sales" engine="innodb" comment="Sales Flat Order Status History">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="Entity ID"/>
<column xsi:type="int" name="parent_id" unsigned="true" nullable="false" identity="false"
comment="Parent ID"/>
<column xsi:type="int" name="is_customer_notified" unsigned="false" nullable="true"
identity="false" comment="Is Customer Notified"/>
<column xsi:type="smallint" name="is_visible_on_front" unsigned="true" nullable="false"
identity="false" default="0" comment="Is Visible On Front"/>
<column xsi:type="text" name="comment" nullable="true" comment="Comment"/>
<column xsi:type="varchar" name="status" nullable="true" length="32" comment="Status"/>
<column xsi:type="timestamp" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP"
comment="Created At"/>
<column xsi:type="varchar" name="entity_name" nullable="true" length="32"
comment="Shows what entity history is bind to."/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_ORDER_STATUS_HISTORY_PARENT_ID_SALES_ORDER_ENTITY_ID"
table="sales_order_status_history" column="parent_id" referenceTable="sales_order"
referenceColumn="entity_id" onDelete="CASCADE"/>
<index referenceId="SALES_ORDER_STATUS_HISTORY_PARENT_ID" indexType="btree">
<column name="parent_id"/>
</index>
<index referenceId="SALES_ORDER_STATUS_HISTORY_CREATED_AT" indexType="btree">
<column name="created_at"/>
</index>
</table>
<table name="sales_order_item" resource="sales" engine="innodb" comment="Sales Flat Order Item">
<column xsi:type="int" name="item_id" unsigned="true" nullable="false" identity="true"
comment="Item ID"/>
<column xsi:type="int" name="order_id" unsigned="true" nullable="false" identity="false"
default="0" comment="Order ID"/>
<column xsi:type="int" name="parent_item_id" unsigned="true" nullable="true" identity="false"
comment="Parent Item ID"/>
<column xsi:type="int" name="quote_item_id" unsigned="true" nullable="true" identity="false"
comment="Quote Item ID"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="timestamp" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP"
comment="Created At"/>
<column xsi:type="timestamp" name="updated_at" on_update="true" nullable="false" default="CURRENT_TIMESTAMP"
comment="Updated At"/>
<column xsi:type="int" name="product_id" unsigned="true" nullable="true" identity="false"
comment="Product ID"/>
<column xsi:type="varchar" name="product_type" nullable="true" length="255" comment="Product Type"/>
<column xsi:type="longtext" name="product_options" nullable="true" comment="Product Options"/>
<column xsi:type="decimal" name="weight" scale="4" precision="12" unsigned="false" nullable="true" default="0"
comment="Weight"/>
<column xsi:type="smallint" name="is_virtual" unsigned="true" nullable="true" identity="false"
comment="Is Virtual"/>
<column xsi:type="varchar" name="sku" nullable="true" length="255" comment="Sku"/>
<column xsi:type="varchar" name="name" nullable="true" length="255" comment="Name"/>
<column xsi:type="text" name="description" nullable="true" comment="Description"/>
<column xsi:type="text" name="applied_rule_ids" nullable="true" comment="Applied Rule Ids"/>
<column xsi:type="text" name="additional_data" nullable="true" comment="Additional Data"/>
<column xsi:type="smallint" name="is_qty_decimal" unsigned="true" nullable="true" identity="false"
comment="Is Qty Decimal"/>
<column xsi:type="smallint" name="no_discount" unsigned="true" nullable="false" identity="false"
default="0" comment="No Discount"/>
<column xsi:type="decimal" name="qty_backordered" scale="4" precision="12" unsigned="false" nullable="true"
default="0" comment="Qty Backordered"/>
<column xsi:type="decimal" name="qty_canceled" scale="4" precision="12" unsigned="false" nullable="true"
default="0" comment="Qty Canceled"/>
<column xsi:type="decimal" name="qty_invoiced" scale="4" precision="12" unsigned="false" nullable="true"
default="0" comment="Qty Invoiced"/>
<column xsi:type="decimal" name="qty_ordered" scale="4" precision="12" unsigned="false" nullable="true"
default="0" comment="Qty Ordered"/>
<column xsi:type="decimal" name="qty_refunded" scale="4" precision="12" unsigned="false" nullable="true"
default="0" comment="Qty Refunded"/>
<column xsi:type="decimal" name="qty_shipped" scale="4" precision="12" unsigned="false" nullable="true"
default="0" comment="Qty Shipped"/>
<column xsi:type="decimal" name="base_cost" scale="4" precision="12" unsigned="false" nullable="true"
default="0" comment="Base Cost"/>
<column xsi:type="decimal" name="price" scale="4" precision="12" unsigned="false" nullable="false" default="0"
comment="Price"/>
<column xsi:type="decimal" name="base_price" scale="4" precision="12" unsigned="false" nullable="false"
default="0" comment="Base Price"/>
<column xsi:type="decimal" name="original_price" scale="4" precision="12" unsigned="false" nullable="true"
comment="Original Price"/>
<column xsi:type="decimal" name="base_original_price" scale="4" precision="12" unsigned="false" nullable="true"
comment="Base Original Price"/>
<column xsi:type="decimal" name="tax_percent" scale="4" precision="12" unsigned="false" nullable="true"
default="0" comment="Tax Percent"/>
<column xsi:type="decimal" name="tax_amount" scale="4" precision="20" unsigned="false" nullable="true"
default="0" comment="Tax Amount"/>
<column xsi:type="decimal" name="base_tax_amount" scale="4" precision="20" unsigned="false" nullable="true"
default="0" comment="Base Tax Amount"/>
<column xsi:type="decimal" name="tax_invoiced" scale="4" precision="20" unsigned="false" nullable="true"
default="0" comment="Tax Invoiced"/>
<column xsi:type="decimal" name="base_tax_invoiced" scale="4" precision="20" unsigned="false" nullable="true"
default="0" comment="Base Tax Invoiced"/>
<column xsi:type="decimal" name="discount_percent" scale="4" precision="12" unsigned="false" nullable="true"
default="0" comment="Discount Percent"/>
<column xsi:type="decimal" name="discount_amount" scale="4" precision="20" unsigned="false" nullable="true"
default="0" comment="Discount Amount"/>
<column xsi:type="decimal" name="base_discount_amount" scale="4" precision="20" unsigned="false"
nullable="true" default="0" comment="Base Discount Amount"/>
<column xsi:type="decimal" name="discount_invoiced" scale="4" precision="20" unsigned="false" nullable="true"
default="0" comment="Discount Invoiced"/>
<column xsi:type="decimal" name="base_discount_invoiced" scale="4" precision="20" unsigned="false"
nullable="true" default="0" comment="Base Discount Invoiced"/>
<column xsi:type="decimal" name="amount_refunded" scale="4" precision="20" unsigned="false" nullable="true"
default="0" comment="Amount Refunded"/>
<column xsi:type="decimal" name="base_amount_refunded" scale="4" precision="20" unsigned="false"
nullable="true" default="0" comment="Base Amount Refunded"/>
<column xsi:type="decimal" name="row_total" scale="4" precision="20" unsigned="false" nullable="false"
default="0" comment="Row Total"/>
<column xsi:type="decimal" name="base_row_total" scale="4" precision="20" unsigned="false" nullable="false"
default="0" comment="Base Row Total"/>
<column xsi:type="decimal" name="row_invoiced" scale="4" precision="20" unsigned="false" nullable="false"
default="0" comment="Row Invoiced"/>
<column xsi:type="decimal" name="base_row_invoiced" scale="4" precision="20" unsigned="false" nullable="false"
default="0" comment="Base Row Invoiced"/>
<column xsi:type="decimal" name="row_weight" scale="4" precision="12" unsigned="false" nullable="true"
default="0" comment="Row Weight"/>
<column xsi:type="decimal" name="base_tax_before_discount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Tax Before Discount"/>
<column xsi:type="decimal" name="tax_before_discount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Tax Before Discount"/>
<column xsi:type="varchar" name="ext_order_item_id" nullable="true" length="255" comment="Ext Order Item ID"/>
<column xsi:type="smallint" name="locked_do_invoice" unsigned="true" nullable="true"
identity="false" comment="Locked Do Invoice"/>
<column xsi:type="smallint" name="locked_do_ship" unsigned="true" nullable="true" identity="false"
comment="Locked Do Ship"/>
<column xsi:type="decimal" name="price_incl_tax" scale="4" precision="20" unsigned="false" nullable="true"
comment="Price Incl Tax"/>
<column xsi:type="decimal" name="base_price_incl_tax" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Price Incl Tax"/>
<column xsi:type="decimal" name="row_total_incl_tax" scale="4" precision="20" unsigned="false" nullable="true"
comment="Row Total Incl Tax"/>
<column xsi:type="decimal" name="base_row_total_incl_tax" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Row Total Incl Tax"/>
<column xsi:type="decimal" name="discount_tax_compensation_amount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Discount Tax Compensation Amount"/>
<column xsi:type="decimal" name="base_discount_tax_compensation_amount" scale="4" precision="20"
unsigned="false" nullable="true" comment="Base Discount Tax Compensation Amount"/>
<column xsi:type="decimal" name="discount_tax_compensation_invoiced" scale="4" precision="20" unsigned="false"
nullable="true" comment="Discount Tax Compensation Invoiced"/>
<column xsi:type="decimal" name="base_discount_tax_compensation_invoiced" scale="4" precision="20"
unsigned="false" nullable="true" comment="Base Discount Tax Compensation Invoiced"/>
<column xsi:type="decimal" name="discount_tax_compensation_refunded" scale="4" precision="20" unsigned="false"
nullable="true" comment="Discount Tax Compensation Refunded"/>
<column xsi:type="decimal" name="base_discount_tax_compensation_refunded" scale="4" precision="20"
unsigned="false" nullable="true" comment="Base Discount Tax Compensation Refunded"/>
<column xsi:type="decimal" name="tax_canceled" scale="4" precision="12" unsigned="false" nullable="true"
comment="Tax Canceled"/>
<column xsi:type="decimal" name="discount_tax_compensation_canceled" scale="4" precision="20" unsigned="false"
nullable="true" comment="Discount Tax Compensation Canceled"/>
<column xsi:type="decimal" name="tax_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Tax Refunded"/>
<column xsi:type="decimal" name="base_tax_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Tax Refunded"/>
<column xsi:type="decimal" name="discount_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Discount Refunded"/>
<column xsi:type="decimal" name="base_discount_refunded" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Discount Refunded"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="item_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_ORDER_ITEM_ORDER_ID_SALES_ORDER_ENTITY_ID" table="sales_order_item"
column="order_id" referenceTable="sales_order" referenceColumn="entity_id" onDelete="CASCADE"/>
<constraint xsi:type="foreign" referenceId="SALES_ORDER_ITEM_STORE_ID_STORE_STORE_ID" table="sales_order_item"
column="store_id" referenceTable="store" referenceColumn="store_id" onDelete="SET NULL"/>
<index referenceId="SALES_ORDER_ITEM_ORDER_ID" indexType="btree">
<column name="order_id"/>
</index>
<index referenceId="SALES_ORDER_ITEM_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
</table>
<table name="sales_order_payment" resource="sales" engine="innodb" comment="Sales Flat Order Payment">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="Entity ID"/>
<column xsi:type="int" name="parent_id" unsigned="true" nullable="false" identity="false"
comment="Parent ID"/>
<column xsi:type="decimal" name="base_shipping_captured" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Shipping Captured"/>
<column xsi:type="decimal" name="shipping_captured" scale="4" precision="20" unsigned="false" nullable="true"
comment="Shipping Captured"/>
<column xsi:type="decimal" name="amount_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Amount Refunded"/>
<column xsi:type="decimal" name="base_amount_paid" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Amount Paid"/>
<column xsi:type="decimal" name="amount_canceled" scale="4" precision="20" unsigned="false" nullable="true"
comment="Amount Canceled"/>
<column xsi:type="decimal" name="base_amount_authorized" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Amount Authorized"/>
<column xsi:type="decimal" name="base_amount_paid_online" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Amount Paid Online"/>
<column xsi:type="decimal" name="base_amount_refunded_online" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Amount Refunded Online"/>
<column xsi:type="decimal" name="base_shipping_amount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Shipping Amount"/>
<column xsi:type="decimal" name="shipping_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Shipping Amount"/>
<column xsi:type="decimal" name="amount_paid" scale="4" precision="20" unsigned="false" nullable="true"
comment="Amount Paid"/>
<column xsi:type="decimal" name="amount_authorized" scale="4" precision="20" unsigned="false" nullable="true"
comment="Amount Authorized"/>
<column xsi:type="decimal" name="base_amount_ordered" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Amount Ordered"/>
<column xsi:type="decimal" name="base_shipping_refunded" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Shipping Refunded"/>
<column xsi:type="decimal" name="shipping_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Shipping Refunded"/>
<column xsi:type="decimal" name="base_amount_refunded" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Amount Refunded"/>
<column xsi:type="decimal" name="amount_ordered" scale="4" precision="20" unsigned="false" nullable="true"
comment="Amount Ordered"/>
<column xsi:type="decimal" name="base_amount_canceled" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Amount Canceled"/>
<column xsi:type="int" name="quote_payment_id" unsigned="false" nullable="true" identity="false"
comment="Quote Payment ID"/>
<column xsi:type="text" name="additional_data" nullable="true" comment="Additional Data"/>
<column xsi:type="varchar" name="cc_exp_month" nullable="true" length="12" comment="Cc Exp Month"/>
<column xsi:type="varchar" name="cc_ss_start_year" nullable="true" length="12" comment="Cc Ss Start Year"/>
<column xsi:type="varchar" name="echeck_bank_name" nullable="true" length="128" comment="Echeck Bank Name"/>
<column xsi:type="varchar" name="method" nullable="true" length="128" comment="Method"/>
<column xsi:type="varchar" name="cc_debug_request_body" nullable="true" length="32"
comment="Cc Debug Request Body"/>
<column xsi:type="varchar" name="cc_secure_verify" nullable="true" length="32" comment="Cc Secure Verify"/>
<column xsi:type="varchar" name="protection_eligibility" nullable="true" length="32"
comment="Protection Eligibility"/>
<column xsi:type="varchar" name="cc_approval" nullable="true" length="32" comment="Cc Approval"/>
<column xsi:type="varchar" name="cc_last_4" nullable="true" length="100" comment="Cc Last 4"/>
<column xsi:type="varchar" name="cc_status_description" nullable="true" length="32"
comment="Cc Status Description"/>
<column xsi:type="varchar" name="echeck_type" nullable="true" length="32" comment="Echeck Type"/>
<column xsi:type="varchar" name="cc_debug_response_serialized" nullable="true" length="32"
comment="Cc Debug Response Serialized"/>
<column xsi:type="varchar" name="cc_ss_start_month" nullable="true" length="128" comment="Cc Ss Start Month"/>
<column xsi:type="varchar" name="echeck_account_type" nullable="true" length="255"
comment="Echeck Account Type"/>
<column xsi:type="varchar" name="last_trans_id" nullable="true" length="255" comment="Last Trans ID"/>
<column xsi:type="varchar" name="cc_cid_status" nullable="true" length="32" comment="Cc Cid Status"/>
<column xsi:type="varchar" name="cc_owner" nullable="true" length="128" comment="Cc Owner"/>
<column xsi:type="varchar" name="cc_type" nullable="true" length="32" comment="Cc Type"/>
<column xsi:type="varchar" name="po_number" nullable="true" length="32" comment="Po Number"/>
<column xsi:type="varchar" name="cc_exp_year" nullable="true" length="4" comment="Cc Exp Year"/>
<column xsi:type="varchar" name="cc_status" nullable="true" length="4" comment="Cc Status"/>
<column xsi:type="varchar" name="echeck_routing_number" nullable="true" length="32"
comment="Echeck Routing Number"/>
<column xsi:type="varchar" name="account_status" nullable="true" length="32" comment="Account Status"/>
<column xsi:type="varchar" name="anet_trans_method" nullable="true" length="32" comment="Anet Trans Method"/>
<column xsi:type="varchar" name="cc_debug_response_body" nullable="true" length="32"
comment="Cc Debug Response Body"/>
<column xsi:type="varchar" name="cc_ss_issue" nullable="true" length="32" comment="Cc Ss Issue"/>
<column xsi:type="varchar" name="echeck_account_name" nullable="true" length="32"
comment="Echeck Account Name"/>
<column xsi:type="varchar" name="cc_avs_status" nullable="true" length="32" comment="Cc Avs Status"/>
<column xsi:type="varchar" name="cc_number_enc" nullable="true" length="128"/>
<column xsi:type="varchar" name="cc_trans_id" nullable="true" length="32" comment="Cc Trans ID"/>
<column xsi:type="varchar" name="address_status" nullable="true" length="32" comment="Address Status"/>
<column xsi:type="text" name="additional_information" nullable="true" comment="Additional Information"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_ORDER_PAYMENT_PARENT_ID_SALES_ORDER_ENTITY_ID"
table="sales_order_payment" column="parent_id" referenceTable="sales_order"
referenceColumn="entity_id" onDelete="CASCADE"/>
<index referenceId="SALES_ORDER_PAYMENT_PARENT_ID" indexType="btree">
<column name="parent_id"/>
</index>
</table>
<table name="sales_shipment" resource="sales" engine="innodb" comment="Sales Flat Shipment">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="Entity ID"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="decimal" name="total_weight" scale="4" precision="12" unsigned="false" nullable="true"
comment="Total Weight"/>
<column xsi:type="decimal" name="total_qty" scale="4" precision="12" unsigned="false" nullable="true"
comment="Total Qty"/>
<column xsi:type="smallint" name="email_sent" unsigned="true" nullable="true" identity="false"
comment="Email Sent"/>
<column xsi:type="smallint" name="send_email" unsigned="true" nullable="true" identity="false"
comment="Send Email"/>
<column xsi:type="int" name="order_id" unsigned="true" nullable="false" identity="false"
comment="Order ID"/>
<column xsi:type="int" name="customer_id" unsigned="false" nullable="true" identity="false"
comment="Customer ID"/>
<column xsi:type="int" name="shipping_address_id" unsigned="false" nullable="true" identity="false"
comment="Shipping Address ID"/>
<column xsi:type="int" name="billing_address_id" unsigned="false" nullable="true" identity="false"
comment="Billing Address ID"/>
<column xsi:type="int" name="shipment_status" unsigned="false" nullable="true" identity="false"
comment="Shipment Status"/>
<column xsi:type="varchar" name="increment_id" nullable="true" length="50" comment="Increment ID"/>
<column xsi:type="timestamp" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP"
comment="Created At"/>
<column xsi:type="timestamp" name="updated_at" on_update="true" nullable="false" default="CURRENT_TIMESTAMP"
comment="Updated At"/>
<column xsi:type="text" name="packages" nullable="true" comment="Packed Products in Packages"/>
<column xsi:type="mediumblob" name="shipping_label" nullable="true" comment="Shipping Label Content"/>
<column xsi:type="text" name="customer_note" nullable="true" comment="Customer Note"/>
<column xsi:type="smallint" name="customer_note_notify" unsigned="true" nullable="true"
identity="false" comment="Customer Note Notify"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_SHIPMENT_ORDER_ID_SALES_ORDER_ENTITY_ID" table="sales_shipment"
column="order_id" referenceTable="sales_order" referenceColumn="entity_id" onDelete="CASCADE"/>
<constraint xsi:type="foreign" referenceId="SALES_SHIPMENT_STORE_ID_STORE_STORE_ID" table="sales_shipment"
column="store_id" referenceTable="store" referenceColumn="store_id" onDelete="SET NULL"/>
<constraint xsi:type="unique" referenceId="SALES_SHIPMENT_INCREMENT_ID_STORE_ID">
<column name="increment_id"/>
<column name="store_id"/>
</constraint>
<index referenceId="SALES_SHIPMENT_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
<index referenceId="SALES_SHIPMENT_TOTAL_QTY" indexType="btree">
<column name="total_qty"/>
</index>
<index referenceId="SALES_SHIPMENT_ORDER_ID" indexType="btree">
<column name="order_id"/>
</index>
<index referenceId="SALES_SHIPMENT_CREATED_AT" indexType="btree">
<column name="created_at"/>
</index>
<index referenceId="SALES_SHIPMENT_UPDATED_AT" indexType="btree">
<column name="updated_at"/>
</index>
<index referenceId="SALES_SHIPMENT_SEND_EMAIL" indexType="btree">
<column name="send_email"/>
</index>
<index referenceId="SALES_SHIPMENT_EMAIL_SENT" indexType="btree">
<column name="email_sent"/>
</index>
</table>
<table name="sales_shipment_grid" resource="sales" engine="innodb" comment="Sales Flat Shipment Grid">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="false"
comment="Entity ID"/>
<column xsi:type="varchar" name="increment_id" nullable="true" length="50" comment="Increment ID"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="varchar" name="order_increment_id" nullable="false" length="32" comment="Order Increment ID"/>
<column xsi:type="int" name="order_id" unsigned="true" nullable="false" identity="false"
comment="Order ID"/>
<column xsi:type="timestamp" name="order_created_at" on_update="false" nullable="false"
default="CURRENT_TIMESTAMP" comment="Order Increment ID"/>
<column xsi:type="varchar" name="customer_name" nullable="false" length="128" comment="Customer Name"/>
<column xsi:type="decimal" name="total_qty" scale="4" precision="12" unsigned="false" nullable="true"
comment="Total Qty"/>
<column xsi:type="int" name="shipment_status" unsigned="false" nullable="true" identity="false"
comment="Shipment Status"/>
<column xsi:type="varchar" name="order_status" nullable="true" length="32" comment="Order"/>
<column xsi:type="varchar" name="billing_address" nullable="true" length="255" comment="Billing Address"/>
<column xsi:type="varchar" name="shipping_address" nullable="true" length="255" comment="Shipping Address"/>
<column xsi:type="varchar" name="billing_name" nullable="true" length="128" comment="Billing Name"/>
<column xsi:type="varchar" name="shipping_name" nullable="true" length="128" comment="Shipping Name"/>
<column xsi:type="varchar" name="customer_email" nullable="true" length="128" comment="Customer Email"/>
<column xsi:type="int" name="customer_group_id" unsigned="false" nullable="true" identity="false"/>
<column xsi:type="varchar" name="payment_method" nullable="true" length="32" comment="Payment Method"/>
<column xsi:type="varchar" name="shipping_information" nullable="true" length="255"
comment="Shipping Method Name"/>
<column xsi:type="timestamp" name="created_at" on_update="false" nullable="true" comment="Created At"/>
<column xsi:type="timestamp" name="updated_at" on_update="false" nullable="true" comment="Updated At"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="SALES_SHIPMENT_GRID_INCREMENT_ID_STORE_ID">
<column name="increment_id"/>
<column name="store_id"/>
</constraint>
<index referenceId="SALES_SHIPMENT_GRID_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
<index referenceId="SALES_SHIPMENT_GRID_TOTAL_QTY" indexType="btree">
<column name="total_qty"/>
</index>
<index referenceId="SALES_SHIPMENT_GRID_ORDER_INCREMENT_ID" indexType="btree">
<column name="order_increment_id"/>
</index>
<index referenceId="SALES_SHIPMENT_GRID_SHIPMENT_STATUS" indexType="btree">
<column name="shipment_status"/>
</index>
<index referenceId="SALES_SHIPMENT_GRID_ORDER_STATUS" indexType="btree">
<column name="order_status"/>
</index>
<index referenceId="SALES_SHIPMENT_GRID_CREATED_AT" indexType="btree">
<column name="created_at"/>
</index>
<index referenceId="SALES_SHIPMENT_GRID_UPDATED_AT" indexType="btree">
<column name="updated_at"/>
</index>
<index referenceId="SALES_SHIPMENT_GRID_ORDER_CREATED_AT" indexType="btree">
<column name="order_created_at"/>
</index>
<index referenceId="SALES_SHIPMENT_GRID_SHIPPING_NAME" indexType="btree">
<column name="shipping_name"/>
</index>
<index referenceId="SALES_SHIPMENT_GRID_BILLING_NAME" indexType="btree">
<column name="billing_name"/>
</index>
<index referenceId="SALES_SHIPMENT_GRID_ORDER_ID" indexType="btree">
<column name="order_id"/>
</index>
<index referenceId="FTI_086B40C8955F167B8EA76653437879B4" indexType="fulltext">
<column name="increment_id"/>
<column name="order_increment_id"/>
<column name="shipping_name"/>
<column name="customer_name"/>
<column name="customer_email"/>
<column name="billing_address"/>
<column name="shipping_address"/>
</index>
</table>
<table name="sales_shipment_item" resource="sales" engine="innodb" comment="Sales Flat Shipment Item">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="Entity ID"/>
<column xsi:type="int" name="parent_id" unsigned="true" nullable="false" identity="false"
comment="Parent ID"/>
<column xsi:type="decimal" name="row_total" scale="4" precision="20" unsigned="false" nullable="true"
comment="Row Total"/>
<column xsi:type="decimal" name="price" scale="4" precision="20" unsigned="false" nullable="true"
comment="Price"/>
<column xsi:type="decimal" name="weight" scale="4" precision="12" unsigned="false" nullable="true"
comment="Weight"/>
<column xsi:type="decimal" name="qty" scale="4" precision="12" unsigned="false" nullable="true" comment="Qty"/>
<column xsi:type="int" name="product_id" unsigned="false" nullable="true" identity="false"
comment="Product ID"/>
<column xsi:type="int" name="order_item_id" unsigned="false" nullable="true" identity="false"
comment="Order Item ID"/>
<column xsi:type="text" name="additional_data" nullable="true" comment="Additional Data"/>
<column xsi:type="text" name="description" nullable="true" comment="Description"/>
<column xsi:type="varchar" name="name" nullable="true" length="255" comment="Name"/>
<column xsi:type="varchar" name="sku" nullable="true" length="255" comment="Sku"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_SHIPMENT_ITEM_PARENT_ID_SALES_SHIPMENT_ENTITY_ID"
table="sales_shipment_item" column="parent_id" referenceTable="sales_shipment"
referenceColumn="entity_id" onDelete="CASCADE"/>
<index referenceId="SALES_SHIPMENT_ITEM_PARENT_ID" indexType="btree">
<column name="parent_id"/>
</index>
</table>
<table name="sales_shipment_track" resource="sales" engine="innodb" comment="Sales Flat Shipment Track">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="Entity ID"/>
<column xsi:type="int" name="parent_id" unsigned="true" nullable="false" identity="false"
comment="Parent ID"/>
<column xsi:type="decimal" name="weight" scale="4" precision="12" unsigned="false" nullable="true"
comment="Weight"/>
<column xsi:type="decimal" name="qty" scale="4" precision="12" unsigned="false" nullable="true" comment="Qty"/>
<column xsi:type="int" name="order_id" unsigned="true" nullable="false" identity="false"
comment="Order ID"/>
<column xsi:type="text" name="track_number" nullable="true" comment="Number"/>
<column xsi:type="text" name="description" nullable="true" comment="Description"/>
<column xsi:type="varchar" name="title" nullable="true" length="255" comment="Title"/>
<column xsi:type="varchar" name="carrier_code" nullable="true" length="32" comment="Carrier Code"/>
<column xsi:type="timestamp" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP"
comment="Created At"/>
<column xsi:type="timestamp" name="updated_at" on_update="true" nullable="false" default="CURRENT_TIMESTAMP"
comment="Updated At"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_SHIPMENT_TRACK_PARENT_ID_SALES_SHIPMENT_ENTITY_ID"
table="sales_shipment_track" column="parent_id" referenceTable="sales_shipment"
referenceColumn="entity_id" onDelete="CASCADE"/>
<index referenceId="SALES_SHIPMENT_TRACK_PARENT_ID" indexType="btree">
<column name="parent_id"/>
</index>
<index referenceId="SALES_SHIPMENT_TRACK_ORDER_ID" indexType="btree">
<column name="order_id"/>
</index>
<index referenceId="SALES_SHIPMENT_TRACK_CREATED_AT" indexType="btree">
<column name="created_at"/>
</index>
</table>
<table name="sales_shipment_comment" resource="sales" engine="innodb" comment="Sales Flat Shipment Comment">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="Entity ID"/>
<column xsi:type="int" name="parent_id" unsigned="true" nullable="false" identity="false"
comment="Parent ID"/>
<column xsi:type="int" name="is_customer_notified" unsigned="false" nullable="true"
identity="false" comment="Is Customer Notified"/>
<column xsi:type="smallint" name="is_visible_on_front" unsigned="true" nullable="false"
identity="false" default="0" comment="Is Visible On Front"/>
<column xsi:type="text" name="comment" nullable="true" comment="Comment"/>
<column xsi:type="timestamp" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP"
comment="Created At"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_SHIPMENT_COMMENT_PARENT_ID_SALES_SHIPMENT_ENTITY_ID"
table="sales_shipment_comment" column="parent_id" referenceTable="sales_shipment"
referenceColumn="entity_id" onDelete="CASCADE"/>
<index referenceId="SALES_SHIPMENT_COMMENT_CREATED_AT" indexType="btree">
<column name="created_at"/>
</index>
<index referenceId="SALES_SHIPMENT_COMMENT_PARENT_ID" indexType="btree">
<column name="parent_id"/>
</index>
</table>
<table name="sales_invoice" resource="sales" engine="innodb" comment="Sales Flat Invoice">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="Entity ID"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="decimal" name="base_grand_total" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Grand Total"/>
<column xsi:type="decimal" name="shipping_tax_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Shipping Tax Amount"/>
<column xsi:type="decimal" name="tax_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Tax Amount"/>
<column xsi:type="decimal" name="base_tax_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Tax Amount"/>
<column xsi:type="decimal" name="store_to_order_rate" scale="4" precision="20" unsigned="false" nullable="true"
comment="Store To Order Rate"/>
<column xsi:type="decimal" name="base_shipping_tax_amount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Shipping Tax Amount"/>
<column xsi:type="decimal" name="base_discount_amount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Discount Amount"/>
<column xsi:type="decimal" name="base_to_order_rate" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base To Order Rate"/>
<column xsi:type="decimal" name="grand_total" scale="4" precision="20" unsigned="false" nullable="true"
comment="Grand Total"/>
<column xsi:type="decimal" name="shipping_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Shipping Amount"/>
<column xsi:type="decimal" name="subtotal_incl_tax" scale="4" precision="20" unsigned="false" nullable="true"
comment="Subtotal Incl Tax"/>
<column xsi:type="decimal" name="base_subtotal_incl_tax" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Subtotal Incl Tax"/>
<column xsi:type="decimal" name="store_to_base_rate" scale="4" precision="20" unsigned="false" nullable="true"
comment="Store To Base Rate"/>
<column xsi:type="decimal" name="base_shipping_amount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Shipping Amount"/>
<column xsi:type="decimal" name="total_qty" scale="4" precision="12" unsigned="false" nullable="true"
comment="Total Qty"/>
<column xsi:type="decimal" name="base_to_global_rate" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base To Global Rate"/>
<column xsi:type="decimal" name="subtotal" scale="4" precision="20" unsigned="false" nullable="true"
comment="Subtotal"/>
<column xsi:type="decimal" name="base_subtotal" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Subtotal"/>
<column xsi:type="decimal" name="discount_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Discount Amount"/>
<column xsi:type="int" name="billing_address_id" unsigned="false" nullable="true" identity="false"
comment="Billing Address ID"/>
<column xsi:type="smallint" name="is_used_for_refund" unsigned="true" nullable="true"
identity="false" comment="Is Used For Refund"/>
<column xsi:type="int" name="order_id" unsigned="true" nullable="false" identity="false"
comment="Order ID"/>
<column xsi:type="smallint" name="email_sent" unsigned="true" nullable="true" identity="false"
comment="Email Sent"/>
<column xsi:type="smallint" name="send_email" unsigned="true" nullable="true" identity="false"
comment="Send Email"/>
<column xsi:type="smallint" name="can_void_flag" unsigned="true" nullable="true" identity="false"
comment="Can Void Flag"/>
<column xsi:type="int" name="state" unsigned="false" nullable="true" identity="false"
comment="State"/>
<column xsi:type="int" name="shipping_address_id" unsigned="false" nullable="true" identity="false"
comment="Shipping Address ID"/>
<column xsi:type="varchar" name="store_currency_code" nullable="true" length="3" comment="Store Currency Code"/>
<column xsi:type="varchar" name="transaction_id" nullable="true" length="255" comment="Transaction ID"/>
<column xsi:type="varchar" name="order_currency_code" nullable="true" length="3" comment="Order Currency Code"/>
<column xsi:type="varchar" name="base_currency_code" nullable="true" length="3" comment="Base Currency Code"/>
<column xsi:type="varchar" name="global_currency_code" nullable="true" length="3"
comment="Global Currency Code"/>
<column xsi:type="varchar" name="increment_id" nullable="true" length="50" comment="Increment ID"/>
<column xsi:type="timestamp" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP"
comment="Created At"/>
<column xsi:type="timestamp" name="updated_at" on_update="true" nullable="false" default="CURRENT_TIMESTAMP"
comment="Updated At"/>
<column xsi:type="decimal" name="discount_tax_compensation_amount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Discount Tax Compensation Amount"/>
<column xsi:type="decimal" name="base_discount_tax_compensation_amount" scale="4" precision="20"
unsigned="false" nullable="true" comment="Base Discount Tax Compensation Amount"/>
<column xsi:type="decimal" name="shipping_discount_tax_compensation_amount" scale="4" precision="20"
unsigned="false" nullable="true" comment="Shipping Discount Tax Compensation Amount"/>
<column xsi:type="decimal" name="base_shipping_discount_tax_compensation_amnt" scale="4" precision="20"
unsigned="false" nullable="true" comment="Base Shipping Discount Tax Compensation Amount"/>
<column xsi:type="decimal" name="shipping_incl_tax" scale="4" precision="20" unsigned="false" nullable="true"
comment="Shipping Incl Tax"/>
<column xsi:type="decimal" name="base_shipping_incl_tax" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Shipping Incl Tax"/>
<column xsi:type="decimal" name="base_total_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Total Refunded"/>
<column xsi:type="varchar" name="discount_description" nullable="true" length="255"
comment="Discount Description"/>
<column xsi:type="text" name="customer_note" nullable="true" comment="Customer Note"/>
<column xsi:type="smallint" name="customer_note_notify" unsigned="true" nullable="true"
identity="false" comment="Customer Note Notify"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_INVOICE_ORDER_ID_SALES_ORDER_ENTITY_ID" table="sales_invoice"
column="order_id" referenceTable="sales_order" referenceColumn="entity_id" onDelete="CASCADE"/>
<constraint xsi:type="foreign" referenceId="SALES_INVOICE_STORE_ID_STORE_STORE_ID" table="sales_invoice"
column="store_id" referenceTable="store" referenceColumn="store_id" onDelete="SET NULL"/>
<constraint xsi:type="unique" referenceId="SALES_INVOICE_INCREMENT_ID_STORE_ID">
<column name="increment_id"/>
<column name="store_id"/>
</constraint>
<index referenceId="SALES_INVOICE_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
<index referenceId="SALES_INVOICE_GRAND_TOTAL" indexType="btree">
<column name="grand_total"/>
</index>
<index referenceId="SALES_INVOICE_ORDER_ID" indexType="btree">
<column name="order_id"/>
</index>
<index referenceId="SALES_INVOICE_STATE" indexType="btree">
<column name="state"/>
</index>
<index referenceId="SALES_INVOICE_CREATED_AT" indexType="btree">
<column name="created_at"/>
</index>
<index referenceId="SALES_INVOICE_UPDATED_AT" indexType="btree">
<column name="updated_at"/>
</index>
<index referenceId="SALES_INVOICE_SEND_EMAIL" indexType="btree">
<column name="send_email"/>
</index>
<index referenceId="SALES_INVOICE_EMAIL_SENT" indexType="btree">
<column name="email_sent"/>
</index>
</table>
<table name="sales_invoice_grid" resource="sales" engine="innodb" comment="Sales Flat Invoice Grid">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="false"
comment="Entity ID"/>
<column xsi:type="varchar" name="increment_id" nullable="true" length="50" comment="Increment ID"/>
<column xsi:type="int" name="state" unsigned="false" nullable="true" identity="false"
comment="State"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="varchar" name="store_name" nullable="true" length="255" comment="Store Name"/>
<column xsi:type="int" name="order_id" unsigned="true" nullable="false" identity="false"
comment="Order ID"/>
<column xsi:type="varchar" name="order_increment_id" nullable="true" length="50" comment="Order Increment ID"/>
<column xsi:type="timestamp" name="order_created_at" on_update="false" nullable="true"
comment="Order Created At"/>
<column xsi:type="varchar" name="customer_name" nullable="true" length="255" comment="Customer Name"/>
<column xsi:type="varchar" name="customer_email" nullable="true" length="255" comment="Customer Email"/>
<column xsi:type="int" name="customer_group_id" unsigned="false" nullable="true" identity="false"/>
<column xsi:type="varchar" name="payment_method" nullable="true" length="128" comment="Payment Method"/>
<column xsi:type="varchar" name="store_currency_code" nullable="true" length="3" comment="Store Currency Code"/>
<column xsi:type="varchar" name="order_currency_code" nullable="true" length="3" comment="Order Currency Code"/>
<column xsi:type="varchar" name="base_currency_code" nullable="true" length="3" comment="Base Currency Code"/>
<column xsi:type="varchar" name="global_currency_code" nullable="true" length="3"
comment="Global Currency Code"/>
<column xsi:type="varchar" name="billing_name" nullable="true" length="255" comment="Billing Name"/>
<column xsi:type="varchar" name="billing_address" nullable="true" length="255" comment="Billing Address"/>
<column xsi:type="varchar" name="shipping_address" nullable="true" length="255" comment="Shipping Address"/>
<column xsi:type="varchar" name="shipping_information" nullable="true" length="255"
comment="Shipping Method Name"/>
<column xsi:type="decimal" name="subtotal" scale="4" precision="20" unsigned="false" nullable="true"
comment="Subtotal"/>
<column xsi:type="decimal" name="shipping_and_handling" scale="4" precision="20" unsigned="false"
nullable="true" comment="Shipping and handling amount"/>
<column xsi:type="decimal" name="grand_total" scale="4" precision="20" unsigned="false" nullable="true"
comment="Grand Total"/>
<column xsi:type="timestamp" name="created_at" on_update="false" nullable="true" comment="Created At"/>
<column xsi:type="timestamp" name="updated_at" on_update="false" nullable="true" comment="Updated At"/>
<column xsi:type="decimal" name="base_grand_total" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Grand Total"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="SALES_INVOICE_GRID_INCREMENT_ID_STORE_ID">
<column name="increment_id"/>
<column name="store_id"/>
</constraint>
<index referenceId="SALES_INVOICE_GRID_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
<index referenceId="SALES_INVOICE_GRID_GRAND_TOTAL" indexType="btree">
<column name="grand_total"/>
</index>
<index referenceId="SALES_INVOICE_GRID_ORDER_ID" indexType="btree">
<column name="order_id"/>
</index>
<index referenceId="SALES_INVOICE_GRID_STATE" indexType="btree">
<column name="state"/>
</index>
<index referenceId="SALES_INVOICE_GRID_ORDER_INCREMENT_ID" indexType="btree">
<column name="order_increment_id"/>
</index>
<index referenceId="SALES_INVOICE_GRID_CREATED_AT" indexType="btree">
<column name="created_at"/>
</index>
<index referenceId="SALES_INVOICE_GRID_UPDATED_AT" indexType="btree">
<column name="updated_at"/>
</index>
<index referenceId="SALES_INVOICE_GRID_ORDER_CREATED_AT" indexType="btree">
<column name="order_created_at"/>
</index>
<index referenceId="SALES_INVOICE_GRID_BILLING_NAME" indexType="btree">
<column name="billing_name"/>
</index>
<index referenceId="FTI_95D9C924DD6A8734EB8B5D01D60F90DE" indexType="fulltext">
<column name="increment_id"/>
<column name="order_increment_id"/>
<column name="billing_name"/>
<column name="billing_address"/>
<column name="shipping_address"/>
<column name="customer_name"/>
<column name="customer_email"/>
</index>
<index referenceId="SALES_INVOICE_GRID_BASE_GRAND_TOTAL" indexType="btree">
<column name="base_grand_total"/>
</index>
</table>
<table name="sales_invoice_item" resource="sales" engine="innodb" comment="Sales Flat Invoice Item">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="Entity ID"/>
<column xsi:type="int" name="parent_id" unsigned="true" nullable="false" identity="false"
comment="Parent ID"/>
<column xsi:type="decimal" name="base_price" scale="4" precision="12" unsigned="false" nullable="true"
comment="Base Price"/>
<column xsi:type="decimal" name="tax_amount" scale="4" precision="12" unsigned="false" nullable="true"
comment="Tax Amount"/>
<column xsi:type="decimal" name="base_row_total" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Row Total"/>
<column xsi:type="decimal" name="discount_amount" scale="4" precision="12" unsigned="false" nullable="true"
comment="Discount Amount"/>
<column xsi:type="decimal" name="row_total" scale="4" precision="20" unsigned="false" nullable="true"
comment="Row Total"/>
<column xsi:type="decimal" name="base_discount_amount" scale="4" precision="12" unsigned="false"
nullable="true" comment="Base Discount Amount"/>
<column xsi:type="decimal" name="price_incl_tax" scale="4" precision="12" unsigned="false" nullable="true"
comment="Price Incl Tax"/>
<column xsi:type="decimal" name="base_tax_amount" scale="4" precision="12" unsigned="false" nullable="true"
comment="Base Tax Amount"/>
<column xsi:type="decimal" name="base_price_incl_tax" scale="4" precision="12" unsigned="false" nullable="true"
comment="Base Price Incl Tax"/>
<column xsi:type="decimal" name="qty" scale="4" precision="12" unsigned="false" nullable="true" comment="Qty"/>
<column xsi:type="decimal" name="base_cost" scale="4" precision="12" unsigned="false" nullable="true"
comment="Base Cost"/>
<column xsi:type="decimal" name="price" scale="4" precision="12" unsigned="false" nullable="true"
comment="Price"/>
<column xsi:type="decimal" name="base_row_total_incl_tax" scale="4" precision="12" unsigned="false"
nullable="true" comment="Base Row Total Incl Tax"/>
<column xsi:type="decimal" name="row_total_incl_tax" scale="4" precision="12" unsigned="false" nullable="true"
comment="Row Total Incl Tax"/>
<column xsi:type="int" name="product_id" unsigned="false" nullable="true" identity="false"
comment="Product ID"/>
<column xsi:type="int" name="order_item_id" unsigned="false" nullable="true" identity="false"
comment="Order Item ID"/>
<column xsi:type="text" name="additional_data" nullable="true" comment="Additional Data"/>
<column xsi:type="text" name="description" nullable="true" comment="Description"/>
<column xsi:type="varchar" name="sku" nullable="true" length="255" comment="Sku"/>
<column xsi:type="varchar" name="name" nullable="true" length="255" comment="Name"/>
<column xsi:type="decimal" name="discount_tax_compensation_amount" scale="4" precision="12" unsigned="false"
nullable="true" comment="Discount Tax Compensation Amount"/>
<column xsi:type="decimal" name="base_discount_tax_compensation_amount" scale="4" precision="12"
unsigned="false" nullable="true" comment="Base Discount Tax Compensation Amount"/>
<column xsi:type="text" name="tax_ratio" nullable="true"
comment="Ratio of tax invoiced over tax of the order item"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_INVOICE_ITEM_PARENT_ID_SALES_INVOICE_ENTITY_ID"
table="sales_invoice_item" column="parent_id" referenceTable="sales_invoice"
referenceColumn="entity_id" onDelete="CASCADE"/>
<index referenceId="SALES_INVOICE_ITEM_PARENT_ID" indexType="btree">
<column name="parent_id"/>
</index>
</table>
<table name="sales_invoice_comment" resource="sales" engine="innodb" comment="Sales Flat Invoice Comment">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="Entity ID"/>
<column xsi:type="int" name="parent_id" unsigned="true" nullable="false" identity="false"
comment="Parent ID"/>
<column xsi:type="smallint" name="is_customer_notified" unsigned="true" nullable="true"
identity="false" comment="Is Customer Notified"/>
<column xsi:type="smallint" name="is_visible_on_front" unsigned="true" nullable="false"
identity="false" default="0" comment="Is Visible On Front"/>
<column xsi:type="text" name="comment" nullable="true" comment="Comment"/>
<column xsi:type="timestamp" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP"
comment="Created At"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_INVOICE_COMMENT_PARENT_ID_SALES_INVOICE_ENTITY_ID"
table="sales_invoice_comment" column="parent_id" referenceTable="sales_invoice"
referenceColumn="entity_id" onDelete="CASCADE"/>
<index referenceId="SALES_INVOICE_COMMENT_CREATED_AT" indexType="btree">
<column name="created_at"/>
</index>
<index referenceId="SALES_INVOICE_COMMENT_PARENT_ID" indexType="btree">
<column name="parent_id"/>
</index>
</table>
<table name="sales_creditmemo" resource="sales" engine="innodb" comment="Sales Flat Creditmemo">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="Entity ID"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="decimal" name="adjustment_positive" scale="4" precision="20" unsigned="false" nullable="true"
comment="Adjustment Positive"/>
<column xsi:type="decimal" name="base_shipping_tax_amount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Shipping Tax Amount"/>
<column xsi:type="decimal" name="store_to_order_rate" scale="4" precision="20" unsigned="false" nullable="true"
comment="Store To Order Rate"/>
<column xsi:type="decimal" name="base_discount_amount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Discount Amount"/>
<column xsi:type="decimal" name="base_to_order_rate" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base To Order Rate"/>
<column xsi:type="decimal" name="grand_total" scale="4" precision="20" unsigned="false" nullable="true"
comment="Grand Total"/>
<column xsi:type="decimal" name="base_adjustment_negative" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Adjustment Negative"/>
<column xsi:type="decimal" name="base_subtotal_incl_tax" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Subtotal Incl Tax"/>
<column xsi:type="decimal" name="shipping_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Shipping Amount"/>
<column xsi:type="decimal" name="subtotal_incl_tax" scale="4" precision="20" unsigned="false" nullable="true"
comment="Subtotal Incl Tax"/>
<column xsi:type="decimal" name="adjustment_negative" scale="4" precision="20" unsigned="false" nullable="true"
comment="Adjustment Negative"/>
<column xsi:type="decimal" name="base_shipping_amount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Shipping Amount"/>
<column xsi:type="decimal" name="store_to_base_rate" scale="4" precision="20" unsigned="false" nullable="true"
comment="Store To Base Rate"/>
<column xsi:type="decimal" name="base_to_global_rate" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base To Global Rate"/>
<column xsi:type="decimal" name="base_adjustment" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Adjustment"/>
<column xsi:type="decimal" name="base_subtotal" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Subtotal"/>
<column xsi:type="decimal" name="discount_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Discount Amount"/>
<column xsi:type="decimal" name="subtotal" scale="4" precision="20" unsigned="false" nullable="true"
comment="Subtotal"/>
<column xsi:type="decimal" name="adjustment" scale="4" precision="20" unsigned="false" nullable="true"
comment="Adjustment"/>
<column xsi:type="decimal" name="base_grand_total" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Grand Total"/>
<column xsi:type="decimal" name="base_adjustment_positive" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Adjustment Positive"/>
<column xsi:type="decimal" name="base_tax_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Tax Amount"/>
<column xsi:type="decimal" name="shipping_tax_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Shipping Tax Amount"/>
<column xsi:type="decimal" name="tax_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Tax Amount"/>
<column xsi:type="int" name="order_id" unsigned="true" nullable="false" identity="false"
comment="Order ID"/>
<column xsi:type="smallint" name="email_sent" unsigned="true" nullable="true" identity="false"
comment="Email Sent"/>
<column xsi:type="smallint" name="send_email" unsigned="true" nullable="true" identity="false"
comment="Send Email"/>
<column xsi:type="int" name="creditmemo_status" unsigned="false" nullable="true" identity="false"
comment="Creditmemo Status"/>
<column xsi:type="int" name="state" unsigned="false" nullable="true" identity="false"
comment="State"/>
<column xsi:type="int" name="shipping_address_id" unsigned="false" nullable="true" identity="false"
comment="Shipping Address ID"/>
<column xsi:type="int" name="billing_address_id" unsigned="false" nullable="true" identity="false"
comment="Billing Address ID"/>
<column xsi:type="int" name="invoice_id" unsigned="false" nullable="true" identity="false"
comment="Invoice ID"/>
<column xsi:type="varchar" name="store_currency_code" nullable="true" length="3" comment="Store Currency Code"/>
<column xsi:type="varchar" name="order_currency_code" nullable="true" length="3" comment="Order Currency Code"/>
<column xsi:type="varchar" name="base_currency_code" nullable="true" length="3" comment="Base Currency Code"/>
<column xsi:type="varchar" name="global_currency_code" nullable="true" length="3"
comment="Global Currency Code"/>
<column xsi:type="varchar" name="transaction_id" nullable="true" length="255" comment="Transaction ID"/>
<column xsi:type="varchar" name="increment_id" nullable="true" length="50" comment="Increment ID"/>
<column xsi:type="timestamp" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP"
comment="Created At"/>
<column xsi:type="timestamp" name="updated_at" on_update="true" nullable="false" default="CURRENT_TIMESTAMP"
comment="Updated At"/>
<column xsi:type="decimal" name="discount_tax_compensation_amount" scale="4" precision="20" unsigned="false"
nullable="true" comment="Discount Tax Compensation Amount"/>
<column xsi:type="decimal" name="base_discount_tax_compensation_amount" scale="4" precision="20"
unsigned="false" nullable="true" comment="Base Discount Tax Compensation Amount"/>
<column xsi:type="decimal" name="shipping_discount_tax_compensation_amount" scale="4" precision="20"
unsigned="false" nullable="true" comment="Shipping Discount Tax Compensation Amount"/>
<column xsi:type="decimal" name="base_shipping_discount_tax_compensation_amnt" scale="4" precision="20"
unsigned="false" nullable="true" comment="Base Shipping Discount Tax Compensation Amount"/>
<column xsi:type="decimal" name="shipping_incl_tax" scale="4" precision="20" unsigned="false" nullable="true"
comment="Shipping Incl Tax"/>
<column xsi:type="decimal" name="base_shipping_incl_tax" scale="4" precision="20" unsigned="false"
nullable="true" comment="Base Shipping Incl Tax"/>
<column xsi:type="varchar" name="discount_description" nullable="true" length="255"
comment="Discount Description"/>
<column xsi:type="text" name="customer_note" nullable="true" comment="Customer Note"/>
<column xsi:type="smallint" name="customer_note_notify" unsigned="true" nullable="true"
identity="false" comment="Customer Note Notify"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_CREDITMEMO_ORDER_ID_SALES_ORDER_ENTITY_ID" table="sales_creditmemo"
column="order_id" referenceTable="sales_order" referenceColumn="entity_id" onDelete="CASCADE"/>
<constraint xsi:type="foreign" referenceId="SALES_CREDITMEMO_STORE_ID_STORE_STORE_ID" table="sales_creditmemo"
column="store_id" referenceTable="store" referenceColumn="store_id" onDelete="SET NULL"/>
<constraint xsi:type="unique" referenceId="SALES_CREDITMEMO_INCREMENT_ID_STORE_ID">
<column name="increment_id"/>
<column name="store_id"/>
</constraint>
<index referenceId="SALES_CREDITMEMO_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
<index referenceId="SALES_CREDITMEMO_ORDER_ID" indexType="btree">
<column name="order_id"/>
</index>
<index referenceId="SALES_CREDITMEMO_CREDITMEMO_STATUS" indexType="btree">
<column name="creditmemo_status"/>
</index>
<index referenceId="SALES_CREDITMEMO_STATE" indexType="btree">
<column name="state"/>
</index>
<index referenceId="SALES_CREDITMEMO_CREATED_AT" indexType="btree">
<column name="created_at"/>
</index>
<index referenceId="SALES_CREDITMEMO_UPDATED_AT" indexType="btree">
<column name="updated_at"/>
</index>
<index referenceId="SALES_CREDITMEMO_SEND_EMAIL" indexType="btree">
<column name="send_email"/>
</index>
<index referenceId="SALES_CREDITMEMO_EMAIL_SENT" indexType="btree">
<column name="email_sent"/>
</index>
</table>
<table name="sales_creditmemo_grid" resource="sales" engine="innodb" comment="Sales Flat Creditmemo Grid">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="false"
comment="Entity ID"/>
<column xsi:type="varchar" name="increment_id" nullable="true" length="50" comment="Increment ID"/>
<column xsi:type="timestamp" name="created_at" on_update="false" nullable="true" comment="Created At"/>
<column xsi:type="timestamp" name="updated_at" on_update="false" nullable="true" comment="Updated At"/>
<column xsi:type="int" name="order_id" unsigned="true" nullable="false" identity="false"
comment="Order ID"/>
<column xsi:type="varchar" name="order_increment_id" nullable="true" length="50" comment="Order Increment ID"/>
<column xsi:type="timestamp" name="order_created_at" on_update="false" nullable="true"
comment="Order Created At"/>
<column xsi:type="varchar" name="billing_name" nullable="true" length="255" comment="Billing Name"/>
<column xsi:type="int" name="state" unsigned="false" nullable="true" identity="false"
comment="Status"/>
<column xsi:type="decimal" name="base_grand_total" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Grand Total"/>
<column xsi:type="varchar" name="order_status" nullable="true" length="32" comment="Order Status"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="varchar" name="billing_address" nullable="true" length="255" comment="Billing Address"/>
<column xsi:type="varchar" name="shipping_address" nullable="true" length="255" comment="Shipping Address"/>
<column xsi:type="varchar" name="customer_name" nullable="false" length="128" comment="Customer Name"/>
<column xsi:type="varchar" name="customer_email" nullable="true" length="128" comment="Customer Email"/>
<column xsi:type="smallint" name="customer_group_id" unsigned="false" nullable="true"
identity="false" comment="Customer Group ID"/>
<column xsi:type="varchar" name="payment_method" nullable="true" length="32" comment="Payment Method"/>
<column xsi:type="varchar" name="shipping_information" nullable="true" length="255"
comment="Shipping Method Name"/>
<column xsi:type="decimal" name="subtotal" scale="4" precision="20" unsigned="false" nullable="true"
comment="Subtotal"/>
<column xsi:type="decimal" name="shipping_and_handling" scale="4" precision="20" unsigned="false"
nullable="true" comment="Shipping and handling amount"/>
<column xsi:type="decimal" name="adjustment_positive" scale="4" precision="20" unsigned="false" nullable="true"
comment="Adjustment Positive"/>
<column xsi:type="decimal" name="adjustment_negative" scale="4" precision="20" unsigned="false" nullable="true"
comment="Adjustment Negative"/>
<column xsi:type="decimal" name="order_base_grand_total" scale="4" precision="20" unsigned="false"
nullable="true" comment="Order Grand Total"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="unique" referenceId="SALES_CREDITMEMO_GRID_INCREMENT_ID_STORE_ID">
<column name="increment_id"/>
<column name="store_id"/>
</constraint>
<index referenceId="SALES_CREDITMEMO_GRID_ORDER_INCREMENT_ID" indexType="btree">
<column name="order_increment_id"/>
</index>
<index referenceId="SALES_CREDITMEMO_GRID_CREATED_AT" indexType="btree">
<column name="created_at"/>
</index>
<index referenceId="SALES_CREDITMEMO_GRID_UPDATED_AT" indexType="btree">
<column name="updated_at"/>
</index>
<index referenceId="SALES_CREDITMEMO_GRID_ORDER_CREATED_AT" indexType="btree">
<column name="order_created_at"/>
</index>
<index referenceId="SALES_CREDITMEMO_GRID_STATE" indexType="btree">
<column name="state"/>
</index>
<index referenceId="SALES_CREDITMEMO_GRID_BILLING_NAME" indexType="btree">
<column name="billing_name"/>
</index>
<index referenceId="SALES_CREDITMEMO_GRID_ORDER_STATUS" indexType="btree">
<column name="order_status"/>
</index>
<index referenceId="SALES_CREDITMEMO_GRID_BASE_GRAND_TOTAL" indexType="btree">
<column name="base_grand_total"/>
</index>
<index referenceId="SALES_CREDITMEMO_GRID_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
<index referenceId="SALES_CREDITMEMO_GRID_ORDER_BASE_GRAND_TOTAL" indexType="btree">
<column name="order_base_grand_total"/>
</index>
<index referenceId="SALES_CREDITMEMO_GRID_ORDER_ID" indexType="btree">
<column name="order_id"/>
</index>
<index referenceId="FTI_32B7BA885941A8254EE84AE650ABDC86" indexType="fulltext">
<column name="increment_id"/>
<column name="order_increment_id"/>
<column name="billing_name"/>
<column name="billing_address"/>
<column name="shipping_address"/>
<column name="customer_name"/>
<column name="customer_email"/>
</index>
</table>
<table name="sales_creditmemo_item" resource="sales" engine="innodb" comment="Sales Flat Creditmemo Item">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="Entity ID"/>
<column xsi:type="int" name="parent_id" unsigned="true" nullable="false" identity="false"
comment="Parent ID"/>
<column xsi:type="decimal" name="base_price" scale="4" precision="12" unsigned="false" nullable="true"
comment="Base Price"/>
<column xsi:type="decimal" name="tax_amount" scale="4" precision="12" unsigned="false" nullable="true"
comment="Tax Amount"/>
<column xsi:type="decimal" name="base_row_total" scale="4" precision="12" unsigned="false" nullable="true"
comment="Base Row Total"/>
<column xsi:type="decimal" name="discount_amount" scale="4" precision="12" unsigned="false" nullable="true"
comment="Discount Amount"/>
<column xsi:type="decimal" name="row_total" scale="4" precision="12" unsigned="false" nullable="true"
comment="Row Total"/>
<column xsi:type="decimal" name="base_discount_amount" scale="4" precision="12" unsigned="false"
nullable="true" comment="Base Discount Amount"/>
<column xsi:type="decimal" name="price_incl_tax" scale="4" precision="12" unsigned="false" nullable="true"
comment="Price Incl Tax"/>
<column xsi:type="decimal" name="base_tax_amount" scale="4" precision="12" unsigned="false" nullable="true"
comment="Base Tax Amount"/>
<column xsi:type="decimal" name="base_price_incl_tax" scale="4" precision="12" unsigned="false" nullable="true"
comment="Base Price Incl Tax"/>
<column xsi:type="decimal" name="qty" scale="4" precision="12" unsigned="false" nullable="true" comment="Qty"/>
<column xsi:type="decimal" name="base_cost" scale="4" precision="12" unsigned="false" nullable="true"
comment="Base Cost"/>
<column xsi:type="decimal" name="price" scale="4" precision="12" unsigned="false" nullable="true"
comment="Price"/>
<column xsi:type="decimal" name="base_row_total_incl_tax" scale="4" precision="12" unsigned="false"
nullable="true" comment="Base Row Total Incl Tax"/>
<column xsi:type="decimal" name="row_total_incl_tax" scale="4" precision="12" unsigned="false" nullable="true"
comment="Row Total Incl Tax"/>
<column xsi:type="int" name="product_id" unsigned="false" nullable="true" identity="false"
comment="Product ID"/>
<column xsi:type="int" name="order_item_id" unsigned="false" nullable="true" identity="false"
comment="Order Item ID"/>
<column xsi:type="text" name="additional_data" nullable="true" comment="Additional Data"/>
<column xsi:type="text" name="description" nullable="true" comment="Description"/>
<column xsi:type="varchar" name="sku" nullable="true" length="255" comment="Sku"/>
<column xsi:type="varchar" name="name" nullable="true" length="255" comment="Name"/>
<column xsi:type="decimal" name="discount_tax_compensation_amount" scale="4" precision="12" unsigned="false"
nullable="true" comment="Discount Tax Compensation Amount"/>
<column xsi:type="decimal" name="base_discount_tax_compensation_amount" scale="4" precision="12"
unsigned="false" nullable="true" comment="Base Discount Tax Compensation Amount"/>
<column xsi:type="text" name="tax_ratio" nullable="true"
comment="Ratio of tax in the creditmemo item over tax of the order item"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_CREDITMEMO_ITEM_PARENT_ID_SALES_CREDITMEMO_ENTITY_ID"
table="sales_creditmemo_item" column="parent_id" referenceTable="sales_creditmemo"
referenceColumn="entity_id" onDelete="CASCADE"/>
<index referenceId="SALES_CREDITMEMO_ITEM_PARENT_ID" indexType="btree">
<column name="parent_id"/>
</index>
</table>
<table name="sales_creditmemo_comment" resource="sales" engine="innodb" comment="Sales Flat Creditmemo Comment">
<column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="true"
comment="Entity ID"/>
<column xsi:type="int" name="parent_id" unsigned="true" nullable="false" identity="false"
comment="Parent ID"/>
<column xsi:type="int" name="is_customer_notified" unsigned="false" nullable="true"
identity="false" comment="Is Customer Notified"/>
<column xsi:type="smallint" name="is_visible_on_front" unsigned="true" nullable="false"
identity="false" default="0" comment="Is Visible On Front"/>
<column xsi:type="text" name="comment" nullable="true" comment="Comment"/>
<column xsi:type="timestamp" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP"
comment="Created At"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="entity_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_CREDITMEMO_COMMENT_PARENT_ID_SALES_CREDITMEMO_ENTITY_ID"
table="sales_creditmemo_comment" column="parent_id" referenceTable="sales_creditmemo"
referenceColumn="entity_id" onDelete="CASCADE"/>
<index referenceId="SALES_CREDITMEMO_COMMENT_CREATED_AT" indexType="btree">
<column name="created_at"/>
</index>
<index referenceId="SALES_CREDITMEMO_COMMENT_PARENT_ID" indexType="btree">
<column name="parent_id"/>
</index>
</table>
<table name="sales_invoiced_aggregated" resource="sales" engine="innodb" comment="Sales Invoiced Aggregated">
<column xsi:type="int" name="id" unsigned="true" nullable="false" identity="true" comment="ID"/>
<column xsi:type="date" name="period" comment="Period"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="varchar" name="order_status" nullable="true" length="50" comment="Order Status"/>
<column xsi:type="int" name="orders_count" unsigned="false" nullable="false" identity="false"
default="0" comment="Orders Count"/>
<column xsi:type="decimal" name="orders_invoiced" scale="4" precision="12" unsigned="false" nullable="true"
comment="Orders Invoiced"/>
<column xsi:type="decimal" name="invoiced" scale="4" precision="12" unsigned="false" nullable="true"
comment="Invoiced"/>
<column xsi:type="decimal" name="invoiced_captured" scale="4" precision="12" unsigned="false" nullable="true"
comment="Invoiced Captured"/>
<column xsi:type="decimal" name="invoiced_not_captured" scale="4" precision="12" unsigned="false"
nullable="true" comment="Invoiced Not Captured"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_INVOICED_AGGREGATED_STORE_ID_STORE_STORE_ID"
table="sales_invoiced_aggregated" column="store_id" referenceTable="store"
referenceColumn="store_id" onDelete="SET NULL"/>
<constraint xsi:type="unique" referenceId="SALES_INVOICED_AGGREGATED_PERIOD_STORE_ID_ORDER_STATUS">
<column name="period"/>
<column name="store_id"/>
<column name="order_status"/>
</constraint>
<index referenceId="SALES_INVOICED_AGGREGATED_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
</table>
<table name="sales_invoiced_aggregated_order" resource="sales" engine="innodb"
comment="Sales Invoiced Aggregated Order">
<column xsi:type="int" name="id" unsigned="true" nullable="false" identity="true" comment="ID"/>
<column xsi:type="date" name="period" comment="Period"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="varchar" name="order_status" nullable="false" length="50" comment="Order Status"/>
<column xsi:type="int" name="orders_count" unsigned="false" nullable="false" identity="false"
default="0" comment="Orders Count"/>
<column xsi:type="decimal" name="orders_invoiced" scale="4" precision="12" unsigned="false" nullable="true"
comment="Orders Invoiced"/>
<column xsi:type="decimal" name="invoiced" scale="4" precision="12" unsigned="false" nullable="true"
comment="Invoiced"/>
<column xsi:type="decimal" name="invoiced_captured" scale="4" precision="12" unsigned="false" nullable="true"
comment="Invoiced Captured"/>
<column xsi:type="decimal" name="invoiced_not_captured" scale="4" precision="12" unsigned="false"
nullable="true" comment="Invoiced Not Captured"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_INVOICED_AGGREGATED_ORDER_STORE_ID_STORE_STORE_ID"
table="sales_invoiced_aggregated_order" column="store_id" referenceTable="store"
referenceColumn="store_id" onDelete="SET NULL"/>
<constraint xsi:type="unique" referenceId="SALES_INVOICED_AGGREGATED_ORDER_PERIOD_STORE_ID_ORDER_STATUS">
<column name="period"/>
<column name="store_id"/>
<column name="order_status"/>
</constraint>
<index referenceId="SALES_INVOICED_AGGREGATED_ORDER_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
</table>
<table name="sales_order_aggregated_created" resource="sales" engine="innodb"
comment="Sales Order Aggregated Created">
<column xsi:type="int" name="id" unsigned="true" nullable="false" identity="true" comment="ID"/>
<column xsi:type="date" name="period" comment="Period"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="varchar" name="order_status" nullable="false" length="50" comment="Order Status"/>
<column xsi:type="int" name="orders_count" unsigned="false" nullable="false" identity="false"
default="0" comment="Orders Count"/>
<column xsi:type="decimal" name="total_qty_ordered" scale="4" precision="12" unsigned="false" nullable="false"
default="0" comment="Total Qty Ordered"/>
<column xsi:type="decimal" name="total_qty_invoiced" scale="4" precision="12" unsigned="false" nullable="false"
default="0" comment="Total Qty Invoiced"/>
<column xsi:type="decimal" name="total_income_amount" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Income Amount"/>
<column xsi:type="decimal" name="total_revenue_amount" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Revenue Amount"/>
<column xsi:type="decimal" name="total_profit_amount" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Profit Amount"/>
<column xsi:type="decimal" name="total_invoiced_amount" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Invoiced Amount"/>
<column xsi:type="decimal" name="total_canceled_amount" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Canceled Amount"/>
<column xsi:type="decimal" name="total_paid_amount" scale="4" precision="20" unsigned="false" nullable="false"
default="0" comment="Total Paid Amount"/>
<column xsi:type="decimal" name="total_refunded_amount" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Refunded Amount"/>
<column xsi:type="decimal" name="total_tax_amount" scale="4" precision="20" unsigned="false" nullable="false"
default="0" comment="Total Tax Amount"/>
<column xsi:type="decimal" name="total_tax_amount_actual" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Tax Amount Actual"/>
<column xsi:type="decimal" name="total_shipping_amount" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Shipping Amount"/>
<column xsi:type="decimal" name="total_shipping_amount_actual" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Shipping Amount Actual"/>
<column xsi:type="decimal" name="total_discount_amount" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Discount Amount"/>
<column xsi:type="decimal" name="total_discount_amount_actual" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Discount Amount Actual"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_ORDER_AGGREGATED_CREATED_STORE_ID_STORE_STORE_ID"
table="sales_order_aggregated_created" column="store_id" referenceTable="store"
referenceColumn="store_id" onDelete="SET NULL"/>
<constraint xsi:type="unique" referenceId="SALES_ORDER_AGGREGATED_CREATED_PERIOD_STORE_ID_ORDER_STATUS">
<column name="period"/>
<column name="store_id"/>
<column name="order_status"/>
</constraint>
<index referenceId="SALES_ORDER_AGGREGATED_CREATED_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
</table>
<table name="sales_order_aggregated_updated" resource="sales" engine="innodb"
comment="Sales Order Aggregated Updated">
<column xsi:type="int" name="id" unsigned="true" nullable="false" identity="true" comment="ID"/>
<column xsi:type="date" name="period" comment="Period"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="varchar" name="order_status" nullable="false" length="50" comment="Order Status"/>
<column xsi:type="int" name="orders_count" unsigned="false" nullable="false" identity="false"
default="0" comment="Orders Count"/>
<column xsi:type="decimal" name="total_qty_ordered" scale="4" precision="12" unsigned="false" nullable="false"
default="0" comment="Total Qty Ordered"/>
<column xsi:type="decimal" name="total_qty_invoiced" scale="4" precision="12" unsigned="false" nullable="false"
default="0" comment="Total Qty Invoiced"/>
<column xsi:type="decimal" name="total_income_amount" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Income Amount"/>
<column xsi:type="decimal" name="total_revenue_amount" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Revenue Amount"/>
<column xsi:type="decimal" name="total_profit_amount" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Profit Amount"/>
<column xsi:type="decimal" name="total_invoiced_amount" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Invoiced Amount"/>
<column xsi:type="decimal" name="total_canceled_amount" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Canceled Amount"/>
<column xsi:type="decimal" name="total_paid_amount" scale="4" precision="20" unsigned="false" nullable="false"
default="0" comment="Total Paid Amount"/>
<column xsi:type="decimal" name="total_refunded_amount" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Refunded Amount"/>
<column xsi:type="decimal" name="total_tax_amount" scale="4" precision="20" unsigned="false" nullable="false"
default="0" comment="Total Tax Amount"/>
<column xsi:type="decimal" name="total_tax_amount_actual" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Tax Amount Actual"/>
<column xsi:type="decimal" name="total_shipping_amount" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Shipping Amount"/>
<column xsi:type="decimal" name="total_shipping_amount_actual" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Shipping Amount Actual"/>
<column xsi:type="decimal" name="total_discount_amount" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Discount Amount"/>
<column xsi:type="decimal" name="total_discount_amount_actual" scale="4" precision="20" unsigned="false"
nullable="false" default="0" comment="Total Discount Amount Actual"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_ORDER_AGGREGATED_UPDATED_STORE_ID_STORE_STORE_ID"
table="sales_order_aggregated_updated" column="store_id" referenceTable="store"
referenceColumn="store_id" onDelete="SET NULL"/>
<constraint xsi:type="unique" referenceId="SALES_ORDER_AGGREGATED_UPDATED_PERIOD_STORE_ID_ORDER_STATUS">
<column name="period"/>
<column name="store_id"/>
<column name="order_status"/>
</constraint>
<index referenceId="SALES_ORDER_AGGREGATED_UPDATED_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
</table>
<table name="sales_payment_transaction" resource="sales" engine="innodb" comment="Sales Payment Transaction">
<column xsi:type="int" name="transaction_id" unsigned="true" nullable="false" identity="true"
comment="Transaction ID"/>
<column xsi:type="int" name="parent_id" unsigned="true" nullable="true" identity="false"
comment="Parent ID"/>
<column xsi:type="int" name="order_id" unsigned="true" nullable="false" identity="false"
default="0" comment="Order ID"/>
<column xsi:type="int" name="payment_id" unsigned="true" nullable="false" identity="false"
default="0" comment="Payment ID"/>
<column xsi:type="varchar" name="txn_id" nullable="true" length="100" comment="Txn ID"/>
<column xsi:type="varchar" name="parent_txn_id" nullable="true" length="100" comment="Parent Txn ID"/>
<column xsi:type="varchar" name="txn_type" nullable="true" length="15" comment="Txn Type"/>
<column xsi:type="smallint" name="is_closed" unsigned="true" nullable="false" identity="false"
default="1" comment="Is Closed"/>
<column xsi:type="blob" name="additional_information" nullable="true" comment="Additional Information"/>
<column xsi:type="timestamp" name="created_at" on_update="false" nullable="false" default="CURRENT_TIMESTAMP"
comment="Created At"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="transaction_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_PAYMENT_TRANSACTION_ORDER_ID_SALES_ORDER_ENTITY_ID"
table="sales_payment_transaction" column="order_id" referenceTable="sales_order"
referenceColumn="entity_id" onDelete="CASCADE"/>
<constraint xsi:type="foreign" referenceId="FK_B99FF1A06402D725EBDB0F3A7ECD47A2" table="sales_payment_transaction"
column="parent_id" referenceTable="sales_payment_transaction" referenceColumn="transaction_id"
onDelete="CASCADE"/>
<constraint xsi:type="foreign" referenceId="SALES_PAYMENT_TRANSACTION_PAYMENT_ID_SALES_ORDER_PAYMENT_ENTT_ID"
table="sales_payment_transaction" column="payment_id" referenceTable="sales_order_payment"
referenceColumn="entity_id" onDelete="CASCADE"/>
<constraint xsi:type="unique" referenceId="SALES_PAYMENT_TRANSACTION_ORDER_ID_PAYMENT_ID_TXN_ID">
<column name="order_id"/>
<column name="payment_id"/>
<column name="txn_id"/>
</constraint>
<index referenceId="SALES_PAYMENT_TRANSACTION_PARENT_ID" indexType="btree">
<column name="parent_id"/>
</index>
<index referenceId="SALES_PAYMENT_TRANSACTION_PAYMENT_ID" indexType="btree">
<column name="payment_id"/>
</index>
</table>
<table name="sales_refunded_aggregated" resource="sales" engine="innodb" comment="Sales Refunded Aggregated">
<column xsi:type="int" name="id" unsigned="true" nullable="false" identity="true" comment="ID"/>
<column xsi:type="date" name="period" comment="Period"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="varchar" name="order_status" nullable="false" length="50" comment="Order Status"/>
<column xsi:type="int" name="orders_count" unsigned="false" nullable="false" identity="false"
default="0" comment="Orders Count"/>
<column xsi:type="decimal" name="refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Refunded"/>
<column xsi:type="decimal" name="online_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Online Refunded"/>
<column xsi:type="decimal" name="offline_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Offline Refunded"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_REFUNDED_AGGREGATED_STORE_ID_STORE_STORE_ID"
table="sales_refunded_aggregated" column="store_id" referenceTable="store"
referenceColumn="store_id" onDelete="SET NULL"/>
<constraint xsi:type="unique" referenceId="SALES_REFUNDED_AGGREGATED_PERIOD_STORE_ID_ORDER_STATUS">
<column name="period"/>
<column name="store_id"/>
<column name="order_status"/>
</constraint>
<index referenceId="SALES_REFUNDED_AGGREGATED_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
</table>
<table name="sales_refunded_aggregated_order" resource="sales" engine="innodb"
comment="Sales Refunded Aggregated Order">
<column xsi:type="int" name="id" unsigned="true" nullable="false" identity="true" comment="ID"/>
<column xsi:type="date" name="period" comment="Period"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="varchar" name="order_status" nullable="true" length="50" comment="Order Status"/>
<column xsi:type="int" name="orders_count" unsigned="false" nullable="false" identity="false"
default="0" comment="Orders Count"/>
<column xsi:type="decimal" name="refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Refunded"/>
<column xsi:type="decimal" name="online_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Online Refunded"/>
<column xsi:type="decimal" name="offline_refunded" scale="4" precision="20" unsigned="false" nullable="true"
comment="Offline Refunded"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_REFUNDED_AGGREGATED_ORDER_STORE_ID_STORE_STORE_ID"
table="sales_refunded_aggregated_order" column="store_id" referenceTable="store"
referenceColumn="store_id" onDelete="SET NULL"/>
<constraint xsi:type="unique" referenceId="SALES_REFUNDED_AGGREGATED_ORDER_PERIOD_STORE_ID_ORDER_STATUS">
<column name="period"/>
<column name="store_id"/>
<column name="order_status"/>
</constraint>
<index referenceId="SALES_REFUNDED_AGGREGATED_ORDER_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
</table>
<table name="sales_shipping_aggregated" resource="sales" engine="innodb" comment="Sales Shipping Aggregated">
<column xsi:type="int" name="id" unsigned="true" nullable="false" identity="true" comment="ID"/>
<column xsi:type="date" name="period" comment="Period"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="varchar" name="order_status" nullable="true" length="50" comment="Order Status"/>
<column xsi:type="varchar" name="shipping_description" nullable="true" length="255"
comment="Shipping Description"/>
<column xsi:type="int" name="orders_count" unsigned="false" nullable="false" identity="false"
default="0" comment="Orders Count"/>
<column xsi:type="decimal" name="total_shipping" scale="4" precision="20" unsigned="false" nullable="true"
comment="Total Shipping"/>
<column xsi:type="decimal" name="total_shipping_actual" scale="4" precision="20" unsigned="false"
nullable="true" comment="Total Shipping Actual"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_SHIPPING_AGGREGATED_STORE_ID_STORE_STORE_ID"
table="sales_shipping_aggregated" column="store_id" referenceTable="store"
referenceColumn="store_id" onDelete="SET NULL"/>
<constraint xsi:type="unique" referenceId="SALES_SHPP_AGGRED_PERIOD_STORE_ID_ORDER_STS_SHPP_DESCRIPTION">
<column name="period"/>
<column name="store_id"/>
<column name="order_status"/>
<column name="shipping_description"/>
</constraint>
<index referenceId="SALES_SHIPPING_AGGREGATED_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
</table>
<table name="sales_shipping_aggregated_order" resource="sales" engine="innodb"
comment="Sales Shipping Aggregated Order">
<column xsi:type="int" name="id" unsigned="true" nullable="false" identity="true" comment="ID"/>
<column xsi:type="date" name="period" comment="Period"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="varchar" name="order_status" nullable="true" length="50" comment="Order Status"/>
<column xsi:type="varchar" name="shipping_description" nullable="true" length="255"
comment="Shipping Description"/>
<column xsi:type="int" name="orders_count" unsigned="false" nullable="false" identity="false"
default="0" comment="Orders Count"/>
<column xsi:type="decimal" name="total_shipping" scale="4" precision="20" unsigned="false" nullable="true"
comment="Total Shipping"/>
<column xsi:type="decimal" name="total_shipping_actual" scale="4" precision="20" unsigned="false"
nullable="true" comment="Total Shipping Actual"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_SHIPPING_AGGREGATED_ORDER_STORE_ID_STORE_STORE_ID"
table="sales_shipping_aggregated_order" column="store_id" referenceTable="store"
referenceColumn="store_id" onDelete="SET NULL"/>
<constraint xsi:type="unique" referenceId="UNQ_C05FAE47282EEA68654D0924E946761F">
<column name="period"/>
<column name="store_id"/>
<column name="order_status"/>
<column name="shipping_description"/>
</constraint>
<index referenceId="SALES_SHIPPING_AGGREGATED_ORDER_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
</table>
<table name="sales_bestsellers_aggregated_daily" resource="sales" engine="innodb"
comment="Sales Bestsellers Aggregated Daily">
<column xsi:type="int" name="id" unsigned="true" nullable="false" identity="true" comment="ID"/>
<column xsi:type="date" name="period" comment="Period"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="int" name="product_id" unsigned="true" nullable="true" identity="false"
comment="Product ID"/>
<column xsi:type="varchar" name="product_name" nullable="true" length="255" comment="Product Name"/>
<column xsi:type="decimal" name="product_price" scale="4" precision="12" unsigned="false" nullable="false"
default="0" comment="Product Price"/>
<column xsi:type="decimal" name="qty_ordered" scale="4" precision="12" unsigned="false" nullable="false"
default="0" comment="Qty Ordered"/>
<column xsi:type="smallint" name="rating_pos" unsigned="true" nullable="false" identity="false"
default="0" comment="Rating Pos"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_BESTSELLERS_AGGREGATED_DAILY_STORE_ID_STORE_STORE_ID"
table="sales_bestsellers_aggregated_daily" column="store_id" referenceTable="store"
referenceColumn="store_id" onDelete="CASCADE"/>
<constraint xsi:type="unique" referenceId="SALES_BESTSELLERS_AGGREGATED_DAILY_PERIOD_STORE_ID_PRODUCT_ID">
<column name="period"/>
<column name="store_id"/>
<column name="product_id"/>
</constraint>
<index referenceId="SALES_BESTSELLERS_AGGREGATED_DAILY_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
<index referenceId="SALES_BESTSELLERS_AGGREGATED_DAILY_PRODUCT_ID" indexType="btree">
<column name="product_id"/>
</index>
</table>
<table name="sales_bestsellers_aggregated_monthly" resource="sales" engine="innodb"
comment="Sales Bestsellers Aggregated Monthly">
<column xsi:type="int" name="id" unsigned="true" nullable="false" identity="true" comment="ID"/>
<column xsi:type="date" name="period" comment="Period"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="int" name="product_id" unsigned="true" nullable="true" identity="false"
comment="Product ID"/>
<column xsi:type="varchar" name="product_name" nullable="true" length="255" comment="Product Name"/>
<column xsi:type="decimal" name="product_price" scale="4" precision="12" unsigned="false" nullable="false"
default="0" comment="Product Price"/>
<column xsi:type="decimal" name="qty_ordered" scale="4" precision="12" unsigned="false" nullable="false"
default="0" comment="Qty Ordered"/>
<column xsi:type="smallint" name="rating_pos" unsigned="true" nullable="false" identity="false"
default="0" comment="Rating Pos"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_BESTSELLERS_AGGREGATED_MONTHLY_STORE_ID_STORE_STORE_ID"
table="sales_bestsellers_aggregated_monthly" column="store_id" referenceTable="store"
referenceColumn="store_id" onDelete="CASCADE"/>
<constraint xsi:type="unique" referenceId="SALES_BESTSELLERS_AGGREGATED_MONTHLY_PERIOD_STORE_ID_PRODUCT_ID">
<column name="period"/>
<column name="store_id"/>
<column name="product_id"/>
</constraint>
<index referenceId="SALES_BESTSELLERS_AGGREGATED_MONTHLY_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
<index referenceId="SALES_BESTSELLERS_AGGREGATED_MONTHLY_PRODUCT_ID" indexType="btree">
<column name="product_id"/>
</index>
</table>
<table name="sales_bestsellers_aggregated_yearly" resource="sales" engine="innodb"
comment="Sales Bestsellers Aggregated Yearly">
<column xsi:type="int" name="id" unsigned="true" nullable="false" identity="true" comment="ID"/>
<column xsi:type="date" name="period" comment="Period"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
comment="Store ID"/>
<column xsi:type="int" name="product_id" unsigned="true" nullable="true" identity="false"
comment="Product ID"/>
<column xsi:type="varchar" name="product_name" nullable="true" length="255" comment="Product Name"/>
<column xsi:type="decimal" name="product_price" scale="4" precision="12" unsigned="false" nullable="false"
default="0" comment="Product Price"/>
<column xsi:type="decimal" name="qty_ordered" scale="4" precision="12" unsigned="false" nullable="false"
default="0" comment="Qty Ordered"/>
<column xsi:type="smallint" name="rating_pos" unsigned="true" nullable="false" identity="false"
default="0" comment="Rating Pos"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_BESTSELLERS_AGGREGATED_YEARLY_STORE_ID_STORE_STORE_ID"
table="sales_bestsellers_aggregated_yearly" column="store_id" referenceTable="store"
referenceColumn="store_id" onDelete="CASCADE"/>
<constraint xsi:type="unique" referenceId="SALES_BESTSELLERS_AGGREGATED_YEARLY_PERIOD_STORE_ID_PRODUCT_ID">
<column name="period"/>
<column name="store_id"/>
<column name="product_id"/>
</constraint>
<index referenceId="SALES_BESTSELLERS_AGGREGATED_YEARLY_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
<index referenceId="SALES_BESTSELLERS_AGGREGATED_YEARLY_PRODUCT_ID" indexType="btree">
<column name="product_id"/>
</index>
</table>
<table name="sales_order_tax" resource="sales" engine="innodb" comment="Sales Order Tax Table">
<column xsi:type="int" name="tax_id" unsigned="true" nullable="false" identity="true"
comment="Tax ID"/>
<column xsi:type="int" name="order_id" unsigned="true" nullable="false" identity="false"
comment="Order ID"/>
<column xsi:type="varchar" name="code" nullable="true" length="255" comment="Code"/>
<column xsi:type="varchar" name="title" nullable="true" length="255" comment="Title"/>
<column xsi:type="decimal" name="percent" scale="4" precision="12" unsigned="false" nullable="true"
comment="Percent"/>
<column xsi:type="decimal" name="amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Amount"/>
<column xsi:type="int" name="priority" unsigned="false" nullable="false" identity="false"
comment="Priority"/>
<column xsi:type="int" name="position" unsigned="false" nullable="false" identity="false"
comment="Position"/>
<column xsi:type="decimal" name="base_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Amount"/>
<column xsi:type="smallint" name="process" unsigned="false" nullable="false" identity="false"
comment="Process"/>
<column xsi:type="decimal" name="base_real_amount" scale="4" precision="20" unsigned="false" nullable="true"
comment="Base Real Amount"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="tax_id"/>
</constraint>
<index referenceId="SALES_ORDER_TAX_ORDER_ID_PRIORITY_POSITION" indexType="btree">
<column name="order_id"/>
<column name="priority"/>
<column name="position"/>
</index>
</table>
<table name="sales_order_tax_item" resource="sales" engine="innodb" comment="Sales Order Tax Item">
<column xsi:type="int" name="tax_item_id" unsigned="true" nullable="false" identity="true"
comment="Tax Item ID"/>
<column xsi:type="int" name="tax_id" unsigned="true" nullable="false" identity="false"
comment="Tax ID"/>
<column xsi:type="int" name="item_id" unsigned="true" nullable="true" identity="false"
comment="Item ID"/>
<column xsi:type="decimal" name="tax_percent" scale="4" precision="12" unsigned="false" nullable="false"
comment="Real Tax Percent For Item"/>
<column xsi:type="decimal" name="amount" scale="4" precision="20" unsigned="false" nullable="false"
comment="Tax amount for the item and tax rate"/>
<column xsi:type="decimal" name="base_amount" scale="4" precision="20" unsigned="false" nullable="false"
comment="Base tax amount for the item and tax rate"/>
<column xsi:type="decimal" name="real_amount" scale="4" precision="20" unsigned="false" nullable="false"
comment="Real tax amount for the item and tax rate"/>
<column xsi:type="decimal" name="real_base_amount" scale="4" precision="20" unsigned="false" nullable="false"
comment="Real base tax amount for the item and tax rate"/>
<column xsi:type="int" name="associated_item_id" unsigned="true" nullable="true" identity="false"
comment="Id of the associated item"/>
<column xsi:type="varchar" name="taxable_item_type" nullable="false" length="32"
comment="Type of the taxable item"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="tax_item_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_ORDER_TAX_ITEM_ASSOCIATED_ITEM_ID_SALES_ORDER_ITEM_ITEM_ID"
table="sales_order_tax_item" column="associated_item_id" referenceTable="sales_order_item"
referenceColumn="item_id" onDelete="CASCADE"/>
<constraint xsi:type="foreign" referenceId="SALES_ORDER_TAX_ITEM_TAX_ID_SALES_ORDER_TAX_TAX_ID"
table="sales_order_tax_item" column="tax_id" referenceTable="sales_order_tax"
referenceColumn="tax_id" onDelete="CASCADE"/>
<constraint xsi:type="foreign" referenceId="SALES_ORDER_TAX_ITEM_ITEM_ID_SALES_ORDER_ITEM_ITEM_ID"
table="sales_order_tax_item" column="item_id" referenceTable="sales_order_item"
referenceColumn="item_id" onDelete="CASCADE"/>
<constraint xsi:type="unique" referenceId="SALES_ORDER_TAX_ITEM_TAX_ID_ITEM_ID">
<column name="tax_id"/>
<column name="item_id"/>
</constraint>
<index referenceId="SALES_ORDER_TAX_ITEM_ITEM_ID" indexType="btree">
<column name="item_id"/>
</index>
</table>
<table name="sales_order_status" resource="sales" engine="innodb" comment="Sales Order Status Table">
<column xsi:type="varchar" name="status" nullable="false" length="32" comment="Status"/>
<column xsi:type="varchar" name="label" nullable="false" length="128" comment="Label"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="status"/>
</constraint>
</table>
<table name="sales_order_status_state" resource="sales" engine="innodb" comment="Sales Order Status Table">
<column xsi:type="varchar" name="status" nullable="false" length="32" comment="Status"/>
<column xsi:type="varchar" name="state" nullable="false" length="32" comment="Label"/>
<column xsi:type="smallint" name="is_default" unsigned="true" nullable="false" identity="false"
default="0" comment="Is Default"/>
<column xsi:type="smallint" name="visible_on_front" unsigned="true" nullable="false"
identity="false" default="0" comment="Visible on front"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="status"/>
<column name="state"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_ORDER_STATUS_STATE_STATUS_SALES_ORDER_STATUS_STATUS"
table="sales_order_status_state" column="status" referenceTable="sales_order_status"
referenceColumn="status" onDelete="CASCADE"/>
</table>
<table name="sales_order_status_label" resource="sales" engine="innodb" comment="Sales Order Status Label Table">
<column xsi:type="varchar" name="status" nullable="false" length="32" comment="Status"/>
<column xsi:type="smallint" name="store_id" unsigned="true" nullable="false" identity="false"
comment="Store ID"/>
<column xsi:type="varchar" name="label" nullable="false" length="128" comment="Label"/>
<constraint xsi:type="primary" referenceId="PRIMARY">
<column name="status"/>
<column name="store_id"/>
</constraint>
<constraint xsi:type="foreign" referenceId="SALES_ORDER_STATUS_LABEL_STATUS_SALES_ORDER_STATUS_STATUS"
table="sales_order_status_label" column="status" referenceTable="sales_order_status"
referenceColumn="status" onDelete="CASCADE"/>
<constraint xsi:type="foreign" referenceId="SALES_ORDER_STATUS_LABEL_STORE_ID_STORE_STORE_ID"
table="sales_order_status_label" column="store_id" referenceTable="store" referenceColumn="store_id"
onDelete="CASCADE"/>
<index referenceId="SALES_ORDER_STATUS_LABEL_STORE_ID" indexType="btree">
<column name="store_id"/>
</index>
</table>
</schema>