=== CHECKING PURCHASES TABLE SCHEMA ===

Columns in 'purchases' table:
------------------------
id - bigint(20) unsigned - NO - PRI - 
ingredient_id - bigint(20) unsigned - YES - MUL - 
quantity - decimal(15,2) - NO -  - 
price - decimal(15,2) - NO -  - 
unit_id - bigint(20) unsigned - YES - MUL - 
item_name - varchar(255) - YES -  - 
branch_id - bigint(20) unsigned - YES - MUL - 
company_id - bigint(20) unsigned - YES - MUL - 
item_type - enum('ingredient','non_ingredient') - NO -  - ingredient
total_price - decimal(15,2) - NO -  - 
created_at - timestamp - YES -  - 
updated_at - timestamp - YES -  - 
vendor_id - bigint(20) unsigned - YES - MUL - 
warehouse_id - bigint(20) unsigned - YES - MUL - 
expiry_date - date - YES -  - 
status - enum('dipesan','diterima','tertunda') - NO -  - dipesan
payment_status - varchar(255) - NO -  - belum_bayar
payment_date - date - YES -  - 
payment_notes - text - YES -  - 
purchase_date - date - YES -  - 

Data for purchase #443:
------------------------
id: 443
ingredient_id: 98
quantity: 150.00
price: 224700.00
unit_id: 6
item_name: Biskuit lotus
branch_id: 2
company_id: 2
item_type: ingredient
total_price: 224700.00
created_at: 2025-05-01 19:04:10
updated_at: 2025-05-01 20:34:01
vendor_id: 6
warehouse_id: 3
expiry_date: 
status: tertunda
payment_status: belum_bayar
payment_date: 
payment_notes: 
purchase_date: 2025-05-01

Checking related tables with 'purchase' in the name:
------------------------
purchase_details
purchases

=== CHECKING PURCHASES TABLE SCHEMA COMPLETE ===