import Sequelize from "sequelize";
import sequelize from "../config/database.config.js";

const UserStampsAwarded = sequelize.define(
  "user_stamps_awardeds",
  {
    id: {
      type: Sequelize.BIGINT,
      primaryKey: true,
      autoIncrement: true,
      allowNull: false,
    },
    user_id: {
      type: Sequelize.BIGINT,
      allowNull: false,
    },
    cafe_id: {
      type: Sequelize.BIGINT,
      allowNull: false,
    },
    stamp_id: {
      type: Sequelize.BIGINT,
      allowNull: false,
    },
    quantity: {
      type: Sequelize.INTEGER,
      defaultValue: 0,
    },
    order_number: {
      type: Sequelize.STRING,
      allowNull: true,
    },
    created_at: {
      type: Sequelize.DATE,
      defaultValue: Sequelize.NOW,
    },
    updated_at: {
      type: Sequelize.DATE,
      defaultValue: Sequelize.NOW,
    },
  },
  {
    tableName: "user_stamps_awardeds",
    timestamps: true,
    underscored: true,
  }
);

UserStampsAwarded.sync();

export default UserStampsAwarded;