Tables : ir_model_fields


Columns

34

Keys

2

Triggers

0

Comment:

Description:

Indexes

5

Contraints

1


Columns :

Name Caption Primary Key type
id id true INTEGER
name name CHARACTER VARYING
complete_name complete_name CHARACTER VARYING
model model CHARACTER VARYING
relation relation CHARACTER VARYING
relation_field relation_field CHARACTER VARYING
relation_field_id relation_field_id INTEGER
model_id model_id INTEGER
field_description field_description CHARACTER VARYING
help help TEXT
ttype ttype CHARACTER VARYING
selection selection CHARACTER VARYING
copied copied BOOLEAN
related related CHARACTER VARYING
related_field_id related_field_id INTEGER
required required BOOLEAN
readonly readonly BOOLEAN
index index BOOLEAN
translate translate BOOLEAN
size size INTEGER
state state CHARACTER VARYING
on_delete on_delete CHARACTER VARYING
domain domain CHARACTER VARYING
selectable selectable BOOLEAN
relation_table relation_table CHARACTER VARYING
column1 column1 CHARACTER VARYING
column2 column2 CHARACTER VARYING
compute compute TEXT
depends depends CHARACTER VARYING
store store 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_model_fields_pkey true
ir_model_fields_name_unique

Indexes

Name UNIQUE Type Description
ir_model_fields_state_index Ascending
ir_model_fields_model_id_index Ascending
ir_model_fields_model_index Ascending
ir_model_fields_complete_name_index Ascending
ir_model_fields_name_index Ascending

Constraints

Name Expression Description
ir_model_fields_size_gt_zero

((size >= 0))

Columns Detail :

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

Name name
Table ir_model_fields
Type CHARACTER VARYING
Domain
Not null true
Unique true

Name complete_name
Table ir_model_fields
Type CHARACTER VARYING
Domain

Name model
Table ir_model_fields
Type CHARACTER VARYING
Domain
Not null true
Unique true

Name relation
Table ir_model_fields
Type CHARACTER VARYING
Domain

Name relation_field
Table ir_model_fields
Type CHARACTER VARYING
Domain

Name relation_field_id
Table ir_model_fields
Type INTEGER
Domain
Foreign key true

Name model_id
Table ir_model_fields
Type INTEGER
Domain
Not null true
Foreign key true

Name field_description
Table ir_model_fields
Type CHARACTER VARYING
Domain
Not null true

Name help
Table ir_model_fields
Type TEXT
Domain

Name ttype
Table ir_model_fields
Type CHARACTER VARYING
Domain
Not null true

Name selection
Table ir_model_fields
Type CHARACTER VARYING
Domain

Name copied
Table ir_model_fields
Type BOOLEAN
Domain

Name
Table ir_model_fields
Type CHARACTER VARYING
Domain

Name
Table ir_model_fields
Type INTEGER
Domain
Foreign key true

Name required
Table ir_model_fields
Type BOOLEAN
Domain

Name readonly
Table ir_model_fields
Type BOOLEAN
Domain

Name index
Table ir_model_fields
Type BOOLEAN
Domain

Name translate
Table ir_model_fields
Type BOOLEAN
Domain

Name size
Table ir_model_fields
Type INTEGER
Domain

Name state
Table ir_model_fields
Type CHARACTER VARYING
Domain
Not null true

Name on_delete
Table ir_model_fields
Type CHARACTER VARYING
Domain

Name domain
Table ir_model_fields
Type CHARACTER VARYING
Domain

Name selectable
Table ir_model_fields
Type BOOLEAN
Domain

Name relation_table
Table ir_model_fields
Type CHARACTER VARYING
Domain

Name column1
Table ir_model_fields
Type CHARACTER VARYING
Domain

Name column2
Table ir_model_fields
Type CHARACTER VARYING
Domain

Name compute
Table ir_model_fields
Type TEXT
Domain

Name depends
Table ir_model_fields
Type CHARACTER VARYING
Domain

Name store
Table ir_model_fields
Type BOOLEAN
Domain

Name create_uid
Table ir_model_fields
Type INTEGER
Domain
Foreign key true

Name create_date
Table ir_model_fields
Type TIMESTAMP(6)
Domain

Name write_uid
Table ir_model_fields
Type INTEGER
Domain
Foreign key true

Name write_date
Table ir_model_fields
Type TIMESTAMP(6)
Domain

Project

Odoo Data Model

Company

Author

Version

Copyright

Comment

Description