Help, who can tell me, the structural design of php SMS verification code table

mobile phone number

Code verification code

Add_time generation time

Status Usage Status: 1 means used, 0 means unused, and the default value is 0.

The above is the simplest structure, and it should be enough not to be complicated. Add_time can be used to determine whether it has expired, and status can be used to determine whether it has been used. If you resend the verification code, the previous record will be deleted. If the verification code is used for multiple functions, get a type field to distinguish these functions.