CREATE TABLE tblpayment_disputes (
id INT AUTO_INCREMENT PRIMARY KEY,
tenant_id BIGINT UNSIGNED,
payment_records_id BIGINT UNSIGNED,
dispute_ref_id VARCHAR(255),
transactionid VARCHAR(255),
amount DECIMAL(10,2),
dispute_desc TEXT,
status VARCHAR(50),
due_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
FOREIGN KEY (tenant_id) REFERENCES tbltenants(id) ON DELETE CASCADE ON UPDATE CASCADE,
FOREIGN KEY (payment_records_id) REFERENCES tblinvoicepaymentrecords(id)
);

