| Database Table DataDictionaryField |
[This is preliminary documentation and is subject to change.]
The table DataDictionaryField holds base data for fields in dynamic forms in TOPICA
Each row represent a field in dynamic form
FieldsField name | Type | Note | Description |
|---|---|---|---|
FieldName | varchar(50) | Primary key | name of the field |
Viewname | varchar(255) | ||
Caption | varchar(255) | The caption (heading) displayed in the user interface. | |
ControllingFieldName | varchar(50) | ||
ControllingFieldValue | int | ||
DataType | int | Foriegn key to DataType | Data type of field |
FieldSize | int | ||
ReferencesTable | varchar(50) | ||
ReferencesField | varchar(50) | ||
AllowNull | bit | Whether or not null is a valid value for field | |
IsIdentity | bit | Whether or not field is an identity field | |
IsIndex | bit | Whether or not field is part of index | |
IsDateStart | bit | Whether or not field is to be considered as data start field | |
IsDateStop | bit | Whether or not field is to be considered as data stop field | |
IsName | bit | ||
IsStatus | bit | ||
IsInternal | bit | ||
Dimension | bit | ||
Meassure | bit | ||
Link | varchar(255) | ||
Description | Text |