diff options
Diffstat (limited to 'db/index.js')
| -rw-r--r-- | db/index.js | 17 |
1 files changed, 14 insertions, 3 deletions
diff --git a/db/index.js b/db/index.js index b411a8ef..bb94fb98 100644 --- a/db/index.js +++ b/db/index.js @@ -8,12 +8,13 @@ db = new Sequelize(conf.database, conf.username, conf.password, { dialectOptions: { multipleStatements: true } }); +require("./models/accounts.js"); require("./models/invoices.js"); require("./models/payments.js"); require("./models/users.js"); -db["User"].hasMany(db["Payment"], { - as: "payments", +db["User"].hasMany(db["Account"], { + as: "accounts", foreignKey: "user_id" }); @@ -22,7 +23,12 @@ db["User"].hasMany(db["Invoice"], { foreignKey: "user_id" }); -db["Payment"].belongsTo(db["User"], { +db["User"].hasMany(db["Payment"], { + as: "payments", + foreignKey: "user_id" +}); + +db["Account"].belongsTo(db["User"], { as: "user", foreignKey: "user_id" }); @@ -31,3 +37,8 @@ db["Invoice"].belongsTo(db["User"], { as: "user", foreignKey: "user_id" }); + +db["Payment"].belongsTo(db["User"], { + as: "user", + foreignKey: "user_id" +}); |
