Viz Mosart Administrator Guide
Version 5.6 | Published July 22, 2024 ©
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.  |