const { DataTypes } = require('sequelize');
const { dbAuth: db } = require('../../utils');
const catalogMCCP = require('./catalogs-mccp');
const epustakaMCCP = require('./epustaka');

const epustakaCatalogMCCP = db.define('epustaka_catalogs_mccp', {
    id: { primaryKey: true, type: DataTypes.UUID, defaultValue: DataTypes.UUIDV4 },
    epustaka_id: { type: DataTypes.UUID },
    catalog_id: { type: DataTypes.UUID },
    epustaka_id: { type: DataTypes.UUID },
    epustaka_catalog_qty: { type: DataTypes.INTEGER },
    epustaka_catalog_borrow: { type: DataTypes.INTEGER },
    created_by: { type: DataTypes.UUID },
    epustaka_catalog_isprivate: { type: DataTypes.BOOLEAN }
}, {
    freezeTableName: true,
    paranoid: false,
    createdAt: 'created_at',
    updatedAt: 'updated_at',
    // deletedAt: 'deleted_at'
});

catalogMCCP.hasMany(epustakaCatalogMCCP, { as: 'epustaka_catalogs_mccp', foreignKey: 'catalog_id', sourceKey: 'id' });
epustakaCatalogMCCP.belongsTo(catalogMCCP, { as: 'catalog_mccp', foreignKey: 'catalog_id', targetKey: 'id' });
epustakaMCCP.hasMany(epustakaCatalogMCCP, { as: 'epustaka_catalogs_mccp', foreignKey: 'epustaka_id', sourceKey: 'id' });
epustakaCatalogMCCP.belongsTo(epustakaMCCP, { as: 'epustaka_mccp', foreignKey: 'epustaka_id', targetKey: 'id' });

module.exports = epustakaCatalogMCCP;