---
title: "attachment (Odoo)"
description: "itgen_odoo_attachment"
language: en
source_language: en
translation_state: complete
canonical: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.ir.attachment
original: https://documentation.invantive.eu/en/datamodels/odoo/Odoo.ir.attachment
updated: 2023-03-01T15:29:04Z
license: https://documentation.invantive.eu/en/
---

# attachment: Odoo itgen_odoo_attachment

`read only` `per partition`

- Catalog: `Odoo`
- Schema: `ir`
- Label: itgen_odoo_attachment

Attachment

Can only retrieve data.

## Summary

Attachments are used to link binary files or url to any openerp document.

    External attachment storage
    ---------------------------

    The computed field ``datas`` is implemented using ``_file_read``,
    ``_file_write`` and ``_file_delete``, which can be overridden to implement
    other storage engines. Such methods should check for other location pseudo
    uri (example: hdfs://hadoopserver).

    The default implementation is the file:dirname location that stores files
    on the local filesystem using name based on their sha1 hash

## Table Columns

The columns of the table `attachment` 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 | Marks | Documentation |
|---|---|---|:---:|---|---|
| `access_token` | `varchar2` | Access Token | [ ] |  |  |
| `checksum` | `varchar2` | Checksum/SHA1 | [ ] |  |  |
| `company_id` | `varchar2` |  | [ ] |  |  |
| `company_id_label` | `varchar2` |  | [ ] |  |  |
| `create_date` | `datetime` | Created on | [ ] |  |  |
| `create_uid` | `varchar2` |  | [ ] |  |  |
| `create_uid_label` | `varchar2` |  | [ ] |  |  |
| `datas` | `varbinary` | File Content (base64) | [ ] |  |  |
| `db_datas` | `varbinary` | Database Data | [ ] |  |  |
| `description` | `varchar2` | Description | [ ] |  |  |
| `display_name` | `varchar2` | Display Name | [ ] |  |  |
| `document_ids` | `varchar2` |  | [ ] |  |  |
| `file_size` | `int32` | File Size | [ ] |  |  |
| `id` | `int32` | ID | [ ] |  |  |
| `image_height` | `int32` | Image Height | [ ] |  |  |
| `image_src` | `varchar2` | Image Src | [ ] |  |  |
| `image_width` | `int32` | Image Width | [ ] |  |  |
| `index_content` | `varchar2` | Indexed Content | [ ] |  |  |
| `key` | `varchar2` | Key | [ ] |  |  |
| `local_url` | `varchar2` | Attachment URL | [ ] |  |  |
| `mimetype` | `varchar2` | Mime Type | [ ] |  |  |
| `name` | `varchar2` | Name | [x] |  |  |
| `original_id` | `varchar2` |  | [ ] |  |  |
| `original_id_label` | `varchar2` |  | [ ] |  |  |
| `public` | `boolean` | Is public document | [ ] |  |  |
| `raw` | `varbinary` | File Content (raw) | [ ] |  |  |
| `res_field` | `varchar2` | Resource Field | [ ] |  |  |
| `res_id` | `int32` | Resource ID | [ ] |  |  |
| `res_model` | `varchar2` | Resource Model | [ ] |  |  |
| `res_name` | `varchar2` | Resource Name | [ ] |  |  |
| `store_fname` | `varchar2` | Stored Filename | [ ] |  |  |
| `theme_template_id` | `varchar2` |  | [ ] |  |  |
| `theme_template_id_label` | `varchar2` |  | [ ] |  |  |
| `type` | `varchar2` | Type | [x] |  | You can either upload a file from your computer or copy/paste an internet link to your file. |
| `url` | `varchar2` | Url | [ ] |  |  |
| `website_id` | `varchar2` |  | [ ] |  |  |
| `website_id_label` | `varchar2` |  | [ ] |  |  |
| `write_date` | `datetime` | Last Updated on | [ ] |  |  |
| `write_uid` | `varchar2` |  | [ ] |  |  |
| `write_uid_label` | `varchar2` |  | [ ] |  |  |



## Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver:

- [Odoo](/en/release-notes/drivers?driver=odoo)

