import Sequelize from "sequelize";
import sequelize from "../config/database.config.js";
import sequelizePaginate from "sequelize-paginate";

const cafe_menu_items = sequelize.define(
    "cafe_menu_items",
    {
        id: {
            type: Sequelize.BIGINT,
            primaryKey: true,
            autoIncrement: true,
            allowNull: false,
        },
        cafe_id: {
            type: Sequelize.BIGINT(20),
        },
        cafe_menu_id: {
            type: Sequelize.BIGINT(20),
            comment: 'primary key of cafe menu id'
        },
        item_name: {
            type: Sequelize.STRING,
            defaultValue: '',
        },
        item_description: {
            type: Sequelize.TEXT
        },
        item_image_id: {
            type: Sequelize.BIGINT,
        },
        item_type: {
            type: Sequelize.TINYINT(1),
            comment: '1-veg,2-Non-veg,3-Vegan',
        },
        item_price: {
            type: Sequelize.FLOAT(6, 2),
            defaultValue: 0
        },
        status: {
            type: Sequelize.TINYINT(4),
            defaultValue: 0,
            comment: "1 = available, 0 = unavailable"
        },
        item_deleted_at: {
            type: Sequelize.INTEGER(10),
            defaultValue: 0,
            comment: "0-not deleted"
        },
        created_at: {
            type: Sequelize.INTEGER(10),
            defaultValue: 0
        },
        updated_at: {
            type: Sequelize.INTEGER(10),
            defaultValue: 0
        },
    },
    {
        tableName: 'cafe_menu_items',
        timestamps: false,
    }
);
sequelizePaginate.paginate(cafe_menu_items);
export default cafe_menu_items;