

CREATE TABLE `school_tutor_profile` (
  `serial_stf` INT NOT NULL AUTO_INCREMENT,
  `name_stf` VARCHAR(45) NOT NULL,
  `status_stf` ENUM('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_stf`),
   UNIQUE INDEX `serial_stf_UNIQUE` (`serial_stf` ASC));

CREATE TABLE `school_tutor_employee` (
  `serial_stm` INT NOT NULL AUTO_INCREMENT,
  `serial_stf` INT NOT NULL,
  `serial_emp` INT NOT NULL,
  `status_stm` ENUM('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_stm`),
  UNIQUE INDEX `serial_stm_UNIQUE` (`serial_stm` ASC));

CREATE TABLE `prior_student_information` (
  `serial_psi` INT NOT NULL AUTO_INCREMENT,
  `date_psi` DATE NOT NULL,
  `serial_std` INT NOT NULL,
  `serial_scy` INT NOT NULL,
  `information_psi` TEXT NOT NULL,
  `serial_usr` INT NOT NULL,
  `status_psi` ENUM('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_psi`),
  UNIQUE INDEX `serial_psi_UNIQUE` (`serial_psi` ASC));

CREATE TABLE `student_school_record` (
  `serial_ssr` INT NOT NULL AUTO_INCREMENT,
  `serial_psi` INT NOT NULL,
  `date_ssr` DATE NOT NULL,
  `serial_scy` INT NOT NULL,
  `serial_std` INT NOT NULL,
  `matters_dealt_with` TEXT NOT NULL,
  `meeting_agreements` TEXT NOT NULL,
  `profile_access` TEXT NOT NULL,
  `status_ssr` ENUM('ACTIVE','INACTIVE') NOT NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`serial_ssr`),
  UNIQUE INDEX `serial_ssr_UNIQUE` (`serial_ssr` ASC));


INSERT INTO `allowed_pages_by_process` (`serial_prc`,`url_dsc`) VALUES (832,'SectionController@getSectionsBySchoolYearByTutorProfile');
INSERT INTO `allowed_pages_by_process` (`serial_prc`,`url_dsc`) VALUES (832,'CourseController@getAllBySectionAndEmployeeProfile');
INSERT INTO `allowed_pages_by_process` (`serial_prc`,`url_dsc`) VALUES (832,'StudentController@getStudentsByCourse');
INSERT INTO `allowed_pages_by_process` (`serial_prc`,`url_dsc`) VALUES (832,'StudentSchoolRecordController@getIndex');
INSERT INTO `allowed_pages_by_process` (`serial_prc`,`url_dsc`) VALUES (832,'StudentSchoolRecordController@getStudentSchoolRecord');
INSERT INTO `allowed_pages_by_process` (`serial_prc`,`url_dsc`) VALUES (832,'StudentSchoolRecordController@postNewPriorInformation');
INSERT INTO `allowed_pages_by_process` (`serial_prc`,`url_dsc`) VALUES (832,'StudentSchoolRecordController@postEditPriorInformation');
INSERT INTO `allowed_pages_by_process` (`serial_prc`,`url_dsc`) VALUES (832,'StudentSchoolRecordController@postDeletePriorInformation');
INSERT INTO `allowed_pages_by_process` (`serial_prc`,`url_dsc`) VALUES (832,'StudentSchoolRecordController@postNewRecordInformation');
INSERT INTO `allowed_pages_by_process` (`serial_prc`,`url_dsc`) VALUES (832,'StudentSchoolRecordController@postEditRecordInformation');
INSERT INTO `allowed_pages_by_process` (`serial_prc`,`url_dsc`) VALUES (832,'StudentSchoolRecordController@postDeleteRecordInformation');
