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 having different roles. Presently there are the groups/roles

• 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 user	Integer	Yes	It is the primary key. It is automatically incremented, no need to set it manually.
USR_NAME	Name of the user, last lame if personal user	String, max 50 chars	Yes	Main part of the user's name
USR_FIRSTNAME	First name of the personal user	String, max 50 chars	No
USR_INACTIVE	Flag indicating	Integer, one digit	No	NULL or 0 means: active user, value 1 means: user inactive
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	Date/time format	Yes
USR_DATE_DEACTIVATED	Date and time of the deactivation of the user	Date/time format	No	is to be NULL when USR_INACTIVE is NULL or 0