28 lines
741 B
JavaScript
28 lines
741 B
JavaScript
module.exports = (sequelize, type) => {
|
|
const Notifications = sequelize.define('notifications', {
|
|
id: {
|
|
type: type.INTEGER,
|
|
primaryKey: true,
|
|
autoIncrement: true
|
|
},
|
|
user_id: type.INTEGER,
|
|
cohort_id: type.INTEGER,
|
|
message: type.TEXT,
|
|
noti_type: type.TEXT,
|
|
test_type: type.TEXT,//KA,CAT,PT,LE
|
|
test_id: type.INTEGER,
|
|
is_read: type.INTEGER,//0 or 1
|
|
fire_time: type.TEXT,
|
|
meeting_date: {
|
|
type: type.DATE,
|
|
options: {
|
|
useUTC: false
|
|
},
|
|
},
|
|
status: {
|
|
type: type.INTEGER,
|
|
defaultValue: 0
|
|
}
|
|
})
|
|
return Notifications;
|
|
} |