Lemuel Marquez
158 lines
2.9 KiB
JavaScript
158 lines
2.9 KiB
JavaScript
const { DataTypes, Model } = require('sequelize');
|
|
const sequelize = require('../../config/sequelize.conf');
|
|
|
|
class CuestionarioAlumno extends Model {}
|
|
CuestionarioAlumno.init(
|
|
{
|
|
idCuestionarioAlumno: {
|
|
type: DataTypes.INTEGER,
|
|
primaryKey: true,
|
|
allowNull: false,
|
|
unique: true,
|
|
autoIncrement: true,
|
|
},
|
|
sexo: {
|
|
type: DataTypes.STRING(1),
|
|
allowNull: false,
|
|
},
|
|
edad: {
|
|
type: DataTypes.STRING(2),
|
|
allowNull: false,
|
|
},
|
|
servicioMedico: {
|
|
type: DataTypes.STRING(100),
|
|
allowNull: false,
|
|
},
|
|
p1: {
|
|
type: DataTypes.BOOLEAN,
|
|
allowNull: false,
|
|
},
|
|
p2: {
|
|
type: DataTypes.BOOLEAN,
|
|
allowNull: false,
|
|
},
|
|
p3: {
|
|
type: DataTypes.STRING(150),
|
|
allowNull: false,
|
|
},
|
|
p4: {
|
|
type: DataTypes.BOOLEAN,
|
|
allowNull: false,
|
|
},
|
|
p5: {
|
|
type: DataTypes.STRING(7),
|
|
allowNull: false,
|
|
},
|
|
p6: {
|
|
type: DataTypes.BOOLEAN,
|
|
allowNull: false,
|
|
},
|
|
p7: {
|
|
type: DataTypes.BOOLEAN,
|
|
allowNull: false,
|
|
},
|
|
p8: {
|
|
type: DataTypes.STRING(5),
|
|
allowNull: false,
|
|
},
|
|
p9: {
|
|
type: DataTypes.BOOLEAN,
|
|
allowNull: false,
|
|
},
|
|
p10: {
|
|
type: DataTypes.BOOLEAN,
|
|
allowNull: false,
|
|
},
|
|
p11: {
|
|
type: DataTypes.BOOLEAN,
|
|
allowNull: false,
|
|
},
|
|
p12: {
|
|
type: DataTypes.BOOLEAN,
|
|
allowNull: false,
|
|
},
|
|
p13: {
|
|
type: DataTypes.BOOLEAN,
|
|
allowNull: false,
|
|
},
|
|
p14: {
|
|
type: DataTypes.STRING(7),
|
|
allowNull: false,
|
|
},
|
|
p15: {
|
|
type: DataTypes.STRING(7),
|
|
allowNull: false,
|
|
},
|
|
p16: {
|
|
type: DataTypes.STRING(2),
|
|
allowNull: false,
|
|
},
|
|
p17: {
|
|
type: DataTypes.STRING(5),
|
|
allowNull: false,
|
|
},
|
|
p18: {
|
|
type: DataTypes.BOOLEAN,
|
|
allowNull: false,
|
|
},
|
|
p19: {
|
|
type: DataTypes.BOOLEAN,
|
|
allowNull: false,
|
|
},
|
|
p20: {
|
|
type: DataTypes.BOOLEAN,
|
|
allowNull: false,
|
|
},
|
|
p21: {
|
|
type: DataTypes.STRING(9),
|
|
allowNull: false,
|
|
},
|
|
p22: {
|
|
type: DataTypes.STRING(23),
|
|
allowNull: false,
|
|
},
|
|
p23: {
|
|
type: DataTypes.STRING(8),
|
|
allowNull: false,
|
|
},
|
|
p24: {
|
|
type: DataTypes.STRING(8),
|
|
allowNull: false,
|
|
},
|
|
p25: {
|
|
type: DataTypes.BOOLEAN,
|
|
allowNull: false,
|
|
},
|
|
p26: {
|
|
type: DataTypes.BOOLEAN,
|
|
allowNull: false,
|
|
},
|
|
p27: {
|
|
type: DataTypes.STRING(400),
|
|
allowNull: false,
|
|
},
|
|
p28: {
|
|
type: DataTypes.STRING(1),
|
|
allowNull: false,
|
|
},
|
|
p29: {
|
|
type: DataTypes.STRING(1),
|
|
allowNull: false,
|
|
},
|
|
p30: {
|
|
type: DataTypes.STRING(400),
|
|
allowNull: false,
|
|
},
|
|
},
|
|
{
|
|
sequelize,
|
|
modelName: 'CuestionarioAlumno',
|
|
tableName: 'cuestionario_alumno',
|
|
timestamps: true,
|
|
createdAt: true,
|
|
updatedAt: false,
|
|
}
|
|
);
|
|
|
|
module.exports = CuestionarioAlumno;
|