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_ |
varchar2 |
Access Token | |||
checksum |
varchar2 |
Checksum/SHA1 | |||
company_ |
varchar2 |
||||
company_ |
varchar2 |
||||
create_ |
datetime |
Created on | |||
create_ |
varchar2 |
||||
create_ |
varchar2 |
||||
datas |
varbinary |
File Content (base64) | |||
db_ |
varbinary |
Database Data | |||
description |
varchar2 |
Description | |||
display_ |
varchar2 |
Display Name | |||
document_ |
varchar2 |
||||
file_ |
int32 |
File Size | |||
id |
int32 |
ID | |||
image_ |
int32 |
Image Height | |||
image_ |
varchar2 |
Image Src | |||
image_ |
int32 |
Image Width | |||
index_ |
varchar2 |
Indexed Content | |||
key |
varchar2 |
Key | |||
local_ |
varchar2 |
Attachment URL | |||
mimetype |
varchar2 |
Mime Type | |||
name |
varchar2 |
Name | |||
original_ |
varchar2 |
||||
original_ |
varchar2 |
||||
public |
boolean |
Is public document | |||
raw |
varbinary |
File Content (raw) | |||
res_ |
varchar2 |
Resource Field | |||
res_id |
int32 |
Resource ID | |||
res_ |
varchar2 |
Resource Model | |||
res_ |
varchar2 |
Resource Name | |||
store_ |
varchar2 |
Stored Filename | |||
theme_ |
varchar2 |
||||
theme_ |
varchar2 |
||||
type |
varchar2 |
Type | You can either upload a file from your computer or copy/paste an internet link to your file. | ||
url |
varchar2 |
Url | |||
website_ |
varchar2 |
||||
website_ |
varchar2 |
||||
write_ |
datetime |
Last Updated on | |||
write_ |
varchar2 |
||||
write_ |
varchar2 |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: