20220818080301-create-full-interference.js
5d9c74d79942master

20220818080301-create-full-interference.js
View Options

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