w4ab/db.js

const Sequelize = require('sequelize');
const Model = Sequelize.Model;

const sequelize = new Sequelize('w4aclem', 'clement.krebs', 'n4or2bgm', {
    host: 'mysql.iutrs.unistra.fr',
    dialect: 'mysql'
});

class Person extends Model {}
Person.init({
    lastname: Sequelize.STRING,
    firstname: Sequelize.STRING
}, {sequelize, modelName: 'Person'});

class MailAddress extends Model {}
MailAddress.init({
    address: {
        type: Sequelize.STRING,
        validate: {
            isEmail: true
        }
    },
    type: Sequelize.ENUM('home', 'work')
}, {sequelize, modelName: 'MailAddress'});

MailAddress.belongsTo(Person, {onDelete: 'cascade'});
Person.hasMany(MailAddress, {onDelete: 'cascade'});

sequelize.sync();

module.exports = {Person, MailAddress};