mysql - 如何使用sequelize创建外键？

Question

const Sequelize = require('sequelize');
    const sequelize = require('../util/dbconnect');    
    const TableOne= sequelize.define('TableOne', {
          id: {
            type: Sequelize.INTEGER,
            autoIncrement: true,
            allowNull: false,
            primaryKey: true
          },
          awg: {
            type: Sequelize.STRING,
            allowNull: false
          }
        });

        module.exports = TableOne;

        **Table 2:** 

        const Sequelize = require('sequelize');

        const sequelize = require('../util/dbconnect');

        const Tabletwo= sequelize.define('Tabletwo', {
          id: {
            type: Sequelize.INTEGER,
            autoIncrement: true,
            allowNull: false,
            primaryKey: true
          },
          item_des: {
            type: Sequelize.STRING,
          },
          gauge:{
            type: Sequelize.STRING,
          },
          connector_type:{
            type: Sequelize.STRING,
          }

        });

        module.exports = Tabletwo;

如何为两个现有表创建外键并链接它们，如果能解释一下那就太好了，因为我已经阅读了文档但无法解决。

Answer 1

您需要使用belongsTo() 表示法来关联表即。外键。

TableOne.belongsTo(Tabletwo);//将 TabletwoId 添加到 TableOne

或者

TableOne.belongsTo(Tabletwo, {as: '二'});//将 TwoId 添加到 TableOne 而不是 TabletwoId

您可以引用https://sequelize.readthedocs.io/en/2.0/docs/associations/了解更多详情。