This table contains field values as cells.
Column | Data type | Max. length (bytes) | Allow nulls | Description |
ID | bigint | 8 | False | Unique identifier of the table 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. |
Name | nvarchar(255) | 510 | False | The name of the field. |
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). |
BatchID | bigint | 8 | False | The ID of the root document (BatchID in W_Document). |
BatchSiteId | int | 4 | False | Currently not used. |
Identifier | nvarchar(255) | 510 | False | The unique identifier of the field table definition. |
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 | Columns |
FK_W_FieldTable_W_Document | DocumentID -> W_Document.ID DocumentSiteId -> W_Document.SiteId |