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

START TRANSACTION;



--
-- Database: `no01`
--

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

--
-- Table structure for table `atps`
--

CREATE TABLE `atps` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `organization_name` varchar(255) NOT NULL,
  `street_address` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `state` varchar(255) NOT NULL,
  `postal_code` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `employer_identity_number` varchar(255) NOT NULL,
  `previous_provider_number` varchar(255) NOT NULL,
  `dba` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `archive` int(11) NOT NULL DEFAULT 1,
  `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 `atps`
--

INSERT INTO `atps` (`id`, `user_id`, `organization_name`, `street_address`, `city`, `state`, `postal_code`, `country`, `employer_identity_number`, `previous_provider_number`, `dba`, `status`, `archive`, `created_at`, `updated_at`) VALUES
(5, 1, 'Apolo', 'no,22 Jalan Taman Impian', 'Barcelona', 'Selangor', '59000', 'Malaysia', 'gf443', '0128746220', 'edqwedqa', '1', 1, '2024-03-28 20:05:54', '2024-03-29 00:29:45'),
(6, 2, 'Syabas sdn bhd', 'no 6, taman  alam jaya', 'Barcelona', 'Yogyakarta', '23413', 'Indonesia', '0bbyrq', '0128783311', 'none', '0', 0, '2024-03-28 20:14:32', '2024-03-28 20:35:03'),
(7, 2, 'Syabas sdn bhd', 'no 6, taman  alam jaya', 'Barcelona', 'Yogyakarta', '23413', 'Indonesia', '0bbyrq', '0128783311', 'none', '0', 0, '2024-03-28 20:14:32', '2024-03-29 01:07:16'),
(8, 2, 'SEL 123', 'gg', 'i dont know', 'Zou', '23413', 'Benin', '0bbyrq', '0128746220', '-', 'pending', 0, '2024-03-28 20:23:47', '2024-03-28 20:28:44'),
(9, 3, 'Homebois Anchor', 'no,22 Jalan Taman Impian', 'Bukit Jelutong', 'Ohio', '42540', 'United States', 'D3212010821A', '63264442897', 'Apolo', 'pending', 0, '2024-03-28 20:44:21', '2024-03-28 20:44:38'),
(10, 3, 'Wild Card', 'no. 90 tak jumpa jalan', 'PI', 'Ras Al Khaimah', '876543', 'United Arab Emirates', '0bbyrq', '0128783311', 'edqwedqa', 'pending', 0, '2024-03-28 20:56:50', '2024-03-28 20:57:35'),
(11, 5, 'ddkr', 'no. 90 tak jumpa jalan', 'Gaza', 'Gaza Strip', '42540', 'Palestine', '0bbyrq', '0128783311', 'edqwedqa', 'pending', 0, '2024-03-28 21:09:47', '2024-03-29 00:17:44'),
(12, 5, 'tgef', 'refrvg', 'verc', 'Baucau', '45566', 'East Timor', '0bbyrq', '0128783311', '---------------------------', 'pending', 0, '2024-03-28 21:18:07', '2024-03-29 00:17:45'),
(13, 3, 'swrf', 'no. 90 tak jumpa jalan', 'Tawau', 'Luxembourg', '23413', 'Belgium', 'D3212010821A', '0128783311', '---------------------------', 'pending', 0, '2024-03-28 23:48:51', '2024-03-29 00:17:46'),
(14, 3, 'werthjk', 'dsefgthygjkuilo', 'Barcelona', 'England', '59000', 'United Kingdom', 'D3212010821A', '0128783311', '---------------------------', 'pending', 1, '2024-03-28 23:53:49', '2024-03-29 00:29:41'),
(15, 3, 'Syabas sdn bhd', 'no 6, taman  alam jaya', 'Tawau', 'Hainaut', '59000', 'Belgium', 'D3212010821A', '63264442897', 'none', 'pending', 0, '2024-03-29 00:07:02', '2024-03-29 00:07:02'),
(17, 3, 'Syabas sdn bhd', 'no. 90 tak jumpa jalan', 'i dont know', 'West Papua', '876543', 'Indonesia', '0bbyrq', '0128783311', 'none', 'pending', 1, '2024-03-29 00:25:12', '2024-03-29 00:25:12'),
(18, 2, 'Apolo', 'no. 90 tak jumpa jalan', 'Bukit Jelutong', 'Koror', '45566', 'Palau', '0bbyrq', '0128746220', '---------------------------', '1', 0, '2024-03-29 00:32:25', '2024-03-29 01:06:59');

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

--
-- Table structure for table `cdas`
--

CREATE TABLE `cdas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `title_home` varchar(255) NOT NULL,
  `description_home` text NOT NULL,
  `title` varchar(255) NOT NULL,
  `description1_section1` text NOT NULL,
  `description2_section3` text NOT NULL,
  `image_section3` varchar(255) NOT NULL,
  `title_section4` text NOT NULL,
  `description3_section4` text NOT NULL,
  `add_or_section4` varchar(255) DEFAULT NULL,
  `description4_section4` text DEFAULT NULL,
  `archive` int(11) NOT NULL DEFAULT 1,
  `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 `cdas`
--

INSERT INTO `cdas` (`id`, `name`, `title_home`, `description_home`, `title`, `description1_section1`, `description2_section3`, `image_section3`, `title_section4`, `description3_section4`, `add_or_section4`, `description4_section4`, `archive`, `created_at`, `updated_at`) VALUES
(1, 'CDA', 'Certified Data Analyst', 'Certified data analysts can use a variety of tools and techniques to identify trends, patterns, and relationships in data. They can also use this information to develop solutions to business problems and improve decision-making', 'CDA', 'This certificate is designed to validate the skills and knowledge of individuals who collect, clean, and analyze data to extract valuable insights. Certified data analysts can use a variety of tools and techniques to identify trends, patterns, and relationships in data. They can also use this information to develop solutions to business problems and improve decision-making.\r\n\r\nTo obtain CDA certification, a participant must meet certain requirements and then pass a 100-question exam. The CDA exam was created by data analyst for data analyst, so each test question can be related to real-life data project experiences.', 'The CDA certification is widely recognized as the premier data analysis credential in Southeast Asia. This distinction highlights your command of the skills employers seek, your unwavering dedication to professional excellence, and your capacity to perform at the highest echelons of data analysis expertise.\r\n\r\nFurthermore, industry research indicates a burgeoning demand for data analysts, forecasting nearly 2.3 million new project-oriented roles to be filled each year through 2030. With the demand for data analysts soaring to unprecedented levels, there has never been a more opportune moment to earn your CDA certification and embark on a rewarding career path.', '1710998273.jpg', 'To sit for the exam, you must meet the following CDA requirements:', '- Have a secondary degree, such as a high school diploma, GED (general educational development), or global equivalent\r\n- 16 hours of data analysis education/training\r\n- Have basic knowledge of data exploration, data cleaning, data analyzing', NULL, NULL, 0, '2024-03-20 21:17:54', '2024-03-26 00:42:33'),
(2, 'CDS', 'Certified Data Science', 'Certified data scientists have a deep understanding of statistics, machine learning, and artificial intelligence. They can build and train predictive models, identify outliers and anomalies, and develop data-driven strategies.', 'CDS', 'The CDS certification validates the proficiency of data science professionals in utilizing data-driven solutions to tackle intricate business challenges. Certified data scientists possess a comprehensive grasp of statistical concepts, machine learning techniques, and artificial intelligence principles. They excel in constructing and training predictive models, detecting outliers and anomalies, and formulating data-driven strategies.\r\n\r\nEarning CDS certification entails fulfilling specific prerequisites and successfully completing a 100-question examination. The exam encompasses questions related to data science methodology, data analysis, and machine learning with Python. The CDS exam, meticulously crafted by data analysts for data analysts, ensures that each question draws upon real-world data project experiences. This practical approach fosters a deeper understanding of the practical applications of data science in diverse business scenarios.', '1. Help you to demonstrate to potential employers that you have the skills and knowledge necessary to be successful in the field.\r\n2. Data science is a rapidly growing field with high demand for skilled professionals.\r\n3. Earning this certification will help you demonstrate your skills and knowledge to potential employers.\r\nThe field of data science is constantly evolving, and new technologies and techniques are emerging all the time.', '1711002262.jpg', 'Earning your CDS certification is a commitment. That\'s part of what makes it valuable. If you have real-world data science project experience, you’ve finished the hardest part. Before you apply, make sure you meet one of the following sets of CDA Certification requirements:', '- Four-Year College / University Degree\r\n- 20 months of experience working in data science projects within the past eight years\r\n- 24 hours of data analysis education/training or CDA certification', 'OR', '- High School or Secondary School Diploma\r\n- 20 months of experience working in data science projects within the past eight years\r\n- 28 hours of data analysis education/training or CDA certification', 0, '2024-03-20 22:24:22', '2024-03-20 22:24:22'),
(3, 'CDE', 'Certified Data Engineer', 'Certified data engineers have a deep understanding of big data technologies, such as Hadoop, Spark, and Hive. They can design and implement data pipelines, create and optimize data warehouses, and develop data governance policies.', 'CDE', 'The CDE certification validates the expertise of data infrastructure professionals in constructing, maintaining, and governing data ecosystems. Certified data engineers possess a profound comprehension of big data technologies, including Hadoop, Spark, and Hive. They excel in designing and implementing data pipelines, establishing, and optimizing data warehouses, and formulating data governance policies.\r\n\r\nAchieving CDE certification necessitates fulfilling specific prerequisites and successfully completing a 100-question examination. The exam encompasses questions pertaining to relational database management systems (RDBMS), data pipelines, and data warehousing. The CDE exam, meticulously crafted by data engineers for data engineers, ensures that each question draws upon real-world data project experiences. This practical approach cultivates a deeper understanding of the intricacies involved in building and managing robust data infrastructure.', '1. Data engineering is a critical role in any organization that collects and stores data.\r\n2. Earning this certification will help you demonstrate your skills and knowledge to potential employers.\r\n3. It can also help you command a higher salary.', '1711002578.jpg', 'To sit for the exam, you must meet the following CDA requirements:', '- Have a secondary degree, such as a high school diploma, GED (general educational development), or global equivalent.\r\n- 30 hours of data engineer education/training\r\n- Have basic knowledge of RDBMS, data pipelines, and data warehouse.\r\n- IBM\r\n- Must have a bachelor\'s degree in a related field, such as computer science, data ethics, and data modelling.\r\n- You must also have at least two years of working experience', NULL, NULL, 0, '2024-03-20 22:29:38', '2024-03-20 22:29:38'),
(4, 'CAI', 'Certified in Artificial Intelligent', 'Certified AI professionals have a deep understanding of machine learning, deep learning, and natural language processing. They can build and train AI models, design and implement AI solutions, and evaluate the performance of AI systems.', 'CAI', 'This certification validates the skills and expertise of individuals who design, develop, and implement artificial intelligence (AI) systems. Certified AI professionals possess a comprehensive understanding of machine learning, deep learning, and natural language processing. They are capable of building and training AI models, crafting and executing AI solutions, and evaluating the performance of AI systems.\r\n\r\nTo earn CAI certification, candidates must fulfil specific prerequisites and subsequently pass a 100-question examination. The exam encompasses machine learning, deep learning, and AI ethics, with each question grounded in real-world data project experiences, ensuring its relevance to practical applications.', '1. AI is a rapidly growing field with a wide range of applications.\r\n2. Earning this certification will help you demonstrate your understanding of AI to potential employers.\r\n3. It can also help you command a higher salary.', '1711002694.jpg', 'To sit for the exam, you must meet the following CAI requirements:', '- Have a secondary degree, such as a high school diploma, GED (general educational development), or global equivalent.\r\n- 24 hours of Artificial Intelligent education/training\r\n- Have basic knowledge of machine learning, deep learning, and AI ethics\r\n- IBM\r\n- To be eligible to earn this certification, you must have a bachelor\'s degree in a related field, such as computer science, mathematics, or engineering.\r\n- You must also have at least two years of working experience.', NULL, NULL, 0, '2024-03-20 22:31:34', '2024-03-20 22:31:34'),
(5, 'CML', 'Certified in Machine Learning', 'Certified machine learning professionals have a deep understanding of machine learning algorithms, and model deployment. They can build and train machine learning models, select the appropriate algorithm, and evaluate the performance of machine learning models.', 'CML', 'The Certified in Machine Learning (CML) certification validates the expertise of individuals who design, develop, and implement machine learning models. Holders of this certification possess a comprehensive understanding of machine learning algorithms, model evaluation techniques, and model deployment strategies. They are equipped to construct and train machine learning models, select the most suitable algorithm for a given problem, and effectively assess the performance of machine learning models.\r\n\r\nTo earn the CML certification, candidates must fulfil specific prerequisites and pass a rigorous 100-question exam. The exam encompasses supervised, unsupervised, and advanced machine learning concepts. Designed by data analysts for data analysts, the CML exam incorporates real-world data project experiences into each test question.', '1. Machine learning is a powerful tool that can be used to solve a wide range of problems.\r\n2. Earning this certification will help you demonstrate your skills and knowledge of machine learning to potential employers.\r\n3. It can also help you command a higher salary.', '1711002840.jpg', 'To sit for the exam, you must meet the following CML requirements:', '- Have a secondary degree, such as a high school diploma, GED (general educational development), or global equivalent.\r\n- 24 hours of machine learning education/training\r\n- Have basic knowledge of supervised, unsupervised, and advance machine learning.\r\n- To be eligible to earn this certification, you must have a bachelor\'s degree in a related field, such as computer science, mathematics, or statistics.\r\n- You must also have at least two years of experience using machine learning algorithms.', NULL, NULL, 0, '2024-03-20 22:34:00', '2024-03-20 22:54:15'),
(6, 'CDL', 'Certified in Deep Learning', 'Certified deep learning professionals have a deep understanding of deep learning algorithms, neural networks, and model optimization. They can build and train deep learning models, design and implement deep learning solutions, and evaluate the performance of deep learning models.', 'CDL', 'The Certified in Deep Learning (CDL) certification distinguishes individuals who demonstrate exceptional proficiency in designing, developing, and deploying deep learning models. CDL holders possess a profound grasp of deep learning algorithms, neural network architectures, and model optimization techniques. They are adept at constructing and training deep learning models, devising and implementing deep learning solutions, and rigorously evaluating the performance of deep learning models.\r\n\r\nTo attain the coveted CDL certification, candidates must meet stringent prerequisites and excel in a demanding 100-question exam. The exam delves into the intricacies of neural networks, convolutional neural networks, and recurrent neural networks. Crafted by data analysts for data analysts, the CDL exam ensures that each test question aligns with real-world data project experiences.', '1. Deep learning is a cutting-edge technology that is being used to solve a wide range of problems.\r\n2. Earning this certification will help you demonstrate your skills and knowledge of deep learning to potential employers.\r\n3. It can also help you command a higher salary.', '1711002959.jpg', 'To sit for the exam, you must meet the following CDL requirements:', '- Have a secondary degree, such as a high school diploma, GED (general educational development), or global equivalent.\r\n- 24 hours of data analysis education/training.\r\n- Have basic knowledge of neural networks, convolutional, and sequence models.\r\n- DeepLearning.AI\r\n- To be eligible to earn this certification, you must have a bachelor\'s degree in a related field, such as computer science, mathematics, or statistics.\r\n- You must also have at least two years of experience using deep learning models.', NULL, NULL, 0, '2024-03-20 22:35:59', '2024-03-20 22:35:59'),
(7, 'CDM', 'Certified in Data Mining', 'Certified data miners have a deep understanding of data mining algorithms, data preparation, and data visualization. They can identify patterns and trends in data, develop data mining models, and communicate the results of their analysis to others', 'CDM', 'The CDM certification attests to the proficiency of data mining professionals in extracting meaningful insights from vast repositories of data. Certified data miners possess a comprehensive grasp of data mining algorithms, data preparation techniques, and data visualization principles. They excel in identifying patterns and trends within datasets, constructing data mining models, and effectively communicating their findings to diverse audiences.\r\n\r\nEarning CDM certification entails fulfilling specific eligibility criteria and successfully completing a 100-question examination. The exam encompasses questions covering text retrieval and search engines, pattern discovery, and cluster analysis. The CDM exam, meticulously crafted by data analysts for data analysts, ensures that each question draws upon real-world data project experiences. This practical approach fosters a deeper understanding of the challenges and applications of data mining in various business contexts.', '1. Data mining is a valuable skill that can be used to gain insights from data that can be used to make informed decisions.\r\n2. Earning this certification will help you demonstrate your skills and knowledge of data mining to potential employers.\r\n3. It can also help you command a higher salary.', '1711003094.jpg', 'To sit for the exam, you must meet the following CDM requirements:', '- Have a secondary degree, such as a high school diploma, GED (general educational development), or global equivalent.\r\n- 18 hours of data mining education/training\r\n- Have basic knowledge of Text Retrieval and Search Engines, pattern discovery, and cluster analysis.\r\n- Illinois\r\n- To be eligible to earn this certification, you must have a bachelor\'s degree in a related field, such as computer science, statistics, or data visualization.\r\n- You must also have at least two years of experience using data mining tools and techniques.', NULL, NULL, 0, '2024-03-20 22:38:14', '2024-03-20 22:38:14'),
(8, 'CBC', 'Certified in Blockchain', 'Certified Blockchain serves as a testament to the expertise of individuals in comprehending and applying the foundational principles of blockchain technology.', 'CBC', 'The Certified in Blockchain (CBC) certification serves as a testament to the expertise of individuals in comprehending and applying the foundational principles of blockchain technology. Blockchain, a revolutionary distributed ledger technology, empowers the creation of secure and transparent transaction records, fostering trust and immutability in diverse applications.\r\n\r\nBy earning the CBC credential, professionals demonstrate their proficiency in blockchain\'s core concepts, including decentralization, consensus mechanisms, cryptography, and smart contracts. The certification equips individuals with the knowledge and skills to navigate the rapidly evolving blockchain landscape, empowering them to contribute meaningfully to the development and implementation of blockchain-based solutions.', '1. Blockchain is a rapidly growing technology with a wide range of applications.\r\n2. Earning this certification will help you demonstrate your understanding of blockchain to potential employers.\r\n3. It can also help you command a higher salary.', '1711003200.jpg', 'To sit for the exam, you must meet the following CBC requirements:', '- Have a secondary degree, such as a high school diploma, GED (general educational development), or global equivalent.\r\n- 20 hours of blockchain education/training\r\n- Have basic knowledge of decentralization, consensus mechanisms, cryptography, and smart contracts.\r\n- UB\r\n- To be eligible to earn this certification, you must have a bachelor\'s degree in a related field, such as computer science, business, or finance.\r\n- You must also have at least two years of experience using blockchain technology.', NULL, NULL, 0, '2024-03-20 22:40:00', '2024-03-20 22:40:00'),
(9, 'CCS', 'Certified in Cybersecurity', 'Certified cybersecurity stands as a globally recognized emblem of excellence in cybersecurity, validating the expertise of individuals in safeguarding critical information assets.', 'CCS', 'The Certified in Cyber Security (CCS) stands as a globally recognized emblem of excellence in cybersecurity, validating the expertise of individuals in safeguarding critical information assets. Cybersecurity, an indispensable facet of today\'s digital world, encompasses the comprehensive protection of systems, networks, and data from a multitude of threats, including unauthorized access, misuse, disclosure, disruption, alteration, or destruction.\r\n\r\nBy attaining the CCS credential, professionals demonstrate their mastery of cybersecurity\'s core concepts, encompassing risk assessment and management, security architecture and engineering, incident response, and security governance. The certification empowers individuals to effectively navigate the ever-evolving cybersecurity landscape, enabling them to safeguard sensitive information and mitigate emerging threats.', '1. Cybersecurity is a critical skill in today\'s interconnected world.\r\n2. Earning this certification will help you demonstrate your skills and knowledge of cybersecurity to potential employers.\r\n3. It can also help you command a higher salary.', '1711003297.jpg', 'To sit for the exam, you must meet the following CCS requirements:', '- Have a secondary degree, such as a high school diploma, GED (general educational development), or global equivalent.\r\n- 20 hours of cyber security education/training\r\n- Have basic knowledge of unauthorized access, misuse, disclosure, disruption, alteration, or destruction.\r\n- Google\r\n- To be eligible to earn this certification, you must have a bachelor\'s degree in a related field, such as computer science, information security, or network engineering.\r\n- You must also have at least two years of working experience.', NULL, NULL, 0, '2024-03-20 22:41:37', '2024-03-20 22:41:37'),
(10, 'CHD', 'Certified in Hadoop for Big Data', 'Certified Hadoop professionals have a deep understanding of the Hadoop ecosystem, including HDFS, Hive, and Spark. They can design and implement Hadoop clusters, develop Hadoop applications, and optimize Hadoop performance.', 'CHD', 'The Certified Hadoop for Big Data (CHD) credential validates the expertise of individuals in harnessing the power of Hadoop to process and analyze vast amounts of data. Certified Hadoop professionals possess a comprehensive understanding of the Hadoop ecosystem, encompassing HDFS, Hive, and Spark. Their proficiency enables them to design and implement Hadoop clusters, develop robust Hadoop applications, and optimize Hadoop performance for enhanced efficiency.\r\n\r\nTo attain CHD certification, candidates must meet specific prerequisites and successfully complete a rigorous 100-question examination. The exam meticulously assesses candidates\' knowledge of HDFS, MapReduce, and Spark, mirroring real-world data project scenarios. The CHD exam, meticulously crafted by data analysts for data analysts, ensures that each question reflects practical industry challenges and applications.', '1. Demonstrates that you have the expertise to manage and analyze big data using Hadoop.\r\n2. Can open up new career opportunities, including senior-level positions with greater responsibilities and higher salaries.\r\n3. Can help you stay up to date with the latest trends and technologies.', '1711003436.jpg', 'To sit for the exam, you must meet the following CHD requirements:', '- Have a secondary degree, such as a high school diploma, GED (general educational development), or global equivalent.\r\n- 20 hours of data analysis education/training\r\n- Have basic knowledge of HDFS, MapReduce, and Spark\r\n- UC San Diego', NULL, NULL, 0, '2024-03-20 22:43:56', '2024-03-20 22:43:56');

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

--
-- Table structure for table `codes`
--

CREATE TABLE `codes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `contents`
--

