Viz Mosart Administrator Guide
Version 5.6 | Published July 22, 2024 ©
te_template
The table te_template contains the individual templates with information that is shared among all galleries.
Note that information regarding a single template is divided into three parts / tables:
-     
te_template: Contains basic template information. This information is shared among all galleries (i.e. gallery independent).
 -     
td_templatedescription: Contains typically template information to be presented to users that is gallery dependent.
 -     
ti_templateimplementation: Contains the template implementation as created by the Mosart template editor. This information is gallery dependent.
 
| 
         Name  | 
                
         Type  | 
                
         Allow Null  | 
                
         Description  | 
        
| 
         te_recno  | 
                
         integer  | 
                
         No  | 
                
         Primary key.  | 
        
| 
         te_ts_recno  | 
                
         integer  | 
                
         No  | 
                
         Foreign key referencing the corresponding template set in the ts_templateset table.  | 
        
| 
         te_tt_recno  | 
                
         integer  | 
                
         No  | 
                
         Foreign key referencing the corresponding template type in the tt_templatetype table.  | 
        
| 
         te_variant  | 
                
         varchar(32)  | 
                
         No  | 
                
         The Mosart template variant.  | 
        
| 
         te_description  | 
                
         varchar(128)  | 
                
         Yes  | 
                
         Optional template description.  | 
        
| 
         te_hidden  | 
                
         smallint  | 
                
         Yes  | 
                
         Set to true (1) if this template is to be hidden from any user presentations.  | 
        
| 
         te_name  | 
                
         varchar(128)  | 
                
         Yes  | 
                
         Optional template name.  | 
        
| 
         te_sendtoncs  | 
                
         smallint  | 
                
         Yes  | 
                
         Set to true (1) if the template implementation is to be sent to NCS. Used by some NCS only.  |