users
| Column | Type | Null | Default | Links to | Comments | MIME |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| varchar(255) | No | |||||
| password_hash | varchar(255) | No | ||||
| nama_lengkap | varchar(255) | Yes | NULL | |||
| phone | varchar(50) | Yes | NULL | |||
| role | varchar(50) | No | agent | |||
| is_active | tinyint(1) | No | 1 | |||
| created_at | timestamp | No | CURRENT_TIMESTAMP | |||
| last_login | timestamp | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 10 | A | No |