ir_ui_view

1358 rows


Description

View

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('ir_ui_view_id_seq'::regclass)
ir_act_window.search_view_id ir_act_window_search_view_id_fkey N
ir_act_window.view_id ir_act_window_view_id_fkey N
ir_act_window_view.view_id ir_act_window_view_view_id_fkey N
ir_ui_view.inherit_id ir_ui_view_inherit_id_fkey R
ir_ui_view_custom.ref_id ir_ui_view_custom_ref_id_fkey C
ir_ui_view_group_rel.view_id ir_ui_view_group_rel_view_id_fkey C
payment_provider.express_checkout_form_view_id payment_provider_express_checkout_form_view_id_fkey R
payment_provider.inline_form_view_id payment_provider_inline_form_view_id_fkey R
payment_provider.redirect_form_view_id payment_provider_redirect_form_view_id_fkey R
payment_provider.token_inline_form_view_id payment_provider_token_inline_form_view_id_fkey R
report_layout.view_id report_layout_view_id_fkey R
res_company.external_report_layout_id res_company_external_report_layout_id_fkey N
res_country.address_view_id res_country_address_view_id_fkey N
reset_view_arch_wizard.compare_view_id reset_view_arch_wizard_compare_view_id_fkey N
reset_view_arch_wizard.view_id reset_view_arch_wizard_view_id_fkey N
priority int4 10 null

Sequence
inherit_id int4 10 √ null
ir_ui_view.id ir_ui_view_inherit_id_fkey R

Inherited View
create_uid int4 10 √ null
res_users.id ir_ui_view_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

View Name
model varchar 2147483647 √ null

Model
key varchar 2147483647 √ null

Key
type varchar 2147483647 √ null

View Type
arch_fs varchar 2147483647 √ null

Arch Filename
mode varchar 2147483647 null

View inheritance mode
arch_db jsonb 2147483647 √ null

Arch Blob
arch_prev text 2147483647 √ null

Previous View Architecture
arch_updated bool 1 √ null

Modified Architecture
active bool 1 √ null

Active
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on
customize_show bool 1 √ null

Show As Optional Inherit

Indexes

Constraint Name Type Sort Column(s)
ir_ui_view_pkey Primary key Asc id
ir_ui_view__inherit_id_index Performance Asc inherit_id
ir_ui_view__key_index Performance Asc key
ir_ui_view__model_index Performance Asc model
ir_ui_view_model_type_inherit_id Performance Asc/Asc model + inherit_id

Check Constraints

Constraint Name Constraint
ir_ui_view_qweb_required_key ((((type)::text <> 'qweb'::text) OR (key IS NOT NULL)))
ir_ui_view_inheritance_mode ((((mode)::text <> 'extension'::text) OR (inherit_id IS NOT NULL)))

Relationships

Close relationships within degrees of separation