Coordinates

The GAM_COORDINATE table stores information about how objects are displayed on floor plans. It represents the physical coordinates of an object on a floor plan.

The reason there is a separate table for this information is that one object can appear on multiple floor plans. Therefore, this table represents the many-to-many relationship between images/floor plans and objects. There is one coordinate for each object for each image, so one object can only appear once on an image.

There is a many-to-one relationship between the GAM_COORDINATE and GAM_IMAGE tables, each images has multiple coordinates. Each coordinate must belong to an image.

There is a many-to-one relationship between the GAM_COORDINATE and GAM_OBJECT tables, an object can appear on multiple images and thus have multiple coordinates. An object does not need to have any coordinates, but each coordinate must be associated to an object.

Coordinates table

Attribute name	Attribute meaning	Data type	Mandatory	Notes
COO_ID	ID of coordinate	24-bit Integer	Yes	It is the primary key. It is automatically incremented, no need to set it manually.
COO_X	Coordinate on the x axis of the object on the floor plan	Integer with up to 5 digits	No
COO_Y	Coordinate on the y axis of the object on the floor plan	Integer with up to 5 digits	No
COO_OB_ID	ID of the object of this coordinate	24-bit Integer	Yes	It is a foreign key to the primary key of the GAM_OBJECT table.
COO_IMG_ID	ID of the image of this coordinate	24-bit Integer	Yes	It is a foreign key to the primary key of the GAM_IMAGE table.