# Assets ## Documentation The files uploaded to the sites: images, documents and videos. An update changes the display name, the alternative text or the folder; a delete removes the file, also from the pages using it. - Catalog: `Webflow` - Schema: `Assets` - Primary Keys: `id` - Retrieve: True - Insert: False - Update: True - Delete: True ## Table Columns The columns of the table `Assets` 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 update. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `alt_text` | `varchar2` | | ☐ | The text describing the image for visitors who cannot see it. | | `content_type` | `varchar2` | | ☐ | The MIME type, such as image/png. | | `created_on` | `datetime` | | ☐ | When the asset was uploaded, UTC. | | `display_name` | `varchar2` | | ☐ | The name of the asset in the Designer. | | `folder_id` | `varchar2` | | ☐ | The folder of the asset; null at the top. | | `hosted_url` | `varchar2` | | ☐ | The address of the file on the content delivery network of Webflow. | | `id` | `varchar2` | | ☑ | The id of the asset. | | `last_updated` | `datetime` | | ☐ | When the asset was last changed, UTC. | | `original_file_name` | `varchar2` | | ☐ | The name of the file when it was uploaded. | | `site_id` | `varchar2` | | ☑ | The site. | | `size` | `int64` | | ☐ | The size in bytes. | | `variant_count` | `int32` | | ☐ | The number of responsive variants Webflow made of the image. | ## Foreign Keys The values of these columns refer to a row of another table. | Columns | Referenced Table | Referenced Columns | Guarantee | |---|---|---|---| | `folder_id` | [[Assets-AssetFolders\|Assets.AssetFolders]] | `id` | Declared by the connector, not enforced by the platform | | `site_id` | [[Sites-Sites\|Sites.Sites]] | `id` | Declared by the connector, not enforced by the platform |