| upwd_id | int(11) | NO | | PRI | auto_increment | |
| upwd_usr_id | int(11) | NO | | MUL | | |
| upwd_salt_password | varchar(60) | YES | | | | User password. Requires salt (deprecated) |
| upwd_salt | varchar(60) | YES | | | | User password bcrypt (deprecated) |
| upwd_password | varchar(60) | NO | | | | User password. bcrypt format |
| upwd_active | tinyint(1) | YES | | | | Active password |
| upwd_compromised | tinyint(1) | YES | 0 | | | Compromised flag |
| upwd_expiration | timestamp | YES | | | | Expiration Time |
| upwd_modified | timestamp | YES | CURRENT_TIMESTAMP | | on update CURRENT_TIMESTAMP | |
| upwd_created | timestamp | YES | CURRENT_TIMESTAMP | | | |