CREATE TABLE `contents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `organization` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `contact_person` varchar(255) DEFAULT NULL,
  `contact_phone` varchar(255) DEFAULT NULL,
  `contact_email` varchar(255) DEFAULT NULL,
  `date_started` date NOT NULL,
  `date_completed` date NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `provider_name` varchar(255) NOT NULL,
  `course` varchar(255) NOT NULL,
  `description` text DEFAULT NULL,
  `date_started` date NOT NULL,
  `date_completed` date NOT NULL,
  `contact_person` varchar(255) DEFAULT NULL,
  `contact_phone` varchar(255) DEFAULT NULL,
  `contact_email` varchar(255) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT 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 `courses`
--

INSERT INTO `courses` (`id`, `provider_name`, `course`, `description`, `date_started`, `date_completed`, `contact_person`, `contact_phone`, `contact_email`, `user_id`, `created_at`, `updated_at`) VALUES
(1, 'test', 'Management', '-', '2024-03-13', '2024-04-04', NULL, NULL, NULL, 3, '2024-03-26 17:00:10', '2024-03-26 17:00:10');

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

--
-- Table structure for table `eligibilities`
--

CREATE TABLE `eligibilities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `education_level` varchar(255) NOT NULL,
  `education_country` varchar(255) NOT NULL,
  `years_attended` varchar(255) NOT NULL,
  `provider_name` varchar(255) NOT NULL,
  `course_title` varchar(255) NOT NULL,
  `course_start_month` date NOT NULL,
  `course_end_month` date NOT NULL,
  `qualifying_hours` int(11) NOT NULL,
  `organization` varchar(255) NOT NULL,
  `job_title` varchar(255) NOT NULL,
  `functional_area` varchar(255) NOT NULL,
  `organization_focus` varchar(255) NOT NULL,
  `working_period_start_month` date NOT NULL,
  `working_period_end_month` date NOT NULL,
  `status` int(11) NOT NULL DEFAULT 2,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `certificate_id` bigint(20) UNSIGNED 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 `eligibilities`
