Query
CREATE TABLE payment_gateway_transactions (
id INTEGER PRIMARY KEY AUTOINCREMENT,
invoice_id INTEGER NOT NULL,
gateway TEXT NOT NULL,
order_id TEXT NOT NULL,
payment_url TEXT,
token TEXT,
amount DECIMAL(10,2) NOT NULL,
status TEXT DEFAULT 'pending',
payment_type TEXT,
fraud_status TEXT,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,
payment_method VARCHAR(50),
gateway_name VARCHAR(50),
FOREIGN KEY (invoice_id) REFERENCES invoices (id)
)