|
id
|
int(10) unsigned
|
|
|
|
|
nombre
|
varchar(100)
|
|
|
|
|
username
|
varchar(50)
|
|
|
|
|
password_hash
|
varchar(255)
|
|
|
|
|
rol
|
enum
|
-- |
|
cajero
|
|
profesor_id
|
int(10) unsigned
|
|
|
|
|
activo
|
tinyint(1)
|
|
|
1
|
|
intentos_fallidos
|
tinyint(3) unsigned
|
|
|
0
|
|
bloqueado_hasta
|
datetime
|
|
|
|
|
ultimo_login
|
datetime
|
|
|
|
|
ip_ultimo_login
|
varchar(45)
|
|
|
|
|
token_sesion
|
varchar(64)
|
|
|
|
|
created_at
|
timestamp
|
|
|
current_timestamp()
|
|
updated_at
|
timestamp
|
|
|
current_timestamp()
|