Let's Fight
USD
Total Donors
14
Last 1 minute
Total Raised
$ 4,820
12% increased
Make a Donation
Why Donate?
SQL Schema & Transaction History
Table: donations
-- Complete donation table with balance tracking
CREATE TABLE donations (
id INT AUTO_INCREMENT PRIMARY KEY,
donor_name VARCHAR(100) NOT NULL,
amount DECIMAL(12,2) NOT NULL,
currency CHAR(3) DEFAULT 'USD',
reason VARCHAR(50),
transaction_id VARCHAR(50) UNIQUE,
status VARCHAR(20) DEFAULT 'completed',
donated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
id INT AUTO_INCREMENT PRIMARY KEY,
donor_name VARCHAR(100) NOT NULL,
amount DECIMAL(12,2) NOT NULL,
currency CHAR(3) DEFAULT 'USD',
reason VARCHAR(50),
transaction_id VARCHAR(50) UNIQUE,
status VARCHAR(20) DEFAULT 'completed',
donated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
Balance & Stats Queries
-- Total balance (all currencies)
SELECT SUM(amount) AS total_balance
FROM donations
WHERE status = 'completed';
-- Balance by currency SELECT currency, SUM(amount) AS total
FROM donations
GROUP BY currency;
-- Total unique donors SELECT COUNT(DISTINCT donor_name) AS donors
FROM donations;
FROM donations
WHERE status = 'completed';
-- Balance by currency SELECT currency, SUM(amount) AS total
FROM donations
GROUP BY currency;
-- Total unique donors SELECT COUNT(DISTINCT donor_name) AS donors
FROM donations;
Recent Transactions (stored in SQL table above)
| Transaction ID | Donor | Amount | Currency | Reason | Status | Date |
|---|
Recent donors:
Sabbir $ 300
Nazma $ 150
Rana $ 500
No registration / login required · Everyone can view & donate