LMS/E-Learning-Backend-main/app/models/scores.js
2025-09-01 19:37:35 +05:30

31 lines
1.4 KiB
JavaScript

module.exports = (sequelize, type) => {
const Scores = sequelize.define('scores', {
id: {
type: type.INTEGER,
primaryKey: true,
autoIncrement: true
},
know: type.INTEGER, //Mark card as Know It
review: type.INTEGER, //Mark card as Review
bookmark: type.INTEGER, //Bookmark Card
notes: type.INTEGER, //Add notes to card
pq_r: type.INTEGER, //Practice question Answered correctly
pq_w: type.INTEGER, //Practice question Answered incorrectly
ka_r: type.INTEGER, //Knowledge assessment question Answered correctly
ka_w: type.INTEGER, //Knowledge assessment question Answered incorrectly
pt_r: type.INTEGER, //Practice Exam question Answered correctly
pt_w: type.INTEGER, //Practice Exam question Answered incorrectly
cat_r: type.INTEGER, //CAT exam question Answered correctly
cat_w: type.INTEGER, //CAT exam question Answered incorrectly
live_r: type.INTEGER, //Live questions Answered correctly
live_w: type.INTEGER, //Live questions Answered incorrectly
video_watch: type.INTEGER, //Study Material Watch a video
mindmap_view: type.INTEGER, //Study Material View a MindMap
reference_view: type.INTEGER, //Study Material View References
status: {
type: type.INTEGER,
defaultValue: 0
}
})
return Scores;
}