Column

Description

Name

Name of field

Table

Name of EDB table to which the field belongs

Owner

Name of the owner of the data source component to which the field belongs. If the source does not support the notion of an owner, an empty string is displayed.

Type

Type of field. Displayed names of field types are specific for a particular data source.

Precision

Size of field. Interpretation of field precision depends on the field type:

• String (CHAR) – field length in characters specified in EDB;

• Long string (VARCHAR) – maximum length of field in characters;

• Integer (INTEGER, SMALLINT) – maximum number of decimal digits necessary for displaying field value;

• Decimal (DECIMAL, NUMERIC) – quantity of decimal digits (including digits of fractional part) specified in EDB;

• Real (REAL, FLOAT, DOUBLE PRECISION) – maximum number of decimal digits of mantissa;

• Binary (BIT(len)) – length of field in bytes specified in EDB

• Long binary (BIT VARYING (len)) – maximum length of field in bytes;

• Date (DATE) – always 10 (number of characters in the format yyyy-mm-dd);

• Time (TIME) – always 8 (number of characters in the format hh:mm:ss);

• Timestamp (TIMESTAMP) – number of characters in the format yyyy-mm-dd hh:mm:ss[.f…]; [.f…] here is compulsory sign for fractions of a second;

• Boolean (BIT) – always 1.

Scale

Scale of field. Interpretation of field scale depends on type of field:

• String – scale is not applicable;

• Long string – scale is not applicable;

• Integer – scale is not applicable;

• Decimal – quantity of decimal digits to the right of the decimal point;

• Real – scale is not applicable;

• Binary – scale is not applicable;

• Long binary – scale is not applicable;

• Date – scale is not applicable;

• Time – scale is not applicable;

• Timestamp – quantity of digits in the fractional part of number of seconds (to the right of the decimal point);

• Boolean – scale is not applicable.

Autoincremental

Indication of autoincremental field. For autoincremental field the data source sets the value automatically when adding records to EDB table increasing the value to the specified step for every added record. Editing and setting of value for an autoincremental field is inadmissible, as a rule.

Case sensitive

Indication of sensitivity of field values to the case of characters when sorting and searching.

Long value

Indication of a long value. GIS ObjectLand provides limited possibilities for using long values. Only viewing specified number of characters/bytes beginning from first character/byte of field is possible.

Money

Indication of a money field. The indication shows that the present decimal field is intended for storing sums of money. It has a fixed size and scale.

Unsigned

Indication of an unsigned field. All non-numeric fields are unsigned. For numeric fields the indication denotes that that field value should be non-negative.

Null-values

Indication of the possibility of setting an empty (NULL) value of field.

Searchable

Indication of the possibility of searching records by the value of the present field. It can take the following values:

• yes – search by field values allowed;

• no – search by field values not allowed;

• all except LIKE – search by field values allowed except the relations of matching the pattern.

Primary key

Indication showing that the present field is a part of the primary key of EDB table.