<?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" padding="10" 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" padding="5" unsigned="true" nullable="true" identity="false"
                comment="Is Virtual"/>
        <column xsi:type="smallint" name="store_id" padding="5" unsigned="true" nullable="true" identity="false"
                comment="Store ID"/>
        <column xsi:type="int" name="customer_id" padding="10" 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" padding="5" unsigned="true" nullable="true"
                identity="false" comment="Can Ship Partially"/>
        <column xsi:type="smallint" name="can_ship_partially_item" padding="5" unsigned="true" nullable="true"
                identity="false" comment="Can Ship Partially Item"/>
        <column xsi:type="smallint" name="customer_is_guest" padding="5" unsigned="true" nullable="true"
                identity="false" comment="Customer Is Guest"/>
        <column xsi:type="smallint" name="customer_note_notify" padding="5" unsigned="true" nullable="true"
                identity="false" comment="Customer Note Notify"/>
        <column xsi:type="int" name="billing_address_id" padding="11" unsigned="false" nullable="true" identity="false"
                comment="Billing Address ID"/>
        <column xsi:type="int" name="customer_group_id" padding="11" unsigned="false" nullable="true" identity="false"/>
        <column xsi:type="int" name="edit_increment" padding="11" unsigned="false" nullable="true" identity="false"
                comment="Edit Increment"/>
        <column xsi:type="smallint" name="email_sent" padding="5" unsigned="true" nullable="true" identity="false"
                comment="Email Sent"/>
        <column xsi:type="smallint" name="send_email" padding="5" unsigned="true" nullable="true" identity="false"
                comment="Send Email"/>
        <column xsi:type="smallint" name="forced_shipment_with_invoice" padding="5" unsigned="true" nullable="true"
                identity="false" comment="Forced Do Shipment With Invoice"/>
        <column xsi:type="int" name="payment_auth_expiration" padding="11" unsigned="false" nullable="true"
                identity="false" comment="Payment Authorization Expiration"/>
        <column xsi:type="int" name="quote_address_id" padding="11" unsigned="false" nullable="true" identity="false"
                comment="Quote Address ID"/>
        <column xsi:type="int" name="quote_id" padding="11" unsigned="false" nullable="true" identity="false"
                comment="Quote ID"/>
        <column xsi:type="int" name="shipping_address_id" padding="11" 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="32" 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="32"
                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="32" 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" padding="5" unsigned="true" nullable="false"
                identity="false" default="0" comment="Total Item Count"/>
        <column xsi:type="int" name="customer_gender" padding="11" 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" padding="10" 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" padding="5" 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" padding="10" 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" padding="10" unsigned="true" nullable="false" identity="true"
                comment="Entity ID"/>
        <column xsi:type="int" name="parent_id" padding="10" unsigned="true" nullable="true" identity="false"
                comment="Parent ID"/>
        <column xsi:type="int" name="customer_address_id" padding="11" unsigned="false" nullable="true" identity="false"
                comment="Customer Address ID"/>
        <column xsi:type="int" name="quote_address_id" padding="11" unsigned="false" nullable="true" identity="false"
                comment="Quote Address ID"/>
        <column xsi:type="int" name="region_id" padding="11" unsigned="false" nullable="true" identity="false"
                comment="Region ID"/>
        <column xsi:type="int" name="customer_id" padding="11" 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" padding="6" 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" padding="6" 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" padding="10" unsigned="true" nullable="false" identity="true"
                comment="Entity ID"/>
        <column xsi:type="int" name="parent_id" padding="10" unsigned="true" nullable="false" identity="false"
                comment="Parent ID"/>
        <column xsi:type="int" name="is_customer_notified" padding="11" unsigned="false" nullable="true"
                identity="false" comment="Is Customer Notified"/>
        <column xsi:type="smallint" name="is_visible_on_front" padding="5" 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" padding="10" unsigned="true" nullable="false" identity="true"
                comment="Item ID"/>
        <column xsi:type="int" name="order_id" padding="10" unsigned="true" nullable="false" identity="false"
                default="0" comment="Order ID"/>
        <column xsi:type="int" name="parent_item_id" padding="10" unsigned="true" nullable="true" identity="false"
                comment="Parent Item ID"/>
        <column xsi:type="int" name="quote_item_id" padding="10" unsigned="true" nullable="true" identity="false"
                comment="Quote Item ID"/>
        <column xsi:type="smallint" name="store_id" padding="5" 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" padding="10" 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="text" 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" padding="5" 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" padding="5" unsigned="true" nullable="true" identity="false"
                comment="Is Qty Decimal"/>
        <column xsi:type="smallint" name="no_discount" padding="5" 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" padding="5" unsigned="true" nullable="true"
                identity="false" comment="Locked Do Invoice"/>
        <column xsi:type="smallint" name="locked_do_ship" padding="5" 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" padding="10" unsigned="true" nullable="false" identity="true"
                comment="Entity ID"/>
        <column xsi:type="int" name="parent_id" padding="10" 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" padding="11" 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" padding="10" unsigned="true" nullable="false" identity="true"
                comment="Entity ID"/>
        <column xsi:type="smallint" name="store_id" padding="5" 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" padding="5" unsigned="true" nullable="true" identity="false"
                comment="Email Sent"/>
        <column xsi:type="smallint" name="send_email" padding="5" unsigned="true" nullable="true" identity="false"
                comment="Send Email"/>
        <column xsi:type="int" name="order_id" padding="10" unsigned="true" nullable="false" identity="false"
                comment="Order ID"/>
        <column xsi:type="int" name="customer_id" padding="11" unsigned="false" nullable="true" identity="false"
                comment="Customer ID"/>
        <column xsi:type="int" name="shipping_address_id" padding="11" unsigned="false" nullable="true" identity="false"
                comment="Shipping Address ID"/>
        <column xsi:type="int" name="billing_address_id" padding="11" unsigned="false" nullable="true" identity="false"
                comment="Billing Address ID"/>
        <column xsi:type="int" name="shipment_status" padding="11" 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" padding="5" 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" padding="10" 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" padding="5" 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" padding="10" unsigned="true" nullable="false" identity="false"
                comment="Order ID"/>
        <column xsi:type="timestamp" name="order_created_at" on_update="true" 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" padding="11" 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" padding="11" 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="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" padding="10" unsigned="true" nullable="false" identity="true"
                comment="Entity ID"/>
        <column xsi:type="int" name="parent_id" padding="10" 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" padding="11" unsigned="false" nullable="true" identity="false"
                comment="Product ID"/>
        <column xsi:type="int" name="order_item_id" padding="11" 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" padding="10" unsigned="true" nullable="false" identity="true"
                comment="Entity ID"/>
        <column xsi:type="int" name="parent_id" padding="10" 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" padding="10" 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" padding="10" unsigned="true" nullable="false" identity="true"
                comment="Entity ID"/>
        <column xsi:type="int" name="parent_id" padding="10" unsigned="true" nullable="false" identity="false"
                comment="Parent ID"/>
        <column xsi:type="int" name="is_customer_notified" padding="11" unsigned="false" nullable="true"
                identity="false" comment="Is Customer Notified"/>
        <column xsi:type="smallint" name="is_visible_on_front" padding="5" 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" padding="10" unsigned="true" nullable="false" identity="true"
                comment="Entity ID"/>
        <column xsi:type="smallint" name="store_id" padding="5" 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" padding="11" unsigned="false" nullable="true" identity="false"
                comment="Billing Address ID"/>
        <column xsi:type="smallint" name="is_used_for_refund" padding="5" unsigned="true" nullable="true"
                identity="false" comment="Is Used For Refund"/>
        <column xsi:type="int" name="order_id" padding="10" unsigned="true" nullable="false" identity="false"
                comment="Order ID"/>
        <column xsi:type="smallint" name="email_sent" padding="5" unsigned="true" nullable="true" identity="false"
                comment="Email Sent"/>
        <column xsi:type="smallint" name="send_email" padding="5" unsigned="true" nullable="true" identity="false"
                comment="Send Email"/>
        <column xsi:type="smallint" name="can_void_flag" padding="5" unsigned="true" nullable="true" identity="false"
                comment="Can Void Flag"/>
        <column xsi:type="int" name="state" padding="11" unsigned="false" nullable="true" identity="false"
                comment="State"/>
        <column xsi:type="int" name="shipping_address_id" padding="11" 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" padding="5" 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" padding="10" 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" padding="11" unsigned="false" nullable="true" identity="false"
                comment="State"/>
        <column xsi:type="smallint" name="store_id" padding="5" 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" padding="10" 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" padding="11" 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" padding="10" unsigned="true" nullable="false" identity="true"
                comment="Entity ID"/>
        <column xsi:type="int" name="parent_id" padding="10" 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" padding="11" unsigned="false" nullable="true" identity="false"
                comment="Product ID"/>
        <column xsi:type="int" name="order_item_id" padding="11" 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" padding="10" unsigned="true" nullable="false" identity="true"
                comment="Entity ID"/>
        <column xsi:type="int" name="parent_id" padding="10" unsigned="true" nullable="false" identity="false"
                comment="Parent ID"/>
        <column xsi:type="smallint" name="is_customer_notified" padding="5" unsigned="true" nullable="true"
                identity="false" comment="Is Customer Notified"/>
        <column xsi:type="smallint" name="is_visible_on_front" padding="5" 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" padding="10" unsigned="true" nullable="false" identity="true"
                comment="Entity ID"/>
        <column xsi:type="smallint" name="store_id" padding="5" 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" padding="10" unsigned="true" nullable="false" identity="false"
                comment="Order ID"/>
        <column xsi:type="smallint" name="email_sent" padding="5" unsigned="true" nullable="true" identity="false"
                comment="Email Sent"/>
        <column xsi:type="smallint" name="send_email" padding="5" unsigned="true" nullable="true" identity="false"
                comment="Send Email"/>
        <column xsi:type="int" name="creditmemo_status" padding="11" unsigned="false" nullable="true" identity="false"
                comment="Creditmemo Status"/>
        <column xsi:type="int" name="state" padding="11" unsigned="false" nullable="true" identity="false"
                comment="State"/>
        <column xsi:type="int" name="shipping_address_id" padding="11" unsigned="false" nullable="true" identity="false"
                comment="Shipping Address ID"/>
        <column xsi:type="int" name="billing_address_id" padding="11" unsigned="false" nullable="true" identity="false"
                comment="Billing Address ID"/>
        <column xsi:type="int" name="invoice_id" padding="11" 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" padding="5" 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" padding="10" 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" padding="10" 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" padding="11" 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" padding="5" 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" padding="6" 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" padding="10" unsigned="true" nullable="false" identity="true"
                comment="Entity ID"/>
        <column xsi:type="int" name="parent_id" padding="10" 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" padding="11" unsigned="false" nullable="true" identity="false"
                comment="Product ID"/>
        <column xsi:type="int" name="order_item_id" padding="11" 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" padding="10" unsigned="true" nullable="false" identity="true"
                comment="Entity ID"/>
        <column xsi:type="int" name="parent_id" padding="10" unsigned="true" nullable="false" identity="false"
                comment="Parent ID"/>
        <column xsi:type="int" name="is_customer_notified" padding="11" unsigned="false" nullable="true"
                identity="false" comment="Is Customer Notified"/>
        <column xsi:type="smallint" name="is_visible_on_front" padding="5" 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" padding="10" unsigned="true" nullable="false" identity="true" comment="ID"/>
        <column xsi:type="date" name="period" comment="Period"/>
        <column xsi:type="smallint" name="store_id" padding="5" 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" padding="11" 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" padding="10" unsigned="true" nullable="false" identity="true" comment="ID"/>
        <column xsi:type="date" name="period" comment="Period"/>
        <column xsi:type="smallint" name="store_id" padding="5" 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" padding="11" 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" padding="10" unsigned="true" nullable="false" identity="true" comment="ID"/>
        <column xsi:type="date" name="period" comment="Period"/>
        <column xsi:type="smallint" name="store_id" padding="5" 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" padding="11" 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" padding="10" unsigned="true" nullable="false" identity="true" comment="ID"/>
        <column xsi:type="date" name="period" comment="Period"/>
        <column xsi:type="smallint" name="store_id" padding="5" 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" padding="11" 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" padding="10" unsigned="true" nullable="false" identity="true"
                comment="Transaction ID"/>
        <column xsi:type="int" name="parent_id" padding="10" unsigned="true" nullable="true" identity="false"
                comment="Parent ID"/>
        <column xsi:type="int" name="order_id" padding="10" unsigned="true" nullable="false" identity="false"
                default="0" comment="Order ID"/>
        <column xsi:type="int" name="payment_id" padding="10" 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" padding="5" 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" padding="10" unsigned="true" nullable="false" identity="true" comment="ID"/>
        <column xsi:type="date" name="period" comment="Period"/>
        <column xsi:type="smallint" name="store_id" padding="5" 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" padding="11" 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" padding="10" unsigned="true" nullable="false" identity="true" comment="ID"/>
        <column xsi:type="date" name="period" comment="Period"/>
        <column xsi:type="smallint" name="store_id" padding="5" 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" padding="11" 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" padding="10" unsigned="true" nullable="false" identity="true" comment="ID"/>
        <column xsi:type="date" name="period" comment="Period"/>
        <column xsi:type="smallint" name="store_id" padding="5" 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" padding="11" 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" padding="10" unsigned="true" nullable="false" identity="true" comment="ID"/>
        <column xsi:type="date" name="period" comment="Period"/>
        <column xsi:type="smallint" name="store_id" padding="5" 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" padding="11" 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" padding="10" unsigned="true" nullable="false" identity="true" comment="ID"/>
        <column xsi:type="date" name="period" comment="Period"/>
        <column xsi:type="smallint" name="store_id" padding="5" unsigned="true" nullable="true" identity="false"
                comment="Store ID"/>
        <column xsi:type="int" name="product_id" padding="10" 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" padding="5" 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" padding="10" unsigned="true" nullable="false" identity="true" comment="ID"/>
        <column xsi:type="date" name="period" comment="Period"/>
        <column xsi:type="smallint" name="store_id" padding="5" unsigned="true" nullable="true" identity="false"
                comment="Store ID"/>
        <column xsi:type="int" name="product_id" padding="10" 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" padding="5" 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" padding="10" unsigned="true" nullable="false" identity="true" comment="ID"/>
        <column xsi:type="date" name="period" comment="Period"/>
        <column xsi:type="smallint" name="store_id" padding="5" unsigned="true" nullable="true" identity="false"
                comment="Store ID"/>
        <column xsi:type="int" name="product_id" padding="10" 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" padding="5" 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" padding="10" unsigned="true" nullable="false" identity="true"
                comment="Tax ID"/>
        <column xsi:type="int" name="order_id" padding="10" 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" padding="11" unsigned="false" nullable="false" identity="false"
                comment="Priority"/>
        <column xsi:type="int" name="position" padding="11" 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" padding="6" 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" padding="10" unsigned="true" nullable="false" identity="true"
                comment="Tax Item ID"/>
        <column xsi:type="int" name="tax_id" padding="10" unsigned="true" nullable="false" identity="false"
                comment="Tax ID"/>
        <column xsi:type="int" name="item_id" padding="10" 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" padding="10" 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" padding="5" unsigned="true" nullable="false" identity="false"
                default="0" comment="Is Default"/>
        <column xsi:type="smallint" name="visible_on_front" padding="5" 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" padding="5" 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>
