27 lines
715 B
JavaScript
27 lines
715 B
JavaScript
module.exports = (sequelize, type) => {
|
|
const StudyMaterial = sequelize.define('study_materials', {
|
|
id: {
|
|
type: type.INTEGER,
|
|
primaryKey: true,
|
|
autoIncrement: true
|
|
},
|
|
d_id: type.INTEGER,
|
|
sd_id: type.INTEGER,
|
|
topic_id: type.INTEGER,
|
|
subtopic_id: type.INTEGER,
|
|
title: type.STRING,
|
|
certi_id: type.INTEGER,
|
|
cource_id: type.INTEGER,
|
|
content: type.TEXT,
|
|
pdf_files: type.TEXT,
|
|
ppt_files: type.TEXT,
|
|
image_files: type.TEXT,
|
|
excel_files: type.TEXT,
|
|
status: {
|
|
type: type.INTEGER,
|
|
defaultValue: 0
|
|
}
|
|
})
|
|
return StudyMaterial;
|
|
}
|