Magento 2 InstallSchema – Is My Assumption Correct?

I'm creating table with reference key of catalog_product_entity, here I'm little bit of confusing while converting Magento 1.0 to Magento 2.0.

Can you clarify it.

In magento 1.0 simply I can run the below script it will execute and create the table right?

<?php

$installer = $this;
/* @var $installer Mage_Core_Model_Resource_Setup */

$installer->startSetup();

$installer->run("

-- DROP TABLE IF EXISTS `{$this->getTable('custom_info')}`;
CREATE TABLE `{$this->getTable('custom_info')}` (
  `id` INTEGER unsigned NOT NULL auto_increment,
  `product_id` INTEGER unsigned NOT NULL,
  `email` TEXT NOT NULL default '',
  `is_active` ENUM('0','1') NOT NULL DEFAULT '0',
  `date` DATETIME default '0000-00-00 00:00:00',  
  PRIMARY KEY  (`id`),
  KEY `FK_custom_PRODUCT_ID` (`product_id`),
  CONSTRAINT `FK_custom_PRODUCT_ID` FOREIGN KEY (`product_id`) REFERENCES `{$this->getTable('catalog_product_entity')}` (`entity_id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

");

$installer->endSetup();

In Magento 2.0 I have written code as below is it correct procedure or else wrong?

<?php

namespace Learning\Custom\Setup;

use Magento\Framework\Setup\InstallSchemaInterface;
use Magento\Framework\Setup\ModuleContextInterface;
use Magento\Framework\Setup\SchemaSetupInterface;
use Magento\Framework\DB\Ddl\Table;

class InstallSchema implements InstallSchemaInterface
{

    /**
 * Installs DB schema for a module
 *
 * @param SchemaSetupInterface $setup
 * @param ModuleContextInterface $context
 * @return void
 */
public function install(SchemaSetupInterface $setup, ModuleContextInterface $context)
{
    $installer = $setup;
    $installer->startSetup();

    $table = $installer->getConnection()->newTable($installer->getTable('outofstocksubscription_info'))
        ->addColumn(
            'id',
            Table::TYPE_INTEGER,
            10,
            ['identity' => true, 'nullable' => false, 'primary' => true],
            'Post ID'
        )
        ->addColumn(
            'product_id',
            Table::TYPE_INTEGER,
            10,
            ['unsigned' => true, 'nullable' => false, 'default' => '0'],
            'Product Id'
        )
        ->addColumn(
            'email',
            Table::TYPE_TEXT,
            null,
            ['nullable' => false,],
            'E Mail'
        )
        ->addColumn(
            'is_active',
            Table::TYPE_BOOLEAN,
            null,
            ['nullable' => false, 'default' => '0'],
            'Is Active'
        )
        ->addForeignKey(
            $installer->getFkName('outofstocksubscription_info', 'product_id', 'catalog_product_entity', 'entity_id'),
            'product_id',
            $installer->getTable('catalog_product_entity'),
            'entity_id',
            Table::ACTION_CASCADE
        )
        ->addColumn(
            'date',
            Table::TYPE_DATE,
            null,
            [],
            'Date'
        )
        ->setComment(
            'Out of Stock Subscription'
        );

    $installer->getConnection()->createTable($table);
    $installer->endSetup();
}

}

If it is wrong please correct me.

When I ran command: php bin/magento setup:upgrade error is came.

Error

SQLSTATE[HY000]: General error: 1215 Cannot add foreign key
constraint, query was: CREATE TABLE IF NOT EXISTS
custom_info (
id smallint NOT NULL auto_increment COMMENT 'Post ID' ,
product_id smallint UNSIGNED NOT NULL COMMENT 'Product Id' ,
email text NOT NULL COMMENT 'E Mail' ,
is_active bool NOT NULL default '0' COMMENT 'Is Active' ,
date date NULL COMMENT 'Date' ,
PRIMARY KEY (id),
CONSTRAINT CUSTOM__INFO_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID
FOREIGN KEY (id) REFERENCES catalog_product_entity (entity_id)
ON DELETE CASCADE ) COMMENT='Custom Table'
ENGINE=INNODB charset=utf8 COLLATE=utf8_general_ci