diff options
Diffstat (limited to 'db/index.js')
| -rw-r--r-- | db/index.js | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/db/index.js b/db/index.js index 215d34df..4142de33 100644 --- a/db/index.js +++ b/db/index.js @@ -5,11 +5,12 @@ db = new Sequelize(conf.database, conf.username, conf.password, { host: conf.host, dialect: conf.dialect, logging: false, - dialectOptions: { multipleStatements: true } + dialectOptions: conf.dialectOptions }); require("./models/accounts.js"); require("./models/invoices.js"); +require("./models/keys.js"); require("./models/payments.js"); require("./models/users.js"); @@ -23,6 +24,11 @@ db["User"].hasMany(db["Invoice"], { foreignKey: "user_id" }); +db["User"].hasMany(db["Key"], { + as: "keys", + foreignKey: "user_id" +}); + db["User"].hasMany(db["Payment"], { as: "payments", foreignKey: "user_id" @@ -43,6 +49,11 @@ db["Invoice"].belongsTo(db["User"], { foreignKey: "user_id" }); +db["Key"].belongsTo(db["User"], { + as: "user", + foreignKey: "user_id" +}); + db["Payment"].belongsTo(db["Account"], { as: "account", foreignKey: "account_id" |
