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

START TRANSACTION;



--
-- Database: `aic_db`
--

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

--
-- Table structure for table `a_level`
--

CREATE TABLE `a_level` (
  `a_level_id` int(11) NOT NULL,
  `a_level_year` date NOT NULL,
  `a_level_method` varchar(45) NOT NULL,
  `a_level_stream` varchar(45) NOT NULL,
  `a_level_index_no` varchar(45) NOT NULL,
  `a_level_a_plus_count` int(11) NOT NULL,
  `a_level_a_count` int(11) NOT NULL,
  `a_level_b_count` int(11) NOT NULL,
  `a_level_c_count` int(11) NOT NULL,
  `a_level_d_count` int(11) NOT NULL,
  `a_level_s_count` int(11) NOT NULL,
  `a_level_e_count` int(11) NOT NULL,
  `a_level_f_count` int(11) NOT NULL,
  `a_level_create_date` date NOT NULL,
  `a_level_created_time` time NOT NULL,
  `a_level_updated_date` date NOT NULL,
  `a_level_updated_time` time NOT NULL,
  `student_id` int(11) NOT NULL
  `a_level_updated_time` time NOT NULL,
  `student_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `a_level`
--

INSERT INTO `a_level` (`a_level_id`, `a_level_year`, `a_level_method`, `a_level_stream`, `a_level_index_no`, `a_level_a_plus_count`, `a_level_a_count`, `a_level_b_count`, `a_level_c_count`, `a_level_d_count`, `a_level_s_count`, `a_level_e_count`, `a_level_f_count`, `a_level_create_date`, `a_level_created_time`, `a_level_updated_date`, `a_level_updated_time`, `student_id`) VALUES
(0, '2024-05-27', '', 'Commerce', '778878884', 0, 2, 1, 1, 0, 0, 0, 0, '2024-05-27', '01:00:00', '2024-05-27', '01:00:00', 3);

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

--
-- Table structure for table `branch`
--

CREATE TABLE `branch` (
  `branch_id` int(11) NOT NULL,
  `branch_name` varchar(45) NOT NULL,
  `branch_code` varchar(45) NOT NULL,
  `campus_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `branch`
--

INSERT INTO `branch` (`branch_id`, `branch_name`, `branch_code`, `campus_id`) VALUES
(1, 'AIC COLOMBO', 'AIC-COL', 1),
(2, 'AIC KANDY', 'AIC-KNDY', 1),
(3, 'IMC COLOMBO', 'IMC-COL', 2),
(4, 'IMC JAFFNA', 'IMC-JFN', 2);

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

--
-- Table structure for table `campus`
--

CREATE TABLE `campus` (
  `campus_id` int(11) NOT NULL,
  `campus_name` varchar(45) NOT NULL,
  `campus_code` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `campus`
--

INSERT INTO `campus` (`campus_id`, `campus_name`, `campus_code`) VALUES
(1, 'AIC', 'AICC'),
(2, 'IMC', 'IMCC');

--
-- Dumping data for table `education`
--

INSERT INTO `education` (`education_id`, `education_additional_info`, `education_institute`, `education_start_date`, `education_end_date`, `education_current_study`, `education_doc_path`, `education_doc_status`, `education_created_date`, `education_created_time`, `education_updated_date`, `education_updated_time`, `education_type_id`, `education_qual_id`, `student_id`) VALUES
(1, 'tes', 'test', '2024-06-09', '2024-06-13', 0, '/student/assets/uploads/documents/education/8/aic-file-upload_666a8a4e675ab.pdf', 2, '2024-06-13', '11:27:34', '2024-06-13', '11:27:34', 1, 3, 8),
(2, 'tr', 'fd', '0000-00-00', '0000-00-00', 0, '/student/assets/uploads/documents/education/8/aic-file-upload_66714037e2c4d.pdf', 1, '2024-06-13', '13:15:29', '2024-06-18', '13:37:19', 2, 6, 8),
(3, 'test adii 1234', 'test institute 1234', '2024-06-09', '2024-06-21', 1, '/student/assets/uploads/documents/education/8/aic-file-upload_666acd073e8c8.pdf', 1, '2024-06-13', '16:12:15', '2024-06-13', '16:12:15', 2, 8, 8),
(4, '33', '22', '2024-06-11', '2024-06-13', 1, '/student/assets/uploads/documents/education/8/aic-file-upload_666acda5ebead.pdf', 1, '2024-06-13', '16:14:53', '2024-06-13', '16:14:53', 3, 11, 8),
(5, 'gfhy', 'fd', '0000-00-00', '0000-00-00', 0, '/student/assets/uploads/documents/education/8/lunarsolarconsulting-home-page-1_666ace1b2e747.pdf', 1, '2024-06-13', '16:16:51', '2024-06-13', '16:16:51', 2, 10, 8),
(6, 'fj', 't', '0000-00-00', '0000-00-00', 0, '/student/assets/uploads/documents/education/8/aic-file-upload_666aced39f980.pdf', 1, '2024-06-13', '16:19:55', '2024-06-13', '16:19:55', 2, 7, 8),
(7, 'sdf', 'sadf', '0000-00-00', '0000-00-00', 0, '/student/assets/uploads/documents/education/8/aic-file-upload_666acfa74f4dc.pdf', 1, '2024-06-13', '16:23:27', '2024-06-13', '16:23:27', 2, 8, 8),
(8, 'sdfa', 'sdf', '0000-00-00', '0000-00-00', 0, '/student/assets/uploads/documents/education/8/aic-file-upload_666ad14c27fc5.pdf', 1, '2024-06-13', '16:30:28', '2024-06-13', '16:30:28', 2, 7, 8),
(9, 'tr', 'rt', '2024-06-02', '2024-06-03', 1, '/student/assets/uploads/documents/education/8/lunarsolarconsulting-home-page-1_666ad4062e2f8.pdf', 1, '2024-06-13', '16:42:06', '2024-06-13', '16:42:06', 2, 7, 8),
(10, 'fg', 'gfr', '0000-00-00', '0000-00-00', 0, '/student/assets/uploads/documents/education/8/lunarsolarconsulting-home-page-1_66713c117d396.pdf', 1, '2024-06-13', '16:55:01', '2024-06-18', '13:19:37', 1, 2, 8),
(11, 'sdf', 'sd', '2024-06-09', '2024-06-19', 0, '/student/assets/uploads/documents/education/8/attachment_2024_06_66713c3f1dfb8.pdf', 1, '2024-06-14', '11:04:56', '2024-06-18', '13:20:23', 2, 6, 8),
(12, 'fdv', 'dfs', '2024-06-09', '2024-06-18', 1, '/student/assets/uploads/documents/education/8/screencapture-localhost-aic-counselor-all-leads-php-2024-06-14-10_21_26_666be1dcb58f8.pdf', 1, '2024-06-14', '11:53:24', '2024-06-14', '11:53:24', 2, 9, 8),
(13, 'fd', 'f', '2024-06-10', '2024-06-18', 1, '/student/assets/uploads/documents/education/8/screencapture-localhost-aic-counselor-all-leads-php-2024-06-14-10_21_26_666be421afa78.pdf', 1, '2024-06-14', '12:03:05', '2024-06-14', '12:03:05', 2, 7, 8),
(14, 'fdg', 'sdf', '0000-00-00', '0000-00-00', 0, '/student/assets/uploads/documents/education/8/attachment_2024_06_66713cbb45a0e.pdf', 1, '2024-06-17', '16:25:11', '2024-06-18', '13:22:27', 1, 3, 8),
(15, 'yuu', 'rg', '2024-06-18', '0000-00-00', 1, '/student/assets/uploads/documents/education/8/attachment_2024_06_6671488020589.pdf', 1, '2024-06-18', '14:12:28', '2024-06-18', '14:12:40', 3, 11, 8),
(16, '', '', '0000-00-00', '0000-00-00', 0, './assets/uploads/education/1/aic-file-upload_6672b093a24a9_6672b093a24b3.pdf', 2, '0000-00-00', '00:00:00', '0000-00-00', '00:00:00', 3, 11, 1),
(17, 'vfjvb', 'test', '2024-06-10', '2024-06-19', 1, '', 0, '2024-06-19', '16:38:00', '2024-06-19', '16:38:00', 2, 6, 8),
(18, '', '', '0000-00-00', '0000-00-00', 0, './assets/uploads/education/1/aic-file-upload_6672c1a54f28c_6672c1a54f29a.pdf', 1, '0000-00-00', '00:00:00', '0000-00-00', '00:00:00', 1, 1, 1),
(19, '', 'ABC colloge', '2024-06-02', '2024-06-30', 0, '/student/assets/uploads/documents/education/37/aic-file-upload_6673d7137e537.pdf', 1, '2024-06-20', '12:44:29', '2024-06-20', '12:45:31', 1, 1, 37);

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

--
-- Table structure for table `education_qual`
--

CREATE TABLE `education_qual` (
  `education_qual_id` int(11) NOT NULL,
  `education_qual` text NOT NULL,
  `education_type_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `education_qual`
--

INSERT INTO `education_qual` (`education_qual_id`, `education_qual`, `education_type_id`) VALUES
(1, 'O/L - Sri Lanka', 1),
(2, 'O/L - International', 1),
(3, 'A/L - Sri Lanka', 1),
(4, 'A/L - International', 1),
(5, 'Certificate', 2),
(6, 'Degree', 2),
(7, 'Diploma', 2),
(8, 'Master', 2),
(9, 'Professional Qualification', 2),
(10, 'Doctor of Philosophy(PHD)', 2),
(11, 'Other Qualification', 3);

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

--
-- Table structure for table `education_type`
--

CREATE TABLE `education_type` (
  `education_type_id` int(11) NOT NULL,
  `education_type` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `education_type`
--

INSERT INTO `education_type` (`education_type_id`, `education_type`) VALUES
(1, 'Secondary Education'),
(2, 'Higher Education'),
(3, 'Other Education');

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

--
-- Table structure for table `language`
--

CREATE TABLE `language` (
  `language_id` int(11) NOT NULL,
  `language_si` int(11) NOT NULL,
  `language_en` int(11) NOT NULL,
  `language_ta` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT 'user''s counselor_id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `language`
--

INSERT INTO `language` (`language_id`, `language_si`, `language_en`, `language_ta`, `user_id`) VALUES
(1, 1, 1, 0, 4),
(2, 1, 0, 0, 5);

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

--
-- Table structure for table `lead`
--

CREATE TABLE `lead` (
  `lead_id` int(11) NOT NULL,
  `lead_first_name` varchar(45) NOT NULL,
  `lead_last_name` varchar(45) NOT NULL,
  `lead_phone_1` varchar(45) NOT NULL,
  `lead_phone_2` varchar(45) NOT NULL,
  `lead_email` varchar(100) NOT NULL,
  `lead_address` text NOT NULL,
  `lead_source` varchar(45) NOT NULL,
  `lead_pref_lang` varchar(45) NOT NULL,
  `lead_status` int(11) NOT NULL COMMENT '0-Pending|1-Assigned|2-Rejected|3-NotProspective|4-Convertible|5-FutureIntakes|6-Completed|7-Registered',
  `lead_created_date` date NOT NULL,
  `lead_created_time` time NOT NULL,
  `lead_updated_date` date NOT NULL,
  `lead_updated_time` time NOT NULL,
  `campus_id` int(11) NOT NULL,
  `branch_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT 'counselor user_id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `lead`
--

INSERT INTO `lead` (`lead_id`, `lead_first_name`, `lead_last_name`, `lead_phone_1`, `lead_phone_2`, `lead_email`, `lead_address`, `lead_source`, `lead_pref_lang`, `lead_status`, `lead_created_date`, `lead_created_time`, `lead_updated_date`, `lead_updated_time`, `campus_id`, `branch_id`, `user_id`) VALUES
(1, 'Yomal', 'Fernando', '0778978450', '', 'yomal@gmail.com', 'Colombo 04', 'WA', 'EN', 7, '2024-05-14', '19:12:39', '2024-05-20', '16:38:21', 1, 1, 4),
(2, 'Sarani', 'Perera', '0778978450', '0117845850', 'sarani@gmail.com', 'Kandy', 'WA', 'SI', 7, '2024-05-14', '18:26:28', '2024-05-29', '12:54:42', 1, 1, 4),
(3, 'Piumal', 'Liyanage', '0707845789', '0117845820', 'piumal@gmail.com', 'Colombo 04', 'CLL', 'SI', 7, '2024-05-14', '18:30:28', '2024-06-20', '12:12:51', 1, 1, 4),
(4, 'Nethuli', 'Perera', '0774578930', '0117845456', 'nethuli@gmail.com', 'Colombo 04', 'FB', 'SI', 7, '2024-05-14', '17:30:28', '2024-06-20', '12:16:38', 1, 1, 4),
(11, 'janith', 'Perera', '0778945780', '0778978450', 'janith@gmail.com', 'Colombo 05', 'CLL', 'SI', 7, '2024-06-20', '14:20:26', '2024-06-20', '12:43:19', 1, 1, 4);

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

--
-- Table structure for table `note`
--

CREATE TABLE `note` (
  `note_id` int(11) NOT NULL,
  `note_description` text NOT NULL,
  `note_created_date` date NOT NULL,
  `note_created_time` time NOT NULL,
  `note_updated_date` date NOT NULL,
  `note_updated_time` time NOT NULL,
  `lead_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `note`
--

INSERT INTO `note` (`note_id`, `note_description`, `note_created_date`, `note_created_time`, `note_updated_date`, `note_updated_time`, `lead_id`) VALUES
(1, 'Call me on next week', '2024-05-16', '13:20:39', '2024-05-16', '13:20:39', 1),
(2, 'Today I am busy', '2024-05-18', '14:20:39', '2024-05-01', '14:20:39', 1),
(3, 'lead pref and ask to call on next week', '2024-05-20', '14:29:07', '2024-05-20', '14:29:07', 2),
(4, 'pref to jouin next intake', '2024-05-20', '14:32:22', '2024-05-20', '14:32:22', 2),
(5, 'hey test note', '2024-05-20', '14:37:57', '2024-05-20', '14:37:57', 2),
(6, 'FI', '2024-05-20', '14:39:55', '2024-05-20', '14:39:55', 2),
(7, 'con', '2024-05-20', '14:41:10', '2024-05-20', '14:41:10', 2),
(8, 'FGG', '2024-05-20', '14:42:45', '2024-05-20', '14:42:45', 2),
(9, 'completed', '2024-05-20', '14:45:54', '2024-05-20', '14:45:54', 2),
(10, 'NP', '2024-05-20', '14:46:37', '2024-05-20', '14:46:37', 2),
(11, 'testetsdg', '2024-05-20', '14:48:17', '2024-05-20', '14:48:17', 2),
(12, 'he said he will cal again', '2024-05-20', '15:08:18', '2024-05-20', '15:08:18', 3),
(13, 'he said he will join on next intake', '2024-05-20', '15:10:20', '2024-05-20', '15:10:20', 3),
(14, 'convertible lead', '2024-05-20', '15:15:46', '2024-05-20', '15:15:46', 3),
(15, 'not prospective lead', '2024-05-20', '15:16:04', '2024-05-20', '15:16:04', 3),
(16, 'ready to register as student', '2024-05-20', '16:38:21', '2024-05-20', '16:38:21', 1),
(17, 'prefer to join', '2024-05-21', '12:09:43', '2024-05-21', '12:09:43', 2),
(18, 'con', '2024-05-29', '12:54:02', '2024-05-29', '12:54:02', 2),
(19, 'completed', '2024-05-29', '12:54:42', '2024-05-29', '12:54:42', 2),
(20, 'completed', '2024-05-29', '13:05:05', '2024-05-29', '13:05:05', 4),
(21, 'call on next week', '2024-05-29', '13:42:41', '2024-05-29', '13:42:41', 5),
(22, 'ask to come to the campus', '2024-05-29', '13:43:18', '2024-05-29', '13:43:18', 5),
(23, 'not prefer', '2024-05-29', '13:44:50', '2024-05-29', '13:44:50', 5),
(24, 'prefer to get details', '2024-05-29', '13:50:49', '2024-05-29', '13:50:49', 5),
(25, 'prefer to join', '2024-05-29', '13:51:12', '2024-05-29', '13:51:12', 5),
(26, 'conver', '2024-05-30', '13:58:49', '2024-05-30', '13:58:49', 3),
(27, 'con 2', '2024-05-30', '13:59:32', '2024-05-30', '13:59:32', 3),
(28, 'complered', '2024-05-30', '14:00:03', '2024-05-30', '14:00:03', 3),
(29, 'con', '2024-05-30', '14:00:30', '2024-05-30', '14:00:30', 3),
(30, 'con 3', '2024-05-30', '14:00:54', '2024-05-30', '14:00:54', 3),
(31, 'cn', '2024-05-30', '14:03:26', '2024-05-30', '14:03:26', 3),
(32, 'con', '2024-05-30', '14:07:37', '2024-05-30', '14:07:37', 3),
(33, 'convere4', '2024-05-30', '14:08:00', '2024-05-30', '14:08:00', 3),
(34, 'comp', '2024-05-30', '14:09:21', '2024-05-30', '14:09:21', 3),
(35, 'nnnn', '2024-05-30', '14:38:45', '2024-05-30', '14:38:45', 3),
(36, 'ghdn', '2024-05-30', '14:39:35', '2024-05-30', '14:39:35', 3),
(37, '544', '2024-05-30', '15:27:11', '2024-05-30', '15:27:11', 3),
(38, '54', '2024-05-30', '15:27:20', '2024-05-30', '15:27:20', 3),
(39, 'rose', '2024-05-30', '15:29:49', '2024-05-30', '15:29:49', 3),
(40, 'time\'s', '2024-05-30', '15:37:45', '2024-05-30', '15:37:45', 3),
(41, 'ad\'s', '2024-05-30', '15:41:27', '2024-05-30', '15:41:27', 3),
(42, 'Convert', '2024-05-30', '16:39:18', '2024-05-30', '16:39:18', 3),
(43, 'ready to register', '2024-05-30', '16:39:34', '2024-05-30', '16:39:34', 3),
(44, 'con', '2024-05-31', '14:44:15', '2024-05-31', '14:44:15', 3),
(45, 'COM -> convei', '2024-05-31', '14:45:21', '2024-05-31', '14:45:21', 4),
(46, 'compe', '2024-05-31', '15:03:49', '2024-05-31', '15:03:49', 4),
(47, 'now123', '2024-05-31', '15:04:58', '2024-05-31', '15:04:58', 4),
(48, 'completed resf rusig dufhd fdf dfsuhd sdf dofshfd sfd', '2024-05-31', '15:22:27', '2024-05-31', '15:22:27', 3),
(49, 'fii', '2024-06-03', '10:46:59', '2024-06-03', '10:46:59', 4),
(50, 'convv', '2024-06-03', '10:47:13', '2024-06-03', '10:47:13', 4),
(51, 'twsrt', '2024-06-03', '10:47:46', '2024-06-03', '10:47:46', 4),
(52, 'note\'s', '2024-06-03', '10:59:18', '2024-06-03', '10:59:18', 4),
(53, ',m', '2024-06-03', '13:20:00', '2024-06-03', '13:20:00', 4),
(54, 'fad', '2024-06-03', '13:22:43', '2024-06-03', '13:22:43', 4),
(55, 'eff', '2024-06-03', '13:23:26', '2024-06-03', '13:23:26', 4),
(56, 'dv', '2024-06-03', '13:26:59', '2024-06-03', '13:26:59', 4),
(57, 'dfvfd', '2024-06-03', '13:34:59', '2024-06-03', '13:34:59', 4),
(58, 'rfd', '2024-06-03', '13:55:57', '2024-06-03', '13:55:57', 4),
(59, 'dfvfd', '2024-06-03', '13:57:20', '2024-06-03', '13:57:20', 4),
(60, '134', '2024-06-03', '16:54:25', '2024-06-03', '16:54:25', 4),
(61, 'test notes', '2024-06-19', '15:40:56', '2024-06-19', '15:40:56', 3),
(62, 'test', '2024-06-19', '15:41:35', '2024-06-19', '15:41:35', 3),
(63, 'test con', '2024-06-19', '16:26:33', '2024-06-19', '16:26:33', 3),
(64, 'comple', '2024-06-19', '16:27:16', '2024-06-19', '16:27:16', 3),
(65, 'lead convatible', '2024-06-20', '12:40:29', '2024-06-20', '12:40:29', 11),
(66, 'lead completed and ready to join as student', '2024-06-20', '12:42:18', '2024-06-20', '12:42:18', 11);

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

--
-- Table structure for table `o_level`
--

CREATE TABLE `o_level` (
  `o_level_id` int(11) NOT NULL,
  `o_level_year` date NOT NULL,
  `o_level_method` varchar(45) NOT NULL,
  `o_level_index_no` varchar(45) NOT NULL,
  `o_level_a_plus_count` int(11) NOT NULL,
  `o_level_a_count` int(11) NOT NULL,
  `o_level_b_count` int(11) NOT NULL,
  `o_level_c_count` int(11) NOT NULL,
  `o_level_d_count` int(11) NOT NULL,
  `o_level_s_count` int(11) NOT NULL,
  `o_level_e_count` int(11) NOT NULL,
  `o_level_f_count` int(11) NOT NULL,
  `o_level_created_date` date NOT NULL,
  `o_level_created_time` time NOT NULL,
  `o_level_updated_date` date NOT NULL,
  `o_level_updated_time` time NOT NULL,
  `student_id` int(11) NOT NULL
  `o_level_updated_time` time NOT NULL,
  `student_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `o_level`
--

INSERT INTO `o_level` (`o_level_id`, `o_level_year`, `o_level_method`, `o_level_index_no`, `o_level_a_plus_count`, `o_level_a_count`, `o_level_b_count`, `o_level_c_count`, `o_level_d_count`, `o_level_s_count`, `o_level_e_count`, `o_level_f_count`, `o_level_created_date`, `o_level_created_time`, `o_level_updated_date`, `o_level_updated_time`, `student_id`) VALUES
(1, '2024-05-27', 'Method A', '9978885444', 2, 1, 3, 2, 0, 1, 0, 0, '2024-05-27', '14:10:07', '2024-05-27', '14:10:07', 3);

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

--
-- Table structure for table `payment_plan`
--

CREATE TABLE `payment_plan` (
  `payment_plan_id` int(11) NOT NULL,
  `payment_plan_due_date` date NOT NULL,
  `payment_plan_amount` decimal(10,2) NOT NULL,
  `payment_plan_additional_amount` decimal(10,2) NOT NULL,
  `payment_plan_remarks` text NOT NULL,
  `payment_plan_created_date` date NOT NULL,
  `payment_plan_created_time` time NOT NULL,
  `payment_plan_updated_date` date NOT NULL,
  `payment_plan_updated_time` time NOT NULL,
  `student_enrollment_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `payment_plan`
--

INSERT INTO `payment_plan` (`payment_plan_id`, `payment_plan_due_date`, `payment_plan_amount`, `payment_plan_additional_amount`, `payment_plan_remarks`, `payment_plan_created_date`, `payment_plan_created_time`, `payment_plan_updated_date`, `payment_plan_updated_time`, `student_enrollment_id`) VALUES
(1, '2024-06-01', 30000.00, 0.00, 'Initial Payment', '2024-05-28', '18:22:17', '2024-05-28', '18:22:17', 1),
(2, '2024-07-06', 30000.00, 0.00, 'Second payment', '2024-05-28', '18:22:17', '2024-05-28', '18:22:17', 1);

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

--
-- Table structure for table `personal_info`
--

CREATE TABLE `personal_info` (
  `personal_info_id` int(11) NOT NULL,
  `father_name` text NOT NULL,
  `father_occupation` varchar(45) NOT NULL,
  `father_organization` varchar(45) NOT NULL,
  `father_phone_1` varchar(45) NOT NULL,
  `father_phone_2` varchar(45) NOT NULL,
  `mother_name` text NOT NULL,
  `mother_occupation` varchar(45) NOT NULL,
  `mother_organization` varchar(45) NOT NULL,
  `mother_phone_1` varchar(45) NOT NULL,
  `mother_phone_2` varchar(45) NOT NULL,
  `personal_info_created_date` date NOT NULL,
  `personal_info_created_time` time NOT NULL,
  `personal_info_updated_date` date NOT NULL,
  `personal_info_updated_time` time NOT NULL,
  `student_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `personal_info`
--

INSERT INTO `personal_info` (`personal_info_id`, `father_name`, `father_occupation`, `father_organization`, `father_phone_1`, `father_phone_2`, `mother_name`, `mother_occupation`, `mother_organization`, `mother_phone_1`, `mother_phone_2`, `personal_info_created_date`, `personal_info_created_time`, `personal_info_updated_date`, `personal_info_updated_time`, `student_id`) VALUES
(2, 'fg', 'fdsg', 'fdg', '', '', 'dfg', '', '', '', '', '2024-06-18', '16:22:07', '2024-06-18', '16:22:07', 7),
(15, 'father name 1', 'occupation 1', 'organization 1', '011', '022', 'mother name 2', 'ocupation 2', 'organization 2', '033', '044', '2024-06-18', '16:20:32', '2024-06-18', '16:20:32', 7),
(16, 'test father name', 'fsd', 'fv', 'rdgf', 'fdg', 'fdg', 'fdg', 'gf', 'dfs', 'fdg', '2024-06-19', '11:45:30', '2024-06-19', '11:45:30', 7),
(17, 'test father name', 'test father occupation', 'test father organization', '011', '', '', 'test mother organization', 'test mother organization', '033', '066', '2024-06-19', '11:54:47', '2024-06-19', '16:42:39', 8);

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

--
-- Table structure for table `portfolio`
--

CREATE TABLE `portfolio` (
  `portfolio_id` int(11) NOT NULL,
  `portfolio_question` text NOT NULL,
  `portfolio_answer` text NOT NULL,
  `portfolio_created_date` date NOT NULL,
  `portfolio_created_time` time NOT NULL,
  `portfolio_updated_date` date NOT NULL,
  `portfolio_updated_time` time NOT NULL,
  `student_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `portfolio`
--

INSERT INTO `portfolio` (`portfolio_id`, `portfolio_question`, `portfolio_answer`, `portfolio_created_date`, `portfolio_created_time`, `portfolio_updated_date`, `portfolio_updated_time`, `student_id`) VALUES
(1, 'Are you married?', 'No', '2024-05-27', '14:42:18', '2024-05-27', '14:42:18', 7),
(2, 'Why do you choose our Campus for your Higher Education?', 'Because This Campus provide standard level programs.', '2024-05-27', '15:42:18', '2024-05-27', '15:42:18', 7),
(3, 'dfg', 'fdgf', '2024-06-13', '14:02:50', '2024-06-13', '14:02:50', 7),
(4, 'test ques 1', 'test answwer 1', '2024-06-13', '15:43:23', '2024-06-13', '15:43:23', 8),
(5, 'test ques 2', 'test answer 2', '2024-06-13', '15:50:46', '2024-06-13', '15:50:46', 8),
(6, 'test ques 3', 'test ques 3', '2024-06-13', '15:51:08', '2024-06-13', '15:51:08', 8),
(7, 'tes', 'fhdjg', '2024-06-13', '16:59:24', '2024-06-13', '16:59:24', 8),
(8, 'sfa', 'sadf', '2024-06-13', '16:59:29', '2024-06-13', '16:59:29', 8),
(9, 'sadf', 'sadf', '2024-06-13', '16:59:34', '2024-06-13', '16:59:34', 8),
(10, 'asdf', 'sdaf', '2024-06-13', '16:59:38', '2024-06-13', '16:59:38', 8),
(11, 'sdf', 'sdfa', '2024-06-13', '16:59:46', '2024-06-13', '16:59:46', 8),
(12, 'saef', 'sadf', '2024-06-14', '10:03:51', '2024-06-14', '10:03:51', 8),
(13, 'sdfg', 'fdsg', '2024-06-14', '11:02:27', '2024-06-14', '11:02:27', 8),
(14, 'gh', 'ghj', '2024-06-14', '11:11:51', '2024-06-14', '11:11:51', 8),
(15, 'fg', 'gf', '2024-06-14', '11:24:23', '2024-06-14', '11:24:23', 8),
(16, 'bm', 'ghjgh', '2024-06-14', '12:01:48', '2024-06-14', '12:01:48', 8),
(17, 'sfdg', 'fdgsfd', '2024-06-14', '12:04:00', '2024-06-14', '12:04:00', 8),
(18, 'fdg', 'sg', '2024-06-14', '12:04:09', '2024-06-14', '12:04:09', 8),
(19, 'abc', 'abs descriptin', '2024-06-14', '12:23:33', '2024-06-14', '12:23:33', 8),
(20, 'test qq', 'test aa', '2024-06-17', '14:59:01', '2024-06-17', '14:59:01', 8),
(21, 'sd', 'sdf', '2024-06-17', '15:04:05', '2024-06-17', '15:04:05', 8),
(22, 'ty', 'tyo', '2024-06-17', '15:05:30', '2024-06-17', '15:05:30', 8),
(23, 'rf', 'fdg', '2024-06-17', '15:05:51', '2024-06-17', '15:05:51', 8),
(24, 'yu', 'dfg', '2024-06-17', '15:12:36', '2024-06-17', '15:12:36', 8),
(25, 'ui', 'wqd', '2024-06-17', '15:19:37', '2024-06-17', '15:19:37', 9),
(26, 'dsf', 'dfsg', '2024-06-17', '15:22:08', '2024-06-17', '15:22:08', 8),
(27, 'bb', 'bdf', '2024-06-17', '15:22:16', '2024-06-17', '15:22:16', 8),
(28, 's', 'fd', '2024-06-17', '15:22:28', '2024-06-17', '15:22:28', 8),
(29, 'df', 'fdg', '2024-06-17', '15:24:12', '2024-06-17', '15:24:12', 8),
(30, 'zz', 'g', '2024-06-17', '15:24:19', '2024-06-17', '15:24:19', 8),
(31, 'ff', 'hh', '2024-06-17', '15:32:45', '2024-06-17', '15:32:45', 8),
(32, 'fg', 'fg', '2024-06-17', '15:39:21', '2024-06-17', '15:39:21', 8),
(33, 'gfh', 'fgh', '2024-06-17', '15:40:56', '2024-06-17', '15:40:56', 8),
(34, 'opgt', 'fdh', '2024-06-17', '15:41:25', '2024-06-17', '15:41:25', 8),
(35, 'qwe', 'qwe', '2024-06-17', '15:41:38', '2024-06-17', '15:41:38', 8),
(36, 'sdaf', 'fdg', '2024-06-17', '15:56:59', '2024-06-17', '15:56:59', 8),
(37, 'fdg', 'fdg', '2024-06-17', '16:03:34', '2024-06-17', '16:03:34', 8),
(38, 'fh', 'fh', '2024-06-17', '16:03:52', '2024-06-17', '16:03:52', 8),
(39, 'fdgfd', 'fdgh', '2024-06-17', '16:04:06', '2024-06-17', '16:04:06', 8),
(40, 'dfg', 'fdg', '2024-06-17', '16:06:26', '2024-06-17', '16:06:26', 8),
(41, 'test quetion', 'test answer', '2024-06-19', '16:43:09', '2024-06-19', '16:43:09', 8),
(42, 'test question', 'test answer', '2024-06-20', '12:50:15', '2024-06-20', '12:50:15', 8);

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

--
-- Table structure for table `program`
--

CREATE TABLE `program` (
  `program_id` int(11) NOT NULL,
  `program_name` text NOT NULL,
  `program_code` varchar(45) NOT NULL,
  `program_description` text NOT NULL,
  `program_cost` decimal(10,2) NOT NULL,
  `program_cost` decimal(10,2) NOT NULL,
  `program_start_date` date NOT NULL,
  `program_end_date` date NOT NULL,
  `program_status` int(11) NOT NULL,
  `program_created_date` date NOT NULL,
  `program_created_time` time NOT NULL,
  `program_updated_date` date NOT NULL,
  `program_updated_time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `program`
--

INSERT INTO `program` (`program_id`, `program_name`, `program_code`, `program_description`, `program_cost`, `program_start_date`, `program_end_date`, `program_status`, `program_created_date`, `program_created_time`, `program_updated_date`, `program_updated_time`) VALUES
(1, 'Advanced Diploma in Information Technology', 'ADIP-IT', 'Advanced Diploma Level - 6 months', 100000.00, '2024-06-01', '2024-12-28', 1, '2024-05-27', '13:30:07', '2024-05-27', '13:30:07'),
(2, 'Certificate in Information Technology', 'CERT-IT', 'Certificate Level - 3 Months', 60000.00, '2024-06-01', '2024-09-28', 1, '2024-05-27', '14:30:07', '2024-05-27', '14:30:07');

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

--
-- Table structure for table `student_enrollment`
--

CREATE TABLE `student_enrollment` (
  `student_enrollment_id` int(11) NOT NULL,
  `student_id` int(11) NOT NULL,
  `program_id` int(11) NOT NULL,
  `campus_id` int(11) NOT NULL,
  `branch_id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL COMMENT 'counselor user_id',
  `enrollment_status` int(11) NOT NULL COMMENT '0-Inactive|1-Active',
  `enrollment_created_date` date NOT NULL,
  `enrollment_created_time` time NOT NULL,
  `enrollment_updated_date` date NOT NULL,
  `enrollment_updated_time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `student_enrollment`
--

INSERT INTO `student_enrollment` (`student_enrollment_id`, `student_id`, `program_id`, `campus_id`, `branch_id`, `user_id`, `enrollment_status`, `enrollment_created_date`, `enrollment_created_time`, `enrollment_updated_date`, `enrollment_updated_time`) VALUES
(1, 3, 2, 1, 1, 4, 1, '2024-05-27', '17:41:28', '2024-05-27', '17:41:28'),
(2, 3, 1, 1, 1, 4, 1, '2024-05-29', '10:36:17', '2024-05-29', '10:36:17');

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

--
-- Table structure for table `user_role`
--

CREATE TABLE `user_role` (
  `user_role_id` int(11) NOT NULL,
  `user_role_name` varchar(45) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `user_role`
--

INSERT INTO `user_role` (`user_role_id`, `user_role_name`) VALUES
(1, 'Division Admin'),
(2, 'Finance Admin'),
(3, 'Center Function'),
(4, 'Counselor'),
(5, 'Student');

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

--
-- Table structure for table `work`
--

CREATE TABLE `work` (
  `work_id` int(11) NOT NULL,
  `work_job_title` text NOT NULL,
  `work_organization` text NOT NULL,
  `work_start_date` date NOT NULL,
  `work_end_date` date DEFAULT NULL,
  `work_current_work` int(11) NOT NULL,
  `work_additional_info` text NOT NULL,
  `work_doc_path` text NOT NULL,
  `work_doc_status` int(11) NOT NULL COMMENT '0-N/A|1-Available',
  `work_created_date` date NOT NULL,
  `work_created_time` time NOT NULL,
  `work_updated_date` date NOT NULL,
  `work_updated_time` time NOT NULL,
  `student_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `work`
--

INSERT INTO `work` (`work_id`, `work_job_title`, `work_organization`, `work_start_date`, `work_end_date`, `work_current_work`, `work_additional_info`, `work_doc_path`, `work_doc_status`, `work_created_date`, `work_created_time`, `work_updated_date`, `work_updated_time`, `student_id`) VALUES
(1, 'Associate Software Engineer', 'ABC (PVT) LTD', '2023-01-02', '2023-12-04', 0, 'Work as a Associate Software Engineer', '/student/assets/uploads/documents/work/8/aic-file-upload_6671477c501c9.pdf', 1, '2024-06-06', '18:00:24', '2024-06-18', '14:08:20', 8),
(2, 'Software Engineer', 'DEF (Pvt) Ltd.', '2024-01-01', NULL, 1, 'Work as a Software Engineer', '/student/assets/uploads/documents/work/8/aic-file-upload_6672b136ecf34.pdf', 1, '2024-06-06', '19:00:24', '2024-06-19', '15:51:42', 8),
(3, 'test job title', 'test orgnization', '2024-06-09', '2024-06-14', 0, 'test additional information', '/student/assets/uploads/documents/work/8/aic-file-upload_666a90c926cb7.pdf', 1, '2024-06-13', '11:55:13', '2024-06-13', '11:55:13', 8),
(4, 'test job title 2', '', '0000-00-00', '0000-00-00', 1, '', '/student/assets/uploads/documents/work/8/aic-file-upload_667147cab4d0f.pdf', 1, '2024-06-13', '11:57:50', '2024-06-18', '14:09:38', 8),
(5, '', '', '0000-00-00', '0000-00-00', 0, '', '', 0, '2024-06-13', '13:06:43', '2024-06-13', '13:06:43', 8),
(6, 'rsg', 'fdsg', '0000-00-00', '0000-00-00', 1, 'dfg', '/student/assets/uploads/documents/work/8/aic-file-upload_666acfeaa1abe.pdf', 1, '2024-06-13', '16:24:34', '2024-06-13', '16:24:34', 8),
(7, 'gtr', 'rgtd', '0000-00-00', '0000-00-00', 1, 'rfg', '/student/assets/uploads/documents/work/8/aic-file-upload_667276636bf2b.pdf', 1, '2024-06-13', '16:31:02', '2024-06-19', '11:40:43', 8),
(8, 'tesr op', 'test po', '0000-00-00', '0000-00-00', 0, 'sadfsdf', '/student/assets/uploads/documents/work/8/aic-file-upload_666ad42b5b678.pdf', 1, '2024-06-13', '16:42:43', '2024-06-13', '16:42:43', 8),
(9, 'efds', 'sadf', '0000-00-00', '0000-00-00', 0, 'sdfasd', '/student/assets/uploads/documents/work/8/aic-file-upload_666ad6ee65d31.pdf', 1, '2024-06-13', '16:54:30', '2024-06-13', '16:54:30', 8),
(10, 'th', 'd', '0000-00-00', '0000-00-00', 0, 'df', '/student/assets/uploads/documents/work/8/aic-file-upload_6672767fdfc80.pdf', 1, '2024-06-13', '16:55:20', '2024-06-19', '11:41:11', 8),
(11, 'test', 'fdg', '0000-00-00', '0000-00-00', 0, 'dgf', '', 0, '2024-06-14', '10:03:30', '2024-06-14', '10:03:30', 8),
(12, 'test d', 'DJH', '0000-00-00', '0000-00-00', 0, 'fds', '', 0, '2024-06-14', '11:08:01', '2024-06-14', '11:08:01', 8),
(13, 'fgv', 'fdg', '0000-00-00', '0000-00-00', 0, 'sdffd', '', 0, '2024-06-14', '11:13:05', '2024-06-14', '11:13:05', 8),
(14, 'fdg', 'dfg', '0000-00-00', '0000-00-00', 0, 'dg', '', 0, '2024-06-17', '15:23:32', '2024-06-17', '15:23:32', 8),
(15, 'f', 'fg', '0000-00-00', '0000-00-00', 0, 'fd', '', 0, '2024-06-17', '15:24:30', '2024-06-17', '15:24:30', 8),
(16, 'q', 'a', '0000-00-00', '0000-00-00', 0, 'qa', '', 0, '2024-06-17', '15:24:46', '2024-06-17', '15:24:46', 8),
(17, 'rt', 'tr', '2024-06-20', '0000-00-00', 1, 'oppo', '/student/assets/uploads/documents/work/8/aic-file-upload_667148aef307b.pdf', 1, '2024-06-18', '14:13:13', '2024-06-18', '14:13:26', 8);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `a_level`
--
ALTER TABLE `a_level`
  ADD PRIMARY KEY (`a_level_id`);

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

--
-- Indexes for table `campus`
--
ALTER TABLE `campus`
  ADD PRIMARY KEY (`campus_id`);

--
-- Indexes for table `education`
--
ALTER TABLE `education`
  ADD PRIMARY KEY (`education_id`);

--
-- Indexes for table `education_qual`
--
ALTER TABLE `education_qual`
  ADD PRIMARY KEY (`education_qual_id`);

--
-- Indexes for table `education_type`
--
ALTER TABLE `education_type`
  ADD PRIMARY KEY (`education_type_id`);

--
-- Indexes for table `language`
--
ALTER TABLE `language`
  ADD PRIMARY KEY (`language_id`);

--
-- Indexes for table `lead`
--
ALTER TABLE `lead`
  ADD PRIMARY KEY (`lead_id`);

--
-- Indexes for table `note`
--
ALTER TABLE `note`
  ADD PRIMARY KEY (`note_id`);

--
-- Indexes for table `o_level`
--
ALTER TABLE `o_level`
  ADD PRIMARY KEY (`o_level_id`);

--
-- Indexes for table `payment_plan`
--
ALTER TABLE `payment_plan`
  ADD PRIMARY KEY (`payment_plan_id`);

--
-- Indexes for table `personal_info`
--
ALTER TABLE `personal_info`
  ADD PRIMARY KEY (`personal_info_id`);

--
-- Indexes for table `portfolio`
--
ALTER TABLE `portfolio`
  ADD PRIMARY KEY (`portfolio_id`);

--
-- Indexes for table `program`
--
ALTER TABLE `program`
  ADD PRIMARY KEY (`program_id`);

--
-- Indexes for table `student_enrollment`
--
ALTER TABLE `student_enrollment`
  ADD PRIMARY KEY (`student_enrollment_id`);

--
-- Indexes for table `user_role`
--
ALTER TABLE `user_role`
  ADD PRIMARY KEY (`user_role_id`);

--
-- Indexes for table `work`
--
ALTER TABLE `work`
  ADD PRIMARY KEY (`work_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `a_level`
--
ALTER TABLE `a_level`
  MODIFY `a_level_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

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

--
-- AUTO_INCREMENT for table `education_qual`
--
ALTER TABLE `education_qual`
  MODIFY `education_qual_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

--
-- AUTO_INCREMENT for table `education_type`
--
ALTER TABLE `education_type`
  MODIFY `education_type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
ALTER TABLE `education_qual`
  MODIFY `education_qual_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

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

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

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

--
-- AUTO_INCREMENT for table `note`
--
ALTER TABLE `note`
  MODIFY `note_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=67;

--
-- AUTO_INCREMENT for table `o_level`
--
ALTER TABLE `o_level`
  MODIFY `o_level_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

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

--
-- AUTO_INCREMENT for table `personal_info`
--
ALTER TABLE `personal_info`
  MODIFY `personal_info_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `portfolio`
--
ALTER TABLE `portfolio`
  MODIFY `portfolio_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=43;

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

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

--
-- AUTO_INCREMENT for table `user_role`
--
ALTER TABLE `user_role`
  MODIFY `user_role_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `work`
--
ALTER TABLE `work`
  MODIFY `work_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
COMMIT;

