Attempting query: INSERT INTO vouchers (merchant_id,category_id,voucher_title,short_description,voucher_type,redeem_type,status,expiry_date,voucher_count,bux_value) VALUES ('13','6','Test Voucher','Test description','coupon','both','published','2026-04-08','100','500')
php : PHP Warning:  
pg_query(): Query failed: 
ERROR:  new row for relation 
"vouchers" violates check 
constraint 
"vouchers_voucher_type_check"
At line:1 char:1
+ php c:\xampp3\htdocs\bb_api
\test_insert.php > 
c:\xampp3\htdocs\bb_api ...
+ ~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
~~~~~~~~~~~~~
    + CategoryInfo           
   : NotSpecified: (PHP War  
  ning:  p...her_type_chec   
 k":String) [], RemoteExc    
eption
    + FullyQualifiedErrorId  
   : NativeCommandError
 
DETAIL:  Failing row 
contains (75, 13, 6, null, 
100, 2026-04-08, both, 
coupon, null, null, null, 
null, null, null, null, 
published, 1, null, null, 
Test Voucher, null, Test 
description, 0, 0, 500.00, 
0, 0, 0.00, 0, 0, 0, null, 
null, 0, f, null). in C:\xamp
p3\htdocs\bb_api\test_insert.
php on line 33

Warning: pg_query(): Query failed: ERROR:  new row for relation "vouchers" violates check constraint "vouchers_voucher_type_check"
DETAIL:  Failing row contains (75, 13, 6, null, 100, 2026-04-08, both, coupon, null, null, null, null, null, null, null, published, 1, null, null, Test Voucher, null, Test description, 0, 0, 500.00, 0, 0, 0.00, 0, 0, 0, null, null, 0, f, null). in C:\xampp3\htdocs\bb_api\test_insert.php on line 33
ERROR: ERROR:  new row for relation "vouchers" violates check constraint "vouchers_voucher_type_check"
DETAIL:  Failing row contains (75, 13, 6, null, 100, 2026-04-08, both, coupon, null, null, null, null, null, null, null, published, 1, null, null, Test Voucher, null, Test description, 0, 0, 500.00, 0, 0, 0.00, 0, 0, 0, null, null, 0, f, null).