ir_model_fields


Description

Fields

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('ir_model_fields_id_seq'::regclass)
ir_act_server.link_field_id ir_act_server_link_field_id_fkey N
ir_act_server.update_field_id ir_act_server_update_field_id_fkey C
ir_act_server_webhook_field_rel.field_id ir_act_server_webhook_field_rel_field_id_fkey C
ir_default.field_id ir_default_field_id_fkey C
ir_model.website_form_default_field_id ir_model_website_form_default_field_id_fkey N
ir_model_fields.related_field_id ir_model_fields_related_field_id_fkey C
ir_model_fields.relation_field_id ir_model_fields_relation_field_id_fkey C
ir_model_fields_group_rel.field_id ir_model_fields_group_rel_field_id_fkey C
ir_model_fields_selection.field_id ir_model_fields_selection_field_id_fkey C
ir_model_inherit.parent_field_id ir_model_inherit_parent_field_id_fkey C
mail_tracking_value.field_id mail_tracking_value_field_id_fkey N
website_sale_extra_field.field_id website_sale_extra_field_field_id_fkey C
relation_field_id int4 10 √ null
ir_model_fields.id ir_model_fields_relation_field_id_fkey C

Relation field
model_id int4 10 null
ir_model.id ir_model_fields_model_id_fkey C

Model
related_field_id int4 10 √ null
ir_model_fields.id ir_model_fields_related_field_id_fkey C

Related Field
size int4 10 √ null

Size
create_uid int4 10 √ null
res_users.id ir_model_fields_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Field Name
complete_name varchar 2147483647 √ null

Complete Name
model varchar 2147483647 null

Model Name
relation varchar 2147483647 √ null

Related Model
relation_field varchar 2147483647 √ null

Relation Field
ttype varchar 2147483647 null

Field Type
related varchar 2147483647 √ null

Related Field Definition
state varchar 2147483647 null

Type
on_delete varchar 2147483647 √ null

On Delete
domain varchar 2147483647 √ null

Domain
relation_table varchar 2147483647 √ null

Relation Table
column1 varchar 2147483647 √ null

Column 1
column2 varchar 2147483647 √ null

Column 2
depends varchar 2147483647 √ null

Dependencies
currency_field varchar 2147483647 √ null

Currency field
field_description jsonb 2147483647 null

Field Label
help jsonb 2147483647 √ null

Field Help
compute text 2147483647 √ null

Compute
copied bool 1 √ null

Copied
required bool 1 √ null

Required
readonly bool 1 √ null

Readonly
index bool 1 √ null

Indexed
translate bool 1 √ null

Translatable
company_dependent bool 1 √ null

Company Dependent
group_expand bool 1 √ null

Expand Groups
selectable bool 1 √ null

Selectable
store bool 1 √ null

Stored
sanitize bool 1 √ null

Sanitize HTML
sanitize_overridable bool 1 √ null

Sanitize HTML overridable
sanitize_tags bool 1 √ null

Sanitize HTML Tags
sanitize_attributes bool 1 √ null

Sanitize HTML Attributes
sanitize_style bool 1 √ null

Sanitize HTML Style
sanitize_form bool 1 √ null

Sanitize HTML Form
strip_style bool 1 √ null

Strip Style Attribute
strip_classes bool 1 √ null

Strip Class Attribute
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
tracking int4 10 √ null

Enable Ordered Tracking
website_form_blacklisted bool 1 √ true

Blacklisted in web forms

Indexes

Constraint Name Type Sort Column(s)
ir_model_fields_pkey Primary key Asc id
ir_model_fields__complete_name_index Performance Asc complete_name
ir_model_fields__model_id_index Performance Asc model_id
ir_model_fields__model_index Performance Asc model
ir_model_fields__name_index Performance Asc name
ir_model_fields__state_index Performance Asc state
ir_model_fields__website_form_blacklisted_index Performance Asc website_form_blacklisted
ir_model_fields_name_unique Must be unique Asc/Asc model + name

Check Constraints

Constraint Name Constraint
ir_model_fields_name_manual_field ((((state)::text <> 'manual'::text) OR ((name)::text ~~ 'x\_%'::text)))
ir_model_fields_size_gt_zero ((size >= 0))

Relationships

Close relationships within degrees of separation