# Emails ## Documentation The emails 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: `Emails` - Primary Keys: `email_id` Can retrieve data and change data using insert, update and delete. ## Table Columns The columns of the table `Emails` 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 email. | | `editor_url` | `varchar2` | | ☐ | The URL to edit the email in the Stripo editor. | | `email_id` | `int64` | | ☑ | The id of the email. | | `folder_id` | `int64` | | ☐ | The folder of the email; null when in no folder. Set on insert; a move is the procedure move_emails of the package stripo. | | `has_amp` | `char` | | ☐ | Whether there is AMP content. | | `html` | `varchar2` | | ☐ | Write only: the HTML of the email. Read it from EmailContents. | | `language` | `varchar2` | | ☐ | The language of the content. | | `mjml` | `varchar2` | | ☐ | Write only, on insert: MJML markup Stripo compiles into the email, instead of html and css. | | `name` | `varchar2` | | ☐ | The name of the email in the Stripo project. | | `preheader` | `varchar2` | | ☐ | The preheader: the text a mail client shows after the subject. Stripo trims it and turns every run of white space into one space. | | `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. | | `tags` | `varchar2` | | ☐ | Write only, on an insert from mjml: comma-separated tags. | | `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. | | `utm_campaign` | `varchar2` | | ☐ | The UTM campaign added to the links. | | `utm_content` | `varchar2` | | ☐ | The UTM content added to the links. | | `utm_medium` | `varchar2` | | ☐ | The UTM medium added to the links. | | `utm_source` | `varchar2` | | ☐ | The UTM source added to the links. | | `utm_term` | `varchar2` | | ☐ | The UTM term added to the links. |