3.3. Database Structure Diagram
In the figure above, tbl_employee is the main table which is the also the table to be queried during login. tbl_employee extends its data by reference other tables through the foreign key EMPID. This database is structure in phpmyadmin thru InnoDB engine with utf8mb4_general_ci collation.
Current database name used in the web server (inMotion Hosting) is dolexp5_hris_db
Database User credentials in order to use the database:
Username : dolexp5_hrisadmin
Password : dolexp5_hrisadmin