20220818080207-create-visual-interference.js
5d9c74d79942master

20220818080207-create-visual-interference.js
View Options

			module.exports = {
			up: (queryInterface, Sequelize) => queryInterface.createTable('VisualInterferences', {
			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
			},
			anchor: {
			type: Sequelize.INTEGER,
			allowNull: false
			},
			duration: Sequelize.INTEGER,
			repetitions: Sequelize.INTEGER,
			volume: Sequelize.DOUBLE,
			ScenarioId: {
			type: Sequelize.INTEGER,
			allowNull: false,
			onDelete: 'CASCADE',
			references: {
			model: 'Scenarios',
			key: 'id',
			},
			},
			Asset2DId: {
			type: Sequelize.INTEGER,
			allowNull: false,
			references: {
			model: '2DAssets',
			key: 'id',
			},
			}
			}),
			down: (queryInterface, Sequelize) => queryInterface.dropTable('VisualInterferences')
			};