--

INSERT INTO `eligibilities` (`id`, `education_level`, `education_country`, `years_attended`, `provider_name`, `course_title`, `course_start_month`, `course_end_month`, `qualifying_hours`, `organization`, `job_title`, `functional_area`, `organization_focus`, `working_period_start_month`, `working_period_end_month`, `status`, `user_id`, `certificate_id`, `created_at`, `updated_at`) VALUES
(4, 'MastersDegree', 'UK/Leicester', '1999-2002', 'yolo', 'graphic designer', '2024-02-25', '2024-04-05', 90, 'Malindo Air', 'Web designer', 'chip', 'eden hazard', '2024-03-04', '2024-04-11', 1, 1, 8, '2024-03-20 23:48:15', '2024-03-27 20:46:49'),
(5, 'MastersDegree', 'Malaysia', '2018-2027', 'OCTOPUS', 'EXCEL', '2024-01-16', '2024-03-29', 72, 'polo sdn bhd', 'Web designer', 'Test', 'Hold', '2024-01-23', '2024-03-19', 0, 2, 7, '2024-03-24 21:48:44', '2024-03-28 19:48:38'),
(6, 'BachelorDegree', 'Malaysia', '2018-2026', 'ux', 'EXCEL', '2024-03-11', '2024-04-04', 72, 'Malindo Air', 'IOT', 'Try', 'ucl', '2024-03-19', '2024-04-01', 2, 3, 8, '2024-03-26 14:20:43', '2024-03-26 23:02:41'),
(7, 'Doctorate', 'PORTUGAL/LISBON', '2018-2028', 'OCTOPUS', 'IOT', '2004-10-27', '2007-01-16', 164, 'POL SDN BHD', 'IOT', 'Test', 'Hold', '2008-05-13', '2024-03-27', 2, 1, 5, '2024-03-26 19:27:53', '2024-03-27 00:26:09'),
(8, 'HighSchoolDiploma', 'Malaysia', '2018-2027', 'yolo', 'EXCEL', '2024-04-03', '2024-04-05', 90, 'POL SDN BHD', 'Web designer', 'Trys y', 'eden', '2024-03-19', '2024-04-05', 2, 2, 2, '2024-03-28 00:31:33', '2024-03-28 00:31:33'),
(9, 'AssociatesDegree', 'Costa Rica', '2009-2012', 'ux', 'Data Analytic', '2020-01-01', '2021-06-08', 164, 'eeee', 'Driver', 'OL', 'Hold', '2021-10-30', '2024-03-28', 2, 2, 2, '2024-03-28 00:40:15', '2024-03-28 00:40:15');

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `informals`
--

