# Templates ## Documentation The templates of the project. An insert creates one from html and css, or from mjml; an update of name, title or preheader waits for the background operation of Stripo, an update of html or css overwrites the content. - Catalog: `Stripo` - Schema: `Templates` - Primary Keys: `template_id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Templates` are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `created_time` | `datetime` | | ☐ | When the row was created, UTC. | | `css` | `varchar2` | | ☐ | Write only: the CSS of the template. | | `editor_url` | `varchar2` | | ☐ | The URL to edit the template in the Stripo editor. | | `folder_id` | `int64` | | ☐ | The folder of the template; null when in no folder. Set on insert; a move is the procedure move_templates of the package stripo. | | `has_amp` | `char` | | ☐ | Whether there is AMP content. | | `html` | `varchar2` | | ☐ | Write only: the HTML of the template. Read it from TemplateContents. | | `language` | `varchar2` | | ☐ | The language of the content. | | `mjml` | `varchar2` | | ☐ | Write only, on insert: MJML markup Stripo compiles into the template, instead of html and css. | | `name` | `varchar2` | | ☐ | The name of the template in the Stripo project. | | `preview_image` | `varchar2` | | ☐ | The URL of a preview image; null until Stripo rendered one. | | `preview_url` | `varchar2` | | ☐ | The URL of a preview that can be shared. | | `template_id` | `int64` | | ☑ | The id of the template. | | `title` | `varchar2` | | ☐ | The subject line. Stripo trims it and turns every run of spaces, tabs and line breaks into one space. | | `updated_time` | `datetime` | | ☐ | When the row was last changed, UTC. |