Tables : ir_ui_view
Columns16 |
Keys1 |
Triggers0 |
Comment:Description: |
|
Indexes3 |
Contraints2 |
|||
Columns :
| Name | Caption | Primary Key | type |
|---|---|---|---|
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| model | model | CHARACTER VARYING | |
| key | key | CHARACTER VARYING | |
| priority | priority | INTEGER | |
| type | type | CHARACTER VARYING | |
| arch_db | arch_db | TEXT | |
| arch_fs | arch_fs | CHARACTER VARYING | |
| inherit_id | inherit_id | INTEGER | |
| field_parent | field_parent | CHARACTER VARYING | |
| mode | mode | CHARACTER VARYING | |
| 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_ui_view_pkey | true |
Indexes
| Name | UNIQUE | Type | Description |
|---|---|---|---|
| ir_ui_view_model_type_inherit_id | Ascending | ||
| ir_ui_view_inherit_id_index | Ascending | ||
| ir_ui_view_model_index | Ascending |
Constraints
| Name | Expression | Description |
|---|---|---|
| ir_ui_view_inheritance_mode |
((((mode)::text <> 'extension'::text) OR (inherit_id IS NOT NULL))) |
|
| ir_ui_view_qweb_required_key |
((((type)::text <> 'qweb'::text) OR (key IS NOT NULL))) |
Columns Detail :
| Name | id |
| Table | ir_ui_view |
| Type | INTEGER |
| Domain | |
| Primary Key | true |
| Not null | true |
| Default Value | nextval('ir_ui_view_id_seq'::regclass) |
| Name | name |
| Table | ir_ui_view |
| Type | CHARACTER VARYING |
| Domain | |
| Not null | true |
| Name | model |
| Table | ir_ui_view |
| Type | CHARACTER VARYING |
| Domain |
| Name | key |
| Table | ir_ui_view |
| Type | CHARACTER VARYING |
| Domain |
| Name | priority |
| Table | ir_ui_view |
| Type | INTEGER |
| Domain | |
| Not null | true |
| Name | type |
| Table | ir_ui_view |
| Type | CHARACTER VARYING |
| Domain |
| Name | arch_db |
| Table | ir_ui_view |
| Type | TEXT |
| Domain |
| Name | arch_fs |
| Table | ir_ui_view |
| Type | CHARACTER VARYING |
| Domain |
| Name | inherit_id |
| Table | ir_ui_view |
| Type | INTEGER |
| Domain | |
| Foreign key | true |
| Name | field_parent |
| Table | ir_ui_view |
| Type | CHARACTER VARYING |
| Domain |
| Name | mode |
| Table | ir_ui_view |
| Type | CHARACTER VARYING |
| Domain | |
| Not null | true |
| Name | active |
| Table | ir_ui_view |
| Type | BOOLEAN |
| Domain |
| Name | create_uid |
| Table | ir_ui_view |
| Type | INTEGER |
| Domain | |
| Foreign key | true |
| Name | create_date |
| Table | ir_ui_view |
| Type | TIMESTAMP(6) |
| Domain |
| Name | write_uid |
| Table | ir_ui_view |
| Type | INTEGER |
| Domain | |
| Foreign key | true |
| Name | write_date |
| Table | ir_ui_view |
| Type | TIMESTAMP(6) |
| Domain |
Project
Odoo Data Model