Tables : ir_attachment


Columns

25

Keys

1

Triggers

0

Comment:

Description:

Indexes

4

Contraints

0


Columns :

Name Caption Primary Key type
id id true INTEGER
name name CHARACTER VARYING
datas_fname datas_fname CHARACTER VARYING
description description TEXT
res_name res_name CHARACTER VARYING
res_model res_model CHARACTER VARYING
res_model_name res_model_name CHARACTER VARYING
res_field res_field CHARACTER VARYING
res_id res_id INTEGER
company_id company_id INTEGER
type type CHARACTER VARYING
url url CHARACTER VARYING(1024)
public public BOOLEAN
access_token access_token CHARACTER VARYING
db_datas db_datas BYTEA
store_fname store_fname CHARACTER VARYING
file_size file_size INTEGER
checksum checksum CHARACTER VARYING(40)
mimetype mimetype CHARACTER VARYING
index_content index_content TEXT
active active BOOLEAN
create_uid create_uid INTEGER
create_date create_date TIMESTAMP(6)
write_uid write_uid INTEGER
write_date write_date TIMESTAMP(6)

Keys :

Name Primary Key Description
ir_attachment_pkey true

Indexes

Name UNIQUE Type Description
ir_attachment_res_idx Ascending
ir_attachment_checksum_index Ascending
ir_attachment_url_index Ascending
ir_attachment_res_model_name_index Ascending

Columns Detail :

Name id
Table ir_attachment
Type INTEGER
Domain
Primary Key true
Not null true
Default Value nextval('ir_attachment_id_seq'::regclass)

Name name
Table ir_attachment
Type CHARACTER VARYING
Domain
Not null true

Name datas_fname
Table ir_attachment
Type CHARACTER VARYING
Domain

Name description
Table ir_attachment
Type TEXT
Domain

Name res_name
Table ir_attachment
Type CHARACTER VARYING
Domain

Name res_model
Table ir_attachment
Type CHARACTER VARYING
Domain

Name res_model_name
Table ir_attachment
Type CHARACTER VARYING
Domain

Name res_field
Table ir_attachment
Type CHARACTER VARYING
Domain

Name res_id
Table ir_attachment
Type INTEGER
Domain

Name company_id
Table ir_attachment
Type INTEGER
Domain
Foreign key true

Name type
Table ir_attachment
Type CHARACTER VARYING
Domain
Not null true

Name url
Table ir_attachment
Type CHARACTER VARYING(1024)
Domain

Name public
Table ir_attachment
Type BOOLEAN
Domain

Name access_token
Table ir_attachment
Type CHARACTER VARYING
Domain

Name db_datas
Table ir_attachment
Type BYTEA
Domain

Name store_fname
Table ir_attachment
Type CHARACTER VARYING
Domain

Name file_size
Table ir_attachment
Type INTEGER
Domain

Name checksum
Table ir_attachment
Type CHARACTER VARYING(40)
Domain

Name mimetype
Table ir_attachment
Type CHARACTER VARYING
Domain

Name index_content
Table ir_attachment
Type TEXT
Domain

Name active
Table ir_attachment
Type BOOLEAN
Domain

Name create_uid
Table ir_attachment
Type INTEGER
Domain
Foreign key true

Name create_date
Table ir_attachment
Type TIMESTAMP(6)
Domain

Name write_uid
Table ir_attachment
Type INTEGER
Domain
Foreign key true

Name write_date
Table ir_attachment
Type TIMESTAMP(6)
Domain

Project

Odoo Data Model

Company

Author

Version

Copyright

Comment

Description