Table: C_FieldDefinition

ID

int

4

False

Unique identifier of the field definiton.

Rev

int

4

False

Revision number. For internal use.

DocTypeID

int

4

False

The ID of the related document type (ID in DocType).

ParentID

int

4

False

The ID of the parent field definition.

Name

nvarchar(255)

510

False

The name of the field.

Type

int

4

False

The field type. Possible values:

0 = group
1 = string
2 = integer
3 = float
4 = datetime

VarcharValue

nvarchar(255)

510

False

Value if Type=1.

IntValue

int

4

False

Value if Type=2.

FloatValue

float

8

False

Value if Type=3.

DatetimeValue

datetime

8

False

Value if Type=4.

MinValue

float

8

False

Minimum value of the field, if any (applies to the Number type).

(For more information about these settings, see XBOUND Help topic "Creating a field definition".)

MaxValue

float

8

False

Maximum value of the field, if any (applies to the Number type).

MinLength

int

4

False

Minimum length of the field, if any (applies to the Text type).

MaxLength

int

4

False

Maximum length of the field, if any (applies to the Text type).

Mandatory

int

4

False

Tells whether the field is required or not.

ReadOnly

int

4

False

Tells whether the field is read-only or not.

HasDefault

int

4

False

Tells whether a default value is specified for the field.

Protected

int

4

False

Write-protected. Cannot be overwritten.

ValidID

int

4

False

The ID of the validation status (ID in C_Status). 

Identifier

nvarchar(255)

510

False

The unique identifier of the field definition.

Historical

int

4

False

0 = History is not saved.

1 = History is saved.

Reportable

int

4

False

The Use for report option makes field data available for analysis in its own report.

ReportLabel

nvarchar(255)

510

False

The name used as label in reports. 

DeletedAt

datetime

8

True

The date when the data set was deleted from the XBOUND database (main database).

Available in XBOUND 3.8 and later.

FK_C_FieldDefinition_C_DocType

True

DocTypeID -> C_DocType.ID

FK_C_FieldDefinition_C_FieldDefinition

True

ParentID -> C_FieldDefinition.ID