Table: C_CellDef

Definition of a cell within a table. (When a table definition is created in XBOUND, the definition of the individual cells is saved here.)

Column	Data type	Max. length (bytes)	Allow nulls	Description
ID	int	4	False	Unique identifier of the cell definition.
Rev	int	4	False	Revision number. For internal use.
FieldTableDefID	int	4	False	The ID of the related table definition (ID in C_TableDef).
Name	nvarchar(255)	510	False	The name of the cell definition.
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=0 (string).
IntValue	int	4	False	Field value when Type=1 (integer).
FloatValue	float	8	False	Field value when Type=2 (float).
DatetimeValue	datetime	8	False	Field value when Type=3 (datetime).
HasDefault	int	4	False	The cell has a default value.
Protected	int	4	False	Write-protected. Cannot be overwritten.
Item	int	4	False	The sequence number of the cell definition.
ValidID	int	4	False	The ID of the validation status (ID in C_Status).
Identifier	nvarchar(255)	510	False	The unique identifier of the cell 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.

Foreign keys

Name	Columns
FK_C_CellDef_C_TableDef	FieldTableDefID -> C_TableDef.ID