You are required to build a REACT and NODE JS application with PostgreSQL database which has the functionality as stated below.
- Create 50 records in database with the following column fields “sno, customer name, age, phone, location, created_at” and dummy data
- Create a single page application to display the above data in table format with search option, and pagination with 20 records per page.
- The created_at column data has to be displayed in two separate columns as “date” and “time”
- The search functionality will search the data by the column "name" or "location".
- There should be an option to sort the data either by "date" or by "time".