sequelize关联查询的问题

Question

比如我想执行以下查询操作、我该怎么定义Model之间的关联关系？source、key字段都不是主键、或者设置了外键

SELECT
    t1. NAME,
    t1. STATUS,
    t2. USERNAME
FROM
    TASK t1,
    USER_STATUS t2
WHERE
    t1.source = t2. key

Answer 1

还是自己尝试出来了：

T1.belongsTo(T2,{foreignKey: 'source',sourceKey:"key"});

T1 model是属于T2 model、通过foreignKey和sourceKey自定义关联的字段

生成SQL：

SELECT * FROM T1 AS `t1` LEFT OUTER JOIN `T2` AS `t2` ON `t1`.`source` = `t2`.`key`