-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Aug 25, 2025 at 10:44 AM
-- Server version: 8.4.3
-- PHP Version: 8.3.16

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `upedia_academics`
--

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

--
-- Table structure for table `staff_scheduleds`
--

CREATE TABLE `staff_scheduleds` (
  `id` bigint UNSIGNED NOT NULL,
  `course_name_en` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `course_name_ar` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `session` int NOT NULL,
  `schedule` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` date NOT NULL,
  `end_date` date NOT NULL,
  `staff_id` int NOT NULL,
  `category_id` bigint UNSIGNED NOT NULL,
  `track_level_id` bigint UNSIGNED NOT NULL,
  `track_type_id` bigint UNSIGNED NOT NULL,
  `track_id` bigint UNSIGNED NOT NULL,
  `schedule_type` enum('course','track') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'course',
  `meeting_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `staff_scheduleds`
--

INSERT INTO `staff_scheduleds` (`id`, `course_name_en`, `course_name_ar`, `status`, `session`, `schedule`, `start_date`, `end_date`, `staff_id`, `category_id`, `track_level_id`, `track_type_id`, `track_id`, `schedule_type`, `meeting_url`, `created_at`, `updated_at`) VALUES
(268, 'Software Testing - 2025-07-26 - 2025-09-06', 'اختبار البرمجيات - 2025-07-26 - 2025-09-06', 'scheduled', 6, 'once', '2025-07-27', '2025-08-31', 52, 6, 121, 1, 27, 'track', NULL, '2025-07-23 12:33:27', '2025-07-23 12:33:27'),
(269, 'Demo - 2025-07-23 - 2025-07-23', 'Demo - 2025-07-23 - 2025-07-23', 'scheduled', 1, 'once', '2025-07-23', '2025-07-23', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-23 15:33:31', '2025-07-23 15:33:31'),
(270, 'Software Testing - 2025-07-24 - 2025-09-06', 'اختبار البرمجيات - 2025-07-24 - 2025-09-06', 'scheduled', 6, 'once', '2025-07-24', '2025-08-28', 55, 6, 122, 4, 27, 'track', NULL, '2025-07-23 17:08:22', '2025-07-23 17:08:22'),
(271, 'Demo - 2025-07-23 - 2025-07-23', 'Demo - 2025-07-23 - 2025-07-23', 'scheduled', 1, 'once', '2025-07-23', '2025-07-23', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-23 17:11:16', '2025-07-23 17:11:16'),
(272, 'Software Testing - 2025-07-24 - 2025-08-16', 'اختبار البرمجيات - 2025-07-24 - 2025-08-16', 'scheduled', 6, 'twice', '2025-07-24', '2025-08-11', 57, 6, 122, 2, 27, 'track', 'https://us04web.zoom.us/j/78195773886?pwd=BOTcM5jKtVZmb0698f9MWV6ObiJV6f.1', '2025-07-23 22:38:06', '2025-07-28 10:14:34'),
(273, 'Demo - 2025-07-24 - 2025-07-24', 'Demo - 2025-07-24 - 2025-07-24', 'scheduled', 1, 'once', '2025-07-24', '2025-07-24', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/74645569199?pwd=fBkQ7v9FQy0TMf2P01nPI4FZ9oGEv1.1', '2025-07-24 10:22:51', '2025-07-24 10:56:26'),
(274, 'english tracks - 2025-07-24 - 2025-08-23', 'English tracks - 2025-07-24 - 2025-08-23', 'scheduled', 4, 'once', '2025-07-24', '2025-08-14', 33, 1, 2, 2, 1, 'track', NULL, '2025-07-24 10:26:38', '2025-07-24 10:26:38'),
(275, 'Software Testing - 2025-07-28 - 2025-08-23', 'اختبار البرمجيات - 2025-07-28 - 2025-08-23', 'scheduled', 6, 'twice', '2025-07-28', '2025-08-14', 57, 6, 121, 1, 27, 'track', 'https://us04web.zoom.us/j/76371961654?pwd=F3pv2wmE23QY7hNOUkhrCTvaB3hGHo.1', '2025-07-24 10:36:09', '2025-07-28 10:20:45'),
(276, 'speaking - 2025-07-24 - 2025-07-24', 'speaking - 2025-07-24 - 2025-07-24', 'scheduled', 1, 'once', '2025-07-24', '2025-07-24', 33, 2, 0, 0, 5, 'course', 'https://us04web.zoom.us/j/78251812559?pwd=j3bXDiHimLodiWynm0McMxb3K1YbKY.1', '2025-07-24 11:09:39', '2025-07-24 09:20:51'),
(277, 'Demo - 2025-07-24 - 2025-07-24', 'Demo - 2025-07-24 - 2025-07-24', 'scheduled', 1, 'once', '2025-07-24', '2025-07-24', 43, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/74987988275?pwd=RxSSdVqB0wbfVqbbY5MKVak354B1jc.1', '2025-07-24 12:27:04', '2025-07-24 09:33:54'),
(278, 'Demo - 2025-07-24 - 2025-07-24', 'Demo - 2025-07-24 - 2025-07-24', 'scheduled', 1, 'once', '2025-07-24', '2025-07-24', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-24 12:38:59', '2025-07-24 12:38:59'),
(279, 'extra session - 2025-07-24 - 2025-07-24', 'جلسة إضافية - 2025-07-24 - 2025-07-24', 'scheduled', 1, 'once', '2025-07-24', '2025-07-24', 58, 3, 0, 0, 3, 'course', NULL, '2025-07-24 13:53:27', '2025-07-24 13:53:27'),
(280, 'Demo - 2025-07-24 - 2025-07-24', 'Demo - 2025-07-24 - 2025-07-24', 'scheduled', 1, 'once', '2025-07-24', '2025-07-24', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/75909283975?pwd=TvAhrWT47xnTqDrgKeV8FEt2GgMrrA.1', '2025-07-24 13:56:53', '2025-07-24 11:22:30'),
(281, 'Demo - 2025-07-24 - 2025-07-24', 'Demo - 2025-07-24 - 2025-07-24', 'scheduled', 1, 'once', '2025-07-24', '2025-07-24', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/71742115709?pwd=BjxKnWbDBpxSOdihPhNTdkivYhAH5C.1', '2025-07-24 14:25:39', '2025-07-24 12:16:10'),
(282, 'Demo - 2025-07-24 - 2025-07-24', 'Demo - 2025-07-24 - 2025-07-24', 'scheduled', 1, 'once', '2025-07-24', '2025-07-24', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-24 15:04:53', '2025-07-24 15:04:53'),
(283, 'Software Testing - 2025-07-27 - 2025-08-16', 'اختبار البرمجيات - 2025-07-27 - 2025-08-16', 'scheduled', 6, 'fourth', '2025-07-27', '2025-08-04', 58, 6, 121, 2, 27, 'track', NULL, '2025-07-27 13:50:20', '2025-07-27 13:50:20'),
(284, 'Demo - 2025-07-27 - 2025-07-27', 'Demo - 2025-07-27 - 2025-07-27', 'scheduled', 1, 'once', '2025-07-27', '2025-07-27', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/77704631327?pwd=kUbxSa3N3paYDT7zNT4NgycJzkup52.1', '2025-07-27 13:54:03', '2025-07-27 10:57:59'),
(285, 'Demo - 2025-07-28 - 2025-08-02', 'Demo - 2025-07-28 - 2025-08-02', 'scheduled', 1, 'once', '2025-07-28', '2025-07-28', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-28 12:30:09', '2025-07-28 12:30:09'),
(286, 'Demo - 2025-07-28 - 2025-07-28', 'Demo - 2025-07-28 - 2025-07-28', 'scheduled', 1, 'once', '2025-07-28', '2025-07-28', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-28 12:32:10', '2025-07-28 12:32:10'),
(287, 'Demo - 2025-07-28 - 2025-07-28', 'Demo - 2025-07-28 - 2025-07-28', 'scheduled', 1, 'once', '2025-07-28', '2025-07-28', 39, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/72282752788?pwd=3828V3rbWVG4bkMG5myBistovcaQ97.1', '2025-07-28 14:09:00', '2025-07-28 13:58:46'),
(288, 'speaking - 2025-07-28 - 2025-07-28', 'speaking - 2025-07-28 - 2025-07-28', 'scheduled', 1, 'once', '2025-07-28', '2025-07-28', 33, 2, 0, 0, 5, 'course', NULL, '2025-07-28 16:00:38', '2025-07-28 16:00:38'),
(289, 'davd - 2025-07-29 - 2025-09-06', 'david - 2025-07-29 - 2025-09-06', 'scheduled', 5, 'once', '2025-08-03', '2025-08-31', 33, 1, 8, 2, 3, 'track', 'https://us04web.zoom.us/j/74893663134?pwd=HzbQZ56Fgw2PH7qEWGeSLsEwdxSSeG.1', '2025-07-28 16:07:01', '2025-07-28 13:53:35'),
(290, 'Demo - 2025-07-28 - 2025-07-28', 'Demo - 2025-07-28 - 2025-07-28', 'scheduled', 1, 'once', '2025-07-28', '2025-07-28', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/78070000581?pwd=Q223ppHdDwwbie2M9qxDumIH5B6j5Y.1', '2025-07-28 17:02:11', '2025-07-28 14:04:17'),
(291, 'Demo - 2025-07-28 - 2025-07-28', 'Demo - 2025-07-28 - 2025-07-28', 'scheduled', 1, 'once', '2025-07-28', '2025-07-28', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-28 17:05:46', '2025-07-28 17:05:46'),
(292, 'Demo - 2025-07-28 - 2025-07-28', 'Demo - 2025-07-28 - 2025-07-28', 'scheduled', 1, 'once', '2025-07-28', '2025-07-28', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/74549500193?pwd=c6uMokHzaSboCzmwJZpDzNStjyL5rv.1', '2025-07-28 17:30:02', '2025-07-28 14:58:56'),
(293, 'Demo - 2025-07-28 - 2025-07-28', 'Demo - 2025-07-28 - 2025-07-28', 'scheduled', 1, 'once', '2025-07-28', '2025-07-28', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/77522246424?pwd=L0p9h08NHOk3gLvRpttSjPk401dmWG.1', '2025-07-28 17:50:36', '2025-07-29 12:03:15'),
(294, 'speaking - 2025-07-29 - 2025-07-29', 'speaking - 2025-07-29 - 2025-07-29', 'scheduled', 1, 'once', '2025-07-29', '2025-07-29', 33, 2, 0, 0, 5, 'course', NULL, '2025-07-29 12:52:59', '2025-07-29 12:52:59'),
(295, 'Software Testing - 2025-07-30 - 2025-09-13', 'اختبار البرمجيات - 2025-07-30 - 2025-09-13', 'scheduled', 6, 'once', '2025-08-02', '2025-09-06', 57, 6, 122, 1, 27, 'track', NULL, '2025-07-29 13:28:12', '2025-07-29 13:28:12'),
(296, 'Demo - 2025-07-29 - 2025-07-29', 'Demo - 2025-07-29 - 2025-07-29', 'scheduled', 1, 'once', '2025-07-29', '2025-07-29', 25, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/79316375858?pwd=DExobofXjr1NVukd4KrpPm2LqxeUvg.1', '2025-07-29 15:07:31', '2025-07-29 12:16:18'),
(297, 'Demo - 2025-07-29 - 2025-07-29', 'Demo - 2025-07-29 - 2025-07-29', 'scheduled', 1, 'once', '2025-07-29', '2025-07-29', 25, 9, 0, 0, 6, 'course', NULL, '2025-07-29 15:32:16', '2025-07-29 15:32:16'),
(298, 'Demo - 2025-07-29 - 2025-07-29', 'Demo - 2025-07-29 - 2025-07-29', 'scheduled', 1, 'once', '2025-07-29', '2025-07-29', 25, 9, 0, 0, 6, 'course', NULL, '2025-07-29 15:41:01', '2025-07-29 15:41:01'),
(299, 'Demo - 2025-07-29 - 2025-07-29', 'Demo - 2025-07-29 - 2025-07-29', 'scheduled', 1, 'once', '2025-07-29', '2025-07-29', 25, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/76585200328?pwd=SKmD4YuEf97oDTXi5ajwagnCxrrrF0.1', '2025-07-29 16:01:41', '2025-07-29 13:04:02'),
(300, 'Demo - 2025-07-29 - 2025-07-29', 'Demo - 2025-07-29 - 2025-07-29', 'scheduled', 1, 'once', '2025-07-29', '2025-07-29', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/75072893646?pwd=CN7oLzaMLbONdNz6SsaS984MQ11bsW.1', '2025-07-29 17:15:50', '2025-07-29 14:19:13'),
(301, 'Demo - 2025-07-29 - 2025-07-29', 'Demo - 2025-07-29 - 2025-07-29', 'scheduled', 1, 'once', '2025-07-29', '2025-07-29', 37, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/74730825344?pwd=8ASMC8tpoN9ZNKswnhIvsblVyMHmky.1', '2025-07-29 17:22:22', '2025-07-29 14:45:50'),
(302, 'Demo - 2025-07-30 - 2025-07-30', 'Demo - 2025-07-30 - 2025-07-30', 'scheduled', 1, 'once', '2025-07-30', '2025-07-30', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-30 12:34:38', '2025-07-30 12:34:38'),
(303, 'Demo - 2025-07-30 - 2025-07-30', 'Demo - 2025-07-30 - 2025-07-30', 'scheduled', 1, 'once', '2025-07-30', '2025-07-30', 25, 9, 0, 0, 6, 'course', NULL, '2025-07-30 12:37:28', '2025-07-30 12:37:28'),
(305, 'Demo - 2025-07-30 - 2025-07-30', 'Demo - 2025-07-30 - 2025-07-30', 'scheduled', 1, 'once', '2025-07-30', '2025-07-30', 37, 9, 0, 0, 6, 'course', NULL, '2025-07-30 16:15:42', '2025-07-30 16:15:42'),
(306, 'General - 2025-08-03 - 2025-08-16', 'عام - 2025-08-03 - 2025-08-16', 'scheduled', 2, 'once', '2025-08-01', '2025-08-10', 63, 1, 118, 1, 26, 'track', NULL, '2025-08-03 14:27:45', '2025-08-03 14:27:45'),
(315, 'General - 2025-08-04 - 2025-08-23', 'عام - 2025-08-04 - 2025-08-23', 'scheduled', 2, 'once', '2025-08-09', '2025-08-16', 61, 1, 118, 1, 26, 'track', NULL, '2025-08-04 12:50:15', '2025-08-04 12:50:15'),
(317, 'General - 2025-08-04 - 2025-08-23', 'عام - 2025-08-04 - 2025-08-23', 'scheduled', 2, 'once', '2025-08-09', '2025-08-16', 63, 1, 118, 1, 26, 'track', NULL, '2025-08-04 12:53:11', '2025-08-04 12:53:11'),
(318, 'SDLC - 2025-08-06 - 2025-08-16', 'SDLC - 2025-08-06 - 2025-08-16', 'scheduled', 1, 'once', '2025-08-09', '2025-08-09', 33, 11, 129, 9, 29, 'track', NULL, '2025-08-04 13:05:24', '2025-08-04 13:05:24'),
(319, 'Demo - 2025-08-06 - 2025-09-06', 'Demo - 2025-08-06 - 2025-09-06', 'scheduled', 1, 'once', '2025-08-06', '2025-08-06', 43, 9, 0, 0, 6, 'course', NULL, '2025-08-06 14:55:09', '2025-08-06 14:55:09'),
(320, 'Demo - 2025-08-07 - 2025-08-07', 'Demo - 2025-08-07 - 2025-08-07', 'scheduled', 1, 'once', '2025-08-07', '2025-08-07', 43, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/72834022653?pwd=mteg2nzw3rb6bpP5I46XinxXzqQIf7.1', '2025-08-06 15:49:21', '2025-08-06 12:51:06'),
(321, 'Demo - 2025-08-12 - 2025-08-12', 'Demo - 2025-08-12 - 2025-08-12', 'scheduled', 1, 'once', '2025-08-12', '2025-08-12', 51, 9, 0, 0, 6, 'course', NULL, '2025-08-10 12:51:46', '2025-08-10 12:51:46'),
(322, 'Demo - 2025-08-10 - 2025-08-10', 'Demo - 2025-08-10 - 2025-08-10', 'scheduled', 1, 'once', '2025-08-10', '2025-08-10', 51, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/79683612209?pwd=FNs2lFQ2YSx5rMVBGJbSccpZF60E9t.1', '2025-08-10 13:34:20', '2025-08-10 10:39:08'),
(323, 'Demo - 2025-08-10 - 2025-08-10', 'Demo - 2025-08-10 - 2025-08-10', 'scheduled', 1, 'once', '2025-08-10', '2025-08-10', 68, 9, 0, 0, 6, 'course', NULL, '2025-08-10 15:57:35', '2025-08-10 15:57:35'),
(324, 'Demo - 2025-08-11 - 2025-08-11', 'Demo - 2025-08-11 - 2025-08-11', 'scheduled', 1, 'once', '2025-08-11', '2025-08-11', 47, 9, 0, 0, 6, 'course', NULL, '2025-08-11 13:44:39', '2025-08-11 13:44:39'),
(325, 'Demo - 2025-08-12 - 2025-08-12', 'Demo - 2025-08-12 - 2025-08-12', 'scheduled', 1, 'once', '2025-08-12', '2025-08-12', 51, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/75764660413?pwd=ZmQDfYcqmcxP8QWr3lIAHKLE47uz70.1', '2025-08-12 11:14:28', '2025-08-12 08:34:02'),
(326, 'Demo - 2025-08-12 - 2025-08-12', 'Demo - 2025-08-12 - 2025-08-12', 'scheduled', 1, 'once', '2025-08-12', '2025-08-12', 51, 9, 0, 0, 6, 'course', 'https://us04web.zoom.us/j/72410962608?pwd=GllhgkMQXet2IbflUFTy8peLRmQGya.1', '2025-08-12 11:20:44', '2025-08-12 08:39:51'),
(327, 'Demo - 2025-08-12 - 2025-08-12', 'Demo - 2025-08-12 - 2025-08-12', 'scheduled', 1, 'once', '2025-08-12', '2025-08-12', 47, 9, 0, 0, 6, 'course', NULL, '2025-08-12 11:54:17', '2025-08-12 11:54:17');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `staff_scheduleds`
--
ALTER TABLE `staff_scheduleds`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `staff_scheduleds`
--
ALTER TABLE `staff_scheduleds`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=328;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
