This table contains processing information about a field.
Column | Data type | Max. length (bytes) | Allow nulls | Description |
ID | bigint | 8 | False | Unique identifier of the field. |
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. |
DocumentID | bigint | 8 | False | The ID of the related Document (ID in W_Document). |
DocumentSiteId | int | 4 | False | Currently not used. |
ParentID | bigint | 8 | False | The ID of the parent field (ID in this table). |
ParentSiteId | int | 4 | False | Currently not used. |
Name | nvarchar(255) | 510 | False | The name of the field. |
Type | int | 4 | False | The field type. Possible values: 0 = group |
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). |
ErrorID | int | 4 | False | The ID of the error status (ID in C_Status). |
Identifier | nvarchar(255) | 510 | False | The unique identifier of the field definition. |
BatchID | bigint | 8 | False | The ID of the root document (BatchID in W_Document). |
BatchSiteId | int | 4 | False | Currently not used. |
BinaryValue | varbinary(max) | max | False | The value of VarcharValue in binary form. Only filled in when VarcharValue > 255. |
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. |
Name | No Check | Columns |
FK_W_Field_W_Document | True | DocumentID -> W_Document.ID DocumentSiteId -> W_Document.SiteId |
FK_W_Field_W_Field | True | ParentID -> W_Field.ID ParentSiteId -> W_Field.SiteId |