Columns for table 'city_merchant_promotions':
Array
(
    [0] => Array
        (
            [column_name] => id
            [data_type] => uuid
        )

    [1] => Array
        (
            [column_name] => merchant_id
            [data_type] => bigint
        )

    [2] => Array
        (
            [column_name] => sort_order
            [data_type] => integer
        )

    [3] => Array
        (
            [column_name] => created_at
            [data_type] => timestamp without time zone
        )

    [4] => Array
        (
            [column_name] => updated_at
            [data_type] => timestamp without time zone
        )

    [5] => Array
        (
            [column_name] => category_id
            [data_type] => bigint
        )

    [6] => Array
        (
            [column_name] => city
            [data_type] => character varying
        )

    [7] => Array
        (
            [column_name] => banner_title
            [data_type] => character varying
        )

    [8] => Array
        (
            [column_name] => image_url
            [data_type] => text
        )

    [9] => Array
        (
            [column_name] => link_url
            [data_type] => text
        )

)

Sample vouchers to check for promotion fields:
Array
(
    [id] => 185
    [merchant_id] => 72
    [category_id] => 19
    [voucher_template_id] => 
    [voucher_count] => 1
    [expiry_date] => 2026-03-31
    [redeem_type] => both
    [voucher_type] => flat
    [flat_discount_amount] => 1000.00
    [minimum_purchase_amount] => 25000.00
    [percent_value] => 
    [minimum_redeemable_amount] => 
    [maximum_discount_amount] => 
    [buy_quantity] => 
    [get_quantity] => 
    [status] => published
    [current_step] => 4
    [created_at] => 2026-03-16 19:17:52
    [updated_at] => 2026-03-16 19:19:28
    [voucher_title] => Get 1000 off on purchase above 25000
    [image_url] => https://buybux-bucket.s3.us-east-1.amazonaws.com/1773688671379-2025-06-10.webp
    [short_description] => 
    [redeemed_count] => 0
    [claimed_count] => 0
    [bux_value] => 200.00
    [clicks] => 0
    [buy_count] => 0
    [rating] => 0.00
    [number_of_reviews] => 0
    [bux_required] => 0
    [bux_required_max] => 0
    [terms] => 
    [how_to_use] => 
    [share_count] => 0
    [is_trending] => 
    [start_date] => 2026-03-17
)