User

The table GAM_USER was introduced to the GAM database with version 1.3 end of 2023 together with the table GAM_OBJECTINFO in order to personalise the information given on single objects. This can be helpful to

• identify the person who entered a specific information on an object
• later possibly regulate the access to some parts of the Heliummanagement system functionalities

Users can belong to different user groups.Presently there are the groups

• generic: for generic users such as 'anonymous', (value 1)
• personal: for individual users such as "Mustermann, Max", (value 2)
• advanced: with higher rights (future use), (value 3)
• admin: with highest rights (future use), (value 4)

A default, generic user 'anonymous' is expected as a standard and is to be created when the GAM_USER table is created.

User table

Attribute name	Attribute meaning	Data type	Mandatory	Notes
USR_ID	ID of object info	24-bit Integer	Yes	It is the primary key. It is automatically incremented, no need to set it manually.
USR_NAME	name of the user	String, max 50 chars	Yes	Main part of the user's name
USR_FIRSTNAME	Date and time of the creation of the entry	String, max 50 chars	No	optional
USR_INACTIVE	Flag indicating	Integer, one digit	No	NULL or 0 means: active user
USR_EMAILADDRESS	E-mail address of the user if applicable	String, max 100 chars	No	might get useful for future applications
USR_COMMENT	Comment on the user	String, max 1000 chars	No
USR_ROLE	user role/group	Integer, three digits	No	Values: NULL or 0: 'no role', 1: 'generic', 2: 'personal', 3: 'advanced', 4: 'admin'
USR_DATE_CREATED	Date and time of the creation of the entry	String showing date in YYYY-MM-DD hh:mm:ss format	No	Values: 0: 'info' (default), 1: 'task', 2: 'warning', 3: 'error', 4: 'in processing', 5: 'completed/obsolete'
USR_DATE_DEACTIVATED	Show info or hide it	Integer, one digit	No	Values: 0 (false, default), 1 (true, hidden)

generic','personal','advanced','admin'