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] => 6
    [merchant_id] => 19
    [category_id] => 8
    [voucher_template_id] => 35
    [voucher_count] => 125
    [expiry_date] => 2025-11-30
    [redeem_type] => online
    [voucher_type] => flat
    [flat_discount_amount] => 250.00
    [minimum_purchase_amount] => 2500.00
    [percent_value] => 
    [minimum_redeemable_amount] => 
    [maximum_discount_amount] => 
    [buy_quantity] => 
    [get_quantity] => 
    [status] => draft
    [current_step] => 1
    [created_at] => 2025-11-09 07:01:11
    [updated_at] => 2025-11-09 07:01:11
    [voucher_title] => 
    [image_url] => 
    [short_description] => 
    [redeemed_count] => 0
    [claimed_count] => 0
    [bux_value] => 0.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] => 
)