Barangay Information System in PHP, MySQL and Bootstrap

List of Database Tables

Barangay Information System in PHP, MySQL and Bootstrap

This article will provide you with the list of modules of web based barangay system. The said project was design and developed in PHP, MySQL and Bootstrap.

List of Database Tables

  • tblactivity
  • tblactivityphoto
  • tblblotter
  • tblclearance
  • tblhousehold
  • tbllogs
  • tblofficial
  • tblpermit
  • tblresident
  • tblstaff
  • tbluser
  • tblzone

Table 1.0 List of Database Tables for Barangay Information System

List of Database Tables

List of Database Tables

Table 1.0 shows the list of database tables with entities and attributes of barangay information system.

Features/Modules of Barangay Information System

Dashboard

A dashboard is a type of graphical user interface that gives you an overview of the reports, metrics and other important statistics of your application. The image below is the dashboard feature of the barangay information system. It shows the total household number encoded in the system, the number of residents, the total clearances released by the barangay, the total permit issued and as well as the total number of blotter reports processed by the barangay.

Barangay Information System Dashboard

Barangay Information System Dashboard

Barangay Official Module

Barangay official module is a module where the users can add, update and search for barangay official information; such information includes the position, name of the officer, contact number, address, start term and end term. The list of officers will be reflected in the barangay clearance form.

Barangay Information System Official Module

Barangay Information System Official Module

Staff Module

The image below shows the staff module wherein the administrator can add another account with limited privileges. The fullname, username and password are the information needed in order to create another account for staff.

Barangay Information System Staff Module

Barangay Information System Staff Module

Zone Leader Module

The zone leader module includes the zone number, username and password as the fields to fill-in in order to create/add another record. The login credentials will be used in order to gain access in the zone leader dashboard where in the zone leader users can view, review, approve and disapprove the application for clearance and permit.

Barangay Information System Zone Leader Module

Barangay Information System Zone Leader Module

Household Module

A household includes all the persons who occupy a housing unit as their usual place of residence. … Persons per household, or average household size, is obtained by dividing the number of persons in households by the number ofhouseholds (or householders). (https://www.census.gov)

This module includes the following entities; household number, zone, total members, head of family.

Barangay Information System Household Module

Barangay Information System Household Module

Residents Information Module

This is the module that holds and stores the information of residents. This form may vary from one barangay to another barangay (based on our experience). Please refer to the database tables for the list of entities in this module (tblresident). Username and password are included in this form, it will be used to login to their account in order for the residents to apply for a clearance and permit. It simply means that a resident has the option to apply online via the application or they can proceed to the barangay hall to apply for such documents.

Barangay Information System Residents Information Module

Barangay Information System Residents Information Module

Permit Clearance Module

The image below shows the module wherein the administrator can add application for clearance permit. Information to be encoded are the following; the resident name, business name, address, type of business OR number and the amount to be paid. The application will be reviewed by the zone leader for the approval of such request.

Barangay Information System Permit Clearance Module

Barangay Information System Permit Clearance Module

Blotter Module

Police blotter is a slang term that is used in police practice and procedures. It refers to a book that records arrests and other facts and events in a police station, on a daily basis. Arrests are recorded in a police blotter as they occur. (https://definitions.uslegal.com/p/police-blotter/)

For the list of entities and attributes for this module, please refer to the database tables above (tblblotter)

Barangay Information System Blotter Module

Barangay Information System Blotter Module

Clearance Module

The image below shows the module wherein the administrator can add application for barangay clearance. Information to be encoded are the following; clearance number, resident name, findings, purpose, OR number and the amount to be paid. The application will be reviewed by the zone leader for the approval of such request.

Barangay Information System Permit Clearance Module

Barangay Information System Permit Clearance Module

Activity Module

The schedule of activities in the barangay is also part of the encoding process. This module will serve as a reminder and archiving of the activities in the barangay. The record includes the date of activity, the name of the activity or program, and a banner of the program can also be uploaded in the system.

Barangay Information System Activity Module

Barangay Information System Activity Module

Report and Statistics Module

The system is capable of printing different types of statistical record such as the number of resident per zone, the system can also group the residents according to their age, gender, educational attainment and others.

Barangay Information System Report and Statisctics Module

Barangay Information System Report and Statisctics Module

Audit Trail Logs

An audit log is a document that records an event in an information (IT) technology system. In addition to documenting what resources were accessed, audit log entries usually include destination and source addresses, timestamp and user login information. (https://searchcompliance.techtarget.com/definition/audit-log-AL)

The system records every transactions that the user is doing, adding of new record, updating of records are all recorded and stored in this module.

Barangay Information System Audit Log Module

Barangay Information System Audit Log Module

You may visit our facebook page for more information, inquiries and comments.

Hire our team to do the project.

Comments

comments