Table: W_CellHistory

ID

bigint

8

False

Unique Identifier of the history of the cell.

SiteId

int

4

False

Currently not used.

Rev

bigint

8

False

Revision number. For internal use.

Acl

varbinary(max)

max

False

For internal use only.

MAcl

varbinary(max)

max

False

For internal use only.

StepID

bigint

8

False

The ID of the step (ID in the W_Step).

StepSiteId

int

4

False

Currently not used.

TableCellID

bigint

8

False

The ID of the table cell (ID in W_TableCell).

TableCellSiteId

int

4

False

Currently not used.

Name

nvarchar(255)

510

False

The name of the cell.

Type

int

4

False

The data type of the field. Possible values:

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

VarcharValue

nvarchar(255)

510

False

Field value when Type=1 (string).

IntValue

int

4

False

Field value when Type=2 (integer).

FloatValue

float

8

False

Field value when Type=3 (float).

DatetimeValue

datetime

8

False

Field value when Type=4 (datetime).

ValidID

int

4

False

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

Item

int

4

False

The sequence number of the cell.

BinaryValue

varbinary(max)

max

False

The binary value of the cell if its type is Varchar.

BatchID

bigint

8

False

The ID of the root document (BatchID in W_Document).

BatchSiteId

int

4

False

Currently not used.

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_W_CellHistory_W_Step

StepID -> W_Step.ID

StepSiteId -> W_Step.SiteId