Table 39.7. Item's attributes <column>
Attribute name | Description |
---|---|
type= | The type of data which is in the column. The data in the bold font is required.
Data for the table of points:
Data for the table of projects:
|
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. |