Images

The GAM_IMAGE table stores information about images that represent the floor plans in a facility. A network can extend to multiple stories of a building or to multiple buildings, and therefore a network has multiple floor plans so that users of the software can visualise their devices according to their physical location. The physical location of an object can change, vessels can be moved around for example.

Although images usually display the physical locations of objects, they can also display objects for functional purposes.

Objects are represented on images or floor plans through coordinates, as objects can be present on multiple floor plans. That can happen for vessels that are booked in but it is not known where these vessels will be, so they are displayed on multiple images.

There is a many to one relationship between the GAM_IMAGE and GAM_NETWORK tables, each network is made up of multiple floor plans. Each image must belong to a network.

There is a one to many relationship between the GAM_IMAGE and GAM_COORDINATE tables, as each image/floor plan can have multiple coordinates. Each coordinate must belong to one image.

Images table

Attribute name	Attribute meaning	Data type	Mandatory	Notes
IMG_ID	ID of image	24-bit Integer	Yes	It is the primary key. It is automatically incremented, no need to set it manually.
IMG_BLOB	Represents the actual image file of the floor plan	Byte string up to 65,638 bytes in size	No
IMG_NAME	Name of this floor plan	String, up to 50 bytes in size	Yes
IMG_COMMENT	Comments regarding this floor plan	String, up to 1000 bytes in size	No	Changed from mandatory to not mandatory in Version 1.0 (21 May 2021 KK)
IMG_DIAMETER	To be decided later (2-3 months).	32-bit Integer	No
IMG_FILENAME	File name of this floor plan	String, up to 200 bytes in size	YES	Introduced in version 1.0 (21 May 2021 KK)
IMG_OUTOFOPERATION	If the image is out of operation, 0 by default.	Integer from 0 to 9	Yes	You never should clear objects, object types or object classes (or anything else) from the database as old measurements will reference to it.
IMG_NW_ID	ID of the network the floor plan belongs to	24-bit Integer	Yes	It is a foreign key to the primary key of the GAM_NETWORK table.