verify_codes

Column NameTypeCommentsDefaultNullRemark
idbigint UNSIGNEDPrimary IDNOAUTO_INCREMENT
template_idtinyint UNSIGNED模板编号NO
typetinyint UNSIGNED类型1NO1.邮件 / 2.短信
accountvarchar(128)账号NO邮箱或手机,手机号带国际区号,区号无加号
codechar(8)验证码NO
is_enabletinyint UNSIGNED是否有效1NO0=Disable(false) / 1=Enable(true)
expired_attimestamp失效时间NO
created_attimestampCreated TimeCURRENT_TIMESTAMPNO
updated_attimestampUpdated TimeCURRENT_TIMESTAMPNO
deleted_attimestampDeleted TimeYES