aboutsummaryrefslogtreecommitdiffstats
path: root/db/index.js
diff options
context:
space:
mode:
Diffstat (limited to 'db/index.js')
-rw-r--r--db/index.js17
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"
+});