| Database Table DatadictionaryTableField |
[This is preliminary documentation and is subject to change.]
The DatadictionaryTableField table holds data about relations between tables and fields in dynamic forms in dynamic forms TOPICA
Each row represent a table-field relationship in a dynamic form
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 DatadictionnayField | Name of the field in the dynamic form |
Caption | varchar(255) | ||
DefaultBool | bit | ||
DefaultInt | bit | ||
DefaultFloat | bit | ||
ComputationDefault | varchar(2000) | ||
AllowNull | bit | Whether or not null is a valid value for field | |
ListColumn | int | ||
SequenceNumber | int) |