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

const LoyaltyStamp = sequelize.define(
  "manage_loyalty_stamps",
  {
    id: {
      type: Sequelize.BIGINT,
      primaryKey: true,
      autoIncrement: true,
      allowNull: false,
    },
    stamp_color: {
      type: Sequelize.STRING,
    },
    stamp_no: {
      type: Sequelize.INTEGER,
      defaultValue: 0,
    },
    cafe_id: {
      type: Sequelize.BIGINT,
    },
    is_universal: {
      type: Sequelize.TINYINT,
      defaultValue: 0,
      comment: "1 = universal , 0 = non-universal",
    },
    discount_type: {
      type: Sequelize.TINYINT,
      defaultValue: 0,
      comment: "0 = £, 1 = %",
    },
    discount: {
      type: Sequelize.INTEGER,
      defaultValue: 0,
    },
    min_order_value: {
      type: Sequelize.INTEGER,
      defaultValue: 0,
    },
    offer_text: {
      type: Sequelize.STRING,
    },
    stamp_expires_in: {
      type: Sequelize.INTEGER,
      defaultValue: 0,
    },
    stamp_applicable_to_categories: {
      type: Sequelize.STRING,
      allowNull: true,
    },
    created_at: {
      type: Sequelize.INTEGER,
      defaultValue: 0,
    },
    updated_at: {
      type: Sequelize.INTEGER,
      defaultValue: 0,
    },
  },
  {
    tableName: "manage_loyalty_stamps",
    timestamps: false,
  }
);
export default LoyaltyStamp;