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 e.g.

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

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	String showing date in YYYY-MM-DD hh:mm:ss format	Yes
OI_DATE_CHANGED	Date and time of the last change of the entry	String showing date in YYYY-MM-DD hh:mm:ss 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	Minor version number	Integer, three digits	No	default 0
OI_HIDE	Show info or hide it	Integer, one digit	No	Values: 0 (false, default), 1 (true, hidden)