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.