| Database Table DatadictionaryTableFieldComputation |
[This is preliminary documentation and is subject to change.]
The table DataDictionaryTableFieldComputations holds data for computations associated to the dynamic fields in forms in TOPICA.
Each row represent a computation in stored in the Data Dictionary.
FieldsField name | Type | Note | Description |
|---|---|---|---|
TableName | varchar(50) | Primary key, foreign key to DatadictionaryTable | Name of the table holding data for the dynamic form. |
FieldName | varchar(50) | Primary key, foreign key to DatadictionaryField | Name of the field associated to the computation |
ComputationName | varchar(50) | Primary key | name of the computation |
SequenceNumber | int | ||
Disabled | bit | Whether or not the computation is disabled | |
ExpressionString | text | The expression that performs the actual computation. |