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

const GroupCoffeeRun = sequelize.define(
    "group_coffee_run",
    {
        id: {
            type: Sequelize.BIGINT,
            primaryKey: true,
            autoIncrement: true,
            allowNull: false,
        },
        request_unique_id: {
            type: Sequelize.STRING(20),
            allowNull: false
        },
        cafe_id: {
            type: Sequelize.BIGINT.UNSIGNED,
            allowNull: true
        },
        group_id: {
            type: Sequelize.BIGINT.UNSIGNED,
            allowNull: false
        },
        request_created_by: {
            type: Sequelize.BIGINT.UNSIGNED,
            allowNull: false
        },
        user_id: {
            type: Sequelize.BIGINT.UNSIGNED,
            allowNull: false,
            comment: 'request joiner'
        },
        is_contributor_person: {
            type: Sequelize.TINYINT(4),
            defaultValue: 0,
            comment: '0-not,1-contributor'
        },
        is_order_place: {
            type: Sequelize.TINYINT(4),
            defaultValue: 0,
            comment: '0-not,1-yes'
        },
        order_id: {
            type: Sequelize.BIGINT.UNSIGNED,
            allowNull: true
        },
        request_endtime: {
            type: Sequelize.INTEGER(10),
        },
        created_at: {
            type: Sequelize.INTEGER,
            allowNull: true
        },
        updated_at: {
            type: Sequelize.INTEGER,
            allowNull: true
        },
        type: {
            type: Sequelize.TINYINT(4),
            defaultValue: 1,
            comment: '0-inHouse,1-Cafe'
        },
        in_house_order_id: {
            type: Sequelize.BIGINT.UNSIGNED,
            allowNull: true
        },
    },
    {
        tableName: 'group_coffee_runs',
        timestamps: false,
    }
);
sequelizePaginate.paginate(GroupCoffeeRun);
GroupCoffeeRun.sync()
export default GroupCoffeeRun;