Viz Mosart Administrator Guide

Version 3.9 | Published November 04, 2019 ©

tdfi_connection

The table tdfi_connection which contains a list of fields (or newsroomtags) that corresponds to a template description. See also information given in the td_templatedescription table.

This is a relation table defining a many-to-many relationship between the td_templatedescription and fi_field tables

Name

Type

Allow Null

Description

tdfi_recno

integer

No

Primary key

tdfi_td_recno

integer

No

Foreign key referencing the corresponding template description td_recno in the td_templatedescription table

tdfi_fi_recno

integer

No

Foreign key referencing the corresponding field fi_recno in the fi_field table

tdfi_default

varchar(128)

Yes

Optional default value for fields not of type ENUMERATION. I.e for STRING and NUMBER types.

tdfi_em_recno

integer

Yes

Optional foreign key for the default value for ENUMERATION field types. Reference to a enumeration value em_recno in the em_enumerationmember table.