CREATE TABLE IF NOT EXISTS `symptom_form` (
  `serial_smf` INT NOT NULL AUTO_INCREMENT,
  `serial_std` INT NULL,
  `serial_grd` INT NULL,
  `serial_emp` INT NULL,
  `serial_scy` INT NOT NULL,
  `section_smf` VARCHAR(100) NULL,
  `runny_nasal_smf` ENUM('YES', 'NO') NULL,
  `throat_pain_smf` ENUM('YES', 'NO') NULL,
  `cough_smf` ENUM('YES', 'NO') NULL,
  `fever_smf` ENUM('YES', 'NO') NULL,
  `chills_smf` ENUM('YES', 'NO') NULL,
  `respiratory_difficulty_smf` ENUM('YES', 'NO') NULL,
  `abdominal_pain_smf` ENUM('YES', 'NO') NULL,
  `contact_person_infected_smf` ENUM('YES', 'NO') NULL,
  `date_smf` DATE  NULL,
  `type_user_smf` ENUM('STUDENT', 'EMPLOYEE') NULL DEFAULT NULL,
  `status_smf` ENUM('ACTIVE', 'INACTIVE') NULL DEFAULT 'ACTIVE',
  `created_at` DATETIME NULL,
  `updated_at` DATETIME NULL,
  PRIMARY KEY (`serial_smf`),
  INDEX `fk_symptom_form_student_idx` (`serial_std` ASC),
  INDEX `fk_symptom_form_guardian_idx` (`serial_grd` ASC),
  INDEX `fk_symptom_form_employee_idx` (`serial_emp` ASC),
  INDEX `fk_symptom_form_school_year_idx` (`serial_scy` ASC),
  CONSTRAINT `fk_symptom_form_student`
    FOREIGN KEY (`serial_std`)
    REFERENCES `student` (`serial_std`),
  CONSTRAINT `fk_symptom_form_guardian`
    FOREIGN KEY (`serial_grd`)
    REFERENCES `guardian` (`serial_grd`),
  CONSTRAINT `fk_symptom_form_employee`
    FOREIGN KEY (`serial_emp`)
    REFERENCES `employee` (`serial_emp`),
  CONSTRAINT `fk_symptom_form_school_year`
    FOREIGN KEY (`serial_scy`)
    REFERENCES `school_year` (`serial_scy`))
ENGINE = InnoDB;


insert into process(serial_prc,prc_serial_prc, name_prc, link_prc, weight_prc, status_prc, id_exclusion)
values (818,816,'Formulario Síntomas Estudiantes','laravel/public/symptomForm',3.25,'LOCKABLE', null);

insert into allowed_pages_by_process values(818,'symptomformcontroller@getindex');
insert into allowed_pages_by_process values(818,'symptomformcontroller@validatePhoto');
insert into allowed_pages_by_process values(818,'symptomformcontroller@postOpenForm');
insert into allowed_pages_by_process values(818,'symptomformcontroller@postsaveform');

insert into process(serial_prc,prc_serial_prc, name_prc, link_prc, weight_prc, status_prc, id_exclusion)
values (819,816,'Formulario Síntomas Empleados','laravel/public/employeeSymptomForm',3.75,'LOCKABLE', null);

insert into allowed_pages_by_process values(819,'employeesymptomformcontroller@getindex');
insert into allowed_pages_by_process values(819,'employeesymptomformcontroller@validatePhoto');
insert into allowed_pages_by_process values(819,'employeesymptomformcontroller@postopenform');
insert into allowed_pages_by_process values(819,'employeesymptomformcontroller@postsaveform');

select * from process;