giServer Documentation
giServer the easy to use and extensible batch and integration server
Brought to you by:
snov2013
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) | ||||
| 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 address. | |
| phone | Phone number. |
| rights | 5 = SERVER_ADMIN |
| 10 = ADMIN | |
| 20 = BATCH | |
| 30 = INFO | |
| 0 = NONE |
Documentation: Data model
Documentation: datamodel__gis_batches_log