Table arcasys.posper_user
POSper register users

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id varchar 255
posper_logintime.user_id fk_user_logintime R
posper_place.user_id fk_posper_place_user R
posper_ticket.userid FKA0D585C2E68378E8 R
version int 10 Used for optimistic locking
visible bit 0 -
name varchar 255 Displayed name
user_password varchar 255  √  null User PIN, encrypted
image_id varchar 255  √  null
posper_image.id FKC3F73C01BEC833C3 R
-
role_name varchar 255
posper_role.name FKC3F73C012C5B6821 R
-
modifiers int 10  √  0 Forbidden modifiers mask
cardString varchar 45  √  null Identification e.g. Dallas Lock token

Table contained 4 rows at Do Apr 25 17:50 MESZ 2019

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
role_name Performance Asc FKC3F73C012C5B6821
image_id Performance Asc FKC3F73C01BEC833C3

Close relationships  within of separation: