Homec4science
Diffusion Sesame - Configurator (master) Browse

sesame-configurator/backend/src/migrations/20220818075805-create-scenario.js
5d9c74d79942master

Last Change
Raw File

20220818075805-create-scenario.js
View Options

module.exports = {
up: (queryInterface, Sequelize) => queryInterface.createTable('Scenarios', {
id: {
type: Sequelize.INTEGER,
autoIncrement: true,
primaryKey: true
},
scenarioID: {
type: Sequelize.STRING,
allowNull: false,
unique: true
},
goStimuliTime: {
type: Sequelize.DOUBLE,
allowNull: false
},
fixationTime: {
type: Sequelize.DOUBLE,
allowNull: false
},
SSDDuration: {
type: Sequelize.INTEGER,
allowNull: false
},
SSDMinDuration: {
type: Sequelize.INTEGER,
allowNull: false
},
SSDMaxDuration: {
type: Sequelize.INTEGER,
allowNull: false
},
SSDDelta: {
type: Sequelize.INTEGER,
allowNull: false
},
stopStimuliProbability: {
type: Sequelize.DOUBLE,
allowNull: false
},
numberOfStimuli: {
type: Sequelize.INTEGER,
allowNull: false
},
numberOfBreaks: {
type: Sequelize.INTEGER,
allowNull: false
},
ambianceSound: {
type: Sequelize.STRING,
allowNull: false
},
ambianceVolume: {
type: Sequelize.DOUBLE,
allowNull: false
},
anchorPoints: {
type: Sequelize.JSON,
allowNull: false
},
distractors: {
type: Sequelize.JSON,
allowNull: false
},
scoresShowMean: {
type: Sequelize.BOOLEAN,
allowNull: false
},
scoresShowSuccessRate: {
type: Sequelize.BOOLEAN,
allowNull: false
},
scoresFeedbackMessage: {
type: Sequelize.STRING,
allowNull: false
},
allowOverlappingSoundinterference: {
type: Sequelize.BOOLEAN,
allowNull: false
},
stimuliAssetId: {
type: Sequelize.INTEGER,
references: {
model: '3DAssets',
key: 'id',
},
},
levelAssetId: {
type: Sequelize.INTEGER,
references: {
model: '3DAssets',
key: 'id',
},
},
JSONExport: Sequelize.JSON,
SceneId: {
type: Sequelize.INTEGER,
allowNull: false,
references: {
model: 'Scenes',
key: 'id',
},
}
}),
down: (queryInterface, Sequelize) => queryInterface.dropTable('Scenarios')
};
c4science · Help