/*
SQLyog Ultimate v12.5.1 (64 bit)
MySQL - 10.3.8-MariaDB : Database - schemax_academy
*********************************************************************
*/

/*!40101 SET NAMES utf8 */;

/*!40101 SET SQL_MODE=''*/;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`schemax_academy` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `schemax_academy`;

/*Table structure for table `achievments` */

DROP TABLE IF EXISTS `achievments`;

CREATE TABLE `achievments` (
  `courses_id` varchar(36) NOT NULL,
  `traineename` varchar(100) NOT NULL,
  `coursesoffered` varchar(100) NOT NULL,
  `trainingprogram` varchar(100) NOT NULL,
  `achievmenttype` varchar(100) NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `created_user` varchar(40) DEFAULT NULL,
  `updated_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `updated_user` varchar(40) DEFAULT NULL,
  `version_flag` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`courses_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `achievments` */

/*Table structure for table `courses` */

DROP TABLE IF EXISTS `courses`;

CREATE TABLE `courses` (
  `courses_id` varchar(36) NOT NULL,
  `coursesoffered` varchar(100) NOT NULL,
  `nameofcourses` varchar(100) NOT NULL,
  `durationsofcoureses` varchar(100) NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `created_user` varchar(40) DEFAULT NULL,
  `updated_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `updated_user` varchar(40) DEFAULT NULL,
  `version_flag` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`courses_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `courses` */

/*Table structure for table `file_upload` */

DROP TABLE IF EXISTS `file_upload`;

CREATE TABLE `file_upload` (
  `file_upload_id` varchar(36) NOT NULL,
  `file_description` varchar(250) NOT NULL,
  `features_ref_name` enum('Vendor','Customer','Facilitator','Coal_indexes','Cps_contract','Services_Payable','Purchase_Contract','Purchase_Fin_Quality_Results','Purchase_fin_coal_costing','Sales_Contract','Sales_Fin_Quality_Results','Sales_fin_commercial_coal_costing','Sales_fin_performa_coal_costing','Barges','Barge_pur_fin_barge_costing','Barge_pur_fin_other_expenses','Barge_cpc_costing','Barge_Cps_costing','Barging_agreements','Barge_export_tax','Barge_doc_charges','Barge_pre_shipment','Barge_sac_charges','Business_no_debit_note','Business_no_credit_note','Business_no_other_expenses','Mv_Pur_Fin_Doc_Charges','Mv_Pur_Fin_Sac_Charges','Mv_Pur_Fin_Stevedore_Costing','Mv_Pur_Fin_Floating_Crane_Charges','Mv_Supplier_Demurrage','Mv_Buyer_Demurrage','Mv_Sales_Fin_Csc','Mv_Pre_Shipment','mv_dead_freight','Mv_Pur_Fin_Export_Tax','Vessel_completion','Insurance_and_declaration','User_Profile') NOT NULL,
  `features_ref_no` varchar(40) NOT NULL,
  `file` mediumblob NOT NULL,
  `file_name` varchar(250) NOT NULL,
  `size` int(11) NOT NULL DEFAULT 1,
  `original_name` varchar(250) NOT NULL,
  `type` varchar(100) NOT NULL,
  `last_modified` varchar(60) NOT NULL,
  `last_modified_date` varchar(60) NOT NULL,
  `percent` int(11) NOT NULL DEFAULT 1,
  `file_path` varchar(300) NOT NULL,
  `plant_code` varchar(10) NOT NULL,
  `created_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `created_user` varchar(30) DEFAULT NULL,
  `updated_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `updated_user` varchar(30) DEFAULT NULL,
  `version_flag` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`file_upload_id`),
  KEY `FILES_COMMON_QUERY` (`features_ref_name`,`features_ref_no`,`plant_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `file_upload` */

/*Table structure for table `organization` */

DROP TABLE IF EXISTS `organization`;

CREATE TABLE `organization` (
  `organization_id` varchar(36) NOT NULL,
  `organization_name` varchar(50) NOT NULL,
  `contact_number` varchar(15) NOT NULL,
  `organization_type` varchar(50) NOT NULL,
  `size_of_employees` varchar(10) NOT NULL,
  `e_mail` varchar(70) NOT NULL,
  `organization_website` varchar(100) NOT NULL,
  `state` varchar(40) NOT NULL,
  `address` varchar(70) NOT NULL,
  `note` varchar(50) NOT NULL,
  `created_user` varchar(40) NOT NULL,
  `updated_user` varchar(40) NOT NULL,
  `created_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `updated_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `version_flag` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`organization_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `organization` */

/*Table structure for table `organization_post` */

DROP TABLE IF EXISTS `organization_post`;

CREATE TABLE `organization_post` (
  `org_id` varchar(36) NOT NULL,
  `domain_type` varchar(50) NOT NULL,
  `job_type` varchar(50) NOT NULL,
  `job_title` varchar(50) NOT NULL,
  `description` varchar(50) NOT NULL,
  `required_skills` varchar(50) NOT NULL,
  `experience` varchar(50) NOT NULL,
  `created_user` varchar(40) NOT NULL,
  `updated_user` varchar(40) NOT NULL,
  `created_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `updated_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `version_flag` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`org_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `organization_post` */

/*Table structure for table `sequence` */

DROP TABLE IF EXISTS `sequence`;

CREATE TABLE `sequence` (
  `sequence_name` varchar(100) NOT NULL,
  `increment` int(11) NOT NULL DEFAULT 1,
  `min_value` int(11) NOT NULL DEFAULT 1,
  `max_value` bigint(20) NOT NULL DEFAULT 9223372036854775807,
  `cur_value` bigint(20) DEFAULT 1,
  `cycle` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`sequence_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `sequence` */

/*Table structure for table `student_certifications` */

DROP TABLE IF EXISTS `student_certifications`;

CREATE TABLE `student_certifications` (
  `s_certification_id` varchar(36) DEFAULT NULL,
  `s_certificate_source` varchar(100) DEFAULT NULL,
  `s_certification_name` varchar(100) DEFAULT NULL,
  `s_certification_issued_date` varchar(20) DEFAULT NULL,
  `s_certification_expiry_date` varchar(20) DEFAULT NULL,
  `student_data_id` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `student_certifications` */

/*Table structure for table `student_data` */

DROP TABLE IF EXISTS `student_data`;

CREATE TABLE `student_data` (
  `id` varchar(36) NOT NULL,
  `s_name` varchar(20) NOT NULL,
  `s_last_name` varchar(20) NOT NULL,
  `s_age` int(5) DEFAULT NULL,
  `s_date_of_birth` varchar(10) DEFAULT NULL,
  `s_email` varchar(100) DEFAULT NULL,
  `s_phone_number` varchar(15) DEFAULT NULL,
  `s_address` varchar(100) DEFAULT NULL,
  `s_linkedin` varchar(500) DEFAULT NULL,
  `s_objective` varchar(1000) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `student_data` */

/*Table structure for table `student_education_data` */

DROP TABLE IF EXISTS `student_education_data`;

CREATE TABLE `student_education_data` (
  `s_education_id` varchar(36) DEFAULT NULL,
  `s_education_college_name` varchar(100) DEFAULT NULL,
  `s_education_type` varchar(36) DEFAULT NULL,
  `s_education_group` varchar(50) DEFAULT NULL,
  `s_education_percentage` varchar(10) DEFAULT NULL,
  `s_education_university_name` varchar(100) DEFAULT NULL,
  `s_education_address` varchar(100) DEFAULT NULL,
  `student_data_id` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `student_education_data` */

/*Table structure for table `student_goals` */

DROP TABLE IF EXISTS `student_goals`;

CREATE TABLE `student_goals` (
  `s_goal_id` varchar(36) DEFAULT NULL,
  `s_goal_name` varchar(100) DEFAULT NULL,
  `s_goal_desc` varchar(1000) DEFAULT NULL,
  `student_data_id` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `student_goals` */

/*Table structure for table `student_personal_data` */

DROP TABLE IF EXISTS `student_personal_data`;

CREATE TABLE `student_personal_data` (
  `s_personal_data_id` varchar(36) DEFAULT NULL,
  `s_relation_type` varchar(50) DEFAULT NULL,
  `s_relation_name` varchar(50) DEFAULT NULL,
  `s_relation_contact` varchar(50) DEFAULT NULL,
  `student_data_id` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `student_personal_data` */

/*Table structure for table `student_projects` */

DROP TABLE IF EXISTS `student_projects`;

CREATE TABLE `student_projects` (
  `s_project_id` varchar(36) DEFAULT NULL,
  `s_project_title` varchar(50) DEFAULT NULL,
  `s_project_name` varchar(50) DEFAULT NULL,
  `s_project_desc` varchar(1000) DEFAULT NULL,
  `s_project_start_date` varchar(10) DEFAULT NULL,
  `s_project_end_date` varchar(10) DEFAULT NULL,
  `s_project_used_tech` varchar(100) DEFAULT NULL,
  `student_data_id` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `student_projects` */

/*Table structure for table `student_skills_data` */

DROP TABLE IF EXISTS `student_skills_data`;

CREATE TABLE `student_skills_data` (
  `s_skills_id` varchar(36) DEFAULT NULL,
  `s_skill_name` varchar(50) DEFAULT NULL,
  `s_skill_rate` varchar(5) DEFAULT '0',
  `s_skill_version` varchar(10) DEFAULT NULL,
  `student_data_id` varchar(36) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `student_skills_data` */

/*Table structure for table `trainee_material` */

DROP TABLE IF EXISTS `trainee_material`;

CREATE TABLE `trainee_material` (
  `trainee_material_id` varchar(36) NOT NULL,
  `material_type` varchar(255) NOT NULL,
  `material_name` varchar(255) NOT NULL,
  `material_link` varchar(255) NOT NULL,
  `material_file` varchar(255) NOT NULL,
  `created_user` varchar(40) NOT NULL,
  `updated_user` varchar(40) NOT NULL,
  `created_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `updated_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `version_flag` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`trainee_material_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `trainee_material` */

/*Table structure for table `traineejob` */

DROP TABLE IF EXISTS `traineejob`;

CREATE TABLE `traineejob` (
  `trainess_id` varchar(36) NOT NULL,
  `jobTitle` varchar(100) NOT NULL,
  `organization` varchar(100) NOT NULL,
  `cources` varchar(100) NOT NULL,
  `location` varchar(100) NOT NULL,
  `experience` varchar(100) NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `created_user` varchar(40) DEFAULT NULL,
  `updated_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `updated_user` varchar(40) DEFAULT NULL,
  `version_flag` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`trainess_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `traineejob` */

/*Table structure for table `trainees` */

DROP TABLE IF EXISTS `trainees`;

CREATE TABLE `trainees` (
  `trainess_id` varchar(36) NOT NULL,
  `fistname` varchar(100) NOT NULL,
  `lastname` varchar(100) NOT NULL,
  `age` varchar(100) NOT NULL,
  `gender` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `mobile` varchar(100) NOT NULL,
  `photo` varchar(100) NOT NULL,
  `linkedin` varchar(100) NOT NULL,
  `address` varchar(100) NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `created_user` varchar(40) DEFAULT NULL,
  `updated_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `updated_user` varchar(40) DEFAULT NULL,
  `version_flag` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`trainess_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `trainees` */

/*Table structure for table `traineesubscribed` */

DROP TABLE IF EXISTS `traineesubscribed`;

CREATE TABLE `traineesubscribed` (
  `traineeSubScriBedId_id` varchar(36) NOT NULL,
  `studentName` varchar(100) NOT NULL,
  `studentcontact` varchar(100) NOT NULL,
  ` studentemail` varchar(100) NOT NULL,
  `subscriptionPlan` varchar(100) NOT NULL,
  `subscriptionStartDate` varchar(100) NOT NULL,
  `subscriptionEndDate` varchar(100) NOT NULL,
  `subscriptionBenefits` varchar(100) NOT NULL,
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  `created_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `created_user` varchar(40) DEFAULT NULL,
  `updated_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `updated_user` varchar(40) DEFAULT NULL,
  `version_flag` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`traineeSubScriBedId_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `traineesubscribed` */

/*Table structure for table `users` */

DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `users_id` varchar(36) NOT NULL,
  `full_name` varchar(60) NOT NULL,
  `email` varchar(50) NOT NULL,
  `password` varchar(1024) NOT NULL,
  `conform_password` varchar(1024) NOT NULL,
  `currentHashedRefreshToken` varchar(255) DEFAULT NULL,
  `status` varchar(20) NOT NULL,
  `created_user` varchar(40) NOT NULL,
  `updated_user` varchar(40) NOT NULL,
  `created_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `updated_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `version_flag` int(11) NOT NULL DEFAULT 1,
  `is_active` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`users_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `users` */

/*Table structure for table `work_log` */

DROP TABLE IF EXISTS `work_log`;

CREATE TABLE `work_log` (
  `work_log_id` varchar(36) NOT NULL,
  `work_log` varchar(250) NOT NULL,
  `features_ref_name` varchar(250) NOT NULL,
  `features_ref_no` varchar(40) NOT NULL,
  `plant_code` varchar(10) NOT NULL,
  `created_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `created_user` varchar(30) DEFAULT NULL,
  `updated_at` datetime(6) NOT NULL DEFAULT current_timestamp(6),
  `updated_user` varchar(30) DEFAULT NULL,
  `version_flag` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`work_log_id`),
  KEY `Work_LOG_COMMON_QUERY` (`features_ref_name`,`features_ref_no`,`plant_code`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

/*Data for the table `work_log` */

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
