EducReports - V2.0

Whats new?

• MFA Authentication at login (email)
• Enable/Disable users
• System security check
• Enable/Disable students
• Email confirmation at account creation
• New screens

Installation Manual 👇

Database

• First of all, make sure you have a local database based on MySQL 8.

• In phpMyAdmin, create a new database called "educdb"

• In the SQL tab, paste the SQL script below and execute:

 CREATE TABLE `user` (`id_user` int not null PRIMARY KEY auto_increment, 
`username` varchar(30) not null, 
`email` varchar(50) not null, 
`login` varchar(20) not null UNIQUE KEY, 
`password` varchar(32) not null, 
`hierarchy` varchar(20) not null, 
`status` varchar(20) not null default 'Active');

CREATE TABLE `tb_child` (`RA` int not null PRIMARY KEY, 
`child_name` varchar(50) not null, 
`birth` date not null, 
`class` varchar(20) not null, 
`child_photo` longblob not null, 
`child_phone` varchar(10) not null, 
`responsible` varchar(50) not null, 
`address` varchar(100) not null, 
`teacher_name` varchar(50) not null, 
`teacher_id` int not null, 
`status` varchar(20) not null, 
foreign key(teacher_id) references tb_teacher(id_user));

CREATE TABLE `tb_reports` (`ID Rel` int not null auto_increment PRIMARY KEY, 
`child_RA` int not null, 
`birth` date not null, 
`class` varchar(20) not null, 
`report` varchar(5000) not null,
`emission_date` timestamp not null default current_timestamp,
`child_name` varchar(50) not null,
`teacher_name` varchar(50) not null,
foreign key(child_RA) references tb_child(RA));

Application

The application uses environment variables for connection and also email use. With this in mind, you need to set the variables:

• DATABASE_USER (your database user)
• DATABASE_PASSWORD (your database password)
• EMAIL_ADDRESS (email to be used by the email service)
• EMAIL_PASSWORD (email password)