Using POSper/Developer guide/Database-Table descriptions/posper user

From Wikibooks, open books for an open world
Jump to navigation Jump to search

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.