Using POSper/Developer guide/Database-Table descriptions/posper user
posper_user
[edit | edit source]
This table describes a user of tinaposplus. Different users have different rights (by way of what role they're assigned).
| Column Name | Data Type | Null Allowed? | Key? | Comments |
|---|---|---|---|---|
| id | VARCHAR(255) | No | Primary | UUID instead of int |
| version | INT(11) | No | This is used by hibernate to track table versions | |
| visible | BIT(1) | No | Whether or not the user is visible on the login menu | |
| name | VARCHAR(255) | No | This is the user name | |
| user_password | VARCHAR(255) | Yes | This is the user's password, if one has been selected | |
| role_name | VARCHAR(255) | No | Foreign Key | This points to the role associated with the user |
| image_id | VARCHAR(255) | Yes | Foreign Key | If an image has been associated with the user, this points to it. |