-- Find the exact constraint and index names
-- Run these queries and share the output

-- Query 1: Find all foreign key constraints on bids table
SELECT 
    CONSTRAINT_NAME,
    COLUMN_NAME,
    REFERENCED_TABLE_NAME,
    REFERENCED_COLUMN_NAME
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'bids'
  AND REFERENCED_TABLE_NAME IS NOT NULL
ORDER BY CONSTRAINT_NAME, ORDINAL_POSITION;

-- Query 2: Find all indexes on inquiryId and supplierId
SHOW INDEX FROM `bids` WHERE Column_name IN ('inquiryId', 'supplierId');

-- Query 3: Show table structure (to see constraints)
SHOW CREATE TABLE `bids`;

-- After running these, share the output and I'll give you the exact commands!

