Menu

datamodel__gis_users

Stefan Winarzki Stefan Novak

The list of users and their rights are maintained in this table

Field Type Null Key Default Extra
userId int NO PRI NULL auto_increment
tenantId int
userName varchar(30) NO INDEX NULL
lastName varchar(50)
firstName varchar(50)
password varchar(50)
email varchar(50)
phone varchar(50)
rights int NO
lastModifiedBy varchar(50)
lastModifiedAt timestamp

Indexes

Keyname Type Field
PRIMARY PRIMARY userId
IX_users_1 UNIQUE userName
Field Description
userId Auto generated id.
tenantId Id of the tenant, if the user is assigned to a tenant (else NULL). Points to an entry in gis_tenants.
userName Unique user name for login.
lastName Family name.
firstName Given name.
password Encrypted user password.
email Email address.
phone Phone number.
rights 5 = SERVER_ADMIN
10 = ADMIN
20 = BATCH
30 = INFO
0 = NONE

Related

Documentation: Data model
Documentation: datamodel__gis_batches_log