Viz Mosart Administrator Guide
Version 3.9 | Published November 04, 2019 ©
vtefi_connection
The view vtefi_connection is an alternative to the tdfi_connection table. The tdfi_connection table is a relation between the td_templatedescription and fi_fields table while the vtefi_connection view provides a relation between the te_template and fi_fields table (i.e. no need to access the td_templatedescription table directly). The view is a joint view between the td_templatedescription and tdfi_connection tables.
Note that the vtefi_connection view will only return fields for templates description belonging to the gallery with ga_recno = 1. This is added by default and shall equal the SHARED gallery.
|
Name |
Type |
Allow Null |
Description |
|
vtefi_te_recno |
integer |
No |
Foreign key referencing the template te_recno in the te_template table |
|
vtefi_fi_recno |
integer |
No |
Foreign key referencing the corresponding field fi_recno in the fi_field table |
|
vtefi_default |
varchar(128) |
Yes |
Optional default value for fields not of type ENUMERATION. I.e for STRING and NUMBER types. |
|
vtefi_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. |
Template description as stored in the td_templatedescription table that relates to the shared gallery (ga_recno=1) is defined as shared information (i.e. common to all galleries). When the template description is updated from a gallery, a copy is made for the corresponding template description related to the shared gallery.