const Sequelize = require('sequelize');
var db = require("../database/db.js");

const Idioma = db.sequelize.define('IDIOMA', {
    ID_IDIOMA: {
        primaryKey: true,
        type: Sequelize.BIGINT,
        allowNull: false,
        autoIncrement: true
    },

    ID_USUARIO: {
        type: Sequelize.BIGINT,
        allowNull: false,
    },

    NOMBRE: {
        type: Sequelize.STRING,
        allowNull: false,
    },

    NIVEL_COMPRENDE: {
        type: Sequelize.STRING,
        allowNull: true,
    },

    NIVEL_LEE: {
        type: Sequelize.STRING,
        allowNull: true,
    },

    NIVEL_HABLA: {
        type: Sequelize.STRING,
        allowNull: true,
    },

    NIVEL_ESCRIBE: {
        type: Sequelize.STRING,
        allowNull: true,
    },

    FECHA_REGISTRO: {
        type: Sequelize.DATE,
        allowNull: true,
    },

    FECHA_ACTUALIZACION: {
        type: Sequelize.DATE,
        allowNull: true,
    }
},
{
    timestamps: false,
    id: false
});

module.exports = Idioma;