const { DataTypes } = require('sequelize')
const sequelize = require('../database/database')
const Position = require('../models/position')
 
const Employee = sequelize.define('Employee', {
    id: { 
        type: DataTypes.INTEGER,
        autoIncrement: true,
        primaryKey: true
    },
    name: { 
        type: DataTypes.STRING,  
        allowNull: false,
        validate: {
            notNull: true
        }
    },
    city: { type: DataTypes.STRING,  allowNull: true  },
    salary: { type: DataTypes.DOUBLE , defaultValue: 0 },
    positionId: { 
        type: DataTypes.INTEGER
    }
})

//Idegenkulcs:
Employee.belongsTo(Position, {foreignKey: 'positionId', targetKey: 'id'})

//A model és az adatbázis szinkronizálása, nem erőltetve.
sequelize.sync({
    force: false
})
module.exports = Employee