How is the `sales_order_grid` table's structure defined in Magento ≥ 2.3.0?

dmitry_fedyuk · February 11, 2024, 4:10pm

magento/magento2/blob/2.4.6/app/code/Magento/Sales/etc/db_schema.xml#L298-L336


      
          <table name="sales_order_grid" resource="sales" engine="innodb" comment="Sales Flat Order Grid">
              <column xsi:type="int" name="entity_id" unsigned="true" nullable="false" identity="false"
                      comment="Entity ID"/>
              <column xsi:type="varchar" name="status" nullable="true" length="32" comment="Status"/>
              <column xsi:type="smallint" name="store_id" unsigned="true" nullable="true" identity="false"
                      comment="Store ID"/>
              <column xsi:type="varchar" name="store_name" nullable="true" length="255" comment="Store Name"/>
              <column xsi:type="int" name="customer_id" unsigned="true" nullable="true" identity="false"
                      comment="Customer ID"/>
              <column xsi:type="decimal" name="base_grand_total" scale="4" precision="20" unsigned="false" nullable="true"
                      comment="Base Grand Total"/>
              <column xsi:type="decimal" name="base_total_paid" scale="4" precision="20" unsigned="false" nullable="true"
                      comment="Base Total Paid"/>
              <column xsi:type="decimal" name="grand_total" scale="4" precision="20" unsigned="false" nullable="true"
                      comment="Grand Total"/>
              <column xsi:type="decimal" name="total_paid" scale="4" precision="20" unsigned="false" nullable="true"
                      comment="Total Paid"/>
              <column xsi:type="varchar" name="increment_id" nullable="true" length="50" comment="Increment ID"/>
              <column xsi:type="varchar" name="base_currency_code" nullable="true" length="3" comment="Base Currency Code"/>
              <column xsi:type="varchar" name="order_currency_code" nullable="true" length="255"

This file has been truncated. show original