CREATE TABLE `informals` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `organization_group` varchar(255) NOT NULL,
  `course` varchar(255) NOT NULL,
  `discussion_topic` text NOT NULL,
  `date_started` date NOT NULL,
  `date_completed` date NOT NULL,
  `contact_person` varchar(255) DEFAULT NULL,
  `contact_phone` varchar(255) DEFAULT NULL,
  `contact_email` varchar(255) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `knowledge`
--

CREATE TABLE `knowledge` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `organization` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `contact_person` varchar(255) DEFAULT NULL,
  `contact_phone` varchar(255) DEFAULT NULL,
  `contact_email` varchar(255) DEFAULT NULL,
  `date_started` date NOT NULL,
  `date_completed` date NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `provider_name` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `date_started` date NOT NULL,
  `date_completed` date NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `meetings`
--

CREATE TABLE `meetings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `organization` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `meeting_number` varchar(255) DEFAULT NULL,
  `description` text NOT NULL,
  `date_started` date NOT NULL,
  `date_completed` date NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(13, '2014_10_12_000000_create_users_table', 1),
(14, '2014_10_12_100000_create_password_reset_tokens_table', 1),
(15, '2019_08_19_000000_create_failed_jobs_table', 1),
(16, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(17, '2024_02_02_033352_user_background', 1),
(18, '2024_03_04_171042_create_cdas_table', 1),
(19, '2024_03_04_171258_create_eligibilities_table', 1),
(20, '2024_03_18_030133_create_courses_table', 1),
(21, '2024_03_18_033218_create_meetings_table', 1),
(22, '2024_03_18_033234_create_media_table', 1),
(23, '2024_03_18_033245_create_reads_table', 1),
(24, '2024_03_18_033318_create_codes_table', 1),
(25, '2024_03_18_033327_create_works_table', 1),
(26, '2024_03_18_033335_create_contents_table', 1),
(27, '2024_03_18_033354_create_presentations_table', 1),
(28, '2024_03_18_033411_create_knowledge_table', 1),
(29, '2024_03_18_033457_create_volunteers_table', 1),
(30, '2024_03_18_033935_create_informals_table', 1),
(31, '2024_03_21_071516_add_certificate_id_to_eligibilities', 2),
(32, '2024_03_22_033140_create_atp_table', 3),
(33, '2024_03_25_013851_create_atps_table', 4);

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

--
-- Table structure for table `presentations`
--

CREATE TABLE `presentations` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `audience` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `contact_person` varchar(255) DEFAULT NULL,
  `contact_phone` varchar(255) DEFAULT NULL,
  `contact_email` varchar(255) DEFAULT NULL,
  `date_started` date NOT NULL,
  `date_completed` date NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT 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 `presentations`
--

INSERT INTO `presentations` (`id`, `audience`, `title`, `description`, `url`, `contact_person`, `contact_phone`, `contact_email`, `date_started`, `date_completed`, `user_id`, `created_at`, `updated_at`) VALUES
(1, '67', 'testing', '-', 'http://127.0.0.1:8000/Read', '0122324459', NULL, 'cubaan123@gmail.com', '2024-02-29', '2024-04-06', 3, '2024-03-26 17:02:24', '2024-03-26 17:02:24');

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

--
-- Table structure for table `reads`
--

CREATE TABLE `reads` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `author` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `date_started` date NOT NULL,
  `date_completed` date NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `volunteers`
--

CREATE TABLE `volunteers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `organization` varchar(255) NOT NULL,
  `volunteer_course` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `url` varchar(255) DEFAULT NULL,
  `contact_person` varchar(255) DEFAULT NULL,
  `contact_phone` varchar(255) DEFAULT NULL,
  `contact_email` varchar(255) DEFAULT NULL,
  `date_started` date NOT NULL,
  `date_completed` date NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `works`
