20220818091534-create-experience.js
5d9c74d79942master

20220818091534-create-experience.js
View Options

			module.exports = {
			up: (queryInterface, Sequelize) => queryInterface.createTable('Experiences', {
			id: {
			type: Sequelize.INTEGER,
			autoIncrement: true,
			primaryKey: true
			},
			ScenarioId: {
			type: Sequelize.INTEGER,
			allowNull: false,
			onDelete: 'CASCADE',
			references: {
			model: 'Scenarios',
			key: 'id',
			},
			},
			PlayerId: {
			type: Sequelize.INTEGER,
			allowNull: false,
			references: {
			model: 'Players',
			key: 'id',
			},
			}
			}),
			down: (queryInterface, Sequelize) => queryInterface.dropTable('Experiences')
			};