ir_attachment

867 rows


Description

Attachment

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('ir_attachment_id_seq'::regclass)
account_bank_statement_ir_attachment_rel.ir_attachment_id account_bank_statement_ir_attachment_rel_ir_attachment_id_fkey C
account_move.message_main_attachment_id account_move_message_main_attachment_id_fkey N
account_payment.message_main_attachment_id account_payment_message_main_attachment_id_fkey N
account_tour_upload_bill_ir_attachments_rel.ir_attachment_id account_tour_upload_bill_ir_attachments_r_ir_attachment_id_fkey C
activity_attachment_rel.attachment_id activity_attachment_rel_attachment_id_fkey C
discuss_voice_metadata.attachment_id discuss_voice_metadata_attachment_id_fkey C
email_template_attachment_rel.attachment_id email_template_attachment_rel_attachment_id_fkey C
ir_attachment.original_id ir_attachment_original_id_fkey N
mail_compose_message_ir_attachments_rel.attachment_id mail_compose_message_ir_attachments_rel_attachment_id_fkey C
message_attachment_rel.attachment_id message_attachment_rel_attachment_id_fkey C
mrp_document.ir_attachment_id mrp_document_ir_attachment_id_fkey C
product_document.ir_attachment_id product_document_ir_attachment_id_fkey C
snailmail_letter.attachment_id snailmail_letter_attachment_id_fkey C
res_id int4 10 √ null

Resource ID
company_id int4 10 √ null
res_company.id ir_attachment_company_id_fkey N

Company
file_size int4 10 √ null

File Size
create_uid int4 10 √ null
res_users.id ir_attachment_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id ir_attachment_write_uid_fkey N

Last Updated by
name varchar 2147483647 null

Name
res_model varchar 2147483647 √ null

Resource Model
res_field varchar 2147483647 √ null

Resource Field
type varchar 2147483647 null

Type
url varchar 1024 √ null

Url
access_token varchar 2147483647 √ null

Access Token
store_fname varchar 2147483647 √ null

Stored Filename
checksum varchar 40 √ null

Checksum/SHA1
mimetype varchar 2147483647 √ null

Mime Type
description text 2147483647 √ null

Description
index_content text 2147483647 √ null

Indexed Content
public bool 1 √ null

Is public document
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
db_datas bytea 2147483647 √ null

Database Data
original_id int4 10 √ null
ir_attachment.id ir_attachment_original_id_fkey N

Original (unoptimized, unresized) attachment

Indexes

Constraint Name Type Sort Column(s)
ir_attachment_pkey Primary key Asc id
ir_attachment__store_fname_index Performance Asc store_fname
ir_attachment__url_index Performance Asc url
ir_attachment_res_idx Performance Asc/Asc res_model + res_id

Relationships

Close relationships within degrees of separation