-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathMail.js
52 lines (47 loc) · 1.16 KB
/
Mail.js
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
// Mail Model
module.exports = (sequelize, DataTypes) => {
const Mail = sequelize.define("Mail", {
itemId: {
type: DataTypes.INTEGER,
},
bidderId: {
type: DataTypes.INTEGER,
},
sellerId: {
type: DataTypes.INTEGER,
},
bidderRating: {
type: DataTypes.FLOAT,
},
sellerRating: {
type: DataTypes.FLOAT,
},
payed: {
type: DataTypes.BOOLEAN,
defaultValue: false,
},
arrived: {
type: DataTypes.BOOLEAN,
defaultValue: false,
},
itemName: {
type: DataTypes.STRING,
},
});
// Associated through foreign keys automatically
Mail.associate = (models) => {
Mail.belongsTo(models.User, {
foreignKey: 'sellerId',
});
Mail.belongsTo(models.User, {
foreignKey: 'bidderId',
});
Mail.belongsTo(models.Item, {
foreignKey: 'itemId',
});
Mail.hasMany(models.Message, {
onDelete: 'cascade',
});
};
return Mail;
};