How is the `sales_order_grid` table's structure defined in Magento < 2.3?

dmitry_fedyuk · February 11, 2024, 4:30pm

Magento 2.0.0

magento/magento2/blob/2.0.0/app/code/Magento/Sales/Setup/InstallSchema.php#L906-L1064


      
          $table = $installer->getConnection()->newTable(
              $installer->getTable('sales_order_grid')
          )->addColumn(
              'entity_id',
              \Magento\Framework\DB\Ddl\Table::TYPE_INTEGER,
              null,
              ['unsigned' => true, 'nullable' => false, 'primary' => true],
              'Entity Id'
          )->addColumn(
              'status',
              \Magento\Framework\DB\Ddl\Table::TYPE_TEXT,
              32,
              [],
              'Status'
          )->addColumn(
              'store_id',
              \Magento\Framework\DB\Ddl\Table::TYPE_SMALLINT,
              null,
              ['unsigned' => true],
              'Store Id'

This file has been truncated. show original