--

CREATE TABLE `works` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `employer` varchar(255) NOT NULL,
  `job_title` varchar(255) NOT NULL,
  `responsibilities` text DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `contact_person` varchar(255) DEFAULT NULL,
  `contact_phone` varchar(255) DEFAULT NULL,
  `contact_email` varchar(255) DEFAULT NULL,
  `date_started` date NOT NULL,
  `date_completed` date NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `atps`
--
ALTER TABLE `atps`
  ADD PRIMARY KEY (`id`),
  ADD KEY `atps_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `codes`
--
ALTER TABLE `codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `codes_user_id_foreign` (`user_id`);

--
-- Indexes for table `contents`
--
ALTER TABLE `contents`
  ADD PRIMARY KEY (`id`),
  ADD KEY `contents_user_id_foreign` (`user_id`);

--
-- Indexes for table `courses`
--
ALTER TABLE `courses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `courses_user_id_foreign` (`user_id`);

--
-- Indexes for table `eligibilities`
--
ALTER TABLE `eligibilities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `eligibilities_user_id_foreign` (`user_id`),
  ADD KEY `eligibilities_certificate_id_foreign` (`certificate_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `informals`
--
ALTER TABLE `informals`
  ADD PRIMARY KEY (`id`),
  ADD KEY `informals_user_id_foreign` (`user_id`);

--
-- Indexes for table `knowledge`
--
ALTER TABLE `knowledge`
  ADD PRIMARY KEY (`id`),
  ADD KEY `knowledge_user_id_foreign` (`user_id`);

--
-- Indexes for table `media`
--
ALTER TABLE `media`
  ADD PRIMARY KEY (`id`),
  ADD KEY `media_user_id_foreign` (`user_id`);

--
-- Indexes for table `meetings`
--
ALTER TABLE `meetings`
  ADD PRIMARY KEY (`id`),
  ADD KEY `meetings_user_id_foreign` (`user_id`);

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

--
-- Indexes for table `presentations`
--
ALTER TABLE `presentations`
  ADD PRIMARY KEY (`id`),
  ADD KEY `presentations_user_id_foreign` (`user_id`);

--
-- Indexes for table `reads`
--
ALTER TABLE `reads`
  ADD PRIMARY KEY (`id`),
  ADD KEY `reads_user_id_foreign` (`user_id`);

--
-- Indexes for table `volunteers`
--
ALTER TABLE `volunteers`
  ADD PRIMARY KEY (`id`),
  ADD KEY `volunteers_user_id_foreign` (`user_id`);

--
-- Indexes for table `works`
--
ALTER TABLE `works`
  ADD PRIMARY KEY (`id`),
  ADD KEY `works_user_id_foreign` (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `atps`
--
ALTER TABLE `atps`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- AUTO_INCREMENT for table `cdas`
--
ALTER TABLE `cdas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `codes`
--
ALTER TABLE `codes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `contents`
--
ALTER TABLE `contents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `courses`
--
ALTER TABLE `courses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `eligibilities`
--
ALTER TABLE `eligibilities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `informals`
--
ALTER TABLE `informals`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `knowledge`
--
ALTER TABLE `knowledge`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `media`
--
ALTER TABLE `media`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `meetings`
--
ALTER TABLE `meetings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;

--
-- AUTO_INCREMENT for table `presentations`
--
ALTER TABLE `presentations`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `reads`
--
ALTER TABLE `reads`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `volunteers`
--
ALTER TABLE `volunteers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `works`
--
ALTER TABLE `works`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `atps`
--
ALTER TABLE `atps`
  ADD CONSTRAINT `atps_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `codes`
--
ALTER TABLE `codes`
  ADD CONSTRAINT `codes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `contents`
--
ALTER TABLE `contents`
  ADD CONSTRAINT `contents_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `courses`
--
ALTER TABLE `courses`
  ADD CONSTRAINT `courses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `eligibilities`
--
ALTER TABLE `eligibilities`
  ADD CONSTRAINT `eligibilities_certificate_id_foreign` FOREIGN KEY (`certificate_id`) REFERENCES `cdas` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `eligibilities_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `informals`
--
ALTER TABLE `informals`
  ADD CONSTRAINT `informals_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `knowledge`
--
ALTER TABLE `knowledge`
  ADD CONSTRAINT `knowledge_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `media`
--
ALTER TABLE `media`
  ADD CONSTRAINT `media_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `meetings`
--
ALTER TABLE `meetings`
  ADD CONSTRAINT `meetings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `presentations`
--
ALTER TABLE `presentations`
  ADD CONSTRAINT `presentations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `reads`
--
ALTER TABLE `reads`
  ADD CONSTRAINT `reads_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `volunteers`
--
ALTER TABLE `volunteers`
  ADD CONSTRAINT `volunteers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `works`
--
ALTER TABLE `works`
  ADD CONSTRAINT `works_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

