crear.js

const { DataTypes } = require('sequelize')
const { Sequelize } = require('sequelize');

const sequelize = new Sequelize({
    dialect: 'sqlite',
    storage: './blog.sqlite'
})

const Posts = sequelize.define('Posts', {

    id: {
        type: DataTypes.INTEGER,
        autoIncrement: true,
        allowNull: false,
        primaryKey: true
    },
    createdAt: {
        type: DataTypes.DATE      
    },
    updatedAt: {
        type: DataTypes.DATE
    },
    title: {
        type: DataTypes.DATE
    },
    body: {
        type: DataTypes.TEXT
    },
    attachmentId: {
        type: DataTypes.INTEGER,
        references: {
            model: 'attachments',
            key: 'id'
        }
    }
});

const attachments = sequelize.define('Attachments', {
    id: {
        type: DataTypes.INTEGER,
        allowNull: false,
        primaryKey: true,
        autoIncrement: true
    },
    createdAt: {
        type: DataTypes.DATE
    },
    updatedAt: {
        type: DataTypes.DATE
    },
    mime: {
        type: DataTypes.STRING
    },
    url: {
        type: DataTypes.STRING
    },
    image: {
        type: DataTypes.BLOB
    }
});