The item <column>

Table 39.7. Item's attributes <column>

Attribute nameDescription
type=The type of data which is in the column. The data in the bold font is required.

Data for the table of points:

  • id - Identifier of an item in the database

  • number - Complete point number

  • project_id - Project identifier

  • x - Coordinate X

  • y - Coordinate Y

  • z - Coordinate Z

  • num - Point number

  • zpmz - ZPMZ number

  • tl - TL number

  • prec - Quality code

  • created - Date of creation

  • updated - Date of modification

  • ku - CO code

  • pnt_state - Data stage

Data for the table of projects:

  • id - Identifier of an item in the database

  • name - Project name

  • ... any arbitrary data can be further defined. The example is delivered with the GROMA installation in the sample file db.ini.

name=Name of the column in the database.
descrip=Data description. These descriptions appear, for example, in the dialog window to enter and edit projects.
source=

If the item in the project definition shall be taken from the codebook and offered in the form of a list (e.g. coordinate list definition), you can store all the admissible values in a separate table in the database and enter an SQL command here, which can be used to ease loading of the value list from the database. The SQL command must return two values for each item– identifier and description. The description is displayed in the menu, the identifier will be stored in the database.

For example, for the definition of the coordinate system, a table SOURSYST (ID, POPIS) can be created; enter in it the values (1, "S-JTSK") and (2, "local"). Then, the attribute source="SELECT ID,POPIS FROM SOURSYST" can be set in the project definition by the coordinate system item. In the dialog window with the project definition, in the place of the coordinate system, the list of all the items from the table SOURSYSTwill be displayed; in this case, S-JTSK and local.

value=Method of assigning the value. This attribute can only appear in the column of the type id. If set for the value auto, it means that the assigning of the values for this item is solved automatically on the database level (e.g. using triggers, sequences, or AutoIncrement). Detailed information can be found in the User Manual.

Table 39.8. Item's structure <column>

Item <column> contains attributes only.