Viz Mosart Administrator Guide
Version 5.0 | Published June 21, 2022 ©
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 join between the td_templatedescription and tdfi_connection tables.
Note: The vtefi_connection view only returns fields for templates description belonging to the gallery with ga_recno = 1. This is added by default and equal to 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. |
Note: Template description as stored in the td_templatedescription table that relates to the shared gallery (ga_recno=1) is defined to be shared information (i.e. common between 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.