Columns
| Column Name | Column Caption | Primary Key | Type |
|---|---|---|---|
| id | id | true | INTEGER |
| res_model | res_model | CHARACTER VARYING | |
| file | file | BYTEA | |
| file_name | file_name | CHARACTER VARYING | |
| file_type | file_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) | |
| id | id | true | INTEGER |
| res_model | res_model | CHARACTER VARYING | |
| column_name | column_name | CHARACTER VARYING | |
| field_name | field_name | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| value | value | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| value | value | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| value | value | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| value | value | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| value | value | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| value | value | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| f | f | DOUBLE PRECISION | |
| m | m | NUMERIC | |
| c | c | CHARACTER VARYING | |
| currency_id | currency_id | INTEGER | |
| d | d | DATE | |
| dt | dt | TIMESTAMP(6) | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| value | value | DOUBLE PRECISION | |
| value2 | value2 | NUMERIC | |
| currency_id | currency_id | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| value | value | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| value | value | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| value | value | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| value | value | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| parent_id | parent_id | INTEGER | |
| value | value | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| somevalue | somevalue | INTEGER | |
| othervalue | othervalue | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| lang | lang | CHARACTER VARYING | |
| format | format | CHARACTER VARYING | |
| data | data | BYTEA | |
| state | state | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| code | code | CHARACTER VARYING(5) | |
| data | data | BYTEA | |
| filename | filename | CHARACTER VARYING | |
| overwrite | overwrite | BOOLEAN | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| lang | lang | CHARACTER VARYING | |
| overwrite | overwrite | BOOLEAN | |
| state | state | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| show_all | show_all | BOOLEAN | |
| module_id | module_id | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| updated | updated | INTEGER | |
| added | added | INTEGER | |
| state | state | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| module_info | module_info | TEXT | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| group_by_email | group_by_email | BOOLEAN | |
| group_by_name | group_by_name | BOOLEAN | |
| group_by_is_company | group_by_is_company | BOOLEAN | |
| group_by_vat | group_by_vat | BOOLEAN | |
| group_by_parent_id | group_by_parent_id | BOOLEAN | |
| state | state | CHARACTER VARYING | |
| number_group | number_group | INTEGER | |
| current_line_id | current_line_id | INTEGER | |
| dst_partner_id | dst_partner_id | INTEGER | |
| exclude_contact | exclude_contact | BOOLEAN | |
| exclude_journal_item | exclude_journal_item | BOOLEAN | |
| maximum_group | maximum_group | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| base_partner_merge_automatic_wizard_id | base_partner_merge_automatic_wizard_id | INTEGER | |
| res_partner_id | res_partner_id | INTEGER | |
| id | id | true | INTEGER |
| wizard_id | wizard_id | INTEGER | |
| min_id | min_id | INTEGER | |
| aggr_ids | aggr_ids | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| lang | lang | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| wizard_id | wizard_id | INTEGER | |
| user_id | user_id | INTEGER | |
| user_login | user_login | CHARACTER VARYING | |
| new_passwd | new_passwd | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| service_name | service_name | CHARACTER VARYING | |
| account_token | account_token | CHARACTER VARYING | |
| company_id | company_id | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| type | type | CHARACTER VARYING | |
| help | help | TEXT | |
| binding_model_id | binding_model_id | INTEGER | |
| binding_type | binding_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) | |
| tag | tag | CHARACTER VARYING | |
| target | target | CHARACTER VARYING | |
| res_model | res_model | CHARACTER VARYING | |
| context | context | CHARACTER VARYING | |
| params_store | params_store | BYTEA | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| type | type | CHARACTER VARYING | |
| help | help | TEXT | |
| binding_model_id | binding_model_id | INTEGER | |
| binding_type | binding_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) | |
| model | model | CHARACTER VARYING | |
| report_type | report_type | CHARACTER VARYING | |
| report_name | report_name | CHARACTER VARYING | |
| report_file | report_file | CHARACTER VARYING | |
| multi | multi | BOOLEAN | |
| paperformat_id | paperformat_id | INTEGER | |
| print_report_name | print_report_name | CHARACTER VARYING | |
| attachment_use | attachment_use | BOOLEAN | |
| attachment | attachment | CHARACTER VARYING | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| type | type | CHARACTER VARYING | |
| help | help | TEXT | |
| binding_model_id | binding_model_id | INTEGER | |
| binding_type | binding_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) | |
| usage | usage | CHARACTER VARYING | |
| state | state | CHARACTER VARYING | |
| sequence | sequence | INTEGER | |
| model_id | model_id | INTEGER | |
| model_name | model_name | CHARACTER VARYING | |
| code | code | TEXT | |
| crud_model_id | crud_model_id | INTEGER | |
| link_field_id | link_field_id | INTEGER | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| type | type | CHARACTER VARYING | |
| help | help | TEXT | |
| binding_model_id | binding_model_id | INTEGER | |
| binding_type | binding_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) | |
| url | url | TEXT | |
| target | target | CHARACTER VARYING | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| type | type | CHARACTER VARYING | |
| help | help | TEXT | |
| binding_model_id | binding_model_id | INTEGER | |
| binding_type | binding_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) | |
| view_id | view_id | INTEGER | |
| domain | domain | CHARACTER VARYING | |
| context | context | CHARACTER VARYING | |
| res_id | res_id | INTEGER | |
| res_model | res_model | CHARACTER VARYING | |
| src_model | src_model | CHARACTER VARYING | |
| target | target | CHARACTER VARYING | |
| view_mode | view_mode | CHARACTER VARYING | |
| view_type | view_type | CHARACTER VARYING | |
| usage | usage | CHARACTER VARYING | |
| limit | limit | INTEGER | |
| search_view_id | search_view_id | INTEGER | |
| filter | filter | BOOLEAN | |
| auto_search | auto_search | BOOLEAN | |
| multi | multi | BOOLEAN | |
| act_id | act_id | INTEGER | |
| gid | gid | INTEGER | |
| id | id | true | INTEGER |
| sequence | sequence | INTEGER | |
| view_id | view_id | INTEGER | |
| view_mode | view_mode | CHARACTER VARYING | |
| act_window_id | act_window_id | INTEGER | |
| multi | multi | BOOLEAN | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| type | type | CHARACTER VARYING | |
| help | help | TEXT | |
| binding_model_id | binding_model_id | INTEGER | |
| binding_type | binding_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) | |
| id | id | true | INTEGER |
| action_id | action_id | INTEGER | |
| sequence | sequence | INTEGER | |
| state | state | CHARACTER VARYING | |
| name | name | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| datas_fname | datas_fname | CHARACTER VARYING | |
| description | description | TEXT | |
| res_name | res_name | CHARACTER VARYING | |
| res_model | res_model | CHARACTER VARYING | |
| res_model_name | res_model_name | CHARACTER VARYING | |
| res_field | res_field | CHARACTER VARYING | |
| res_id | res_id | INTEGER | |
| company_id | company_id | INTEGER | |
| type | type | CHARACTER VARYING | |
| url | url | CHARACTER VARYING(1024) | |
| public | public | BOOLEAN | |
| access_token | access_token | CHARACTER VARYING | |
| db_datas | db_datas | BYTEA | |
| store_fname | store_fname | CHARACTER VARYING | |
| file_size | file_size | INTEGER | |
| checksum | checksum | CHARACTER VARYING(40) | |
| mimetype | mimetype | CHARACTER VARYING | |
| index_content | index_content | TEXT | |
| 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) | |
| id | id | true | INTEGER |
| key | key | CHARACTER VARYING | |
| value | value | TEXT | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| ir_actions_server_id | ir_actions_server_id | INTEGER | |
| cron_name | cron_name | CHARACTER VARYING | |
| user_id | user_id | INTEGER | |
| active | active | BOOLEAN | |
| interval_number | interval_number | INTEGER | |
| interval_type | interval_type | CHARACTER VARYING | |
| numbercall | numbercall | INTEGER | |
| doall | doall | BOOLEAN | |
| nextcall | nextcall | TIMESTAMP(6) | |
| priority | priority | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| field_id | field_id | INTEGER | |
| user_id | user_id | INTEGER | |
| company_id | company_id | INTEGER | |
| condition | condition | CHARACTER VARYING | |
| json_value | json_value | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| module_id | module_id | INTEGER | |
| error | error | CHARACTER VARYING | |
| wizard_id | wizard_id | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| resource | resource | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| export_id | export_id | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| user_id | user_id | INTEGER | |
| domain | domain | TEXT | |
| context | context | TEXT | |
| sort | sort | TEXT | |
| model_id | model_id | CHARACTER VARYING | |
| is_default | is_default | BOOLEAN | |
| action_id | action_id | INTEGER | |
| 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) | |
| id | id | true | INTEGER |
| create_date | create_date | TIMESTAMP(6) | |
| create_uid | create_uid | INTEGER | |
| name | name | CHARACTER VARYING | |
| type | type | CHARACTER VARYING | |
| dbname | dbname | CHARACTER VARYING | |
| level | level | CHARACTER VARYING | |
| message | message | TEXT | |
| path | path | CHARACTER VARYING | |
| func | func | CHARACTER VARYING | |
| line | line | CHARACTER VARYING | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| smtp_host | smtp_host | CHARACTER VARYING | |
| smtp_port | smtp_port | INTEGER | |
| smtp_user | smtp_user | CHARACTER VARYING | |
| smtp_pass | smtp_pass | CHARACTER VARYING | |
| smtp_encryption | smtp_encryption | CHARACTER VARYING | |
| smtp_debug | smtp_debug | BOOLEAN | |
| sequence | sequence | INTEGER | |
| 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) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| model | model | CHARACTER VARYING | |
| info | info | TEXT | |
| state | state | CHARACTER VARYING | |
| transient | transient | BOOLEAN | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| active | active | BOOLEAN | |
| model_id | model_id | INTEGER | |
| group_id | group_id | INTEGER | |
| perm_read | perm_read | BOOLEAN | |
| perm_write | perm_write | BOOLEAN | |
| perm_create | perm_create | BOOLEAN | |
| perm_unlink | perm_unlink | BOOLEAN | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| definition | definition | CHARACTER VARYING | |
| model | model | INTEGER | |
| module | module | INTEGER | |
| type | type | CHARACTER VARYING(1) | |
| date_update | date_update | TIMESTAMP(6) | |
| date_init | date_init | TIMESTAMP(6) | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_date | write_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| noupdate | noupdate | BOOLEAN | |
| name | name | CHARACTER VARYING | |
| date_init | date_init | TIMESTAMP(6) | |
| date_update | date_update | TIMESTAMP(6) | |
| module | module | CHARACTER VARYING | |
| model | model | CHARACTER VARYING | |
| res_id | res_id | INTEGER | |
| 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) | |
| field_id | field_id | INTEGER | |
| group_id | group_id | INTEGER | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| model | model | INTEGER | |
| module | module | INTEGER | |
| date_update | date_update | TIMESTAMP(6) | |
| date_init | date_init | TIMESTAMP(6) | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_date | write_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| parent_id | parent_id | INTEGER | |
| name | name | CHARACTER VARYING | |
| description | description | TEXT | |
| sequence | sequence | INTEGER | |
| visible | visible | BOOLEAN | |
| exclusive | exclusive | BOOLEAN | |
| id | id | true | INTEGER |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_date | write_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| website | website | CHARACTER VARYING | |
| summary | summary | CHARACTER VARYING | |
| name | name | CHARACTER VARYING | |
| author | author | CHARACTER VARYING | |
| icon | icon | CHARACTER VARYING | |
| state | state | CHARACTER VARYING(16) | |
| latest_version | latest_version | CHARACTER VARYING | |
| shortdesc | shortdesc | CHARACTER VARYING | |
| category_id | category_id | INTEGER | |
| description | description | TEXT | |
| application | application | BOOLEAN | |
| demo | demo | BOOLEAN | |
| web | web | BOOLEAN | |
| license | license | CHARACTER VARYING(32) | |
| sequence | sequence | INTEGER | |
| auto_install | auto_install | BOOLEAN | |
| to_buy | to_buy | BOOLEAN | |
| maintainer | maintainer | CHARACTER VARYING | |
| contributors | contributors | TEXT | |
| published_version | published_version | CHARACTER VARYING | |
| url | url | CHARACTER VARYING | |
| menus_by_module | menus_by_module | TEXT | |
| reports_by_module | reports_by_module | TEXT | |
| views_by_module | views_by_module | TEXT | |
| id | id | true | INTEGER |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_date | write_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| name | name | CHARACTER VARYING | |
| module_id | module_id | INTEGER | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| module_id | module_id | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| 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) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| active | active | BOOLEAN | |
| model_id | model_id | INTEGER | |
| domain_force | domain_force | TEXT | |
| perm_read | perm_read | BOOLEAN | |
| perm_write | perm_write | BOOLEAN | |
| perm_create | perm_create | BOOLEAN | |
| perm_unlink | perm_unlink | BOOLEAN | |
| global | global | BOOLEAN | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| code | code | CHARACTER VARYING | |
| implementation | implementation | CHARACTER VARYING | |
| active | active | BOOLEAN | |
| prefix | prefix | CHARACTER VARYING | |
| suffix | suffix | CHARACTER VARYING | |
| number_next | number_next | INTEGER | |
| number_increment | number_increment | INTEGER | |
| padding | padding | INTEGER | |
| company_id | company_id | INTEGER | |
| use_date_range | use_date_range | BOOLEAN | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| date_from | date_from | DATE | |
| date_to | date_to | DATE | |
| sequence_id | sequence_id | INTEGER | |
| number_next | number_next | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| server_id | server_id | INTEGER | |
| col1 | col1 | INTEGER | |
| value | value | TEXT | |
| 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) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| res_id | res_id | INTEGER | |
| lang | lang | CHARACTER VARYING | |
| type | type | CHARACTER VARYING | |
| src | src | TEXT | |
| value | value | TEXT | |
| module | module | CHARACTER VARYING | |
| state | state | CHARACTER VARYING | |
| comments | comments | TEXT | |
| id | id | true | INTEGER |
| parent_path | parent_path | CHARACTER VARYING | |
| name | name | CHARACTER VARYING | |
| active | active | BOOLEAN | |
| sequence | sequence | INTEGER | |
| parent_id | parent_id | INTEGER | |
| web_icon | web_icon | CHARACTER VARYING | |
| action | action | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| menu_id | menu_id | INTEGER | |
| gid | gid | INTEGER | |
| 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) | |
| id | id | true | INTEGER |
| ref_id | ref_id | INTEGER | |
| user_id | user_id | INTEGER | |
| arch | arch | TEXT | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| view_id | view_id | INTEGER | |
| group_id | group_id | INTEGER | |
| wiz_id | wiz_id | INTEGER | |
| module_id | module_id | INTEGER | |
| server_id | server_id | INTEGER | |
| action_id | action_id | INTEGER | |
| id | id | true | INTEGER |
| view_id | view_id | INTEGER | |
| image | image | CHARACTER VARYING | |
| CHARACTER VARYING | |||
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| default | default | BOOLEAN | |
| format | format | CHARACTER VARYING | |
| margin_top | margin_top | DOUBLE PRECISION | |
| margin_bottom | margin_bottom | DOUBLE PRECISION | |
| margin_left | margin_left | DOUBLE PRECISION | |
| margin_right | margin_right | DOUBLE PRECISION | |
| page_height | page_height | INTEGER | |
| page_width | page_width | INTEGER | |
| orientation | orientation | CHARACTER VARYING | |
| header_line | header_line | BOOLEAN | |
| header_spacing | header_spacing | INTEGER | |
| dpi | dpi | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| street | street | CHARACTER VARYING | |
| street2 | street2 | CHARACTER VARYING | |
| zip | zip | CHARACTER VARYING | |
| city | city | CHARACTER VARYING | |
| state | state | INTEGER | |
| country | country | INTEGER | |
| CHARACTER VARYING | |||
| phone | phone | CHARACTER VARYING | |
| active | active | BOOLEAN | |
| bic | bic | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| partner_id | partner_id | INTEGER | |
| currency_id | currency_id | INTEGER | |
| sequence | sequence | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| parent_id | parent_id | INTEGER | |
| report_header | report_header | TEXT | |
| report_footer | report_footer | TEXT | |
| logo_web | logo_web | BYTEA | |
| account_no | account_no | CHARACTER VARYING | |
| CHARACTER VARYING | |||
| phone | phone | CHARACTER VARYING | |
| company_registry | company_registry | CHARACTER VARYING | |
| paperformat_id | paperformat_id | INTEGER | |
| external_report_layout_id | external_report_layout_id | INTEGER | |
| base_onboarding_company_state | base_onboarding_company_state | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| cid | cid | INTEGER | |
| user_id | user_id | INTEGER | |
| id | id | true | INTEGER |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| code | code | CHARACTER VARYING(2) | |
| address_format | address_format | TEXT | |
| address_view_id | address_view_id | INTEGER | |
| currency_id | currency_id | INTEGER | |
| phone_code | phone_code | INTEGER | |
| name_position | name_position | CHARACTER VARYING | |
| vat_label | vat_label | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| res_country_id | res_country_id | INTEGER | |
| res_country_group_id | res_country_group_id | INTEGER | |
| id | id | true | INTEGER |
| country_id | country_id | INTEGER | |
| name | name | CHARACTER VARYING | |
| code | code | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| symbol | symbol | CHARACTER VARYING | |
| rounding | rounding | NUMERIC | |
| decimal_places | decimal_places | INTEGER | |
| active | active | BOOLEAN | |
| position | position | CHARACTER VARYING | |
| currency_unit_label | currency_unit_label | CHARACTER VARYING | |
| currency_subunit_label | currency_subunit_label | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | DATE | |
| rate | rate | NUMERIC | |
| currency_id | currency_id | INTEGER | |
| company_id | company_id | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| comment | comment | TEXT | |
| category_id | category_id | INTEGER | |
| color | color | INTEGER | |
| share | share | BOOLEAN | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| gid | gid | INTEGER | |
| hid | hid | INTEGER | |
| uid | uid | INTEGER | |
| gid | gid | INTEGER | |
| gid | gid | INTEGER | |
| uid | uid | INTEGER | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| code | code | CHARACTER VARYING | |
| iso_code | iso_code | CHARACTER VARYING | |
| translatable | translatable | BOOLEAN | |
| active | active | BOOLEAN | |
| direction | direction | CHARACTER VARYING | |
| date_format | date_format | CHARACTER VARYING | |
| time_format | time_format | CHARACTER VARYING | |
| week_start | week_start | INTEGER | |
| grouping | grouping | CHARACTER VARYING | |
| decimal_point | decimal_point | CHARACTER VARYING | |
| thousands_sep | thousands_sep | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| write_uid | write_uid | INTEGER | |
| name | name | CHARACTER VARYING | |
| company_id | company_id | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| display_name | display_name | CHARACTER VARYING | |
| date | date | DATE | |
| title | title | INTEGER | |
| parent_id | parent_id | INTEGER | |
| ref | ref | CHARACTER VARYING | |
| lang | lang | CHARACTER VARYING | |
| tz | tz | CHARACTER VARYING | |
| user_id | user_id | INTEGER | |
| vat | vat | CHARACTER VARYING | |
| website | website | CHARACTER VARYING | |
| comment | comment | TEXT | |
| credit_limit | credit_limit | DOUBLE PRECISION | |
| barcode | barcode | CHARACTER VARYING | |
| active | active | BOOLEAN | |
| customer | customer | BOOLEAN | |
| supplier | supplier | BOOLEAN | |
| employee | employee | BOOLEAN | |
| function | function | CHARACTER VARYING | |
| type | type | CHARACTER VARYING | |
| street | street | CHARACTER VARYING | |
| street2 | street2 | CHARACTER VARYING | |
| zip | zip | CHARACTER VARYING | |
| city | city | CHARACTER VARYING | |
| state_id | state_id | INTEGER | |
| country_id | country_id | INTEGER | |
| CHARACTER VARYING | |||
| phone | phone | CHARACTER VARYING | |
| mobile | mobile | CHARACTER VARYING | |
| is_company | is_company | BOOLEAN | |
| industry_id | industry_id | INTEGER | |
| color | color | INTEGER | |
| partner_share | partner_share | BOOLEAN | |
| commercial_partner_id | commercial_partner_id | INTEGER | |
| commercial_company_name | commercial_company_name | CHARACTER VARYING | |
| company_name | company_name | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| acc_number | acc_number | CHARACTER VARYING | |
| sanitized_acc_number | sanitized_acc_number | CHARACTER VARYING | |
| acc_holder_name | acc_holder_name | CHARACTER VARYING | |
| partner_id | partner_id | INTEGER | |
| bank_id | bank_id | INTEGER | |
| sequence | sequence | INTEGER | |
| currency_id | currency_id | INTEGER | |
| company_id | company_id | INTEGER | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| parent_path | parent_path | CHARACTER VARYING | |
| name | name | CHARACTER VARYING | |
| color | color | INTEGER | |
| parent_id | parent_id | INTEGER | |
| 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) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| full_name | full_name | 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) | |
| category_id | category_id | INTEGER | |
| partner_id | partner_id | INTEGER | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| shortcut | shortcut | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| active | active | BOOLEAN | |
| login | login | CHARACTER VARYING | |
| password | password | CHARACTER VARYING | |
| company_id | company_id | INTEGER | |
| partner_id | partner_id | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| signature | signature | TEXT | |
| action_id | action_id | INTEGER | |
| share | share | BOOLEAN | |
| create_uid | create_uid | INTEGER | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| rule_group_id | rule_group_id | INTEGER | |
| group_id | group_id | INTEGER | |
| id | id | true | INTEGER |
| char | char | CHARACTER VARYING | |
| integer | integer | INTEGER | |
| float | float | DOUBLE PRECISION | |
| numeric | numeric | NUMERIC | |
| many2one | many2one | INTEGER | |
| binary | binary | BYTEA | |
| date | date | DATE | |
| datetime | datetime | TIMESTAMP(6) | |
| selection | selection | INTEGER | |
| selection_str | selection_str | CHARACTER VARYING | |
| html | html | TEXT | |
| text | text | TEXT | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) | |
| id | id | true | INTEGER |
| name | name | CHARACTER VARYING | |
| user_id | user_id | INTEGER | |
| id | id | true | INTEGER |
| menu_id | menu_id | INTEGER | |
| name | name | CHARACTER VARYING | |
| create_uid | create_uid | INTEGER | |
| create_date | create_date | TIMESTAMP(6) | |
| write_uid | write_uid | INTEGER | |
| write_date | write_date | TIMESTAMP(6) |
Project
Odoo Data Model