-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `u435998440_chrisworld_new`
--

-- --------------------------------------------------------

--
-- Table structure for table `appointments`
--

CREATE TABLE `appointments` (
  `appointment_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `staff_id` int(11) NOT NULL,
  `branch_id` int(11) NOT NULL,
  `date_time` datetime NOT NULL,
  `status` enum('scheduled','completed','cancelled') DEFAULT 'scheduled',
  `reason` text DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `branches`
--

CREATE TABLE `branches` (
  `branch_id` int(11) NOT NULL,
  `branch_name` varchar(100) NOT NULL,
  `email` varchar(255) DEFAULT NULL,
  `location` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `branches`
--

INSERT INTO `branches` (`branch_id`, `branch_name`, `email`, `location`, `address`, `phone`, `created_at`) VALUES
(1, 'Ikeja Branch', NULL, 'Lagos state', 'No 54 The Omotola Plaza Afolabi Aina Street Off Allen Junction By Alade New Market Ikeja', '09076426318', '2024-12-03 18:15:46'),
(2, 'Enugu Branch', NULL, 'Enugu State', 'No 44 Okpara Avenue, Eastern Gateway Plaza, Old Park, Enugu State', '08050667532', '2024-12-03 18:15:46'),
(3, 'Aba Branch', NULL, 'Eclinic', '7 Factory Road', '09025294085', '2024-12-05 06:26:25'),
(9, 'Abuja Branch', NULL, 'FCT Abuja', 'D1-45 Dawaki Modern Market Off Galadima, Kubwa Express Way.', '09113125978', '2025-02-17 07:12:04'),
(11, 'Online Media ', NULL, 'Lagos', 'The Omotola Plaza', '09011374243', '2025-02-27 09:58:39');

-- --------------------------------------------------------

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `category_id` int(11) NOT NULL,
  `category_name` varchar(255) NOT NULL,
  `category_description` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`category_id`, `category_name`, `category_description`) VALUES
(1, 'Operational Expenses', 'Office Rent and Utilities, Office Supplies, Software and Technology, Insurance'),
(2, 'Staffing and Payroll', 'Salaries and Wages, Benefits, Training and Development'),
(3, 'Marketing and Advertising', 'Digital Marketing, Print and Media Advertising, Events and Sponsorships'),
(4, 'Legal and Professional Fees', 'Legal Counsel, Accounting and Bookkeeping, Consulting Fees'),
(5, 'Surrogate and Intended Parent Support', 'Surrogate Compensation, Medical Expenses, Psychological Support, Travel and Accommodation'),
(6, 'Medical and Clinic Partnerships', 'Fertility Clinic Fees, Medical Screening Costs'),
(7, 'Administrative and Miscellaneous Expenses', 'Background Checks, Postage and Shipping, Bank Fees'),
(8, 'Compliance and Regulatory Costs', 'Licensing Fees, Compliance Audits'),
(9, 'Miscellaneous Expenses', 'Contingency Funds, Charitable Contributions');

--
-- Triggers `clients`
--
DELIMITER $$
END
$$
DELIMITER ;

-- --------------------------------------------------------

--
-- Table structure for table `consultations`
--

CREATE TABLE `consultations` (
  `consultation_id` int(11) NOT NULL,
  `inquiry_id` int(11) NOT NULL,
  `scheduled_date` datetime NOT NULL,
  `status` enum('scheduled','completed','cancelled') DEFAULT 'scheduled',
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `donations`
--

CREATE TABLE `donations` (
  `donation_id` int(11) NOT NULL,
  `donor_id` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `status` enum('pending','completed','failed') NOT NULL DEFAULT 'pending',
  `donation_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `expenses`
--

CREATE TABLE `expenses` (
  `expense_id` int(11) NOT NULL,
  `branch_id` int(11) NOT NULL,
  `category` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `expense_date` datetime NOT NULL,
  `category_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `expenses`
--

INSERT INTO `expenses` (`expense_id`, `branch_id`, `category`, `description`, `amount`, `expense_date`, `category_id`) VALUES
(10, 2, '', 'We sent transport fare to Mr Williams surrogate to go to the hospital for her appointment', 2500.00, '2024-10-11 00:00:00', 5),
(11, 2, '', 'We sent transport fare to Mr Williams surrogate to go to the hospital for her appointment', 2500.00, '2024-11-22 00:00:00', 5),
(12, 2, '', 'We sent transport fare to Mr Williams surrogate to go to the hospital for her appointment', 2500.00, '2024-11-24 00:00:00', 5),
(13, 2, '', 'We sent transport fare to Mr Williams surrogate to go to the hospital for her appointment', 2500.00, '2025-01-30 00:00:00', 5),
(14, 2, '', 'We sent transport fare to Mr Williams surrogate to go to the hospital for her appointment', 2500.00, '2025-02-20 00:00:00', 5),
(15, 2, '', 'We sent transport fare to Mr Williams surrogate to go to the hospital for her appointment', 2500.00, '2025-02-22 00:00:00', 5),
(16, 2, '', 'We sent transport fare to Mr Williams surrogate to go to the hospital for her appointment', 2500.00, '2025-02-28 00:00:00', 5),
(17, 2, '', 'Paid the branch manager her January salary 2025', 80000.00, '2025-02-28 00:00:00', 2),
(18, 1, '', 'Soap cleaner and petrol', 13000.00, '2025-02-28 00:00:00', 9),
(19, 1, '', 'February salary', 80000.00, '2025-02-28 00:00:00', 2),
(20, 1, '', '3 months feeding allowance for Austin Patience', 90000.00, '2025-01-31 00:00:00', 6),
(21, 2, '', 'we paid February salary to Enugu branch manager', 80000.00, '2025-03-03 00:00:00', 2),
(22, 2, 'Medical and Clinic Partnerships', 'We paid Grabbo clinic Abuja for the post-luteal drug we bought from them for Enugu branch surroages. One package of the drug is sold for 125,900, we bough two packs', 251800.00, '2024-12-17 00:00:00', NULL),
(23, 2, 'Medical and Clinic Partnerships', 'We paid Grabbo clinic Abuja for the second post-luteal drug we bought from them for Enugu branch surrogates. One package of the drug is sold for 125,900, we bought also two packs', 251800.00, '2025-01-01 00:00:00', NULL),
(24, 2, 'Medical and Clinic Partnerships', 'We paid Grabbo clinic Abuja for the third post-luteal drug we bought from them for Enugu branch surrogates. There was a slight increment in the price of the drugs here, one package of the drug is now sold for 137,800, we bought two packages.', 275800.00, '2025-01-14 00:00:00', NULL),
(25, 2, 'Medical and Clinic Partnerships', 'We paid Grabbo clinic Abuja for the fourth post-luteal drug we bought from them for Enugu branch surrogates. One package of the drug is sold for 137,900, we bought two packages.', 275800.00, '2025-01-27 00:00:00', NULL),
(26, 2, 'Medical and Clinic Partnerships', 'We paid Grabbo clinic Abuja for the fifth post-luteal drug we bought from them for Enugu branch surrogates. One package of the drug is sold for 137,900, we bought two packages', 275800.00, '2025-02-10 00:00:00', NULL),
(27, 2, 'Miscellaneous Expenses', 'We paid the nurse that gives the post-luteal injection for both Mr/Mrs Nkama and Mr/Mrs Elom Mercy surrogate here in Enugu.', 15000.00, '2024-12-28 00:00:00', NULL),
(28, 2, 'Miscellaneous Expenses', 'We paid the nurse that gives the post-luteal injection for both Mr/Mrs Nkama and Mr/Mrs Elom mercy surrogate here in Enugu for the second time. ', 15000.00, '2025-01-17 00:00:00', NULL),
(29, 2, 'Miscellaneous Expenses', 'We paid the nurse that gives the post-luteal injection for both Mr/Mrs Nkama and Mr/Mrs Elom mercy surrogate here in Enugu for the third time. ', 15000.00, '2025-01-30 00:00:00', NULL),
(30, 2, 'Miscellaneous Expenses', 'We paid the nurse that gives the post-luteal injection for both Mr/Mrs Nkama and Mr/Mrs Elom mercy surrogate here in Enugu for the fourth time. ', 15000.00, '2025-02-14 00:00:00', NULL),
(31, 2, 'Miscellaneous Expenses', 'We paid the nurse that gives the post-luteal injection for both Mr/Mrs Nkama and Mr/Mrs Elom mercy surrogate here in Enugu for the fifth time. ', 15000.00, '2025-02-27 00:00:00', NULL),
(32, 2, 'Miscellaneous Expenses', 'We paid the lady (housekeeper) that assist both Mr/Mrs Nkama and Mr/Mrs Elom surrogate mothers in house chores and other things. This is the first payment for two weeks duration. ', 20000.00, '2024-12-28 00:00:00', NULL),
(33, 2, 'Miscellaneous Expenses', 'We paid the lady (housekeeper) that assist both Mr/Mrs Nkama and Mr/Mrs Elom surrogate mothers in house chores and other things. This is the 2nd payment for two weeks duration. There was a slight reduction in price here', 15000.00, '2025-01-17 00:00:00', NULL),
(34, 2, 'Miscellaneous Expenses', 'We paid the lady (housekeeper) that assist both Mr/Mrs Nkama and Mr/Mrs Elom surrogate mothers in house chores and other things. This is the 3rd payment for two weeks duration. ', 15000.00, '2025-01-30 00:00:00', NULL),
(35, 2, 'Miscellaneous Expenses', 'We paid the lady (housekeeper) that assist both Mr/Mrs Nkama and Mr/Mrs Elom surrogate mothers in house chores and other things. This is the 4th payment for two weeks duration. ', 15000.00, '2025-02-14 00:00:00', NULL),
(36, 2, 'Miscellaneous Expenses', 'We paid the lady (housekeeper) that assist both Mr/Mrs Nkama and Mr/Mrs Elom surrogate mothers in house chores and other things. This is the 5th payment for two weeks duration. ', 15000.00, '2025-02-27 00:00:00', NULL),
(37, 2, 'Operational Expenses', 'we weigbill company\'s polo and face cap to Abuja for the Branch manager.', 7000.00, '2025-03-05 00:00:00', NULL),
(38, 2, 'Medical and Clinic Partnerships', 'We paid St Elizabeth hospital when Mr/Mrs Nkama surrogate was admitted at the hospital. ', 39500.00, '2025-01-23 00:00:00', NULL),
(39, 2, 'Medical and Clinic Partnerships', 'We paid St. Elizabeth hospital when Mr/Mrs Elom Mercy\'s surrogate was admitted.', 40500.00, '2025-01-29 00:00:00', NULL),
(40, 2, 'Medical and Clinic Partnerships', 'We paid St. Elizabeth Hospital for the first scan done for both Mr/Mrs NKAMA and Mr/Mrs ELOM surrogate mothers to confirm heartbeat. ', 20000.00, '2025-01-14 00:00:00', NULL),
(41, 2, 'Surrogate and Intended Parent Support', 'We sent Feeding fee to Mr/Mrs Elom Mercy\'s surrogate, when she admitted at the hospital', 5000.00, '2025-01-28 00:00:00', NULL),
(42, 2, 'Medical and Clinic Partnerships', 'We paid St. Elizabeth hospital for the second scan the two surrogate went for. For both Mr/Mrs NKAMA and Mr/Mrs ELOM ', 10000.00, '2025-02-04 00:00:00', NULL),
(43, 3, '', 'hospital requirements and expenses ', 90000.00, '2025-03-01 00:00:00', 6),
(44, 2, 'Surrogate and Intended Parent Support', 'Payment for Embryo transfer for Mr/Mrs Nkama Surrogate', 60000.00, '2024-12-18 00:00:00', NULL),
(45, 2, 'Surrogate and Intended Parent Support', 'Payment for Embryo transfer for Mr/Mrs Elom mercy Surrogate', 60000.00, '2024-12-18 00:00:00', NULL),
(46, 2, 'Surrogate and Intended Parent Support', 'Payment for Confirmation fee for Mr/Mrs Nkama Surrogate', 60000.00, '2025-01-01 00:00:00', NULL),
(47, 2, 'Surrogate and Intended Parent Support', 'Payment for Confirmation fee for Mr/Mrs Elom Mercy Surrogate', 60000.00, '2025-01-01 00:00:00', NULL),
(48, 2, 'Surrogate and Intended Parent Support', 'Payment for January monthly allowance for Mr/Mrs Nkama Surrogate', 80000.00, '2025-01-14 00:00:00', NULL),
(49, 3, '', 'tfare', 12000.00, '2025-03-05 00:00:00', 8),
(50, 2, 'Surrogate and Intended Parent Support', 'Payment for February monthly allowance for Mr/Mrs Nkama Surrogate', 80000.00, '2025-02-01 00:00:00', NULL),
(51, 2, 'Surrogate and Intended Parent Support', 'Payment for March monthly allowance for Mr/Mrs Nkama Surrogate', 80000.00, '2025-03-04 00:00:00', NULL),
(52, 2, 'Surrogate and Intended Parent Support', 'Payment for January monthly allowance for Mr/Mrs ELOM Mercy Surrogate', 80000.00, '2025-01-14 00:00:00', NULL),
(53, 2, 'Surrogate and Intended Parent Support', 'Payment for February monthly allowance for Mr/Mrs ELOM Mercy Surrogate', 80000.00, '2025-02-04 00:00:00', NULL),
(54, 2, 'Surrogate and Intended Parent Support', 'Payment for March monthly allowance for Mr/Mrs ELOM Mercy Surrogate', 80000.00, '2025-03-01 00:00:00', NULL),
(55, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Okafor Ebere surrogate for her appointment at the hospital. She came with her sister who was also an intending donor. The transport was for both of them', 15000.00, '2025-01-21 00:00:00', NULL),
(56, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Okafor Ebere surrogate for her appointment at the hospital.', 6000.00, '2025-02-06 00:00:00', NULL),
(57, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare (2000) for Mr/Mrs Okafor Ebere surrogate to get a drug prescribed by the doctor and also we paid for the drug which cost 20,000', 22000.00, '2025-02-11 00:00:00', NULL),
(58, 2, 'Surrogate and Intended Parent Support', 'We sent feeding fee for Mr/Mrs Okafor Ebere surrogate. ', 20000.00, '2025-02-17 00:00:00', NULL),
(59, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Okafor Ebere surrogate for her appointment at the hospital.', 8000.00, '2025-02-25 00:00:00', NULL),
(60, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Okafor Ebere surrogate for her appointment at the hospital.', 8000.00, '2025-02-25 00:00:00', NULL),
(61, 2, 'Medical and Clinic Partnerships', 'We paid St. Elizabeth hospital for Mr/Mrs Okafor Ebere intending donor for panel test.', 10000.00, '2025-01-21 00:00:00', NULL),
(62, 2, 'Miscellaneous Expenses', 'We paid a plumber that repaired the toilet and kitchen sink at the apartments where the surrogates are living.', 15500.00, '2025-01-14 00:00:00', NULL),
(63, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fares for Mr/Mrs Emmanuel (Mr. Williams) surrogate for her appointments at the hospital and this payment covers for the five times she attended before she declined. NB: This was the first surrogate (Miss Chisom) who stopped on the way.', 12500.00, '2024-12-19 00:00:00', NULL),
(64, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Nkama surrogate for her appointment at the hospital.', 3000.00, '2024-11-14 00:00:00', NULL),
(65, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Nkama surrogate for her appointment at the hospital.', 4000.00, '2024-11-27 00:00:00', NULL),
(66, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Nkama surrogate for her appointment at the hospital.', 4000.00, '2024-12-04 00:00:00', NULL),
(67, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Nkama surrogate for her appointment at the hospital.', 4000.00, '2024-12-07 00:00:00', NULL),
(68, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Nkama surrogate for her appointment at the hospital.', 4000.00, '2024-12-11 00:00:00', NULL),
(69, 2, 'Surrogate and Intended Parent Support', 'We sent 2000 to Mr/Mrs Nkama surrogate to buy syringes and pay a nurse to give her the injection the hospital gave to her', 2000.00, '2024-12-11 00:00:00', NULL),
(70, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Nkama surrogate for her to transport herself to the apartment for the embryo transfer', 3000.00, '2024-12-17 00:00:00', NULL),
(71, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Nkama surrogate for her appointment at the hospital for first scan', 2500.00, '2024-12-31 00:00:00', NULL),
(72, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Nkama surrogate for her appointment at the hospital.', 2500.00, '2025-01-13 00:00:00', NULL),
(73, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Nkama surrogate for her appointment at the hospital.', 2500.00, '2025-01-21 00:00:00', NULL),
(74, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Nkama surrogate for her appointment at the hospital.', 2500.00, '2025-02-04 00:00:00', NULL),
(75, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Nkama surrogate for her appointment at the hospital.', 2500.00, '2025-02-19 00:00:00', NULL),
(76, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Nkama surrogate for her appointment at the hospital.', 2500.00, '2025-03-05 00:00:00', NULL),
(77, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Elom Mercy surrogate for her appointment at the hospital.', 2500.00, '2024-11-06 00:00:00', NULL),
(78, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Elom Mercy surrogate for her appointment at the hospital.', 2500.00, '2024-11-14 00:00:00', NULL),
(79, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Elom Mercy surrogate for her appointment at the hospital.', 2500.00, '2024-11-27 00:00:00', NULL),
(80, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Elom Mercy surrogate for her appointment at the hospital.', 2500.00, '2024-12-04 00:00:00', NULL),
(81, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Elom Mercy surrogate for her appointment at the hospital.', 2500.00, '2024-12-11 00:00:00', NULL),
(82, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Elom Mercy surrogate to transport herself to the apartment for embryo transfer ', 2500.00, '2024-12-16 00:00:00', NULL),
(83, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Elom Mercy surrogate for her appointment at the hospital.', 2500.00, '2024-12-31 00:00:00', NULL),
(84, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Elom Mercy surrogate for her appointment at the hospital.', 2500.00, '2025-01-13 00:00:00', NULL),
(85, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Elom Mercy surrogate for her appointment at the hospital.', 2500.00, '2025-01-19 00:00:00', NULL),
(86, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Elom Mercy surrogate for her appointment at the hospital.', 2500.00, '2024-11-01 00:00:00', NULL),
(87, 2, 'Surrogate and Intended Parent Support', 'We sent feeding fee for Mr/Mrs Elom Mercy surrogate when she was admitted in the hospital', 12000.00, '2025-02-20 00:00:00', NULL),
(88, 2, 'Surrogate and Intended Parent Support', 'We sent Transport fare for Mr/Mrs Elom Mercy surrogate for her appointment at the hospital, for three square meal', 12000.00, '2025-02-22 00:00:00', NULL),
(89, 2, 'Medical and Clinic Partnerships', 'We paid St. Elizabeth hospital for the pregnancy test done for Mr/Mrs Nkama and Mr/Mrs Elom surroagte. 3000 for each person.', 6000.00, '2024-12-31 00:00:00', NULL),
(90, 2, 'Operational Expenses', 'We paid for the apartment the surrogates are staying here in Enugu. ', 1200000.00, '2024-11-27 00:00:00', NULL),
(91, 2, 'Surrogate and Intended Parent Support', 'We subscribed electricity bill for the surrogate for the first time at the apartment', 10000.00, '2024-12-18 00:00:00', NULL),
(92, 2, 'Surrogate and Intended Parent Support', 'We subscribed electricity bill for the surrogate for the 2nd time at the apartment', 5000.00, '2024-02-04 00:00:00', NULL),
(93, 2, 'Surrogate and Intended Parent Support', 'We subscribed electricity bill for the surrogate for the 3rd time at the apartment', 6000.00, '2025-02-22 00:00:00', NULL),
(94, 2, 'Surrogate and Intended Parent Support', 'We filled the first gas for the surrogate staying at the apartment. ', 9450.00, '2024-12-14 00:00:00', NULL),
(95, 2, 'Surrogate and Intended Parent Support', 'We bought plastic table and chairs for the surrogate at the apartment', 36500.00, '2024-12-13 00:00:00', NULL),
(96, 2, 'Surrogate and Intended Parent Support', 'We bought hangers, mobbing bucket, mobbing stick, broom/parker, pegs and toilet bush for the surrogate at the apartment ', 17300.00, '2024-12-13 00:00:00', NULL),
(97, 2, 'Surrogate and Intended Parent Support', 'We bought gas cylinder(34,500), fridge(145,000) and the transport fare (2500) for that, for the surrogate at the apartment ', 182000.00, '2024-12-12 00:00:00', NULL),
(98, 2, 'Miscellaneous Expenses', 'We paid a guy to clean the apartment for the surrogates before they move in.', 15000.00, '2024-12-08 00:00:00', NULL),
(99, 1, 'Operational Expenses', 'Electricity bill', 30000.00, '2025-05-03 00:00:00', NULL),
(100, 1, 'Surrogate and Intended Parent Support', 'chikwes monthly allowance ', 580000.00, '2024-08-01 00:00:00', NULL),
(101, 1, 'Operational Expenses', 'office errand ', 5800.00, '2025-03-20 00:00:00', NULL),
(102, 1, 'Surrogate and Intended Parent Support', 'chikwe loan', 120000.00, '2025-01-25 00:00:00', NULL),
(103, 2, 'Medical and Clinic Partnerships', 'We paid St. Elizabeth hospital for balance for the IVF and Investigations done for both Nkama and Elom (Intending parents)', 1630500.00, '2024-11-13 00:00:00', NULL),
(104, 2, 'Medical and Clinic Partnerships', 'We paid St. Elizabeth hospital for Mr/Mrs Nkama surrogate antenatal fee (33500), for Mr/Mrs Elom Mercy surrogate antenatal fee (23500) and mr/mrs Elom mercy surrogate injection', 126000.00, '2025-02-24 00:00:00', NULL),
(105, 2, 'Medical and Clinic Partnerships', 'We paid St. Elizabeth hospital part payment for IVF for Mr/Mrs Okafor Ebere procedure', 500000.00, '2025-02-06 00:00:00', NULL),
(106, 1, 'Surrogate and Intended Parent Support', 'Tfare for Mrs Esther Surrogate ', 18000.00, '2025-02-20 00:00:00', NULL),
(107, 1, 'Surrogate and Intended Parent Support', 'CHIKWE TFARE ', 50000.00, '2024-08-20 00:00:00', NULL),
(108, 2, 'Surrogate and Intended Parent Support', 'We sent Mr/Mrs Nkama surrogate (Chinaza) transport fare for her 2weeks Antenatal visits', 2500.00, '2025-03-05 00:00:00', NULL),
(109, 2, 'Surrogate and Intended Parent Support', 'We sent Mr/Mrs Elom Mercy surrogate (Gift) transport fare for her 2weeks Antenatal visits', 2500.00, '2025-03-06 00:00:00', NULL),
(110, 2, 'Surrogate and Intended Parent Support', 'We bought a drug for Mr/Mrs Nkama surrogate, which the hospital doesn\'t have. ', 4000.00, '2025-03-05 00:00:00', NULL),
(111, 2, 'Surrogate and Intended Parent Support', 'We sent Mr/Mrs Okafor ebere surrogate (Natalia) transport fare for hospital appointment ', 8100.00, '2025-03-05 00:00:00', NULL),
(112, 2, 'Medical and Clinic Partnerships', 'We paid St. Elizabeth Hospital 9000 for Mr/Mrs Nkama\'s surroagte antenatal visit', 9000.00, '2025-03-06 00:00:00', NULL),
(113, 2, 'Operational Expenses', 'We subscribed Enugu Office electricity bill ', 10000.00, '2025-03-07 00:00:00', NULL),
(114, 2, 'Surrogate and Intended Parent Support', 'We sent 10k to Mr/Mrs Elom Mercy\'s surrogate for miscellaneous ', 10000.00, '2025-03-07 00:00:00', NULL),
(115, 1, 'Surrogate and Intended Parent Support', 'chikwe tfare to the hospital ', 12000.00, '2025-03-07 00:00:00', NULL),
(116, 1, 'Surrogate and Intended Parent Support', 'feeding in the hospital for chikwe for 3 days', 24000.00, '2025-03-07 00:00:00', NULL),
(117, 1, 'Operational Expenses', 'Generator Cover to prevent rain', 25000.00, '2025-03-10 00:00:00', NULL),
(118, 1, 'Surrogate and Intended Parent Support', 'chikwes feeding ', 8000.00, '2025-03-10 00:00:00', NULL),
(119, 2, 'Miscellaneous Expenses', 'The transport to get the stuffs weigh billed from Aba to Enugu to the apartment,, to take the Mr. Emmanuel surrogate to the apartment, to buy iceblock for the fridge and repair the fan at the apartment (5000).', 16300.00, '2025-03-08 00:00:00', NULL),
(120, 2, 'Surrogate and Intended Parent Support', 'We paid the carpenter initial deposit to construct a bed stand for both Mr. Nkama and Mr. Elom\'s surrogate mothers. each one is 25k', 30000.00, '2025-03-08 00:00:00', NULL),
(121, 2, 'Miscellaneous Expenses', 'Electrician\'s workmanship (1500), socket for the apartment (2000), Light subscription at the apartment(6000) and transport for the nurse that gave Mr/mrs Elom\'s surrogate injection(20000)', 29500.00, '2025-03-10 00:00:00', NULL),
(122, 2, 'Miscellaneous Expenses', 'we bought ice block for the fridge= 1500, transport to take it to the apartment = 600', 2100.00, '2025-03-11 00:00:00', NULL),
(123, 2, 'Surrogate and Intended Parent Support', 'Transport for an intending surrogate for her initial check up. for (Mrs Eke princess)', 2000.00, '2025-03-11 00:00:00', NULL),
(124, 2, 'Surrogate and Intended Parent Support', 'Filled gas for the surrogates at the apartment (9100), transport to take the intending surrogate to the hospital for check up (1500)', 10600.00, '2025-03-11 00:00:00', NULL),
(125, 2, 'Medical and Clinic Partnerships', 'Paid St. Elizabeth hospital for the folder, panel test and pregnancy test done for an intending surrogate mum', 15000.00, '2025-03-12 00:00:00', NULL),
(126, 2, 'Surrogate and Intended Parent Support', 'Transport for Mrs Ebere Okafor surrogate for her appointment at the hospital ', 8100.00, '2025-03-12 00:00:00', NULL),
(127, 11, 'Marketing and Advertising', 'Client Ad', 9000.00, '2025-03-04 00:00:00', NULL),
(128, 2, 'Medical and Clinic Partnerships', 'We paid st. Elizabeth hospital for medical stuffs', 1970000.00, '2025-03-07 00:00:00', NULL),
(129, 11, 'Marketing and Advertising', 'Surrogate ad', 5000.00, '2025-03-10 00:00:00', NULL),
(130, 2, 'Operational Expenses', 'We paid the housekeeper for her two weeks duration job for the surrogate at the apartment ', 15000.00, '2025-03-13 00:00:00', NULL),
(131, 2, 'Medical and Clinic Partnerships', 'we paid St.Elizabeth  hospital part payment for medical procedures', 400000.00, '2025-03-06 00:00:00', NULL),
(132, 2, 'Surrogate and Intended Parent Support', 'sent transport fare to Mr/Mrs nkama surrogate for her hospital appointment ', 2500.00, '2025-03-13 00:00:00', NULL),
(133, 2, 'Surrogate and Intended Parent Support', 'sent transport fare to Mr/Mrs Eke Princess surrogate to the hospital for her appointment ', 2500.00, '2025-03-13 00:00:00', NULL),
(134, 2, 'Medical and Clinic Partnerships', 'We bought drugs from Aba for the surrogates', 122000.00, '2025-03-13 00:00:00', NULL),
(135, 2, 'Miscellaneous Expenses', 'Transport to run some errands for surrogates at the branch', 2100.00, '2025-03-13 00:00:00', NULL),
(136, 2, 'Surrogate and Intended Parent Support', 'transport and feeding money for Mrs. Eke ebere surrogate for her first appointment at the hospital', 4000.00, '2025-03-12 00:00:00', NULL),
(137, 9, 'Surrogate and Intended Parent Support', 'feeding fee', 20000.00, '2025-03-10 00:00:00', NULL),
(138, 9, 'Operational Expenses', 'electricity bill', 3100.00, '2025-03-13 00:00:00', NULL),
(139, 2, 'Medical and Clinic Partnerships', 'We paid St. Elizabeth hospital for Mr/Mrs Nkama\'s surrogate cervical cerclage procedure ', 200000.00, '2025-03-13 00:00:00', NULL),
(140, 2, 'Surrogate and Intended Parent Support', 'We balanced the carpenter man for the floor bed he did for the surrogate and the driver that convey the stuff to the apartment', 27000.00, '2025-03-13 00:00:00', NULL),
(141, 9, 'Operational Expenses', 'printing and photocopy fee', 2500.00, '2025-03-14 00:00:00', NULL),
(142, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 6000.00, '2025-03-14 00:00:00', NULL),
(143, 9, 'Operational Expenses', 'Data Subscription', 6000.00, '2025-03-13 00:00:00', NULL),
(144, 1, 'Surrogate and Intended Parent Support', 'chikwes feeding ', 12000.00, '2025-03-12 00:00:00', NULL),
(145, 1, 'Miscellaneous Expenses', 'chikwes apartment ', 8000.00, '2025-03-13 00:00:00', NULL),
(146, 1, 'Surrogate and Intended Parent Support', 'tfare for Abeokuta surrogates for Emmanuel Blessing and Oluwaseun', 9500.00, '2025-03-13 00:00:00', NULL),
(147, 1, 'Operational Expenses', 'printing and photocopy ', 6500.00, '2025-03-10 00:00:00', NULL),
(148, 2, 'Surrogate and Intended Parent Support', 'Sent transport fare to Mr/Mrs Nkama surrogate for her hospital appointment ', 2500.00, '2025-03-14 00:00:00', NULL),
(149, 2, 'Legal and Professional Fees', 'legal/lawyer fee for the lawyer for contracts', 100000.00, '2025-03-14 00:00:00', NULL),
(150, 2, 'Surrogate and Intended Parent Support', 'paid Mr/Mrs Nkama surrogate for the cervical cercerge done on her at the hospital', 50000.00, '2025-03-14 00:00:00', NULL),
(151, 2, 'Surrogate and Intended Parent Support', 'Paid Mrs. Okafor Ebere\'s surrogate for her transport to the hospital for her appointment', 8100.00, '2025-03-15 00:00:00', NULL),
(152, 1, 'Operational Expenses', 'for printing of contract ', 1800.00, '2025-03-17 00:00:00', NULL),
(153, 1, 'Surrogate and Intended Parent Support', 'chikwes tfare', 12000.00, '2025-03-18 00:00:00', NULL),
(154, 1, 'Surrogate and Intended Parent Support', 'Emmanuel blessing', 65000.00, '2025-03-12 00:00:00', NULL),
(155, 1, 'Surrogate and Intended Parent Support', 'Mrs. Esther surrogate tfare', 3000.00, '2025-03-17 00:00:00', NULL),
(156, 2, 'Miscellaneous Expenses', 'transport fare for the branch office assistant to run some errands', 2800.00, '2025-03-17 00:00:00', NULL),
(157, 2, 'Operational Expenses', 'Data subscription for the office', 5000.00, '2025-03-18 00:00:00', NULL),
(158, 2, 'Operational Expenses', 'printing and photocopying of contract forms/documents ', 3500.00, '2025-03-18 00:00:00', NULL),
(159, 9, 'Legal and Professional Fees', 'lawyer fee', 50000.00, '2025-03-15 00:00:00', NULL),
(160, 9, 'Miscellaneous Expenses', 'Transportation fare', 1800.00, '2025-03-17 00:00:00', NULL),
(161, 2, 'Surrogate and Intended Parent Support', 'sent transport fare to Mr and Mrs Ekeh princess surrogate for her appointment to the office for signing of contracts', 2500.00, '2025-03-18 00:00:00', NULL),
(162, 9, 'Surrogate and Intended Parent Support', 'Househelp/insecticides fee', 15500.00, '2025-03-17 00:00:00', NULL),
(163, 9, 'Operational Expenses', 'Form scanning', 700.00, '2025-03-17 00:00:00', NULL),
(164, 2, 'Medical and Clinic Partnerships', 'paid st. Elizabeth part payment for ivf', 400000.00, '2025-03-18 00:00:00', NULL),
(165, 2, 'Surrogate and Intended Parent Support', 'transport fare for Mrs. okafor ebere surrogate for her appointment with the hospital ', 8100.00, '2025-03-19 00:00:00', NULL),
(166, 2, 'Surrogate and Intended Parent Support', 'Transport fare Mr/Mrs Elom Mercy\' surrogate for her appointment at the hospital for Antenatal visit', 2500.00, '2025-03-19 00:00:00', NULL),
(167, 2, 'Surrogate and Intended Parent Support', 'Transport fare for Mr/Mrs Emmanuel  (Mr. Williams) surrogate for her appointment at the hospital', 3000.00, '2025-03-19 00:00:00', NULL),
(168, 2, 'Surrogate and Intended Parent Support', 'light subscription for the surroagte at the apartment ', 10000.00, '2025-03-19 00:00:00', NULL),
(169, 2, 'Surrogate and Intended Parent Support', 'Transport fare for Mr/Mrs Emmanuel  (Mr. Williams) surrogate for her appointment at the hospital', 2500.00, '2025-03-20 00:00:00', NULL),
(170, 11, 'Marketing and Advertising', 'Surrogate ad', 3500.00, '2025-03-17 00:00:00', NULL),
(171, 11, 'Marketing and Advertising', 'Follower ad', 18000.00, '2025-03-18 00:00:00', NULL),
(172, 11, 'Marketing and Advertising', 'Data subscription ', 6000.00, '2025-03-14 00:00:00', NULL),
(173, 2, 'Operational Expenses', 'Bought mattress and other stuffs for the surrogates at the apartment', 160000.00, '2025-03-20 00:00:00', NULL),
(174, 2, 'Operational Expenses', 'Bought things for the surrogates at the apartment', 57000.00, '2025-03-20 00:00:00', NULL),
(175, 2, 'Operational Expenses', 'Payment for Enugu weigh bill from Aba', 15300.00, '2025-03-20 00:00:00', NULL),
(176, 1, 'Legal and Professional Fees', 'chikwes helper payments ', 20000.00, '2025-03-20 00:00:00', NULL),
(177, 1, 'Operational Expenses', 'printing and scanning ', 4500.00, '2025-03-20 00:00:00', NULL),
(178, 2, 'Surrogate and Intended Parent Support', 'Transport fare was sent to Mrs Okafor Ebere surrogate ', 4100.00, '2025-03-21 00:00:00', NULL),
(179, 2, 'Medical and Clinic Partnerships', 'Paid St. Elizabeth hospital for Mr/Mrs Elom Mercy\'s surrogate antenatal bill and Mr. Emmanuel surrogate PT Blood test', 14000.00, '2025-03-21 00:00:00', NULL),
(180, 2, 'Operational Expenses', 'Sent the nurse her service charge for mr. williams surrogate', 15000.00, '2025-03-21 00:00:00', NULL),
(181, 2, 'Surrogate and Intended Parent Support', 'transport fare for an intending surrogate for Mrs. Onyedikachi', 2500.00, '2025-03-21 00:00:00', NULL),
(182, 2, 'Surrogate and Intended Parent Support', 'Transport fare for Mrs. Okafor Ebere\'s surrogate to move to the apartment', 8100.00, '2025-03-22 00:00:00', NULL),
(183, 2, 'Operational Expenses', 'Transport fare for errands to carry mattress to the apartment, and to take Mrs. Elom Mercy surrogate to the hospital ', 5500.00, '2025-03-22 00:00:00', NULL),
(184, 2, 'Surrogate and Intended Parent Support', 'Paid Mr. Emmanuel\'s surrogate(Mr. William\'s) her allowance ', 60000.00, '2025-03-22 00:00:00', NULL),
(185, 2, 'Operational Expenses', 'Paid the nurse for the injection she gave both Mr/Mrs Nkama and Mr/Mrs Elom surrogates ', 20000.00, '2025-03-25 00:00:00', NULL),
(186, 9, 'Surrogate and Intended Parent Support', 'Transpoirtation fare', 5000.00, '2025-03-21 00:00:00', NULL),
(187, 9, 'Surrogate and Intended Parent Support', 'Transportation fee', 3000.00, '2025-03-21 00:00:00', NULL),
(188, 11, 'Marketing and Advertising', 'Follower Ad', 6000.00, '2025-03-25 00:00:00', NULL),
(189, 9, 'Medical and Clinic Partnerships', 'Injection fee', 10000.00, '2025-03-22 00:00:00', NULL),
(190, 2, 'Operational Expenses', 'Electricity  subscription for the office ', 10000.00, '2025-03-25 00:00:00', NULL),
(191, 9, 'Operational Expenses', 'Meter recharge', 10000.00, '2025-03-25 00:00:00', NULL),
(192, 2, 'Surrogate and Intended Parent Support', 'We bought the post luteal drug for Mrs. Okafor Ebere surrogate', 135000.00, '2025-03-25 00:00:00', NULL),
(193, 2, 'Operational Expenses', 'We weigh billed the post luteal drug for Mrs. Okafor Ebere surrogate from Aba to ENUGU', 8500.00, '2025-03-25 00:00:00', NULL),
(194, 1, 'Operational Expenses', 'wifi delivery ', 7500.00, '2025-03-21 00:00:00', NULL),
(195, 1, 'Operational Expenses', 'for office errands and transportation ', 10200.00, '2025-03-25 00:00:00', NULL),
(196, 1, 'Operational Expenses', 'office errands ', 4000.00, '2025-03-25 00:00:00', NULL),
(197, 1, 'Surrogate and Intended Parent Support', 'chikwes tfare to the hospital and back Friday and Saturday ', 16500.00, '2025-03-21 00:00:00', NULL),
(198, 1, 'Surrogate and Intended Parent Support', 'cleaner for chikwe', 20000.00, '2025-03-20 00:00:00', NULL),
(199, 2, 'Operational Expenses', 'Weigh bill of drugs to Enugu', 3500.00, '2025-03-25 00:00:00', NULL),
(200, 2, 'Surrogate and Intended Parent Support', 'We paid Mrs Okafor Ebere\'s surrogate for her embryo transfer ', 60000.00, '2025-05-26 00:00:00', NULL),
(201, 2, 'Surrogate and Intended Parent Support', 'Sent transport fare Mr/Mrs Nkama surrogate to the hospital for her Antenatal visit', 3000.00, '2025-03-26 00:00:00', NULL),
(202, 2, 'Operational Expenses', 'Paid the housekeeper for her job, paid the plumber and transport fares ', 28650.00, '2025-03-26 00:00:00', NULL),
(203, 2, 'Medical and Clinic Partnerships', 'Paid St. Elizabeth hospital for Mr/Mrs Nkama surrogate antenatal visit', 11000.00, '2025-03-26 00:00:00', NULL),
(204, 2, 'Surrogate and Intended Parent Support', 'Transport fare to Mr/Mrs Onyenobi Onyedikachi surrogate appointment both to the office and hospital', 2000.00, '2025-03-26 00:00:00', NULL),
(205, 2, 'Operational Expenses', 'Transport the hospital with the surrogate, bought drugs for Mr/Mrs Onyenobi surrogate and drug for Mr. Okafor Ebere surrogate', 6900.00, '2025-03-26 00:00:00', NULL),
(206, 9, 'Surrogate and Intended Parent Support', 'Monthly Allowance', 80000.00, '2025-03-26 00:00:00', NULL),
(207, 9, 'Surrogate and Intended Parent Support', 'transportation fare ', 3000.00, '2025-03-27 00:00:00', NULL),
(208, 2, 'Surrogate and Intended Parent Support', 'Sent transport fare to Mr/Mrs Onyenobi surrogate for her appointment at the office. 5k was sent which is twice transport which will cover her her appointment date at the office', 5000.00, '2025-03-28 00:00:00', NULL),
(209, 9, 'Operational Expenses', 'Electricity fee', 3100.00, '2025-03-28 00:00:00', NULL),
(210, 9, 'Surrogate and Intended Parent Support', 'househelp fee', 15500.00, '2025-03-30 00:00:00', NULL),
(211, 9, 'Operational Expenses', 'transportation fare', 1600.00, '2025-03-30 00:00:00', NULL),
(212, 9, 'Operational Expenses', 'Subcription and security fee', 7500.00, '2025-04-01 00:00:00', NULL),
(213, 9, 'Operational Expenses', 'treansportation fare', 35000.00, '2025-04-01 00:00:00', NULL),
(214, 9, 'Staffing and Payroll', 'March salary', 80000.00, '2025-03-29 00:00:00', NULL),
(215, 9, 'Staffing and Payroll', 'March salary', 80000.00, '2025-03-29 00:00:00', NULL),
(216, 9, 'Surrogate and Intended Parent Support', 'Transportation fare to the hospital', 5100.00, '2025-04-03 00:00:00', NULL),
(217, 9, 'Surrogate and Intended Parent Support', 'Transportation back home', 4000.00, '2025-04-03 00:00:00', NULL),
(218, 9, 'Operational Expenses', 'Transportation fare from hospital to office', 1300.00, '2025-04-03 00:00:00', NULL),
(219, 2, 'Surrogate and Intended Parent Support', 'Transport fare for Eke princess surrogate to the hospital', 2500.00, '2025-03-29 00:00:00', NULL),
(220, 2, 'Surrogate and Intended Parent Support', 'Transport fare to Mrs. Okafor Ebere surrogate after her embryo transfer and 1500 for apartment contribution to build a mini gate ', 5500.00, '2025-03-29 00:00:00', NULL),
(221, 2, 'Staffing and Payroll', 'March salary for Enugu Branch office assistant', 80000.00, '2025-03-29 00:00:00', NULL),
(222, 2, 'Surrogate and Intended Parent Support', 'April allowance for Mr/Mrs Elom Mercy surrogate ', 80000.00, '2025-04-01 00:00:00', NULL),
(223, 2, 'Surrogate and Intended Parent Support', 'April allowance for Mr/Mrs Nkama\'s surrogate ', 80000.00, '2025-04-01 00:00:00', NULL),
(224, 2, 'Operational Expenses', 'Airtime for office phone', 1000.00, '2025-04-02 00:00:00', NULL),
(225, 2, 'Surrogate and Intended Parent Support', 'Transport fare for Antenatal visit for Mr/Mrs Elom Mercy\'s surrogate ', 2500.00, '2025-04-02 00:00:00', NULL),
(226, 2, 'Surrogate and Intended Parent Support', 'Brough drug for Mrs Okafor Ebere\'s surrogate (7000) and transport to take it to her (1500)', 8500.00, '2025-04-02 00:00:00', NULL),
(227, 2, 'Operational Expenses', 'Balance for the old cleaner at the apartment ', 10000.00, '2025-04-03 00:00:00', NULL),
(228, 2, 'Surrogate and Intended Parent Support', 'Gas for the surrogates at the apartment ', 7000.00, '2025-04-03 00:00:00', NULL),
(229, 2, 'Operational Expenses', 'Data for the office phone ', 4000.00, '2025-04-03 00:00:00', NULL),
(230, 9, 'Surrogate and Intended Parent Support', 'Atenatal fee', 15940.00, '2025-04-03 00:00:00', NULL),
(231, 9, 'Surrogate and Intended Parent Support', 'Transportation fare to the hospital', 3000.00, '2025-04-04 00:00:00', NULL),
(232, 2, 'Surrogate and Intended Parent Support', 'Transport fare for Mrs. Okafor Ebere\'s surrogate for her appointment at the hospital', 2500.00, '2025-04-05 00:00:00', NULL),
(233, 2, 'Surrogate and Intended Parent Support', 'Transport fare for Mr/Mrs Onyenobi Onyedikachi surrogate for her appointment at the hospital', 2500.00, '2025-04-05 00:00:00', NULL),
(234, 2, 'Surrogate and Intended Parent Support', 'Electricity subscription for the surrogates at the apartment. ', 10000.00, '2025-04-05 00:00:00', NULL),
(235, 9, 'Operational Expenses', 'Electricity bill', 18100.00, '2025-04-08 00:00:00', NULL),
(236, 11, 'Marketing and Advertising', 'Client ad', 9000.00, '2025-04-02 00:00:00', NULL),
(237, 11, 'Marketing and Advertising', 'Surrogate ad', 3500.00, '2025-04-05 00:00:00', NULL),
(238, 11, 'Marketing and Advertising', 'Egg donor & surrogate ad', 8000.00, '2025-04-08 00:00:00', NULL),
(239, 2, 'Surrogate and Intended Parent Support', 'Transport fare to Mr/Mrs ONYENOBI Surrogate', 2500.00, '2025-04-08 00:00:00', NULL),
(240, 2, 'Surrogate and Intended Parent Support', 'sent feeding fare to Mr/Mrs Nkama\'s surrogate, she was admitted. feeding for one day ', 8000.00, '2025-04-08 00:00:00', NULL),
(241, 2, 'Surrogate and Intended Parent Support', 'Transport fare for Mrs Okafor Ebere\'s surrogate to the hospital for pt test', 2500.00, '2025-04-09 00:00:00', NULL),
(242, 2, 'Operational Expenses', 'Transport to take Mr/Mrs Nkama\'s surrogate to the hospital, and back to the office', 5000.00, '2025-04-09 00:00:00', NULL),
(243, 9, 'Operational Expenses', 'Weghbill and transportation fee', 7700.00, '2025-04-09 00:00:00', NULL),
(244, 2, 'Medical and Clinic Partnerships', 'Paid St. Elizabeth hospital for the pregnancy test done by Mrs. Ebere\'s surrogate ', 3000.00, '2025-04-09 00:00:00', NULL),
(245, 2, 'Operational Expenses', 'Nurse service fee for Mrs. Okafor Ebere\'s surrogate mum injection', 15000.00, '2025-04-10 00:00:00', NULL),
(246, 2, 'Medical and Clinic Partnerships', 'Paid St. Elizabeth hospital for Mr/Mrs Nkama\'s surrogate mum hospital bill', 66000.00, '2025-04-11 00:00:00', NULL),
(247, 9, 'Surrogate and Intended Parent Support', 'Embryo Transfer Fee', 60000.00, '2025-04-11 00:00:00', NULL),
(248, 9, 'Surrogate and Intended Parent Support', 'Transportation Fee', 2500.00, '2025-04-11 00:00:00', NULL),
(249, 9, 'Surrogate and Intended Parent Support', 'Transportation Fee', 2500.00, '2025-04-11 00:00:00', NULL),
(250, 9, 'Operational Expenses', 'Weighbill Fee', 1500.00, '2025-04-10 00:00:00', NULL),
(251, 9, 'Operational Expenses', 'Gas filling', 5000.00, '2025-04-10 00:00:00', NULL),
(252, 11, 'Marketing and Advertising', 'Surrogate Abia state', 4000.00, '2025-04-10 00:00:00', NULL),
(253, 11, 'Marketing and Advertising', 'Instagram ad', 9000.00, '2025-04-10 00:00:00', NULL),
(254, 9, 'Medical and Clinic Partnerships', 'Medical Procedures', 500000.00, '2025-04-12 00:00:00', NULL),
(255, 9, 'Operational Expenses', 'Househelp Fee', 12500.00, '2025-04-14 00:00:00', NULL),
(256, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 4500.00, '2025-04-15 00:00:00', NULL),
(257, 9, 'Surrogate and Intended Parent Support', 'Transportation fare to the hospital', 2000.00, '2025-04-14 00:00:00', NULL),
(258, 9, 'Surrogate and Intended Parent Support', 'Transportation fare to the hospital', 9100.00, '2025-04-15 00:00:00', NULL),
(259, 1, 'Medical and Clinic Partnerships', 'payments for chikwe hospital bill at God bless hospital ', 1250000.00, '2025-03-30 00:00:00', NULL),
(260, 1, 'Surrogate and Intended Parent Support', 'chikwes compensation', 1660000.00, '2025-04-01 00:00:00', NULL),
(261, 1, 'Surrogate and Intended Parent Support', 'Titilope transfer fee', 60000.00, '2025-03-21 00:00:00', NULL),
(262, 1, 'Surrogate and Intended Parent Support', 'titilope pregnancy fee', 60000.00, '2025-04-10 00:00:00', NULL),
(263, 2, 'Surrogate and Intended Parent Support', 'Transport farw was sent to Mr/Mrs Elom Mercy\'s surrogate ', 3000.00, '2025-04-16 00:00:00', NULL),
(264, 2, 'Surrogate and Intended Parent Support', 'Bought television for the surrogates at the apartment, along side remote and hanger', 120000.00, '2025-04-17 00:00:00', NULL),
(265, 2, 'Surrogate and Intended Parent Support', 'Bought Gotv decoder for the surrogate at the apartment ', 28500.00, '2025-04-17 00:00:00', NULL),
(266, 2, 'Operational Expenses', 'Bought Extension (7500) and Tv Guard (5000)', 12500.00, '2025-04-17 00:00:00', NULL),
(267, 2, 'Operational Expenses', 'To subscribe the decoder (6000) and mount it (12000)', 18000.00, '2025-04-17 00:00:00', NULL),
(268, 2, 'Medical and Clinic Partnerships', 'paid the hospital for Elom mercy surrogate hospital bill', 13500.00, '2025-04-17 00:00:00', NULL),
(269, 9, 'Medical and Clinic Partnerships', 'Atenatal fee', 57990.00, '2025-04-17 00:00:00', NULL),
(270, 9, 'Operational Expenses', 'Cough medicine', 2000.00, '2025-04-18 00:00:00', NULL),
(271, 9, 'Operational Expenses', 'Insecticide', 5500.00, '2025-04-22 00:00:00', NULL),
(272, 2, 'Surrogate and Intended Parent Support', 'sent transport fare to Mr/Mrs Nkama surrogate for her appointment at the hospital ', 10000.00, '2025-04-22 00:00:00', NULL),
(273, 9, 'Operational Expenses', 'Data subcription ', 6000.00, '2025-04-23 00:00:00', NULL),
(274, 9, 'Operational Expenses', 'Fan repairs', 12200.00, '2025-04-23 00:00:00', NULL),
(275, 2, 'Surrogate and Intended Parent Support', 'Sent transport  fare to Mr/Mrs Nkama surrogate for antenatal visit', 3000.00, '2025-04-23 00:00:00', NULL),
(276, 2, 'Surrogate and Intended Parent Support', 'Electricity subscription for the surrogates ', 10000.00, '2025-04-23 00:00:00', NULL),
(277, 2, 'Operational Expenses', 'HDMI Wife for the decoder and transport fare to take the television and other stuff to the apartment ', 9600.00, '2025-04-23 00:00:00', NULL),
(278, 9, 'Surrogate and Intended Parent Support', 'transportation fare to the hospital', 3000.00, '2025-04-25 00:00:00', NULL),
(279, 9, 'Operational Expenses', 'Light fee', 3100.00, '2025-04-25 00:00:00', NULL),
(280, 9, 'Surrogate and Intended Parent Support', 'Monthly allowance', 80000.00, '2025-04-26 00:00:00', NULL),
(281, 9, 'Surrogate and Intended Parent Support', 'Househelp payment', 10000.00, '2025-04-28 00:00:00', NULL),
(282, 9, 'Surrogate and Intended Parent Support', 'Feeding allowance', 30000.00, '2025-04-28 00:00:00', NULL),
(283, 2, 'Medical and Clinic Partnerships', 'Paid St. Elizabeth hospital for Mr/Mrs Nkama surrogate mum antenatal visit ', 5000.00, '2025-04-24 00:00:00', NULL),
(284, 2, 'Operational Expenses', 'Bought office chair for a new branch manager ', 56500.00, '2025-04-26 00:00:00', NULL),
(285, 2, 'Operational Expenses', 'Office Light subscription and transport to carry the office chair bought to the office ', 12000.00, '2025-04-29 00:00:00', NULL),
(286, 2, 'Surrogate and Intended Parent Support', 'Sent money to Mrs. Elom Mercy surrogate mum', 10000.00, '2025-04-29 00:00:00', NULL),
(287, 2, 'Staffing and Payroll', 'PAID THE BRANCH MANAGER HER APRIL SALARY', 80000.00, '2025-04-28 00:00:00', NULL),
(288, 2, 'Surrogate and Intended Parent Support', 'PAID MR/MRS NKAMA SURROGATE HER APRIL ALLOWANCE', 80000.00, '2025-05-01 00:00:00', NULL),
(289, 2, 'Surrogate and Intended Parent Support', 'PAID MR/MRS MERCY ELOM SURROGATE HER MAY ALLOWANCE', 80000.00, '2025-05-01 00:00:00', NULL),
(290, 2, 'Surrogate and Intended Parent Support', 'Bought sweeper for the surrogates (6000) and transport fare to take it to them(700)', 6700.00, '2025-05-02 00:00:00', NULL),
(291, 2, 'Miscellaneous Expenses', 'Paid the new cleaner for the month of April ', 30000.00, '2025-05-02 00:00:00', NULL),
(292, 9, 'Surrogate and Intended Parent Support', 'Transportation fare to the hospital', 10000.00, '2025-05-01 00:00:00', NULL),
(293, 9, 'Surrogate and Intended Parent Support', 'Injection fee', 10000.00, '2025-05-02 00:00:00', NULL),
(294, 9, 'Surrogate and Intended Parent Support', 'Injection fee', 10000.00, '2025-05-02 00:00:00', NULL),
(295, 9, 'Surrogate and Intended Parent Support', 'Injection fee', 10000.00, '2025-05-02 00:00:00', NULL),
(296, 9, 'Surrogate and Intended Parent Support', 'Gotv subscription03085', 7500.00, '2025-05-03 00:00:00', NULL),
(297, 2, 'Operational Expenses', 'Balance for the cleaner payment', 5000.00, '2025-05-05 00:00:00', NULL),
(298, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 3000.00, '2025-05-06 00:00:00', NULL),
(299, 9, 'Operational Expenses', 'Light fee', 3100.00, '2025-05-06 00:00:00', NULL),
(300, 2, 'Surrogate and Intended Parent Support', 'Repaired surrogate gas burner at the apartment ', 4000.00, '2025-05-06 00:00:00', NULL),
(301, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 3000.00, '2025-05-06 00:00:00', NULL),
(302, 9, 'Surrogate and Intended Parent Support', 'Transportation fare to the hospital', 3000.00, '2025-05-06 00:00:00', NULL),
(303, 2, 'Surrogate and Intended Parent Support', 'Transport fare was sent to Mr. Lawrence donor to the hospital ', 2000.00, '2025-05-05 00:00:00', NULL),
(304, 2, 'Surrogate and Intended Parent Support', 'Transport fare was sent to Mr. Nkama surrogate to the hospital ', 3000.00, '2025-05-07 00:00:00', NULL),
(305, 2, 'Surrogate and Intended Parent Support', 'Mr. Nkama surrogate maternity allowance was sent  (50k)', 50000.00, '2025-05-08 00:00:00', NULL),
(306, 2, 'Surrogate and Intended Parent Support', 'light subscription for the surrogates at the apartment ', 10000.00, '2025-05-07 00:00:00', NULL),
(307, 2, 'Medical and Clinic Partnerships', 'Paid Champion Diagnostic center for Mr/Mrs Nkama surrogate scan', 6000.00, '2025-05-07 00:00:00', NULL),
(308, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 3000.00, '2025-05-09 00:00:00', NULL),
(309, 9, 'Operational Expenses', 'Water', 6000.00, '2025-05-09 00:00:00', NULL),
(310, 2, 'Medical and Clinic Partnerships', 'Paid St. Elizabeth hospital for Mr/Mrs Nkama\'s surrogate Antenatal visit', 12500.00, '2025-05-09 00:00:00', NULL),
(311, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 3000.00, '2025-05-12 00:00:00', NULL),
(312, 9, 'Operational Expenses', 'House help and insecticide', 15500.00, '2025-05-12 00:00:00', NULL),
(313, 9, 'Surrogate and Intended Parent Support', 'water', 6000.00, '2025-05-14 00:00:00', NULL),
(314, 9, 'Operational Expenses', 'Transportation fare', 3000.00, '2025-05-13 00:00:00', NULL),
(315, 9, 'Surrogate and Intended Parent Support', 'Monthly Allowance', 60000.00, '2025-05-13 00:00:00', NULL),
(316, 2, 'Medical and Clinic Partnerships', 'Paid st. Elizabeth hospital part payment for ivf for mr. Lawrence ', 1000000.00, '2025-05-11 00:00:00', NULL),
(317, 2, 'Surrogate and Intended Parent Support', 'Sent transport fare to Mr. LAWRENCE to return to Enugu in order to resume her treatment ', 8000.00, '2025-05-12 00:00:00', NULL),
(318, 2, 'Surrogate and Intended Parent Support', 'Sent transport to Mr/Mrs Elom surrogate to go for scan', 3000.00, '2025-05-14 00:00:00', NULL),
(319, 2, 'Surrogate and Intended Parent Support', 'Sent transport fare to Mr LAWERENCE surrogate for her appointment at the hospital', 2500.00, '2025-05-15 00:00:00', NULL),
(320, 2, 'Surrogate and Intended Parent Support', 'Paid Mr/Mrs Elom Mercy\'s surrogate for her maternity allowance ', 50000.00, '2025-05-15 00:00:00', NULL),
(321, 2, 'Operational Expenses', 'Scan done for Mr/Mrs Mercy\'s surrogate (6000) plus transport fares', 8500.00, '2025-05-15 00:00:00', NULL),
(322, 9, 'Surrogate and Intended Parent Support', 'Feeding fee', 30000.00, '2025-05-15 00:00:00', NULL),
(323, 9, 'Surrogate and Intended Parent Support', 'Monthly allowance', 80000.00, '2025-05-14 00:00:00', NULL),
(324, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 10000.00, '2025-05-15 00:00:00', NULL),
(325, 2, 'Surrogate and Intended Parent Support', 'Transport fare sent to Mr. LAWERENCE for her appointment at the hospital', 2500.00, '2025-05-17 00:00:00', NULL),
(326, 2, 'Surrogate and Intended Parent Support', 'GOTV Subscription for the surrogates at the apartment ', 5800.00, '2025-05-17 00:00:00', NULL),
(327, 2, 'Surrogate and Intended Parent Support', 'Balanced Mr/Mrs Nkama\'s surrogate mum her maternity allowance ', 30000.00, '2025-05-17 00:00:00', NULL),
(328, 9, 'Surrogate and Intended Parent Support', 'Transportation fare to the hospitral', 3000.00, '2025-05-19 00:00:00', NULL),
(329, 9, 'Operational Expenses', 'Light fee', 3100.00, '2025-05-19 00:00:00', NULL),
(330, 2, 'Surrogate and Intended Parent Support', 'Light subscription for the surrogates at the apartment ', 10000.00, '2025-05-19 00:00:00', NULL),
(331, 2, 'Surrogate and Intended Parent Support', 'Transport fare was sent to Mr. Lawrence donor for her appointment at the hospital', 2500.00, '2025-05-20 00:00:00', NULL),
(332, 2, 'Surrogate and Intended Parent Support', 'sent transport fare to Mr Lawrence surrogate for her appointment at the hospital ', 3000.00, '2025-05-23 00:00:00', NULL),
(333, 9, 'Operational Expenses', 'Photocopy and printing', 1600.00, '2025-05-19 00:00:00', NULL),
(334, 9, 'Surrogate and Intended Parent Support', 'Transportation fare to the hospital', 3000.00, '2025-05-20 00:00:00', NULL),
(335, 9, 'Surrogate and Intended Parent Support', 'Drugs', 2000.00, '2025-05-20 00:00:00', NULL),
(336, 9, 'Operational Expenses', 'Transportation fare', 2000.00, '2025-05-21 00:00:00', NULL),
(337, 9, 'Medical and Clinic Partnerships', 'Medical fee', 32000.00, '2025-05-20 00:00:00', NULL),
(338, 9, 'Medical and Clinic Partnerships', 'Ivf medications', 350000.00, '2025-05-22 00:00:00', NULL),
(339, 9, 'Surrogate and Intended Parent Support', 'Ivf Fee', 150000.00, '2025-05-22 00:00:00', NULL),
(340, 9, 'Operational Expenses', 'Extension Fee', 6000.00, '2025-05-23 00:00:00', NULL),
(341, 9, 'Surrogate and Intended Parent Support', 'Househelp and Insecticide', 15500.00, '2025-05-20 00:00:00', NULL),
(342, 9, 'Operational Expenses', 'Data Fee', 6000.00, '2025-05-26 00:00:00', NULL),
(343, 2, 'Surrogate and Intended Parent Support', 'transport fare Mr. LAWRENCE donor', 2000.00, '2025-05-26 00:00:00', NULL),
(344, 2, 'Surrogate and Intended Parent Support', 'Light subscription for the office ', 10000.00, '2025-05-28 00:00:00', NULL),
(345, 2, 'Surrogate and Intended Parent Support', 'Transport fare for Mr/Mrs Nkama surrogate for her antenatal visit to the hospital', 3000.00, '2025-05-28 00:00:00', NULL),
(346, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 7500.00, '2025-05-27 00:00:00', NULL),
(347, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 7800.00, '2025-05-27 00:00:00', NULL),
(348, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 3000.00, '2025-05-28 00:00:00', NULL),
(349, 9, 'Surrogate and Intended Parent Support', 'Atenatal fee', 34440.00, '2025-05-28 00:00:00', NULL),
(350, 2, 'Staffing and Payroll', 'Salary of the branch manager for the month of May', 90000.00, '2025-05-28 00:00:00', NULL),
(351, 2, 'Surrogate and Intended Parent Support', 'Sent transport fare for Mr. LAWRENCE surrogate for her appointment at the apartment', 3000.00, '2025-05-29 00:00:00', NULL),
(352, 2, 'Surrogate and Intended Parent Support', 'Loan was given to Mr/Mrs Nkama\'s surrogate (Chinaza)', 50000.00, '2025-05-29 00:00:00', NULL);
INSERT INTO `expenses` (`expense_id`, `branch_id`, `category`, `description`, `amount`, `expense_date`, `category_id`) VALUES
(353, 9, 'Surrogate and Intended Parent Support', 'Transportation fee', 10000.00, '2025-05-29 00:00:00', NULL),
(354, 9, 'Surrogate and Intended Parent Support', 'Atenatal fee', 14600.00, '2025-05-30 00:00:00', NULL),
(355, 9, 'Staffing and Payroll', 'May Salary', 90000.00, '2025-05-22 00:00:00', NULL),
(356, 2, 'Surrogate and Intended Parent Support', 'Transport fare for Mr. LAWRENCE donor ', 2000.00, '2025-05-31 00:00:00', NULL),
(357, 9, 'Surrogate and Intended Parent Support', 'Househelp fee', 5000.00, '2025-06-02 00:00:00', NULL),
(358, 2, 'Surrogate and Intended Parent Support', 'Paid Mr/Mrs Nkama\'s surrogate mum for her June monthly allowance \r\n', 80000.00, '2025-06-01 00:00:00', NULL),
(359, 2, 'Surrogate and Intended Parent Support', 'Paid Mr/Mrs elom mercy\'s surrogate mum for her June monthly allowance ', 80000.00, '2025-06-01 00:00:00', NULL),
(360, 2, 'Surrogate and Intended Parent Support', 'transport for a donor', 4000.00, '2025-06-01 00:00:00', NULL),
(361, 2, 'Surrogate and Intended Parent Support', 'light subscription at the surrogate apartment', 10000.00, '2025-06-02 00:00:00', NULL),
(362, 9, 'Surrogate and Intended Parent Support', 'Delivery items', 60000.00, '2025-06-02 00:00:00', NULL),
(363, 9, 'Operational Expenses', 'Electricity bills', 3100.00, '2025-06-03 00:00:00', NULL),
(364, 2, 'Operational Expenses', 'printing of document and transportation ', 2000.00, '2025-06-03 00:00:00', NULL),
(365, 2, 'Surrogate and Intended Parent Support', 'monthly payment for the cleaner at the apartment \r\n', 35000.00, '2025-06-04 00:00:00', NULL),
(366, 2, 'Surrogate and Intended Parent Support', 'transportation fare for Mr and Mrs Elom Mercy\'s surrogate ', 3000.00, '2025-06-04 00:00:00', NULL),
(367, 2, 'Surrogate and Intended Parent Support', 'Hospital bill for Mr and Mrs Elom surrogate ', 4500.00, '2025-06-04 00:00:00', NULL),
(368, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 5000.00, '2025-06-03 00:00:00', NULL),
(369, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 3000.00, '2025-06-04 00:00:00', NULL),
(370, 9, 'Surrogate and Intended Parent Support', 'Embryo transfer fee', 60000.00, '2025-06-04 00:00:00', NULL),
(371, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 3000.00, '2025-06-05 00:00:00', NULL),
(372, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 7400.00, '2025-06-05 00:00:00', NULL),
(373, 9, 'Surrogate and Intended Parent Support', 'Maternity', 5000.00, '2025-06-05 00:00:00', NULL),
(374, 9, 'Medical and Clinic Partnerships', 'Medical costs', 756500.00, '2025-06-05 00:00:00', NULL),
(375, 9, 'Medical and Clinic Partnerships', 'Medical costs', 56150.00, '2025-06-05 00:00:00', NULL),
(376, 9, 'Surrogate and Intended Parent Support', 'Compensation fee', 1600000.00, '2025-06-06 00:00:00', NULL),
(377, 9, 'Surrogate and Intended Parent Support', 'Ivf fee', 1600000.00, '2025-06-06 00:00:00', NULL),
(378, 9, 'Surrogate and Intended Parent Support', 'Transportation fee', 3100.00, '2025-06-06 00:00:00', NULL),
(379, 2, 'Surrogate and Intended Parent Support', 'Transport fare for Mr Lawrence donor ', 2000.00, '2025-06-04 00:00:00', NULL),
(380, 2, 'Surrogate and Intended Parent Support', 'Taking the donor to the surrogates apartment ', 1000.00, '2025-06-06 00:00:00', NULL),
(381, 2, 'Surrogate and Intended Parent Support', 'Gas filling for surrogate chinaza ', 4500.00, '2025-10-06 00:00:00', NULL),
(382, 2, 'Surrogate and Intended Parent Support', 'Mosquito net for Mr Nkama\'s surrogate ', 10000.00, '2025-11-06 00:00:00', NULL),
(383, 2, 'Surrogate and Intended Parent Support', 'Antenatal fee for Mr and Mrs Nkama\'s surrogate ', 10500.00, '2025-06-06 00:00:00', NULL),
(384, 2, 'Surrogate and Intended Parent Support', 'Transport fare for Mr Lawrence surrogate ', 2500.00, '2025-09-06 00:00:00', NULL),
(385, 2, 'Surrogate and Intended Parent Support', 'Support from Mr Lawrence to their surrogate ', 10000.00, '2025-08-06 00:00:00', NULL),
(386, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 5000.00, '2025-06-13 00:00:00', NULL),
(387, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 3000.00, '2025-06-13 00:00:00', NULL),
(388, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 3000.00, '2025-06-13 00:00:00', NULL),
(389, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 2000.00, '2025-06-13 00:00:00', NULL),
(390, 9, 'Operational Expenses', 'Printing of Documents', 3000.00, '2025-06-14 00:00:00', NULL),
(391, 9, 'Surrogate and Intended Parent Support', 'transportation fare', 2500.00, '2025-06-17 00:00:00', NULL),
(392, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 5400.00, '2025-06-17 00:00:00', NULL),
(393, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 3600.00, '2025-06-17 00:00:00', NULL),
(394, 9, 'Surrogate and Intended Parent Support', 'Registeration fee', 40000.00, '2025-06-17 00:00:00', NULL),
(395, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 3000.00, '2025-06-18 00:00:00', NULL),
(396, 9, 'Surrogate and Intended Parent Support', 'Confirmation of pregnancy fee', 60000.00, '2025-06-19 00:00:00', NULL),
(397, 9, 'Surrogate and Intended Parent Support', 'Injections fee', 5000.00, '2025-06-23 00:00:00', NULL),
(398, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 3000.00, '2025-06-25 00:00:00', NULL),
(399, 9, 'Surrogate and Intended Parent Support', 'Light fee', 3100.00, '2025-06-28 00:00:00', NULL),
(400, 9, 'Staffing and Payroll', 'June salary', 90000.00, '2025-06-28 00:00:00', NULL),
(401, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 3000.00, '2025-06-30 00:00:00', NULL),
(402, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 3000.00, '2025-06-30 00:00:00', NULL),
(403, 9, 'Surrogate and Intended Parent Support', 'Injection fee', 5000.00, '2025-06-30 00:00:00', NULL),
(404, 2, 'Surrogate and Intended Parent Support', 'Mosquito Net for Mrs Mercy\'s surrogate ', 10000.00, '2025-06-11 00:00:00', NULL),
(405, 2, 'Surrogate and Intended Parent Support', 'Transportation fare for Prof Lawrence surrogate', 2500.00, '2025-06-12 00:00:00', NULL),
(406, 2, 'Surrogate and Intended Parent Support', 'Registration Fee for Mrs Regina Ejoor ', 50000.00, '2025-06-12 00:00:00', NULL),
(407, 2, 'Surrogate and Intended Parent Support', 'Recharging of light for surrogate Apartment ', 10000.00, '2025-06-12 00:00:00', NULL),
(408, 2, 'Surrogate and Intended Parent Support', 'Transportation fare for Prof Lawrence surrogate', 2500.00, '2025-06-13 00:00:00', NULL),
(409, 2, 'Surrogate and Intended Parent Support', 'Transportation fare for Prof Lawrence surrogate ', 2500.00, '2025-06-14 00:00:00', NULL),
(410, 2, 'Surrogate and Intended Parent Support', 'Money sent to Mrs Nkama surrogate ', 5000.00, '2025-06-14 00:00:00', NULL),
(411, 2, 'Surrogate and Intended Parent Support', 'Recharging of Gotv for surrogate apartment ', 5800.00, '2025-06-17 00:00:00', NULL),
(412, 2, 'Surrogate and Intended Parent Support', 'Buying of  broom,mob and brush for surrogate apartment ', 10000.00, '2025-06-17 00:00:00', NULL),
(413, 2, 'Surrogate and Intended Parent Support', 'Printing of Mrs Regina\'s form ', 200.00, '2025-06-17 00:00:00', NULL),
(414, 2, 'Surrogate and Intended Parent Support', 'Money sent to Oluchi Confidence', 2000.00, '2025-06-17 00:00:00', NULL),
(415, 2, 'Surrogate and Intended Parent Support', 'Money sent to Prof Lawrence surrogate ', 20000.00, '2025-06-17 00:00:00', NULL),
(416, 2, 'Surrogate and Intended Parent Support', 'Transportation fare to Mrs Elom\'s surrogate ', 3000.00, '2025-06-18 00:00:00', NULL),
(417, 2, 'Surrogate and Intended Parent Support', 'Part payment for IVF and Surrogacy', 1200000.00, '2026-06-18 00:00:00', NULL),
(418, 2, 'Operational Expenses', 'Recharging of office light ', 10000.00, '2025-06-18 00:00:00', NULL),
(419, 2, 'Surrogate and Intended Parent Support', 'Transportation fare to the hospital', 3000.00, '2025-06-18 00:00:00', NULL),
(420, 2, 'Surrogate and Intended Parent Support', 'Completion of initial payment by Mrs Regina Ejoor for IVF and Surrogacy', 1200000.00, '2025-06-19 00:00:00', NULL),
(421, 2, 'Surrogate and Intended Parent Support', 'Money sent to Mrs Nkama\'s surrogate', 5000.00, '2025-06-21 00:00:00', NULL),
(422, 2, 'Surrogate and Intended Parent Support', 'Sperm freezing for Prof Lawrence ', 400000.00, '2025-06-21 00:00:00', NULL),
(423, 2, 'Surrogate and Intended Parent Support', 'Transport fare to the hospital with a new surrogate', 4000.00, '2025-06-21 00:00:00', NULL),
(424, 2, 'Surrogate and Intended Parent Support', 'Blood test for new surrogate', 16500.00, '2025-06-21 00:00:00', NULL),
(425, 2, 'Surrogate and Intended Parent Support', 'Transportation fare for Mrs Nkama\'s surrogate ', 3000.00, '2025-06-25 00:00:00', NULL),
(426, 2, 'Surrogate and Intended Parent Support', 'Transportation fare for Prof Lawrence surrogate', 3000.00, '2025-06-26 00:00:00', NULL),
(427, 2, 'Surrogate and Intended Parent Support', 'Recharging of light for surrogate\'s apartment ', 10000.00, '2025-06-26 00:00:00', NULL),
(428, 2, 'Surrogate and Intended Parent Support', 'Monthly Allowance to Mrs Nkama\'s surrogate', 80000.00, '2025-07-01 00:00:00', NULL),
(429, 2, 'Surrogate and Intended Parent Support', 'Monthly Allowance for Mrs Elom\'s surrogate ', 80000.00, '2025-07-01 00:00:00', NULL),
(430, 1, 'Staffing and Payroll', 'salary for june', 100.00, '2025-06-28 00:00:00', NULL),
(431, 2, 'Surrogate and Intended Parent Support', 'Taking the new staff to the hospital and surrogate apartment ', 2600.00, '2025-07-01 00:00:00', NULL),
(432, 2, 'Staffing and Payroll', 'june salary to Enugu manager', 80000.00, '2025-06-28 00:00:00', NULL),
(433, 9, 'Operational Expenses', 'Office expenses', 60000.00, '2025-07-01 00:00:00', NULL),
(434, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 3000.00, '2025-07-02 00:00:00', NULL),
(435, 9, 'Surrogate and Intended Parent Support', 'Transportation fare', 3000.00, '2025-07-02 00:00:00', NULL);

-- --------------------------------------------------------

--
-- Table structure for table `feedback`
--

CREATE TABLE `feedback` (
  `feedback_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `rating` int(11) NOT NULL,
  `category` varchar(50) NOT NULL,
  `comment` text NOT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `files`
--

CREATE TABLE `files` (
  `file_id` int(11) NOT NULL,
  `uploaded_by` int(11) DEFAULT NULL,
  `shared_with_branch_id` int(11) DEFAULT NULL,
  `shared_with_user_id` int(11) DEFAULT NULL,
  `file_path` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `finances`
--

CREATE TABLE `finances` (
  `transaction_id` int(11) NOT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `project_id` int(11) DEFAULT NULL,
  `transaction_type` enum('income','expense') NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `description` text DEFAULT NULL,
  `transaction_date` date NOT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `groups`
--

CREATE TABLE `groups` (
  `group_id` int(11) NOT NULL,
  `group_name` varchar(255) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `groups`
--

INSERT INTO `groups` (`group_id`, `group_name`, `created_at`) VALUES
(1, 'Team Alpha', '2024-12-04 05:36:07'),
(2, 'Team Beta', '2024-12-04 05:36:07'),
(3, 'Project Managers', '2024-12-04 05:36:07'),
(4, 'Developers', '2024-12-04 05:36:07');

-- --------------------------------------------------------

--
-- Table structure for table `group_members`
--

CREATE TABLE `group_members` (
  `group_member_id` int(11) NOT NULL,
  `group_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `added_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `inquiries`
--

CREATE TABLE `inquiries` (
  `inquiry_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `inquiry_type` enum('intended_parent','surrogate') NOT NULL,
  `description` text NOT NULL,
  `status` enum('new','reviewed','consultation_scheduled','completed','rejected') DEFAULT 'new',
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `invoices`
--

CREATE TABLE `invoices` (
  `invoice_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `project_id` int(11) DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `amount_due` decimal(12,2) NOT NULL,
  `due_date` date NOT NULL,
  `status` enum('Unpaid','Paid','Overdue') DEFAULT 'Unpaid',
  `created_by` int(11) DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `invoices`
--

INSERT INTO `invoices` (`invoice_id`, `client_id`, `project_id`, `branch_id`, `description`, `amount_due`, `due_date`, `status`, `created_by`, `created_at`) VALUES
(1, 8, 26, 1, 'wrref', 600.00, '2025-06-04', 'Unpaid', 44, '2025-06-30 16:19:26'),
(2, 9, 27, 2, 'I am paying for surogacy', 50000.00, '2025-06-04', 'Unpaid', 44, '2025-06-30 16:56:52'),
(3, 8, 25, 2, 'first pay', 10000000.00, '2025-07-07', 'Paid', 44, '2025-06-30 17:47:12'),
(4, 8, 25, 2, 'first pay', 10000000.00, '2025-07-07', 'Unpaid', 44, '2025-06-30 18:07:53');

-- --------------------------------------------------------

--
-- Table structure for table `invoice_items`
--

CREATE TABLE `invoice_items` (
  `item_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `description` text NOT NULL,
  `amount` decimal(12,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `messages`
--

CREATE TABLE `messages` (
  `message_id` int(11) NOT NULL,
  `sender_id` int(11) DEFAULT NULL,
  `receiver_id` int(11) DEFAULT NULL,
  `group_id` int(11) DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `body` text NOT NULL,
  `attachment` varchar(255) DEFAULT NULL,
  `is_read` tinyint(1) DEFAULT 0,
  `created_at` datetime DEFAULT current_timestamp(),
  `file_path` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `message_threads`
--

CREATE TABLE `message_threads` (
  `thread_id` int(11) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `notification_id` int(11) NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `message` varchar(255) NOT NULL,
  `is_read` tinyint(1) DEFAULT 0,
  `created_at` datetime DEFAULT current_timestamp(),
  `type` enum('task','message','project') NOT NULL,
  `content` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `notifications`
--

INSERT INTO `notifications` (`notification_id`, `user_id`, `message`, `is_read`, `created_at`, `type`, `content`) VALUES
(423, 15, '', 0, '2025-06-30 15:43:08', 'task', 'You have been assigned a new task: content'),
(424, 15, '', 0, '2025-07-04 21:07:22', 'task', 'You have been assigned a new task: content'),
(425, 15, '', 0, '2025-07-04 21:17:53', 'task', 'You have been assigned a new task: content'),
(426, 15, '', 0, '2025-07-04 21:20:16', 'task', 'You have been assigned a new task: content'),
(427, 15, '', 0, '2025-07-04 21:20:48', 'task', 'You have been assigned a new task: content'),
(428, 15, '', 0, '2025-07-04 21:21:25', 'task', 'You have been assigned a new task: content'),
(429, 15, '', 0, '2025-07-04 21:27:12', 'task', 'You have been assigned a new task: content'),
(430, 15, '', 0, '2025-07-04 21:27:52', 'task', 'You have been assigned a new task: content'),
(431, 15, '', 0, '2025-07-04 21:28:19', 'task', 'You have been assigned a new task: content'),
(432, 15, '', 0, '2025-07-04 21:28:34', 'task', 'You have been assigned a new task: content'),
(433, 15, '', 0, '2025-07-04 21:29:21', 'task', 'You have been assigned a new task: content'),
(434, 15, '', 0, '2025-07-04 21:29:55', 'task', 'You have been assigned a new task: content'),
(435, 15, '', 0, '2025-07-04 21:30:33', 'task', 'You have been assigned a new task: content'),
(436, 15, '', 0, '2025-07-04 21:31:07', 'task', 'You have been assigned a new task: content'),
(437, 15, '', 0, '2025-07-04 21:31:15', 'task', 'You have been assigned a new task: content'),
(438, 15, '', 0, '2025-07-04 21:50:38', 'task', 'You have been assigned a new task: content'),
(439, 15, '', 0, '2025-07-04 23:16:41', 'task', 'You have been assigned a new task: content');

-- --------------------------------------------------------

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `payment_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `project_id` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `payment_date` datetime NOT NULL,
  `payment_method` enum('bank_transfer','cash','credit_card','online') NOT NULL,
  `purpose` varchar(255) DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `snapshot_balance` decimal(10,2) DEFAULT NULL,
  `amount_paid` decimal(10,2) NOT NULL DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`payment_id`, `client_id`, `project_id`, `amount`, `payment_date`, `payment_method`, `purpose`, `branch_id`, `snapshot_balance`, `amount_paid`) VALUES
(15, 8, 25, 1000000.00, '0000-00-00 00:00:00', 'bank_transfer', 'first part payment', 2, 4000000.00, 1000000.00),
(16, 9, 26, 1000000.00, '2024-11-26 00:00:00', 'online', 'FIRST SURROGACY INSTALLMENTS PAYMENTS ', 1, 3500000.00, 1000000.00),
(17, 14, 31, 3000000.00, '2024-12-07 00:00:00', 'bank_transfer', 'FIRST SURROGACY INSTALLMENTS PAYMENTS ', 1, 3000000.00, 3000000.00),
(18, 13, 30, 50000.00, '2025-01-16 00:00:00', 'bank_transfer', 'for registration ', 2, 14000000.00, 50000.00),
(19, 13, 30, 1000000.00, '2025-02-06 00:00:00', 'bank_transfer', 'first deposit for surrogacy ', 2, 13000000.00, 1000000.00),
(20, 13, 30, 3000000.00, '2025-02-08 00:00:00', 'bank_transfer', 'second part deposit for surrogacy ', 2, 10000000.00, 3000000.00),
(21, 11, 28, 50000.00, '2024-10-10 00:00:00', 'bank_transfer', 'for registration ', 2, 6500000.00, 50000.00),
(22, 11, 28, 1500000.00, '2024-10-16 00:00:00', 'bank_transfer', 'for part payment for IVF', 2, 5000000.00, 1500000.00),
(23, 12, 29, 50000.00, '2024-11-04 00:00:00', 'bank_transfer', 'for registration ', 2, 5000000.00, 50000.00),
(24, 12, 29, 2000000.00, '2024-11-16 00:00:00', 'bank_transfer', 'first Payment for surrogacy ', 2, 3000000.00, 2000000.00),
(25, 10, 27, 50000.00, '2024-09-17 00:00:00', 'bank_transfer', 'for registration ', 2, 6400000.00, 50000.00),
(26, 10, 27, 2600000.00, '2024-09-25 00:00:00', 'bank_transfer', 'for part payment for IVF and surrogacy ', 2, 3800000.00, 2600000.00),
(27, 10, 27, 1300000.00, '2024-11-14 00:00:00', 'bank_transfer', 'for  IVF balance ', 2, 2500000.00, 1300000.00),
(28, 10, 27, 1000000.00, '2025-01-16 00:00:00', 'bank_transfer', 'second part payment for surrogacy ', 2, 1500000.00, 1000000.00),
(29, 16, 32, 2000000.00, '2024-11-03 00:00:00', 'online', 'FIRST SURROGACY INSTALLMENTS PAYMENTS ', 1, 3000000.00, 2000000.00),
(30, 11, 28, 1000000.00, '2024-11-14 00:00:00', 'bank_transfer', 'for IVF balance ', 2, 4000000.00, 1000000.00),
(31, 11, 28, 40500.00, '2025-01-29 00:00:00', 'bank_transfer', 'surrogate admission at the hospital', 2, 3959500.00, 40500.00),
(32, 10, 27, 39500.00, '2025-01-23 00:00:00', 'bank_transfer', 'surrogate admission at the hospital', 2, 1460500.00, 39500.00),
(33, 11, 28, 180000.00, '2024-12-17 00:00:00', 'bank_transfer', 'for first post luteal drug', 2, 3779500.00, 180000.00),
(34, 11, 28, 180000.00, '2024-12-31 00:00:00', 'bank_transfer', 'for second post luteal drug', 2, 3599500.00, 180000.00),
(35, 11, 28, 180000.00, '2025-01-14 00:00:00', 'bank_transfer', 'for third post luteal drug', 2, 3419500.00, 180000.00),
(36, 11, 28, 180000.00, '2025-01-24 00:00:00', 'bank_transfer', 'for 4th post luteal drug', 2, 3239500.00, 180000.00),
(37, 11, 28, 180000.00, '2025-02-09 00:00:00', 'bank_transfer', 'for 5th post luteal drug', 2, 3059500.00, 180000.00),
(38, 10, 27, 180000.00, '2024-12-17 00:00:00', 'bank_transfer', 'for first post luteal drug', 2, 1280500.00, 180000.00),
(39, 10, 27, 180000.00, '2024-12-31 00:00:00', 'bank_transfer', 'for second post luteal drug', 2, 1100500.00, 180000.00),
(40, 10, 27, 195000.00, '2025-01-14 00:00:00', 'bank_transfer', 'for 3rd post luteal drug and nurse transport', 2, 905500.00, 195000.00),
(41, 10, 27, 195000.00, '2025-01-28 00:00:00', 'bank_transfer', 'for4th post luteal drug and nurse transport', 2, 710500.00, 195000.00),
(42, 10, 27, 195000.00, '2025-02-10 00:00:00', 'bank_transfer', 'for 5th post luteal drug and nurse transport', 2, 515500.00, 195000.00),
(43, 10, 27, 10000.00, '2025-01-14 00:00:00', 'bank_transfer', 'For first scan done for the surrogate to confirm heartbeat ', 2, 505500.00, 10000.00),
(44, 11, 28, 10000.00, '2025-01-14 00:00:00', 'bank_transfer', 'For first scan done for the surrogate to confirm heartbeat ', 2, 3049500.00, 10000.00),
(45, 11, 28, 5000.00, '2025-02-05 00:00:00', 'bank_transfer', 'for the second scan done for her surrogate', 2, 3044500.00, 5000.00),
(46, 10, 27, 5000.00, '2025-02-04 00:00:00', 'bank_transfer', 'for the second scan done for her surrogate', 2, 500500.00, 5000.00),
(47, 16, 32, 1500000.00, '2024-09-30 00:00:00', 'bank_transfer', 'second part payments for surrogacy ', 1, 1500000.00, 1500000.00),
(48, 11, 28, 25000.00, '2025-03-04 00:00:00', 'bank_transfer', 'for the injection prescribed by the doctor (10days)', 2, 3019500.00, 25000.00),
(49, 11, 28, 80000.00, '2025-02-24 00:00:00', 'bank_transfer', 'for a drug prescribed by the doctor', 2, 2939500.00, 80000.00),
(50, 11, 28, 25000.00, '2025-02-24 00:00:00', 'bank_transfer', 'for surrogate antenatal fee', 2, 2914500.00, 25000.00),
(51, 10, 27, 65000.00, '2025-02-24 00:00:00', 'bank_transfer', 'for antenatal registration for surrogate ', 2, 435500.00, 65000.00),
(52, 10, 27, 19500.00, '2025-03-06 00:00:00', 'bank_transfer', 'For Antenatal visit and drug bought', 2, 416000.00, 19500.00),
(53, 10, 27, 300000.00, '2025-03-11 00:00:00', 'bank_transfer', 'For cervical cerclage ', 2, 116000.00, 300000.00),
(54, 11, 28, 260000.00, '2025-03-09 00:00:00', 'bank_transfer', 'For cervical cerclage and nurse injection fee', 2, 2654500.00, 260000.00),
(55, 13, 30, 2200000.00, '2025-03-07 00:00:00', 'bank_transfer', 'for part payment for surrogacy ', 2, 7800000.00, 2200000.00),
(56, 13, 30, 300000.00, '2025-02-24 00:00:00', 'bank_transfer', 'for sperm freezing ', 2, 7500000.00, 300000.00),
(57, 18, 33, 1500000.00, '2025-03-03 00:00:00', 'bank_transfer', 'for first part payment for surrogacy', 2, 4000000.00, 1500000.00),
(58, 10, 27, 95000.00, '2025-03-13 00:00:00', 'bank_transfer', 'for the drugs after the surrogate cervical cer', 2, 21000.00, 95000.00),
(59, 18, 33, 1300000.00, '2025-03-14 00:00:00', 'bank_transfer', 'part payment for IVF', 2, 2700000.00, 1300000.00),
(60, 16, 32, 50000.00, '2025-03-17 00:00:00', 'bank_transfer', 'Chikwes tfare', 1, 1450000.00, 50000.00),
(61, 11, 28, 30000.00, '2025-03-20 00:00:00', 'bank_transfer', 'For antenatal and drugs', 2, 2624500.00, 30000.00),
(62, 12, 29, 30000.00, '2025-03-21 00:00:00', 'bank_transfer', 'nurse charge', 2, 2970000.00, 30000.00),
(63, 15, 36, 50000.00, '2025-02-08 00:00:00', 'cash', 'for registration ', 2, 8000000.00, 50000.00),
(64, 15, 36, 1000000.00, '2025-02-17 00:00:00', 'bank_transfer', 'deposit for surrogacy', 2, 7000000.00, 1000000.00),
(65, 15, 36, 2000000.00, '2025-03-06 00:00:00', 'bank_transfer', 'part payment for surrogacy', 2, 5000000.00, 2000000.00),
(66, 10, 27, 15000.00, '2025-03-26 00:00:00', 'bank_transfer', 'nurse charge', 2, 6000.00, 15000.00),
(67, 19, 34, 106300.00, '2025-03-03 00:00:00', 'bank_transfer', 'Medication fee', 9, 4893700.00, 106300.00),
(72, 19, 34, 2000000.00, '2024-10-30 00:00:00', 'bank_transfer', 'Payment for surrogacy', 9, -99999999.99, 2000000.00),
(73, 20, 35, 50000.00, '2025-01-30 00:00:00', 'bank_transfer', 'Registration fee', 9, 5550000.00, 50000.00),
(74, 20, 35, 500000.00, '2025-02-17 00:00:00', 'bank_transfer', 'First part payment for surrogacy', 9, 5050000.00, 500000.00),
(75, 19, 34, 500000.00, '2025-02-14 00:00:00', 'bank_transfer', 'Surrogate fee', 9, -99999999.99, 500000.00),
(76, 19, 34, 30000.00, '2025-03-01 00:00:00', 'bank_transfer', 'Medication fee', 9, -99999999.99, 30000.00),
(77, 10, 27, 20000.00, '2025-04-01 00:00:00', 'bank_transfer', 'For Antenatal visit and drugs', 2, -14000.00, 20000.00),
(78, 19, 34, 50940.00, '2025-04-03 00:00:00', 'bank_transfer', 'Atenatal fee', 9, -99999999.99, 50940.00),
(79, 10, 27, 89000.00, '2025-04-10 00:00:00', 'bank_transfer', 'surrogate hospital bill plus feeding and transport', 2, -103000.00, 89000.00),
(80, 16, 32, 1300000.00, '2025-03-28 00:00:00', 'bank_transfer', 'Hospital bill', 1, 150000.00, 1300000.00),
(81, 16, 32, 300000.00, '2025-02-28 00:00:00', 'bank_transfer', 'Hospital bill for babies things', 1, -150000.00, 300000.00),
(82, 11, 28, 40500.00, '2025-04-17 00:00:00', 'bank_transfer', 'For Antenatal visit and drug bought', 2, 2584000.00, 40500.00),
(83, 19, 34, 77990.00, '2025-04-17 00:00:00', 'bank_transfer', 'Atenatal fee', 9, -99999999.99, 77990.00),
(84, 10, 27, 10000.00, '2025-04-24 00:00:00', 'bank_transfer', 'For Antenatal visit and drug bought', 2, -113000.00, 10000.00),
(85, 19, 34, 200000.00, '2025-04-29 00:00:00', 'bank_transfer', 'Part payment for egg donor', 9, -99999999.99, 200000.00),
(86, 19, 34, 130590.00, '2025-05-03 00:00:00', 'bank_transfer', 'Atenatal fee', 9, -99999999.99, 130590.00),
(87, 23, 37, 100000.00, '2025-04-08 00:00:00', 'bank_transfer', 'for registration ', 2, 9180000.00, 100000.00),
(88, 23, 37, 2000000.00, '2025-04-24 00:00:00', 'bank_transfer', '1M FOR IVF AND 1M FOR SURROGATE', 2, 7180000.00, 2000000.00),
(89, 23, 37, 2500000.00, '2025-05-08 00:00:00', 'bank_transfer', '2M FOR IVF AND 500K FOR DONOR', 2, 4680000.00, 2500000.00),
(90, 19, 34, 1300000.00, '2025-05-07 00:00:00', 'bank_transfer', 'Payment for surrogacy', 9, -99999999.99, 1300000.00),
(91, 10, 27, 25000.00, '2025-05-09 00:00:00', 'bank_transfer', 'For Antenatal visit, drug bought and scan', 2, -138000.00, 25000.00),
(92, 11, 28, 500000.00, '2025-05-14 00:00:00', 'bank_transfer', 'for third part payment at 24weeks', 2, 2084000.00, 500000.00),
(93, 10, 27, 700000.00, '2025-05-15 00:00:00', 'bank_transfer', '3rd part payment at 24weeks for surrogacy ', 2, -838000.00, 700000.00),
(94, 19, 34, 39680.00, '2025-05-19 00:00:00', 'bank_transfer', 'Atenatal fee', 9, -99999999.99, 39680.00),
(95, 11, 28, 700000.00, '2025-05-26 00:00:00', 'bank_transfer', 'part payment for final payment of 1m', 2, 1384000.00, 700000.00),
(96, 11, 28, 300000.00, '2025-05-27 00:00:00', 'bank_transfer', 'for completion of the 1m final payment', 2, 1084000.00, 300000.00),
(97, 20, 35, 45440.00, '2025-05-28 00:00:00', 'bank_transfer', 'Atenatal fee', 9, 5004560.00, 45440.00),
(98, 22, 38, 1000000.00, '2025-04-11 00:00:00', 'bank_transfer', 'Payment for surrogacy', 9, 1100000.00, 1000000.00),
(99, 19, 34, 31800.00, '2025-05-30 00:00:00', 'bank_transfer', 'Atenatal fee', 9, -99999999.99, 31800.00),
(114, 19, 34, 2700000.00, '2025-06-05 00:00:00', 'bank_transfer', 'Balance for Surrogacy and Delivery fee', 9, -99999999.99, 2700000.00),
(115, 23, 37, 2200000.00, '2025-06-05 00:00:00', 'bank_transfer', 'For IVF and part payment of surrogacy ', 2, 2479972.00, 2200000.00),
(116, 20, 35, 20000.00, '2025-06-23 00:00:00', 'bank_transfer', 'Medication fee', 9, 4984560.00, 20000.00);

-- --------------------------------------------------------

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `permission_id` int(11) NOT NULL,
  `permission_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`permission_id`, `permission_name`) VALUES
(18, 'Manage Branches'),
(20, 'Manage Donors'),
(7, 'Manage Finance'),
(21, 'Manage Intended Parents'),
(3, 'Manage Projects'),
(6, 'Manage Surrogacy Workflow'),
(19, 'Manage Surrogates'),
(4, 'Manage Tasks'),
(1, 'Manage Users'),
(5, 'Send Messages'),
(17, 'View Financials'),
(2, 'View Reports');

-- --------------------------------------------------------

--
-- Table structure for table `projects`
--

CREATE TABLE `projects` (
  `project_id` int(11) NOT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `client_id` int(11) DEFAULT NULL,
  `surrogate_id` int(11) DEFAULT NULL,
  `project_name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `status` enum('pending','in_progress','completed','archived') DEFAULT 'pending',
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `file_path` varchar(255) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `balance` decimal(15,2) DEFAULT 0.00,
  `amount_paid` decimal(10,2) NOT NULL DEFAULT 0.00
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `projects`
--

INSERT INTO `projects` (`project_id`, `branch_id`, `client_id`, `surrogate_id`, `project_name`, `description`, `status`, `start_date`, `end_date`, `created_at`, `updated_at`, `file_path`, `amount`, `balance`, `amount_paid`) VALUES
(25, 2, 8, 2, 'surrogacy program', 'a surrogacy program ', 'completed', '2025-02-22', '2025-12-25', '2025-02-22 07:22:56', '2025-02-28 11:59:55', NULL, 5000000.00, 0.00, 0.00),
(26, 1, 9, 3, 'SURROGACY ', 'TO PROVIDE AND MANAGE HER SURROGATE ', 'in_progress', '2024-11-26', '2025-11-26', '2025-02-24 11:58:51', '2025-02-26 14:43:42', NULL, 4500000.00, 0.00, 0.00),
(27, 2, 10, 4, 'SURROGACY PH IP1', 'This is an ongoing surrogacy program for an intending parents that bases in Port Harcourt Nigeria,  which started on the 22nd October 2024 with the surrogate starting her medications at the hospital. The Embryo transfer was done on the 7th December 2024. The surrogate was confirmed pregnant on the 30th December 2024. the surrogate has done 2nd scans and has started Antenatal visits and she is currently 13weeks plus pregnant with twins.', 'in_progress', '2024-10-22', '2025-08-27', '2025-02-25 13:59:05', '2025-02-28 09:00:59', NULL, 6450000.00, 0.00, 0.00),
(28, 2, 11, 5, 'SURROGACY ANAMBRA   IP2', 'This is an ongoing surrogacy program for an intending parents that bases in Awka, Anambra state, which started on the 22nd October 2024 with the surrogate starting her medications at the hospital. The Embryo transfer was done on the 7th December 2024. The surrogate was confirmed pregnant on the 30th December 2024. the surrogate has done 2nd scans and has started Antenatal visits and she is currently 13weeks plus pregnant. She has been admitted twice at the hospital, firstly for malaria  on 28th January 2025. secondly for threatened miscarriage on the 19th February 2025 which was managed effectively by the doctor. ', 'in_progress', '2024-10-22', '2025-08-27', '2025-02-26 09:09:50', '2025-02-28 09:01:38', NULL, 6550000.00, 0.00, 0.00),
(29, 2, 12, 6, 'SURROGACY (MR. WILLIAMS) IP3', 'This is an ongoing surrogacy program which started on the 21st January 2025 with the surrogate starting her medications at the hospital. The Embryo transfer is yet to be done. Here, we only cover for the surrogate management while the intending parent covers for the payment of IVF payment which they directly to their preferred hospital(they use a different hospital from ours) Mr. Williams serves as a middle man between us and the intending parents. The intending parents bases in Abuja, Nigeria.', 'in_progress', '2025-01-21', '2025-12-28', '2025-02-26 09:23:55', '2025-02-28 09:00:36', NULL, 5050000.00, 0.00, 0.00),
(30, 2, 13, 7, 'SURROGACY  UK IP4', 'This is an ongoing surrogacy program, The intending parents is based in the United Kingdom. The intending parents are using their sperm and a donor\'s egg(chocolate, O+, AA). The surrogate has done the necessary medical investigations and on medications.', 'in_progress', '2025-02-06', '2026-01-12', '2025-02-26 11:48:53', '2025-02-28 09:00:04', NULL, 14050000.00, 0.00, 0.00),
(31, 1, 14, 8, 'SURROGACY ', 'PROVIDE AND MANAGE THE SURROGATE FROM START TO FULL TERM', 'in_progress', '2024-10-17', '2025-10-16', '2025-02-26 14:43:13', '2025-02-26 14:44:06', NULL, 6000000.00, 0.00, 0.00),
(32, 1, 16, 9, 'SURROGACY ', 'Surrogacy program ', 'in_progress', '2024-11-03', '2025-11-04', '2025-03-03 11:08:51', '2025-03-03 11:08:51', NULL, 5000000.00, 0.00, 0.00),
(33, 2, 18, 10, 'SURROGACY USA IP 5', 'This is a client who is based in USA, she has used one of our branches before but she is currently using Enugu branch. she will be using donor\'s egg for the procedure. ', 'in_progress', '2025-03-13', '2026-12-31', '2025-03-13 13:38:46', '2025-03-26 15:33:04', NULL, 5500000.00, 0.00, 0.00),
(34, 9, 19, 11, 'Surrogacy Project', 'Surrogacy Program', 'completed', '2024-09-26', '2025-09-26', '2025-03-14 11:43:50', '2025-06-23 13:35:21', NULL, 5000000.00, 0.00, 0.00),
(35, 9, 20, 12, 'Surrogacy Project', 'Surrogacy program', 'in_progress', '2025-03-14', '2026-03-15', '2025-03-14 12:00:12', '2025-03-14 12:00:12', NULL, 5600000.00, 0.00, 0.00),
(36, 2, 15, 14, 'SURROGACY EBONYI IP6', 'This is a surrogacy program, which the intending parents resides in Ebonyi state. Here, a donor\'s egg will be used together with the Intending Father\'s sperm for the feralization of an embryo. This program will follow the April batch of IVF at the facility. ', 'in_progress', '2025-03-26', '2026-12-31', '2025-03-27 07:58:36', '2025-03-27 07:58:36', NULL, 8050000.00, 0.00, 0.00),
(37, 2, 23, 10, 'SURROGACY USA/ ENU LAWERENCE', 'This is a new surrogacy program, the IP is professor based in New York. He is a single young man, who will go with a donor\'s egg and his own sperm during the course of the program. ', 'in_progress', '2025-05-07', '2026-02-12', '2025-05-08 07:50:20', '2025-05-08 07:50:20', NULL, 9280000.00, 0.00, 0.00),
(38, 9, 22, 15, 'Surrogacy Project', 'Ivf Programme', 'in_progress', '2025-04-11', '2026-04-12', '2025-05-28 13:06:55', '2025-05-28 13:06:55', NULL, 2100000.00, 0.00, 0.00);

-- --------------------------------------------------------

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `role_id` int(11) NOT NULL,
  `role_name` varchar(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`role_id`, `role_name`) VALUES
(1, 'Admin'),
(2, 'Branch Manager'),
(19, 'client'),
(18, 'Donor'),
(16, 'Intended Parent'),
(3, 'Staff'),
(17, 'Surrogate');

-- --------------------------------------------------------

--
-- Table structure for table `role_permissions`
--

CREATE TABLE `role_permissions` (
  `role_permission_id` int(11) NOT NULL,
  `role_id` int(11) NOT NULL,
  `permission_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `role_permissions`
--

INSERT INTO `role_permissions` (`role_permission_id`, `role_id`, `permission_id`) VALUES
(1, 1, 1),
(2, 1, 2),
(3, 1, 3),
(4, 1, 4),
(5, 1, 5),
(6, 1, 6),
(7, 1, 7),
(8, 1, 17),
(9, 1, 18),
(10, 1, 19),
(11, 1, 20),
(12, 1, 21),
(16, 1, 1),
(17, 1, 2),
(18, 1, 3),
(19, 1, 4),
(20, 1, 5),
(21, 1, 6),
(22, 1, 7),
(23, 1, 17),
(24, 1, 18),
(25, 1, 19),
(26, 1, 20),
(27, 1, 21),
(31, 2, 18),
(32, 2, 3),
(33, 2, 4),
(34, 2, 17),
(38, 2, 18),
(39, 2, 3),
(40, 2, 4),
(41, 2, 17),
(45, 3, 4),
(46, 3, 4);

-- --------------------------------------------------------

--
-- Table structure for table `surrogacy_stages`
--

CREATE TABLE `surrogacy_stages` (
  `stage_id` int(11) NOT NULL,
  `stage_name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `parent_stage_id` int(11) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `status` enum('pending','in_progress','completed') DEFAULT 'pending',
  `project_id` int(11) DEFAULT NULL,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `surrogacy_stages`
--

INSERT INTO `surrogacy_stages` (`stage_id`, `stage_name`, `description`, `parent_stage_id`, `start_date`, `end_date`, `status`, `project_id`, `updated_at`) VALUES
(1, 'Inquiry and Consultation', 'Initial inquiry and consultation with intended parents and surrogates.', NULL, '2024-12-05', '2024-12-31', 'in_progress', NULL, '2025-03-02 12:52:01'),
(2, 'Application and Screening', 'Complete application forms and conduct screenings.', 1, NULL, NULL, 'pending', NULL, '2025-03-02 12:52:01'),
(3, 'Matching and Agreement', 'Match surrogates with intended parents and finalize agreements.', 2, NULL, NULL, 'pending', NULL, '2025-03-02 12:52:01'),
(4, 'Medical Preparation', 'Prepare for embryo transfer.', 3, NULL, NULL, 'pending', NULL, '2025-03-02 12:52:01'),
(5, 'Pregnancy Monitoring', 'Monitor the pregnancy through regular checkups.', 4, NULL, NULL, 'pending', NULL, '2025-03-02 12:52:01'),
(6, 'Delivery and Handover', 'Facilitate delivery and handover process.', 5, NULL, NULL, 'pending', NULL, '2025-03-02 12:52:01'),
(7, 'Post-Delivery Support', 'Provide post-delivery medical and emotional care.', 6, NULL, NULL, 'pending', NULL, '2025-03-02 12:52:01'),
(8, 'Follow-Up and Feedback', 'Collect feedback and perform periodic check-ins.', 7, NULL, NULL, 'pending', NULL, '2025-03-02 12:52:01'),
(9, '', '', NULL, NULL, NULL, NULL, NULL, '2025-03-02 12:52:01'),
(10, 'Initial Consultation', '', NULL, '0000-00-00', '0000-00-00', 'completed', 16, '2025-03-02 12:52:01'),
(11, '', '', NULL, NULL, NULL, NULL, NULL, '2025-03-02 12:52:01'),
(12, 'Delivery', '', NULL, '0000-00-00', '0000-00-00', 'completed', 2, '2025-03-02 12:52:01'),
(13, '', '', NULL, NULL, NULL, NULL, NULL, '2025-03-02 12:52:01'),
(14, '', '', NULL, NULL, NULL, NULL, NULL, '2025-03-02 12:52:01'),
(15, 'Initial Consultation', '', NULL, '0000-00-00', '0000-00-00', 'completed', 1, '2025-03-02 12:52:01'),
(17, '', '', NULL, NULL, NULL, NULL, NULL, '2025-03-02 12:52:01'),
(18, 'Medical Screening', '', NULL, '0000-00-00', '0000-00-00', 'completed', 1, '2025-03-02 12:52:01'),
(19, '', '', NULL, NULL, NULL, NULL, NULL, '2025-03-02 12:52:01'),
(20, '', '', NULL, NULL, NULL, NULL, NULL, '2025-03-02 12:52:01'),
(21, 'Legal Agreements', '', NULL, '2025-02-21', '0000-00-00', 'completed', 1, '2025-03-02 12:52:01'),
(22, 'Pregnancy Confirmation', 'After two weeks, a blood test confirms pregnancy.', NULL, '0000-00-00', '0000-00-00', 'completed', 1, '2025-03-02 12:52:01'),
(23, '', '', NULL, NULL, NULL, NULL, NULL, '2025-03-02 12:52:01'),
(24, '', '', NULL, NULL, NULL, NULL, 3, '2025-03-02 12:52:01'),
(25, '', '', NULL, NULL, NULL, NULL, NULL, '2025-03-02 12:52:01'),
(26, '', '', NULL, NULL, NULL, NULL, NULL, '2025-03-02 12:52:01'),
(27, '', '', NULL, NULL, NULL, NULL, NULL, '2025-03-02 12:52:01'),
(28, '', '', NULL, NULL, NULL, NULL, NULL, '2025-03-02 12:52:01'),
(29, '', '', NULL, NULL, NULL, NULL, 3, '2025-03-02 12:52:01'),
(30, '', '', NULL, NULL, NULL, NULL, 4, '2025-03-02 12:52:01'),
(31, 'Legal Agreements', 'Contracts outlining responsibilities, compensation, medical care, and legal rights.', NULL, '0000-00-00', NULL, 'completed', 5, '2025-03-02 12:52:01'),
(32, '', '', NULL, NULL, NULL, NULL, 5, '2025-03-02 12:52:01'),
(33, 'Medical Screening', 'Blood tests, ultrasound, and uterine evaluation for the surrogate.', NULL, '2025-02-15', NULL, 'completed', 16, '2025-03-02 12:52:01'),
(34, 'Legal Agreements', 'Contracts outlining responsibilities, compensation, medical care, and legal rights.', NULL, '0000-00-00', '2025-02-15', 'completed', 16, '2025-03-02 12:52:01'),
(35, 'Embryo Transfer', 'A fertilized embryo (from intended parents or donors) is transferred into the surrogate’s uterus.', NULL, '2025-02-15', '2025-02-15', 'completed', 16, '2025-03-02 12:52:01'),
(36, 'Pregnancy Confirmation', 'After two weeks, a blood test confirms pregnancy.', NULL, '2025-02-13', '2025-02-15', 'completed', 16, '2025-03-02 12:52:01'),
(37, 'Delivery', 'The surrogate delivers the baby at a pre-selected hospital.', NULL, '2025-02-15', NULL, 'completed', 16, '2025-03-02 12:52:01'),
(38, 'Medical Screening', 'Blood tests, ultrasound, and uterine evaluation for the surrogate.', NULL, '2025-02-11', NULL, 'completed', 17, '2025-03-02 12:52:01'),
(39, 'Initial Consultation', 'Intended parents (IPs) and surrogates meet with an agency or fertility clinic.', NULL, '2025-02-15', NULL, 'completed', 17, '2025-03-02 12:52:01'),
(40, 'Legal Agreements', 'Contracts outlining responsibilities, compensation, medical care, and legal rights.', NULL, '2025-02-15', NULL, 'completed', 17, '2025-03-02 12:52:01'),
(41, 'Embryo Transfer', 'A fertilized embryo (from intended parents or donors) is transferred into the surrogate’s uterus.', NULL, '2025-02-14', NULL, 'completed', 17, '2025-03-02 12:52:01'),
(42, 'Pregnancy Confirmation', 'After two weeks, a blood test confirms pregnancy.', NULL, '2025-02-15', NULL, 'completed', 17, '2025-03-02 12:52:01'),
(43, 'Delivery', 'The surrogate delivers the baby at a pre-selected hospital.', NULL, '2025-02-15', NULL, 'completed', 17, '2025-03-02 12:52:01'),
(44, 'Legal Agreements', 'Contracts outlining responsibilities, compensation, medical care, and legal rights.', NULL, '2025-02-21', NULL, 'completed', 1, '2025-03-02 12:52:01'),
(45, 'Legal Agreements', 'Contracts outlining responsibilities, compensation, medical care, and legal rights.', NULL, '2025-02-21', NULL, 'completed', 1, '2025-03-02 12:52:01'),
(46, 'Initial Consultation', 'Intended parents (IPs) and surrogates meet with an agency or fertility clinic.', NULL, '2025-02-21', NULL, 'in_progress', 23, '2025-03-02 12:52:01'),
(47, 'Initial Consultation', 'Intended parents (IPs) and surrogates meet with an agency or fertility clinic.', NULL, '2025-02-22', NULL, 'completed', 25, '2025-03-02 12:52:01'),
(48, 'Medical Screening', 'Blood tests, ultrasound, and uterine evaluation for the surrogate.', NULL, '2025-02-22', NULL, 'completed', 25, '2025-03-02 12:52:01'),
(49, 'Legal Agreements', 'Contracts outlining responsibilities, compensation, medical care, and legal rights.', NULL, '2025-02-22', NULL, 'completed', 25, '2025-03-02 12:52:01'),
(50, 'Embryo Transfer', 'A fertilized embryo (from intended parents or donors) is transferred into the surrogate’s uterus.', NULL, '2025-02-22', NULL, 'completed', 25, '2025-03-02 12:52:01'),
(51, 'Pregnancy Confirmation', 'After two weeks, a blood test confirms pregnancy.', NULL, '2025-02-22', NULL, 'completed', 25, '2025-03-02 12:52:01'),
(52, 'Delivery', 'The surrogate delivers the baby at a pre-selected hospital.', NULL, '2025-02-22', NULL, 'completed', 25, '2025-03-02 12:52:01'),
(53, 'Initial Consultation', 'Intended parents (IPs) and surrogates meet with an agency or fertility clinic.', NULL, '2025-02-24', NULL, 'completed', 26, '2025-03-02 12:52:01'),
(54, 'Legal Agreements', 'Contracts outlining responsibilities, compensation, medical care, and legal rights.', NULL, '2025-02-24', NULL, 'completed', 26, '2025-03-02 12:52:01'),
(55, 'Medical Screening', 'Blood tests, ultrasound, and uterine evaluation for the surrogate.', NULL, '2025-02-24', NULL, 'pending', 26, '2025-03-02 12:52:01'),
(56, 'Initial Consultation', 'Intended parents (IPs) and surrogates meet with an agency or fertility clinic.', NULL, '2025-01-16', NULL, 'completed', 30, '2025-03-04 11:36:35'),
(57, 'Medical Screening', 'Blood tests, ultrasound, and uterine evaluation for the surrogate.', NULL, '2025-02-21', NULL, 'completed', 30, '2025-03-04 11:39:53'),
(58, 'Legal Agreements', 'Contracts outlining responsibilities, compensation, medical care, and legal rights.', NULL, '2025-02-06', NULL, 'completed', 30, '2025-03-04 11:40:46'),
(59, 'Initial Consultation', 'Intended parents (IPs) and surrogates meet with an agency or fertility clinic.', NULL, '2024-10-02', NULL, 'completed', 27, '2025-03-04 11:42:05'),
(60, 'Medical Screening', 'Blood tests, ultrasound, and uterine evaluation for the surrogate.', NULL, '2024-10-30', NULL, 'completed', 27, '2025-03-04 11:43:34'),
(61, 'Legal Agreements', 'Contracts outlining responsibilities, compensation, medical care, and legal rights.', NULL, '2024-11-08', NULL, 'completed', 27, '2025-03-04 11:44:27'),
(62, 'Embryo Transfer', 'A fertilized embryo (from intended parents or donors) is transferred into the surrogate’s uterus.', NULL, '2024-12-18', NULL, 'completed', 27, '2025-03-04 11:45:58'),
(63, 'Pregnancy Confirmation', 'After two weeks, a blood test confirms pregnancy.', NULL, '2024-12-31', NULL, 'completed', 27, '2025-03-04 11:46:54'),
(64, 'Initial Consultation', 'Intended parents (IPs) and surrogates meet with an agency or fertility clinic.', NULL, '2024-10-10', NULL, 'completed', 28, '2025-03-04 11:47:51'),
(65, 'Medical Screening', 'Blood tests, ultrasound, and uterine evaluation for the surrogate.', NULL, '2024-11-01', NULL, 'completed', 28, '2025-03-04 11:49:38'),
(66, 'Legal Agreements', 'Contracts outlining responsibilities, compensation, medical care, and legal rights.', NULL, '2024-11-07', NULL, 'completed', 28, '2025-03-04 11:50:20'),
(67, 'Embryo Transfer', 'A fertilized embryo (from intended parents or donors) is transferred into the surrogate’s uterus.', NULL, '2024-12-18', NULL, 'completed', 28, '2025-03-04 11:50:57'),
(68, 'Pregnancy Confirmation', 'After two weeks, a blood test confirms pregnancy.', NULL, '2024-12-31', NULL, 'completed', 28, '2025-03-04 11:51:44'),
(69, 'Initial Consultation', 'Intended parents (IPs) and surrogates meet with an agency or fertility clinic.', NULL, '2024-11-04', NULL, 'completed', 29, '2025-03-04 12:23:11'),
(70, 'Medical Screening', 'Blood tests, ultrasound, and uterine evaluation for the surrogate.', NULL, '2025-01-16', NULL, 'completed', 29, '2025-03-04 12:24:08'),
(71, 'Legal Agreements', 'Contracts outlining responsibilities, compensation, medical care, and legal rights.', NULL, '2025-01-23', NULL, 'completed', 29, '2025-03-04 12:24:44'),
(72, 'Embryo Transfer', 'A fertilized embryo (from intended parents or donors) is transferred into the surrogate’s uterus.', NULL, '2025-03-07', NULL, 'completed', 29, '2025-03-13 13:28:40'),
(73, 'Initial Consultation', 'Intended parents (IPs) and surrogates meet with an agency or fertility clinic.', NULL, '2025-03-03', NULL, 'completed', 33, '2025-03-13 14:45:46'),
(74, 'Medical Screening', 'Blood tests, ultrasound, and uterine evaluation for the surrogate.', NULL, '2025-03-13', NULL, 'completed', 33, '2025-03-13 14:46:06'),
(75, 'Legal Agreements', 'Contracts outlining responsibilities, compensation, medical care, and legal rights.', NULL, '2025-03-18', NULL, 'completed', 33, '2025-03-27 08:07:18'),
(76, 'Embryo Transfer', 'A fertilized embryo (from intended parents or donors) is transferred into the surrogate’s uterus.', NULL, '2025-03-26', NULL, 'completed', 30, '2025-03-27 08:04:18'),
(77, 'Initial Consultation', 'Intended parents (IPs) and surrogates meet with an agency or fertility clinic.', NULL, '2025-02-08', NULL, 'completed', 36, '2025-03-27 08:05:18'),
(78, 'Medical Screening', 'Blood tests, ultrasound, and uterine evaluation for the surrogate.', NULL, '2025-03-26', NULL, 'completed', 36, '2025-03-27 08:05:46'),
(79, 'Medical Screening', 'Blood tests, ultrasound, and uterine evaluation for the surrogate.', NULL, '2025-05-08', NULL, 'completed', 34, '2025-05-26 11:10:43'),
(80, 'Legal Agreements', 'Contracts outlining responsibilities, compensation, medical care, and legal rights.', NULL, '2025-03-27', NULL, 'in_progress', 35, '2025-03-28 08:01:13'),
(81, 'Legal Agreements', 'Contracts outlining responsibilities, compensation, medical care, and legal rights.', NULL, '2025-05-19', NULL, 'completed', 34, '2025-05-26 11:07:28'),
(82, 'Initial Consultation', 'Intended parents (IPs) and surrogates meet with an agency or fertility clinic.', NULL, '2025-03-12', NULL, 'completed', 34, '2025-03-28 09:13:59'),
(83, 'Legal Agreements', 'Contracts outlining responsibilities, compensation, medical care, and legal rights.', NULL, '2025-03-28', NULL, 'completed', 36, '2025-03-28 09:39:41'),
(84, 'Embryo Transfer', 'A fertilized embryo (from intended parents or donors) is transferred into the surrogate’s uterus.', NULL, '2025-04-11', NULL, 'completed', 34, '2025-04-14 10:20:44'),
(85, 'Initial Consultation', 'Intended parents (IPs) and surrogates meet with an agency or fertility clinic.', NULL, '2025-04-08', NULL, 'completed', 37, '2025-05-08 07:51:28'),
(86, 'Pregnancy Confirmation', 'After two weeks, a blood test confirms pregnancy.', NULL, '2025-06-19', NULL, 'in_progress', 34, '2025-06-23 13:39:04');

-- --------------------------------------------------------

--
-- Table structure for table `surrogates`
--

CREATE TABLE `surrogates` (
  `surrogate_id` int(11) NOT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `first_name` varchar(100) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `dob` date DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `nationality` varchar(100) DEFAULT NULL,
  `marital_status` enum('single','married','divorced','widowed') DEFAULT NULL,
  `number_of_children` int(11) DEFAULT NULL,
  `previous_surrogacy` enum('yes','no') DEFAULT NULL,
  `height` decimal(5,2) DEFAULT NULL,
  `weight` decimal(5,2) DEFAULT NULL,
  `bmi` decimal(5,2) DEFAULT NULL,
  `blood_type` varchar(10) DEFAULT NULL,
  `medical_conditions` text DEFAULT NULL,
  `lifestyle` text DEFAULT NULL,
  `pregnancy_history` text DEFAULT NULL,
  `contract_signed` enum('yes','no','pending') DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive','pending') DEFAULT NULL,
  `email` varchar(150) NOT NULL,
  `phone` varchar(15) DEFAULT NULL,
  `medical_history` text DEFAULT NULL,
  `availability_status` enum('available','matched','inactive') DEFAULT 'available',
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `surrogates`
--

INSERT INTO `surrogates` (`surrogate_id`, `branch_id`, `first_name`, `last_name`, `dob`, `address`, `nationality`, `marital_status`, `number_of_children`, `previous_surrogacy`, `height`, `weight`, `bmi`, `blood_type`, `medical_conditions`, `lifestyle`, `pregnancy_history`, `contract_signed`, `photo`, `status`, `email`, `phone`, `medical_history`, `availability_status`, `created_at`, `updated_at`) VALUES
(2, 2, 'Christian', 'Ifeanyi', '1999-04-23', '651 N Broad Street Middletown Delaware US', 'Nigeria', 'single', 1, 'no', 5.00, 75.00, -0.40, 'slim', 'healthy', 'love reading and traveling ', 'twice', 'yes', NULL, 'active', 'admin@chrisworld.com', '091131259', 'investigation done and qualify', 'available', '2025-02-22 07:18:53', '2025-02-22 07:18:53'),
(3, 1, 'YUSUF', 'ANIFAT', '1996-10-28', '37,ALLI STREETS ITAFAJI LAGOS ', 'Nigeria', 'single', 1, 'no', 6.00, 65.00, 25.00, 'O+', 'pending ', 'fashion designer', 'ONCE', 'yes', NULL, 'active', 'Titilopeanifat626@gmail.com', '09133237253', 'pending ', 'available', '2025-02-24 11:42:21', '2025-02-24 11:42:21'),
(4, 2, 'EZE', 'CHINAZA FLORENCE', '1999-06-12', 'Obollo afor, nsukka Enugu', 'Nigeria', 'single', 1, 'no', 5.00, 67.00, 18.00, 'O+', 'Healthy and Satisfactory ', 'she doesn\'t drink or smokes', 'She has had one previous pregnancy ', 'yes', 'IMG-20250225-WA0001.jpg', 'active', 'florence1998@gmail.com', '08065700512', 'healthy and fit to be a surrogate mother', 'available', '2025-02-25 13:00:10', '2025-02-25 13:00:10'),
(5, 2, 'JOHN ', 'GIFT ', '2000-10-22', '33 AGAYIBA STREET ST MARYLAND OPPOSIT CUBANA BAR INDEPENDECE LAYOUT ENUGU', 'Nigeria', 'single', 1, 'no', 5.00, 65.00, 18.00, 'O+', 'Healthy and Satisfactory ', 'She has a healthy lifestyle, she doesn\'t drink or smokes', 'Has had one previous pregnancy, which has a living male child', 'yes', 'IMG-20241031-WA0010[1].jpg', 'active', 'giftyjohn205@gmail.com', '07031958540', 'medical fit to be a surrogate mother', 'available', '2025-02-25 13:12:17', '2025-02-25 13:12:17'),
(6, 2, 'UCHENDU', 'CHIWEMMERI QUEEN', '1999-12-23', '24 Kingsway Bridal road Aria Market New market Enugu', 'Nigeria', 'single', 1, 'no', 5.00, 62.00, 18.00, 'O+', 'Healthy and Medically fit for the procedures', 'She has a healthy lifestyle, good moral behaviour, she doesn\'t smoke or drinks', 'She has had one previous pregnancy ', 'yes', 'IMG-20241102-WA0003[1].jpg', 'active', 'uchenduchiwemmeri@gmail.com', '07048856111', 'No significant medical history that will be be detrimental to the program. she is fit', 'available', '2025-02-25 13:35:42', '2025-02-25 13:35:42'),
(7, 2, 'AGBO', 'UKAMAKA NATALIA', '1999-01-03', 'Ezeakwu village, Eha-aloma Nsukka', 'Nigeria', 'single', 1, 'no', 6.00, 70.00, 20.00, 'O+', 'From all the medical investigations done, she is medical fit to be a surrogate mother', 'She has a healthy lifestyles ', 'Only one previous pregnancy ', 'yes', NULL, 'active', 'agboukamaka40@gmail.com', '09070790475', 'Healthy and Satisfactory ', 'available', '2025-02-25 13:41:01', '2025-02-25 13:41:01'),
(8, 1, 'AUSTIN ', 'PATIENCE ', '1997-09-30', 'Agbara ijuri lusada ogun state', 'Nigeria', 'single', 2, 'no', 6.00, 65.00, 25.00, 'O+', 'good ', 'unquestionable', '2 times ', 'yes', NULL, 'active', 'patienceaustin3@gmail.com', '09025448534', 'Good ', 'available', '2025-02-26 14:33:02', '2025-02-26 14:33:02'),
(9, 1, 'Emordi', 'Chikwe', '1996-06-28', '26 camp davis road,Ayobo lagos', 'Nigeria', 'single', 2, 'no', 6.00, 65.00, 25.00, 'O+', 'Good ', 'Encouraging ', '2', 'yes', NULL, 'active', 'chikwesus23@gmail.com', '09134117372', 'Good  ', 'available', '2025-02-27 13:28:04', '2025-02-27 13:28:04'),
(10, 2, 'ENEKWEMCHI', 'DIVINE AMARACHI', '1998-09-19', 'NO 4 COLLEGE ROAD ABAKPA NIKE ENUGU', 'Nigeria', 'single', 1, 'no', 5.00, 69.00, 18.00, 'D+', 'Satisfactory and fit to be a surrogate mother', 'healthy lifestyle', 'Have had one pregnancy history which resulted to a child. ', 'no', 'IMG_20250313_140914470[1].jpg', 'active', 'EnekwemchiDivine20@gmail.com', '08090718010', 'no significant medical history that will be detrimental to the program', 'available', '2025-03-13 13:20:50', '2025-03-13 13:20:50'),
(11, 9, 'anachuna', 'florence', '1999-07-01', 'apo,abuja', 'Nigeria', 'single', 1, 'no', 158.00, 60.00, 24.10, 'o+', 'no', 'extrovert', '1', 'yes', NULL, 'active', 'johnflorence@gmail.com', '09131977893', 'none', 'available', '2025-03-13 14:34:24', '2025-03-13 14:34:24'),
(12, 9, 'Obiayo', 'Ifunanya Marvellous', '1999-07-20', 'Aba,Abia state', 'Nigeria', 'single', 1, 'no', 158.00, 40.00, 17.80, 'A+', 'none', 'introvert', '2', 'yes', NULL, 'active', 'marvyikem635@gmail.com', '08169148273', 'none', 'available', '2025-03-14 11:06:59', '2025-03-14 11:06:59'),
(13, 1, 'Samuel ', 'Regina', '2000-03-09', 'no 13,Allioludegun strt Ayobo', 'Nigeria', 'single', 1, 'no', 6.00, 65.00, 25.00, 'O+', 'good ', 'unquestionable', '1 times ', 'yes', NULL, 'active', 'reginasamuel0309@gmail.com', '08060697087', 'Good ', 'available', '2025-03-20 13:58:05', '2025-03-20 13:58:05'),
(14, 2, 'OKEREKE', 'OLUCHI PRINCESS', '2003-12-17', 'Agbani road Enugu', 'Nigeria', 'single', 1, 'no', 5.00, 60.00, 18.00, 'O+', 'Satisfactory ', 'No negative lifestyle that will be harmful to the baby', 'Has had one previous pregnancy, which the baby is two years old now', 'yes', 'IMG_20250326_162038040[1].jpg', 'active', 'princessokerekeo@gmail.com', '09011973749', 'Satisfactory and healthy or fit to be a surroagte mother', 'available', '2025-03-26 15:27:59', '2025-03-26 15:27:59'),
(15, 9, 'Nwankwo', 'chidimma', '1999-09-30', 'No.4 opposite Patriot School Kubwa abuja.', 'Nigeria', 'single', 1, 'yes', 104.00, 74.00, 68.40, 'B+', 'NONE', 'work and Productivity', '2.', 'yes', NULL, 'active', 'QueenKalu@gmail.com', '08165540133', 'None', 'available', '2025-05-19 10:06:45', '2025-05-19 10:06:45');

-- --------------------------------------------------------

--
-- Table structure for table `tasks`
--

CREATE TABLE `tasks` (
  `task_id` int(11) NOT NULL,
  `project_id` int(11) DEFAULT NULL,
  `assigned_to` int(11) DEFAULT NULL,
  `task_name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `priority` enum('low','medium','high') DEFAULT 'medium',
  `position` int(11) DEFAULT 0,
  `dependent_task_id` int(11) DEFAULT NULL,
  `status` enum('pending','in_progress','completed') DEFAULT 'pending',
  `deadline` datetime NOT NULL,
  `created_at` datetime DEFAULT current_timestamp(),
  `updated_at` datetime DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `type` enum('general','donation') DEFAULT 'general',
  `amount` decimal(10,2) DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `tasks`
--

INSERT INTO `tasks` (`task_id`, `project_id`, `assigned_to`, `task_name`, `description`, `start_date`, `priority`, `position`, `dependent_task_id`, `status`, `deadline`, `created_at`, `updated_at`, `type`, `amount`, `branch_id`) VALUES
(2, NULL, 15, 'content', 'Post one of the flyer on our pages.', NULL, 'high', 0, NULL, 'pending', '2025-07-01 17:00:00', '2025-06-30 15:43:07', '2025-06-30 15:43:07', 'general', NULL, 11);

-- --------------------------------------------------------

--
-- Table structure for table `transactions`
--

CREATE TABLE `transactions` (
  `transaction_id` int(11) NOT NULL,
  `client_id` int(11) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `transaction_date` date DEFAULT NULL,
  `description` text DEFAULT NULL,
  `branch_id` int(11) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

-- --------------------------------------------------------

--
-- Table structure for table `user_activity_logs`
--

CREATE TABLE `user_activity_logs` (
  `log_id` int(11) NOT NULL,
  `user_id` int(11) UNSIGNED DEFAULT NULL,
  `activity_description` text NOT NULL,
  `created_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_activity_logs`
--

INSERT INTO `user_activity_logs` (`log_id`, `user_id`, `activity_description`, `created_at`) VALUES
(1, 9, 'Sent a message to user ID 1', '2024-12-05 12:40:11'),
(2, 2, 'Sent a message to user ID 6', '2025-02-14 08:48:41'),
(3, 2, 'Sent a message to user ID 1', '2025-02-14 18:33:05'),
(4, 2, 'Sent a message to user ID 15', '2025-02-14 20:20:12'),
(5, 15, 'Sent a message to user ID 1', '2025-02-14 20:22:07'),
(6, 2, 'Created a new task: post the event', '2025-02-15 22:53:36');

-- --------------------------------------------------------

--
-- Table structure for table `workflow_stages`
--

CREATE TABLE `workflow_stages` (
  `stage_id` int(11) NOT NULL,
  `stage_name` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `parent_stage_id` int(11) DEFAULT NULL,
  `status` enum('pending','in_progress','completed') DEFAULT 'pending',
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `workflow_stages`
--

INSERT INTO `workflow_stages` (`stage_id`, `stage_name`, `description`, `parent_stage_id`, `status`, `start_date`, `end_date`) VALUES
(1, 'Inquiry and Consultation', 'Initial inquiry and consultation with intended parents and surrogates.', NULL, 'in_progress', NULL, NULL),
(2, 'Application and Screening', 'Complete application forms and conduct screenings.', NULL, 'completed', NULL, NULL),
(3, 'Matching and Agreement', 'Match surrogates with intended parents and finalize agreements.', NULL, 'pending', NULL, NULL),
(4, 'Medical Preparation', 'Prepare for embryo transfer.', NULL, 'pending', NULL, NULL),
(5, 'Pregnancy Monitoring', 'Monitor the pregnancy through regular checkups.', NULL, 'pending', NULL, NULL),
(6, 'Delivery and Handover', 'Facilitate delivery and handover process.', NULL, 'pending', NULL, NULL),
(7, 'Post-Delivery Support', 'Provide post-delivery medical and emotional care.', NULL, 'pending', NULL, NULL),
(8, 'Follow-Up and Feedback', 'Collect feedback and perform periodic check-ins.', NULL, 'pending', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `workflow_tasks`
--

CREATE TABLE `workflow_tasks` (
  `task_id` int(11) NOT NULL,
  `stage_id` int(11) NOT NULL,
  `task_name` varchar(255) NOT NULL,
  `assigned_to` int(11) DEFAULT NULL,
  `status` enum('pending','in_progress','completed') DEFAULT 'pending',
  `deadline` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `appointments`
--
ALTER TABLE `appointments`
  ADD PRIMARY KEY (`appointment_id`),
  ADD KEY `user_id` (`user_id`),
  ADD KEY `staff_id` (`staff_id`),
  ADD KEY `branch_id` (`branch_id`);

--
-- Indexes for table `branches`
--
ALTER TABLE `branches`
  ADD PRIMARY KEY (`branch_id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`category_id`),
  ADD UNIQUE KEY `category_name` (`category_name`);

--
-- Indexes for table `consultations`
--
ALTER TABLE `consultations`
  ADD PRIMARY KEY (`consultation_id`),
  ADD KEY `inquiry_id` (`inquiry_id`);

--
-- Indexes for table `donations`
--
ALTER TABLE `donations`
  ADD PRIMARY KEY (`donation_id`),
  ADD KEY `donor_id` (`donor_id`);

--
-- Indexes for table `expenses`
--
ALTER TABLE `expenses`
  ADD PRIMARY KEY (`expense_id`),
  ADD KEY `branch_id` (`branch_id`),
  ADD KEY `category_id` (`category_id`);

--
-- Indexes for table `feedback`
--
ALTER TABLE `feedback`
  ADD PRIMARY KEY (`feedback_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `files`
--
ALTER TABLE `files`
  ADD PRIMARY KEY (`file_id`),
  ADD KEY `uploaded_by` (`uploaded_by`),
  ADD KEY `shared_with_branch_id` (`shared_with_branch_id`),
  ADD KEY `shared_with_user_id` (`shared_with_user_id`);

--
-- Indexes for table `finances`
--
ALTER TABLE `finances`
  ADD PRIMARY KEY (`transaction_id`),
  ADD KEY `branch_id` (`branch_id`),
  ADD KEY `project_id` (`project_id`);

--
-- Indexes for table `groups`
--
ALTER TABLE `groups`
  ADD PRIMARY KEY (`group_id`);

--
-- Indexes for table `group_members`
--
ALTER TABLE `group_members`
  ADD PRIMARY KEY (`group_member_id`),
  ADD KEY `group_id` (`group_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `inquiries`
--
ALTER TABLE `inquiries`
  ADD PRIMARY KEY (`inquiry_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `invoices`
--
ALTER TABLE `invoices`
  ADD PRIMARY KEY (`invoice_id`),
  ADD KEY `client_id` (`client_id`),
  ADD KEY `project_id` (`project_id`),
  ADD KEY `created_by` (`created_by`),
  ADD KEY `fk_invoices_branch` (`branch_id`);

--
-- Indexes for table `invoice_items`
--
ALTER TABLE `invoice_items`
  ADD PRIMARY KEY (`item_id`),
  ADD KEY `invoice_id` (`invoice_id`);

--
-- Indexes for table `messages`
--
ALTER TABLE `messages`
  ADD PRIMARY KEY (`message_id`),
  ADD KEY `sender_id` (`sender_id`),
  ADD KEY `receiver_id` (`receiver_id`),
  ADD KEY `branch_id` (`branch_id`),
  ADD KEY `group_id` (`group_id`);

--
-- Indexes for table `message_threads`
--
ALTER TABLE `message_threads`
  ADD PRIMARY KEY (`thread_id`),
  ADD KEY `created_by` (`created_by`);

--
-- Indexes for table `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`notification_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`payment_id`),
  ADD KEY `client_id` (`client_id`),
  ADD KEY `project_id` (`project_id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`permission_id`),
  ADD UNIQUE KEY `permission_name` (`permission_name`);

--
-- Indexes for table `projects`
--
ALTER TABLE `projects`
  ADD PRIMARY KEY (`project_id`),
  ADD KEY `branch_id` (`branch_id`),
  ADD KEY `client_id` (`client_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`role_id`),
  ADD UNIQUE KEY `role_name` (`role_name`);

--
-- Indexes for table `role_permissions`
--
ALTER TABLE `role_permissions`
  ADD PRIMARY KEY (`role_permission_id`),
  ADD KEY `role_id` (`role_id`),
  ADD KEY `permission_id` (`permission_id`);

--
-- Indexes for table `surrogacy_stages`
--
ALTER TABLE `surrogacy_stages`
  ADD PRIMARY KEY (`stage_id`),
  ADD KEY `parent_stage_id` (`parent_stage_id`);

--
-- Indexes for table `surrogates`
--
ALTER TABLE `surrogates`
  ADD PRIMARY KEY (`surrogate_id`),
  ADD UNIQUE KEY `email` (`email`);

--
-- Indexes for table `tasks`
--
ALTER TABLE `tasks`
  ADD PRIMARY KEY (`task_id`),
  ADD KEY `project_id` (`project_id`),
  ADD KEY `assigned_to` (`assigned_to`),
  ADD KEY `dependent_task_id` (`dependent_task_id`),
  ADD KEY `idx_status` (`status`);

--
-- Indexes for table `transactions`
--
ALTER TABLE `transactions`
  ADD PRIMARY KEY (`transaction_id`),
  ADD KEY `client_id` (`client_id`),
  ADD KEY `branch_id` (`branch_id`),
  ADD KEY `category_id` (`category_id`);

--
-- Indexes for table `user_activity_logs`
--
ALTER TABLE `user_activity_logs`
  ADD PRIMARY KEY (`log_id`),
  ADD KEY `user_id` (`user_id`);

--
-- Indexes for table `workflow_stages`
--
ALTER TABLE `workflow_stages`
  ADD PRIMARY KEY (`stage_id`),
  ADD KEY `parent_stage_id` (`parent_stage_id`);

--
-- Indexes for table `workflow_tasks`
--
ALTER TABLE `workflow_tasks`
  ADD PRIMARY KEY (`task_id`),
  ADD KEY `stage_id` (`stage_id`),
  ADD KEY `assigned_to` (`assigned_to`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `appointments`
--
ALTER TABLE `appointments`
  MODIFY `appointment_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `branches`
--
ALTER TABLE `branches`
  MODIFY `branch_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `consultations`
--
ALTER TABLE `consultations`
  MODIFY `consultation_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `donations`
--
ALTER TABLE `donations`
  MODIFY `donation_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `expenses`
--
ALTER TABLE `expenses`
  MODIFY `expense_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=436;

--
-- AUTO_INCREMENT for table `feedback`
--
ALTER TABLE `feedback`
  MODIFY `feedback_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `files`
--
ALTER TABLE `files`
  MODIFY `file_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `finances`
--
ALTER TABLE `finances`
  MODIFY `transaction_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `groups`
--
ALTER TABLE `groups`
  MODIFY `group_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `group_members`
--
ALTER TABLE `group_members`
  MODIFY `group_member_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `inquiries`
--
ALTER TABLE `inquiries`
  MODIFY `inquiry_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `invoices`
--
ALTER TABLE `invoices`
  MODIFY `invoice_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `invoice_items`
--
ALTER TABLE `invoice_items`
  MODIFY `item_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `messages`
--
ALTER TABLE `messages`
  MODIFY `message_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `message_threads`
--
ALTER TABLE `message_threads`
  MODIFY `thread_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `notifications`
--
ALTER TABLE `notifications`
  MODIFY `notification_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=440;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `payment_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=117;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `permission_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `projects`
--
ALTER TABLE `projects`
  MODIFY `project_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=39;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `role_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `role_permissions`
--
ALTER TABLE `role_permissions`
  MODIFY `role_permission_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;

--
-- AUTO_INCREMENT for table `surrogacy_stages`
--
ALTER TABLE `surrogacy_stages`
  MODIFY `stage_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=87;

--
-- AUTO_INCREMENT for table `surrogates`
--
ALTER TABLE `surrogates`
  MODIFY `surrogate_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `tasks`
--
ALTER TABLE `tasks`
  MODIFY `task_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `transactions`
--
ALTER TABLE `transactions`
  MODIFY `transaction_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `user_activity_logs`
--
ALTER TABLE `user_activity_logs`
  MODIFY `log_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `workflow_stages`
--
ALTER TABLE `workflow_stages`
  MODIFY `stage_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `workflow_tasks`
--
ALTER TABLE `workflow_tasks`
  MODIFY `task_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `appointments`
--
ALTER TABLE `appointments`
  ADD CONSTRAINT `appointments_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`),
  ADD CONSTRAINT `appointments_ibfk_2` FOREIGN KEY (`staff_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `appointments_ibfk_3` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`branch_id`);

--
-- Constraints for table `consultations`
--
ALTER TABLE `consultations`
  ADD CONSTRAINT `consultations_ibfk_1` FOREIGN KEY (`inquiry_id`) REFERENCES `inquiries` (`inquiry_id`);

--
-- Constraints for table `donations`
--
ALTER TABLE `donations`
  ADD CONSTRAINT `donations_ibfk_1` FOREIGN KEY (`donor_id`) REFERENCES `users` (`user_id`) ON DELETE CASCADE;

--
-- Constraints for table `expenses`
--
ALTER TABLE `expenses`
  ADD CONSTRAINT `expenses_ibfk_1` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`branch_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `expenses_ibfk_2` FOREIGN KEY (`category_id`) REFERENCES `categories` (`category_id`),
  ADD CONSTRAINT `expenses_ibfk_3` FOREIGN KEY (`category_id`) REFERENCES `categories` (`category_id`);

--
-- Constraints for table `feedback`
--
ALTER TABLE `feedback`
  ADD CONSTRAINT `feedback_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`);

--
-- Constraints for table `files`
--
ALTER TABLE `files`
  ADD CONSTRAINT `files_ibfk_1` FOREIGN KEY (`uploaded_by`) REFERENCES `users` (`user_id`),
  ADD CONSTRAINT `files_ibfk_2` FOREIGN KEY (`shared_with_branch_id`) REFERENCES `branches` (`branch_id`),
  ADD CONSTRAINT `files_ibfk_3` FOREIGN KEY (`shared_with_user_id`) REFERENCES `users` (`user_id`);

--
-- Constraints for table `finances`
--
ALTER TABLE `finances`
  ADD CONSTRAINT `finances_ibfk_1` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`branch_id`),
  ADD CONSTRAINT `finances_ibfk_2` FOREIGN KEY (`project_id`) REFERENCES `projects` (`project_id`);

--
-- Constraints for table `group_members`
--
ALTER TABLE `group_members`
  ADD CONSTRAINT `group_members_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`group_id`),
  ADD CONSTRAINT `group_members_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`);

--
-- Constraints for table `inquiries`
--
ALTER TABLE `inquiries`
  ADD CONSTRAINT `inquiries_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`);

--
-- Constraints for table `invoices`
--
ALTER TABLE `invoices`
  ADD CONSTRAINT `fk_invoices_branch` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`branch_id`) ON DELETE SET NULL ON UPDATE CASCADE,
  ADD CONSTRAINT `invoices_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `clients` (`client_id`),
  ADD CONSTRAINT `invoices_ibfk_2` FOREIGN KEY (`project_id`) REFERENCES `projects` (`project_id`),
  ADD CONSTRAINT `invoices_ibfk_3` FOREIGN KEY (`created_by`) REFERENCES `users` (`user_id`);

--
-- Constraints for table `invoice_items`
--
ALTER TABLE `invoice_items`
  ADD CONSTRAINT `invoice_items_ibfk_1` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`invoice_id`) ON DELETE CASCADE;

--
-- Constraints for table `messages`
--
ALTER TABLE `messages`
  ADD CONSTRAINT `messages_ibfk_1` FOREIGN KEY (`sender_id`) REFERENCES `users` (`user_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `messages_ibfk_2` FOREIGN KEY (`receiver_id`) REFERENCES `users` (`user_id`) ON DELETE SET NULL,
  ADD CONSTRAINT `messages_ibfk_3` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`branch_id`),
  ADD CONSTRAINT `messages_ibfk_4` FOREIGN KEY (`group_id`) REFERENCES `groups` (`group_id`);

--
-- Constraints for table `message_threads`
--
ALTER TABLE `message_threads`
  ADD CONSTRAINT `message_threads_ibfk_1` FOREIGN KEY (`created_by`) REFERENCES `users` (`user_id`);

--
-- Constraints for table `notifications`
--
ALTER TABLE `notifications`
  ADD CONSTRAINT `notifications_ibfk_1` FOREIGN KEY (`user_id`) REFERENCES `users` (`user_id`);

--
-- Constraints for table `payments`
--
ALTER TABLE `payments`
  ADD CONSTRAINT `payments_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `clients` (`client_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `payments_ibfk_2` FOREIGN KEY (`project_id`) REFERENCES `projects` (`project_id`) ON DELETE CASCADE;

--
-- Constraints for table `projects`
--
ALTER TABLE `projects`
  ADD CONSTRAINT `projects_ibfk_1` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`branch_id`),
  ADD CONSTRAINT `projects_ibfk_2` FOREIGN KEY (`client_id`) REFERENCES `clients` (`client_id`) ON DELETE CASCADE;

--
-- Constraints for table `role_permissions`
--
ALTER TABLE `role_permissions`
  ADD CONSTRAINT `role_permissions_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `roles` (`role_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_permissions_ibfk_2` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`permission_id`) ON DELETE CASCADE;

--
-- Constraints for table `surrogacy_stages`
--
ALTER TABLE `surrogacy_stages`
  ADD CONSTRAINT `surrogacy_stages_ibfk_1` FOREIGN KEY (`parent_stage_id`) REFERENCES `surrogacy_stages` (`stage_id`);

--
-- Constraints for table `tasks`
--
ALTER TABLE `tasks`
  ADD CONSTRAINT `tasks_ibfk_1` FOREIGN KEY (`project_id`) REFERENCES `projects` (`project_id`),
  ADD CONSTRAINT `tasks_ibfk_2` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`user_id`),
  ADD CONSTRAINT `tasks_ibfk_3` FOREIGN KEY (`dependent_task_id`) REFERENCES `tasks` (`task_id`) ON DELETE SET NULL;

--
-- Constraints for table `transactions`
--
ALTER TABLE `transactions`
  ADD CONSTRAINT `transactions_ibfk_1` FOREIGN KEY (`client_id`) REFERENCES `clients` (`client_id`),
  ADD CONSTRAINT `transactions_ibfk_2` FOREIGN KEY (`branch_id`) REFERENCES `branches` (`branch_id`),
  ADD CONSTRAINT `transactions_ibfk_3` FOREIGN KEY (`category_id`) REFERENCES `categories` (`category_id`);

--
-- Constraints for table `workflow_stages`
--
ALTER TABLE `workflow_stages`
  ADD CONSTRAINT `workflow_stages_ibfk_1` FOREIGN KEY (`parent_stage_id`) REFERENCES `workflow_stages` (`stage_id`) ON DELETE SET NULL;

--
-- Constraints for table `workflow_tasks`
--
ALTER TABLE `workflow_tasks`
  ADD CONSTRAINT `workflow_tasks_ibfk_1` FOREIGN KEY (`stage_id`) REFERENCES `workflow_stages` (`stage_id`) ON DELETE CASCADE,
  ADD CONSTRAINT `workflow_tasks_ibfk_2` FOREIGN KEY (`assigned_to`) REFERENCES `users` (`user_id`);
COMMIT;

