// 1. 导入sequelize的连接
const { DataTypes } = require('sequelize')
const seq = require('../db/seq')
const Goods = require('./goods.model')

// 2. 定义Cart模型
const Cart = seq.define('zd_carts', {
  goods_id: {
    type: DataTypes.INTEGER,
    allowNull: false,
    comment: '商品的id',
  },
  user_id: {
    type: DataTypes.INTEGER,
    allowNull: false,
    comment: '用户的id',
  },
  number: {
    type: DataTypes.INTEGER,
    allowNull: false,
    defaultValue: 1,
    comment: '商品的数量',
  },
  selected: {
    type: DataTypes.BOOLEAN,
    allowNull: false,
    defaultValue: true,
    comment: '是否选中',
  },
})

// 3. 同步数据(建表)
// Cart.sync({ force: true })
Cart.belongsTo(Goods, {
  foreignKey: 'goods_id',
  as: 'goods_info',
})
// 4. 导出Cart模型
module.exports = Cart