|
id
|
int(10) unsigned
|
|
|
|
|
username
|
varchar(190)
|
|
|
|
|
email
|
varchar(190)
|
|
|
|
|
gender
|
enum
|
-- |
|
|
|
password_hash
|
varchar(255)
|
|
|
|
|
role
|
enum
|
-- |
|
user
|
|
avatar
|
varchar(255)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
phone
|
varchar(50)
|
|
|
|
|
status
|
enum
|
-- |
|
active
|
|
name
|
varchar(190)
|
|
|
|
|
bio
|
text
|
|
|
|
|
preferences
|
longtext
|
|
|
|
|
reset_token_hash
|
varchar(255)
|
|
|
|
|
reset_expires_at
|
datetime
|
|
|
|
|
email_verified
|
tinyint(1)
|
|
|
0
|
|
verified_at
|
datetime
|
|
|
|
|
verify_token
|
varchar(64)
|
|
|
|
|
verify_expires_at
|
datetime
|
|
|
|
|
verify_sent_at
|
datetime
|
|
|
|