User Onboarding Tool - Backend API and DB design

Challenge Objectives

• Design the DB schema and API for the project

Project Background

We are building a new UI based tool for a financial services company. This will be an internal tool to onboard new users and manage users from a centralized location.

Technology Stack

• Node 12
• NestJS - https://github.com/nestjs/nest
• Postgresql

Requirements

You can find the latest design here: https://marvelapp.com/1gd9fcag

The project has 3 types of roles:

• Regular User - regular user will apply for an ANZ role, and fill applications.
• Approval User - approval user will review the regular users' applications, and approve or reject.
• Admin User - admin user will manage applications, questions, and settings. 

Please check this more detailed UI interaction document for more details: https://docs.google.com/document/d/1QYPHYKjSutHoueEZq87v-0yWG7iqh16IyCzp8q1ASFE/edit

Note that we need to integrate with SSO from an external project. 
 

Final Submission Guidelines

• Swagger YAML file
  • For each API, provide a simple description about how it should be implemented
  • Error cases should be well defined for all APIs.
• Postgresql DB Schema
• UI and API mapping