Field

Type

Description

iId

UINT16

Specifies the ID of the field type.

szName

DBINAME

Specifies the symbolic name of field type; for example, ALPHA.

szNativeName

DBINAME

Name used in SQL DDL statements.

szText

DBINAME

Descriptive text.

iPhyType

UINT16

Specifies the physical/native type.

iXltType

UINT16

Specifies the default translated type.

iXltSubType

UINT16

Specifies the default translated subtype.

iMaxUnits1

UINT16

Specifies the maximum units allowed (1).

iMaxUnits2

UINT16

Specifies the maximum units allowed (2).

iPhySize

UINT16

Specifies the physical size in bytes (per unit).

bRequired

BOOL

If TRUE, supports required option.

bDefaultVal

BOOL

If TRUE, supports user-specified default.

bMinVal

BOOL

If TRUE, the field supports the minimum validity constraint.

bMaxVal

BOOL

If TRUE, the field supports the maximum validity constraint.

bRefIntegrity

BOOL

If TRUE, the field can participate in referential integrity.

bOtherChecks

BOOL

If TRUE, the field supports other kinds of checks.

bKeyed

BOOL

If TRUE, the field type can be keyed.

bMultiplePerTable

BOOL

If TRUE, the table can have more than one of this type.

iMinUnits1

UINT16

Specifies the minimum units required (1).

iMinUnits2

UINT16

Specifies the minimum units required (2).

bCreateable

BOOL

If TRUE, the field type can be created.