Checking vendors_main table structure...

✅ vendors_main table exists

Current columns:
- vendor_id (int)
- vendor_code (varchar(20))
- company_name (varchar(255))
- contact_person (varchar(255))
- email (varchar(255))
- phone (varchar(20))
- mobile (varchar(20))
- website (varchar(255))
- address (text)
- city (varchar(100))
- state (varchar(100))
- country (varchar(100))
- postal_code (varchar(20))
- category_id (int)
- tax_number (varchar(50))
- registration_number (varchar(50))
- bank_name (varchar(255))
- bank_account (varchar(50))
- payment_terms (varchar(100))
- credit_limit (decimal(15,2))
- rating (enum('excellent','good','average','poor'))
- status (enum('active','inactive','suspended','blacklisted'))
- notes (text)
- created_by (int)
- created_at (timestamp)
- updated_at (timestamp)
- vendor_name (varchar(100))
- vendor_category (varchar(50))
- is_preferred (tinyint(1))