Skip to content

verify_codes

Column NameTypeCommentDefaultNullRemark
idbigint UNSIGNEDPrimary Key IDNOAuto Increment
template_idtinyint UNSIGNEDTemplate IDNO
typetinyint UNSIGNEDType1NO1.Email / 2.SMS
accountvarchar(128)AccountNOEmail or phone, phone number with international area code, no plus sign
codevarchar(8)Verification CodeNO
is_enabledtinyint UNSIGNEDIs Valid1NO0.Invalid / 1.Valid
expired_attimestampExpiration TimeNO
created_attimestampCreate TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdate TimeYES
deleted_attimestampDelete TimeYES

Released under the Apache-2.0 License