Tables : res_partner


Columns

42

Keys

1

Triggers

0

Comment:

Description:

Indexes

7

Contraints

1


Columns :

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

Keys :

Name Primary Key Description
res_partner_pkey true

Indexes

Name UNIQUE Type Description
res_partner_commercial_partner_id_index Ascending
res_partner_company_id_index Ascending
res_partner_ref_index Ascending
res_partner_parent_id_index Ascending
res_partner_date_index Ascending
res_partner_display_name_index Ascending
res_partner_name_index Ascending

Constraints

Name Expression Description
res_partner_check_name

(((((type)::text = 'contact'::text) AND (name IS NOT NULL)) OR ((type)::text <> 'contact'::text)))

Columns Detail :

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

Name write_uid
Table res_partner
Type INTEGER
Domain
Foreign key true

Name name
Table res_partner
Type CHARACTER VARYING
Domain

Name company_id
Table res_partner
Type INTEGER
Domain
Foreign key true

Name create_date
Table res_partner
Type TIMESTAMP(6)
Domain

Name display_name
Table res_partner
Type CHARACTER VARYING
Domain

Name date
Table res_partner
Type DATE
Domain

Name title
Table res_partner
Type INTEGER
Domain
Foreign key true

Name parent_id
Table res_partner
Type INTEGER
Domain
Foreign key true

Name ref
Table res_partner
Type CHARACTER VARYING
Domain

Name lang
Table res_partner
Type CHARACTER VARYING
Domain

Name tz
Table res_partner
Type CHARACTER VARYING
Domain

Name user_id
Table res_partner
Type INTEGER
Domain
Foreign key true

Name vat
Table res_partner
Type CHARACTER VARYING
Domain

Name website
Table res_partner
Type CHARACTER VARYING
Domain

Name comment
Table res_partner
Type TEXT
Domain

Name credit_limit
Table res_partner
Type DOUBLE PRECISION
Domain

Name barcode
Table res_partner
Type CHARACTER VARYING
Domain

Name active
Table res_partner
Type BOOLEAN
Domain

Name customer
Table res_partner
Type BOOLEAN
Domain

Name supplier
Table res_partner
Type BOOLEAN
Domain

Name employee
Table res_partner
Type BOOLEAN
Domain

Name function
Table res_partner
Type CHARACTER VARYING
Domain

Name type
Table res_partner
Type CHARACTER VARYING
Domain

Name street
Table res_partner
Type CHARACTER VARYING
Domain

Name street2
Table res_partner
Type CHARACTER VARYING
Domain

Name zip
Table res_partner
Type CHARACTER VARYING
Domain

Name city
Table res_partner
Type CHARACTER VARYING
Domain

Name state_id
Table res_partner
Type INTEGER
Domain
Foreign key true

Name country_id
Table res_partner
Type INTEGER
Domain
Foreign key true

Name email
Table res_partner
Type CHARACTER VARYING
Domain

Name phone
Table res_partner
Type CHARACTER VARYING
Domain

Name mobile
Table res_partner
Type CHARACTER VARYING
Domain

Name is_company
Table res_partner
Type BOOLEAN
Domain

Name industry_id
Table res_partner
Type INTEGER
Domain
Foreign key true

Name color
Table res_partner
Type INTEGER
Domain

Name partner_share
Table res_partner
Type BOOLEAN
Domain

Name commercial_partner_id
Table res_partner
Type INTEGER
Domain
Foreign key true

Name commercial_company_name
Table res_partner
Type CHARACTER VARYING
Domain

Name company_name
Table res_partner
Type CHARACTER VARYING
Domain

Name create_uid
Table res_partner
Type INTEGER
Domain
Foreign key true

Name write_date
Table res_partner
Type TIMESTAMP(6)
Domain

Project

Odoo Data Model

Company

Author

Version

Copyright

Comment

Description