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,
        },
        created_at: {
            type: Sequelize.INTEGER,
            defaultValue: 0,
        },
        updated_at: {
            type: Sequelize.INTEGER,
            defaultValue : 0,
        },
    },
    {
        tableName: 'manage_loyalty_stamps',
        timestamps: false,
    }
);
export default LoyaltyStamp;