| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| id | int | NO | PRI | auto_increment | |
| username | varchar(50) | NO | UNI | ||
| password | varchar(255) | YES | |||
| role | enum('admin','user') | YES | user | ||
| cabang | varchar(10) | YES | |||
| created_at | timestamp | NO | CURRENT_TIMESTAMP | DEFAULT_GENERATED | |
| status | varchar(20) | YES | active | ||
| remember_token | varchar(100) | YES | |||
| password_changed_at | datetime | YES | |||
| last_login | datetime | YES | |||
| login_attempts | int | YES | 0 | ||
| account_locked_until | datetime | YES |
| ID | Username | Role | Cabang |
|---|---|---|---|
| 1 | admin | admin | 01 |
| 2 | user | user | 02 |
| 3 | hania | user | 01 |