OTP

sunbird.otp [PRIMARY KEY: (type, key)]

Table used to store OTP information

Column Name	Data Type	Description	Sample Data
type	text	OTP Communication mode	EMAIL/PHONE
key	text	Email/Phone of the user	98******10
attemptedcount	int	Number of times OTP mismatch was identified	2
createdon	timestamp	record created on timestamp
otp	text	OTP	254789

sunbird.rate_limit [PRIMARY KEY: (key, unit)]

Table used to store rate limit information (number of requests per hour/day)

Column Name	Data Type	Description	Sample Data
key	text	Email/Phone of the user	[e-mail]
unit	text	DAY/HOUR	DAY
count	int		1
rate	int	Number of notifications that can be sent as per limit	20