20220818091238-create-ambiance-interference.js
5d9c74d79942master

20220818091238-create-ambiance-interference.js
View Options

			module.exports = {
			up: (queryInterface, Sequelize) => queryInterface.createTable('AmbianceInterferences', {
			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
			},
			duration: {
			type: Sequelize.INTEGER,
			allowNull: false
			},
			intencity: {
			type: Sequelize.INTEGER,
			allowNull: false
			},
			ScenarioId: {
			type: Sequelize.INTEGER,
			allowNull: false,
			onDelete: 'CASCADE',
			references: {
			model: 'Scenarios',
			key: 'id',
			},
			}
			}),
			down: (queryInterface, Sequelize) => queryInterface.dropTable('AmbianceInterferences')
			};