Tables : ir_property
Columns16 |
Keys1 |
Triggers0 |
Comment:Description: |
|
Indexes5 |
Contraints0 |
|||
Columns :
| Name | Caption | Primary Key | type |
|---|---|---|---|
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| res_id | res_id | CHARACTER VARYING | |
| company_id | company_id | INTEGER | |
| fields_id | fields_id | INTEGER | |
| value_float | value_float | DOUBLE PRECISION | |
| value_integer | value_integer | INTEGER | |
| value_text | value_text | TEXT | |
| value_binary | value_binary | BYTEA | |
| value_reference | value_reference | CHARACTER VARYING | |
| value_datetime | value_datetime | TIMESTAMP(6) | |
| type | type | CHARACTER VARYING | |
| 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_property_pkey | true |
Indexes
| Name | UNIQUE | Type | Description |
|---|---|---|---|
| ir_property_type_index | Ascending | ||
| ir_property_fields_id_index | Ascending | ||
| ir_property_company_id_index | Ascending | ||
| ir_property_res_id_index | Ascending | ||
| ir_property_name_index | Ascending |
Columns Detail :
| Name | id |
| Table | ir_property |
| Type | INTEGER |
| Domain | |
| Primary Key | true |
| Not null | true |
| Default Value | nextval('ir_property_id_seq'::regclass) |
| Name | name |
| Table | ir_property |
| Type | CHARACTER VARYING |
| Domain |
| Name | res_id |
| Table | ir_property |
| Type | CHARACTER VARYING |
| Domain |
| Name | company_id |
| Table | ir_property |
| Type | INTEGER |
| Domain | |
| Foreign key | true |
| Name | fields_id |
| Table | ir_property |
| Type | INTEGER |
| Domain | |
| Not null | true |
| Foreign key | true |
| Name | value_float |
| Table | ir_property |
| Type | DOUBLE PRECISION |
| Domain |
| Name | value_integer |
| Table | ir_property |
| Type | INTEGER |
| Domain |
| Name | value_text |
| Table | ir_property |
| Type | TEXT |
| Domain |
| Name | value_binary |
| Table | ir_property |
| Type | BYTEA |
| Domain |
| Name | value_reference |
| Table | ir_property |
| Type | CHARACTER VARYING |
| Domain |
| Name | value_datetime |
| Table | ir_property |
| Type | TIMESTAMP(6) |
| Domain |
| Name | type |
| Table | ir_property |
| Type | CHARACTER VARYING |
| Domain | |
| Not null | true |
| Name | create_uid |
| Table | ir_property |
| Type | INTEGER |
| Domain | |
| Foreign key | true |
| Name | create_date |
| Table | ir_property |
| Type | TIMESTAMP(6) |
| Domain |
| Name | write_uid |
| Table | ir_property |
| Type | INTEGER |
| Domain | |
| Foreign key | true |
| Name | write_date |
| Table | ir_property |
| Type | TIMESTAMP(6) |
| Domain |
Project
Odoo Data Model