attachment |
Attachment
Catalog: Odoo
Schema: ir
Documentation:
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
The data in this table is partitioned per value of the column.
This is a read-only table. The Odoo API may not support changing the data or the Invantive SQL driver for Odoo does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Odoo API.
Table Columns
The columns of the table attachment are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
---|---|---|---|---|
access_token |
string |
Access Token |
☐ |
|
checksum |
string |
Checksum/SHA1 |
☐ |
|
company_id_label |
string |
|
☐ |
|
company_id |
string |
|
☐ |
|
create_date |
datetime |
Created on |
☐ |
|
create_uid_label |
string |
|
☐ |
|
create_uid |
string |
|
☐ |
|
datas |
byte[] |
File Content (base64) |
☐ |
|
db_datas |
byte[] |
Database Data |
☐ |
|
description |
string |
Description |
☐ |
|
display_name |
string |
Display Name |
☐ |
|
document_ids |
string |
|
☐ |
|
file_size |
int32 |
File Size |
☐ |
|
id |
int32 |
ID |
☐ |
|
image_height |
int32 |
Image Height |
☐ |
|
image_src |
string |
Image Src |
☐ |
|
image_width |
int32 |
Image Width |
☐ |
|
index_content |
string |
Indexed Content |
☐ |
|
key |
string |
Key |
☐ |
|
local_url |
string |
Attachment URL |
☐ |
|
mimetype |
string |
Mime Type |
☐ |
|
name |
string |
Name |
☑ |
|
original_id_label |
string |
|
☐ |
|
original_id |
string |
|
☐ |
|
public |
boolean |
Is public document |
☐ |
|
raw |
byte[] |
File Content (raw) |
☐ |
|
res_field |
string |
Resource Field |
☐ |
|
res_id |
int32 |
Resource ID |
☐ |
|
res_model |
string |
Resource Model |
☐ |
|
res_name |
string |
Resource Name |
☐ |
|
store_fname |
string |
Stored Filename |
☐ |
|
theme_template_id_label |
string |
|
☐ |
|
theme_template_id |
string |
|
☐ |
|
type |
string |
Type |
☑ |
You can either upload a file from your computer or copy/paste an internet link to your file. |
url |
string |
Url |
☐ |
|
website_id_label |
string |
|
☐ |
|
website_id |
string |
|
☐ |
|
write_date |
datetime |
Last Updated on |
☐ |
|
write_uid_label |
string |
|
☐ |
|
write_uid |
string |
|
☐ |
|
01-03-2023 15:29 Version 22.1.135-BETA+3826