Object Info

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

• keep track of defect equipment and the necessary repair
• remind the acting personnel to e.g. control the parameter settings for a specific vessel.

An Object Info entry is created giving information on a specific object. The creator of the entry and the creation date and time is saved. The entry can be modified, the author and the date and time of the last change is saved. Object Infos are categorised in 6 types (see section INFOTYPE in table below). The type might change with time from e.g. 'task' over 'in processing' to 'completed/obsolete' representing the progress of the work on the respective problem.

The information on the creator and the last author of an Object Info entry is contained in the table GAM_USER. A default user 'anonymous' is forseen as a standard.

Object info table

Attribute name	Attribute meaning	Data type	Mandatory	Notes
OI_ID	ID of object info	24-bit Integer	Yes	It is the primary key. It is automatically incremented, no need to set it manually.
OI_OBJECT_ID	ID of the object to which the object info is related to	24-bit Integer	Yes
OI_DATE	Date and time of the creation of the entry	Date/Time format	Yes
OI_DATE_CHANGED	Date and time of the last change of the entry	Date/Time format	No
OI_USER_ID	ID of the user creating the entry	24-bit Integer	Yes	Relates to the table GAM_USER
OI_USER_CHANGED_ID	ID of the user creating the entry	24-bit Integer	No	Relates to the table GAM_USER
OI_INFOTEXT	Here is the information	String, max 1000 chars	Yes
OI_INFOTYPE	Defines, which type of information is given	Integer, three digits	No	Values: 0: 'info' (default), 1: 'task', 2: 'warning', 3: 'error', 4: 'in processing', 5: 'completed/obsolete'
OI_HIDE	Show info or hide it	Integer, one digit	No	Values: 0 (false, default), 1 (true, hidden)