Tables : res_company


Columns

20

Keys

2

Triggers

0

Comment:

Description:

Indexes

1

Contraints

0


Columns :

Name Caption Primary Key type
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
email email 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)

Keys :

Name Primary Key Description
res_company_pkey true
res_company_name_uniq

Indexes

Name UNIQUE Type Description
res_company_parent_id_index Ascending

Columns Detail :

Name id
Table res_company
Type INTEGER
Domain
Primary Key true
Not null true
Default Value nextval('res_company_id_seq'::regclass)

Name name
Table res_company
Type CHARACTER VARYING
Domain
Not null true
Unique true

Name partner_id
Table res_company
Type INTEGER
Domain
Not null true
Foreign key true

Name currency_id
Table res_company
Type INTEGER
Domain
Not null true
Foreign key true

Name sequence
Table res_company
Type INTEGER
Domain

Name create_date
Table res_company
Type TIMESTAMP(6)
Domain

Name parent_id
Table res_company
Type INTEGER
Domain
Foreign key true

Name report_header
Table res_company
Type TEXT
Domain

Name
Table res_company
Type TEXT
Domain

Name logo_web
Table res_company
Type BYTEA
Domain

Name account_no
Table res_company
Type CHARACTER VARYING
Domain

Name email
Table res_company
Type CHARACTER VARYING
Domain

Name phone
Table res_company
Type CHARACTER VARYING
Domain

Name company_registry
Table res_company
Type CHARACTER VARYING
Domain

Name paperformat_id
Table res_company
Type INTEGER
Domain
Foreign key true

Name external_report_layout_id
Table res_company
Type INTEGER
Domain
Foreign key true

Name base_onboarding_company_state
Table res_company
Type CHARACTER VARYING
Domain

Name create_uid
Table res_company
Type INTEGER
Domain
Foreign key true

Name write_uid
Table res_company
Type INTEGER
Domain
Foreign key true

Name write_date
Table res_company
Type TIMESTAMP(6)
Domain

Project

Odoo Data Model

Company

Author

Version

Copyright

Comment

Description