--- retail_orders ---
Array
(
    [0] => Array
        (
            [Field] => id
            [Type] => int
            [Null] => NO
            [Key] => PRI
            [Default] => 
            [Extra] => auto_increment
        )

    [1] => Array
        (
            [Field] => user_id
            [Type] => int
            [Null] => NO
            [Key] => MUL
            [Default] => 
            [Extra] => 
        )

    [2] => Array
        (
            [Field] => branch_id
            [Type] => int
            [Null] => YES
            [Key] => MUL
            [Default] => 
            [Extra] => 
        )

    [3] => Array
        (
            [Field] => admin_id
            [Type] => int
            [Null] => YES
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [4] => Array
        (
            [Field] => total_cash
            [Type] => decimal(10,2)
            [Null] => NO
            [Key] => 
            [Default] => 0.00
            [Extra] => 
        )

    [5] => Array
        (
            [Field] => total_points
            [Type] => int
            [Null] => NO
            [Key] => 
            [Default] => 0
            [Extra] => 
        )

    [6] => Array
        (
            [Field] => total_wallet
            [Type] => decimal(10,2)
            [Null] => NO
            [Key] => 
            [Default] => 0.00
            [Extra] => 
        )

    [7] => Array
        (
            [Field] => payment_method
            [Type] => varchar(50)
            [Null] => NO
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [8] => Array
        (
            [Field] => pickup_status
            [Type] => enum('PENDING','COMPLETED','CANCELLED')
            [Null] => YES
            [Key] => 
            [Default] => PENDING
            [Extra] => 
        )

    [9] => Array
        (
            [Field] => created_at
            [Type] => timestamp
            [Null] => YES
            [Key] => 
            [Default] => CURRENT_TIMESTAMP
            [Extra] => DEFAULT_GENERATED
        )

)
--- echop_redemptions ---
Array
(
    [0] => Array
        (
            [Field] => id
            [Type] => int
            [Null] => NO
            [Key] => PRI
            [Default] => 
            [Extra] => auto_increment
        )

    [1] => Array
        (
            [Field] => user_id
            [Type] => int
            [Null] => NO
            [Key] => MUL
            [Default] => 
            [Extra] => 
        )

    [2] => Array
        (
            [Field] => prize_id
            [Type] => int
            [Null] => NO
            [Key] => MUL
            [Default] => 
            [Extra] => 
        )

    [3] => Array
        (
            [Field] => staff_id
            [Type] => int
            [Null] => NO
            [Key] => MUL
            [Default] => 
            [Extra] => 
        )

    [4] => Array
        (
            [Field] => chops_deducted
            [Type] => int
            [Null] => NO
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [5] => Array
        (
            [Field] => remark
            [Type] => text
            [Null] => YES
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [6] => Array
        (
            [Field] => status
            [Type] => enum('PENDING','COMPLETED','CANCELLED')
            [Null] => NO
            [Key] => 
            [Default] => COMPLETED
            [Extra] => 
        )

    [7] => Array
        (
            [Field] => created_at
            [Type] => datetime
            [Null] => NO
            [Key] => 
            [Default] => CURRENT_TIMESTAMP
            [Extra] => DEFAULT_GENERATED
        )

)
--- appointments ---
Array
(
    [0] => Array
        (
            [Field] => id
            [Type] => int
            [Null] => NO
            [Key] => PRI
            [Default] => 
            [Extra] => auto_increment
        )

    [1] => Array
        (
            [Field] => user_id
            [Type] => int
            [Null] => NO
            [Key] => MUL
            [Default] => 
            [Extra] => 
        )

    [2] => Array
        (
            [Field] => staff_id
            [Type] => int
            [Null] => YES
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [3] => Array
        (
            [Field] => branch_id
            [Type] => int
            [Null] => YES
            [Key] => MUL
            [Default] => 
            [Extra] => 
        )

    [4] => Array
        (
            [Field] => appointment_date
            [Type] => date
            [Null] => YES
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [5] => Array
        (
            [Field] => appointment_time
            [Type] => time
            [Null] => YES
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [6] => Array
        (
            [Field] => note
            [Type] => text
            [Null] => YES
            [Key] => 
            [Default] => 
            [Extra] => 
        )

    [7] => Array
        (
            [Field] => status
            [Type] => enum('PENDING','CONFIRMED','CANCELLED','ATTENDED','ABSENT')
            [Null] => NO
            [Key] => 
            [Default] => PENDING
            [Extra] => 
        )

    [8] => Array
        (
            [Field] => created_at
            [Type] => timestamp
            [Null] => NO
            [Key] => 
            [Default] => CURRENT_TIMESTAMP
            [Extra] => DEFAULT_GENERATED
        )

    [9] => Array
        (
            [Field] => updated_at
            [Type] => timestamp
            [Null] => NO
            [Key] => 
            [Default] => CURRENT_TIMESTAMP
            [Extra] => DEFAULT_GENERATED on update CURRENT_TIMESTAMP
        )

)