Viz Mosart Administrator Guide

Version 5.2 | Published May 22, 2023 ©

fi_field

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.