32 lines
962 B
JavaScript
32 lines
962 B
JavaScript
module.exports = (sequelize, type) => {
|
|
const QueDBUpdate = sequelize.define('quedb_updates', {
|
|
id: {
|
|
type: type.INTEGER,
|
|
primaryKey: true,
|
|
autoIncrement: true
|
|
},
|
|
user_id: type.INTEGER,
|
|
queid: type.INTEGER,
|
|
question: type.TEXT,
|
|
option1: type.TEXT,
|
|
option2: type.TEXT,
|
|
option3: type.TEXT,
|
|
option4: type.TEXT,
|
|
explanation: type.TEXT,
|
|
correct: type.INTEGER,
|
|
type: type.ENUM('correction', 'delete', 'feedback', 'tag'),
|
|
feedback: type.TEXT,
|
|
difficulty: type.ENUM('VERY SIMPLE', 'SIMPLE', 'AVERAGE', 'ABOVE AVERAGE', 'HARD', 'DIFFICULT', 'TRICKY'),
|
|
software: type.TEXT,
|
|
notes: type.TEXT,
|
|
addressed: {
|
|
type: type.INTEGER,
|
|
defaultValue: 0
|
|
},
|
|
status: {
|
|
type: type.INTEGER,
|
|
defaultValue: 0
|
|
}
|
|
})
|
|
return QueDBUpdate;
|
|
} |