The table fi_field contains valid fields or newsroomtags used by Mosart templates for receiving user input. Normally these fields are exposed to the uses in the NRCS via dedicated ActiveX components. Note that a single field can be shared by many templates.
Name | Type | Allow Null | Description |
|---|---|---|---|
fi_recno | integer | No | Primary key. |
fi_name | varchar(32) | No | The field name. Normally presented to users. |
fi_description | varchar(128) | Yes | Optional field description. |
fi_type | varchar(32) | No | The field type. Supported values are ‘ENUMERATION’, ‘NUMBER’, ‘STRING’. |
fi_en_recno | integer | Yes | Optional foreign key for ENUMERATION fields. If set, referencing the corresponding enumeration in the en_enumeration table. |
fi_mask | varchar(128) | Yes | Optional input mask. Used for STRING fields only. |