Scribd
Upload
47 views8 pages

API Development and DB Structure Guide

The document describes database tables and APIs for a customer policy and information system. Table 1 contains product information. Tables 2 contains customer, policy, and payment information. Table 3 contains mobile numbers and policy numbers for an opt-in service. Table 4 stores mobile numbers and one-time passwords (OTPs). Table 5 logs all audits. The system provides APIs for customer policy information, email and mobile number validation, updating contact details, and a two-step opt-in process via mobile number. It is implemented with Java EE, Spring frameworks, and uses MySQL, Oracle or PostgreSQL for the database.

Uploaded by

varunraj kothakota
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
47 views8 pages

API Development and DB Structure Guide

The document describes database tables and APIs for a customer policy and information system. Table 1 contains product information. Tables 2 contains customer, policy, and payment information. Table 3 contains mobile numbers and policy numbers for an opt-in service. Table 4 stores mobile numbers and one-time passwords (OTPs). Table 5 logs all audits. The system provides APIs for customer policy information, email and mobile number validation, updating contact details, and a two-step opt-in process via mobile number. It is implemented with Java EE, Spring frameworks, and uses MySQL, Oracle or PostgreSQL for the database.

Uploaded by

varunraj kothakota
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

DB Structure

Table 1-{Product ID, Product Name, Product Details, Product Launch Date, Product
End Date}

Table 2-{Policy Number, Customer ID, Customer Name, Insured Name, DOB, Email
Address, Mobile Number, Premium Mode[Monthly,Half Yearly, Yearly], Policy
Status[Active,Inactive], Customer PAN NO, , Policy Issuance Date, Contact Number
Last_updated, Email Address Last_updated, Bank Account Number,
whatsapp_opt_in_status,Product Name,Product ID, Reinvest Applicable[Boolean],
Outstanding Payout, Unclaimed Amount, NEFT Registered[Boolean] , Last Premium
Paid[Y,N]}
Table 3-{Optin ID, Mobile Number, Policy Number(Unique Field), Optin Date}
Table 4- {Mobile Number, OTP, Expire Time, Created Time}
Table 5- {Audit Log for Each Type of Details Updation}

Status Codes

API Creation
Security JWT Token

Customer Policy Info

Email Validation

Mobile Number Validation

Mobile Number Updation

Email Address Updation


PAN Card Updation

Whatsapp opt in Step1

Whatsapp opt in Step2

Implementation Stack
Java EE, Jersey JAX-RS, Spring MVC, Spring Boot, Hibernate
Design Pattern Micro services REST APIs
Documentation Swagger
DB-MySQL, Oracle, Postgres
Github Veriosn Control for Task Code Sharing
Task Description

1001-Old User,1002-New User,1003-OTP Sent,1004-


Request,1005-Validation,1006-Get

Input

Mobile Number, OTP

Policy Number, JWT Token

Email Address,DOB, JWT Token

Mobile Number,DOB, JWT Token

Mobile Number, Policy Number, JWT Token

Email Address, Policy Number, JWT Token


PAN Number, Policy Number, JWT Token

Mobile Number

Mobile, OTP
escription

Validation

Check Mobile Number in Table 2 and Create Entry in Table 4


Check Authentication, Check Policy Number If Validation
Success send Table 2 Single Row as Output

Check Table 2 for Email Address and DOB

Check Table 2 for Mobile Number and DOB

Check Table 2 for Mobile Number

Check Table 2 for Email Address


Check Table 2 for PAN Number

Check Number Exists in Table 3 then Mobile number already


Opted-"Thank You Message" else Check Number in Table 2 and
Send OTP to Mobile Logic

Check Number and OTP in Table 4 and Create Entry in Table 3


with All Policy Numbers from Table2 for that Mobile Number
Output

Status:1004,
Token:"qwerg79ihtujt67udvtrdehfc5tfg5y5tytgvyfghjhg654567ufrdd5tfe
4",
Refresh:"bvfrtyhgty76tyugfryf656t678t34rtr4tggtr6ygfde4t65e45ty56yg
756yy"
Status:1006,
Data:{Customer Policy Info}
Status:1005
Data:"[email protected]"
Status:1005
Data:"77******09"

Status:1004
Data:"SR10001"
Message:"Service Request for Mobile Number Updation Generated"

Status:1004
Data:"SR10002"
Message:"Service Request for Emai Address Updation Generated"
Status:1004
Data:"SR10003"
Message:"Service Request for PAN Card Updation Generated"

Status: 1001, Message: "Thank You for Optin Request Completed"


Status: 1003, Message: "Optin OTP Sent on the Mobile Number"

Status: 1002, Message: "Thank You for Optin Request Completed"

You might also like