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