CREATE TABLE `finance_donors` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `donor_name` varchar(255) NOT NULL,
  `contact` varchar(255) DEFAULT NULL,
  `amount` decimal(12,2) NOT NULL,
  `donation_date` date NOT NULL,
  `notes` text DEFAULT NULL,
  `requisition_id` varchar(64) DEFAULT NULL,
  `file_url` varchar(255) DEFAULT NULL,
  `scanned_form_link` varchar(255) DEFAULT NULL,
  `submitted_by` varchar(255) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL ON UPDATE current_timestamp(),
  `chapter_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
