. Database Schema
Let’s see the data we need to store:
Data Related to user
User ID: A unique user id or API key to make user globally distinguishable
Name: The name of the user
Email: The email id of the user
Creation Date: The date on which the user was registered
Data Related to ShortLink
Short Url: 6/7 character long unique short URL
Original Url: The original long URL
UserId: The unique user id or API key of the user who created the short URL