20220818080114-create-sound-interference.js
5d9c74d79942master

20220818080114-create-sound-interference.js
View Options

			module.exports = {
			up: (queryInterface, Sequelize) => queryInterface.createTable('SoundInterferences', {
			id: {
			type: Sequelize.INTEGER,
			autoIncrement: true,
			primaryKey: true
			},
			interferenceId: {
			type: Sequelize.STRING,
			allowNull: false,
			unique: true
			},
			startTime: {
			type: Sequelize.DOUBLE,
			allowNull: false
			},
			probability: {
			type: Sequelize.DOUBLE,
			allowNull: false
			},
			interval: {
			type: Sequelize.DOUBLE,
			allowNull: false
			},
			volume: {
			type: Sequelize.DOUBLE,
			allowNull: false
			},
			repetitions: {
			type: Sequelize.INTEGER,
			allowNull: false
			},
			ScenarioId: {
			type: Sequelize.INTEGER,
			allowNull: false,
			onDelete: 'CASCADE',
			references: {
			model: 'Scenarios',
			key: 'id',
			},
			},
			SoundAssetId: {
			type: Sequelize.INTEGER,
			allowNull: false,
			references: {
			model: 'SoundAssets',
			key: 'id',
			},
			}
			}),
			down: (queryInterface, Sequelize) => queryInterface.dropTable('SoundInterferences')
			};