res_partner

42 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('res_partner_id_seq'::regclass)
account_analytic_account.partner_id account_analytic_account_partner_id_fkey N
account_analytic_distribution_model.partner_id account_analytic_distribution_model_partner_id_fkey C
account_analytic_line.partner_id account_analytic_line_partner_id_fkey N
account_bank_statement_line.partner_id account_bank_statement_line_partner_id_fkey R
account_move.commercial_partner_id account_move_commercial_partner_id_fkey R
account_move.partner_id account_move_partner_id_fkey R
account_move.partner_shipping_id account_move_partner_shipping_id_fkey N
account_move_line.partner_id account_move_line_partner_id_fkey R
account_move_send_res_partner_rel.res_partner_id account_move_send_res_partner_rel_res_partner_id_fkey C
account_payment.partner_id account_payment_partner_id_fkey R
account_payment_register.partner_id account_payment_register_partner_id_fkey R
account_reconcile_model_partner_mapping.partner_id account_reconcile_model_partner_mapping_partner_id_fkey C
account_reconcile_model_res_partner_rel.res_partner_id account_reconcile_model_res_partner_rel_res_partner_id_fkey C
base_partner_merge_automatic_wizard.dst_partner_id base_partner_merge_automatic_wizard_dst_partner_id_fkey N
base_partner_merge_automatic_wizard_res_partner_rel.res_partner_id base_partner_merge_automatic_wizard_res_par_res_partner_id_fkey C
discuss_channel_member.partner_id discuss_channel_member_partner_id_fkey C
ir_act_server_res_partner_rel.res_partner_id ir_act_server_res_partner_rel_res_partner_id_fkey C
mail_activity.request_partner_id mail_activity_request_partner_id_fkey N
mail_compose_message.author_id mail_compose_message_author_id_fkey N
mail_compose_message_res_partner_rel.partner_id mail_compose_message_res_partner_rel_partner_id_fkey C
mail_followers.partner_id mail_followers_partner_id_fkey C
mail_mail_res_partner_rel.res_partner_id mail_mail_res_partner_rel_res_partner_id_fkey C
mail_message.author_id mail_message_author_id_fkey N
mail_message_reaction.partner_id mail_message_reaction_partner_id_fkey C
mail_message_res_partner_rel.res_partner_id mail_message_res_partner_rel_res_partner_id_fkey C
mail_message_res_partner_starred_rel.res_partner_id mail_message_res_partner_starred_rel_res_partner_id_fkey C
mail_notification.author_id mail_notification_author_id_fkey N
mail_notification.res_partner_id mail_notification_res_partner_id_fkey C
mail_partner_device.partner_id mail_partner_device_partner_id_fkey R
mail_wizard_invite_res_partner_rel.res_partner_id mail_wizard_invite_res_partner_rel_res_partner_id_fkey C
payment_link_wizard.partner_id payment_link_wizard_partner_id_fkey N
payment_token.partner_id payment_token_partner_id_fkey R
payment_transaction.partner_id payment_transaction_partner_id_fkey R
portal_share_res_partner_rel.res_partner_id portal_share_res_partner_rel_res_partner_id_fkey C
portal_wizard_res_partner_rel.res_partner_id portal_wizard_res_partner_rel_res_partner_id_fkey C
portal_wizard_user.partner_id portal_wizard_user_partner_id_fkey C
procurement_group.partner_id procurement_group_partner_id_fkey N
product_supplierinfo.partner_id product_supplierinfo_partner_id_fkey C
purchase_order.dest_address_id purchase_order_dest_address_id_fkey N
purchase_order.partner_id purchase_order_partner_id_fkey R
purchase_order_line.partner_id purchase_order_line_partner_id_fkey N
res_company.partner_id res_company_partner_id_fkey R
res_partner.commercial_partner_id res_partner_commercial_partner_id_fkey N
res_partner.parent_id res_partner_parent_id_fkey N
res_partner_autocomplete_sync.partner_id res_partner_autocomplete_sync_partner_id_fkey C
res_partner_bank.partner_id res_partner_bank_partner_id_fkey C
res_partner_res_partner_category_rel.partner_id res_partner_res_partner_category_rel_partner_id_fkey C
res_users.partner_id res_users_partner_id_fkey R
res_users_settings_volumes.guest_id res_users_settings_volumes_guest_id_fkey C
res_users_settings_volumes.partner_id res_users_settings_volumes_partner_id_fkey C
sale_order.partner_id sale_order_partner_id_fkey R
sale_order.partner_invoice_id sale_order_partner_invoice_id_fkey R
sale_order.partner_shipping_id sale_order_partner_shipping_id_fkey R
sale_order_cancel.author_id sale_order_cancel_author_id_fkey N
sale_order_line.order_partner_id sale_order_line_order_partner_id_fkey N
sms_sms.partner_id sms_sms_partner_id_fkey N
snailmail_letter.partner_id snailmail_letter_partner_id_fkey R
snailmail_letter_missing_required_fields.partner_id snailmail_letter_missing_required_fields_partner_id_fkey N
stock_move.partner_id stock_move_partner_id_fkey N
stock_move.restrict_partner_id stock_move_restrict_partner_id_fkey N
stock_move_line.owner_id stock_move_line_owner_id_fkey N
stock_picking.owner_id stock_picking_owner_id_fkey N
stock_picking.partner_id stock_picking_partner_id_fkey N
stock_quant.owner_id stock_quant_owner_id_fkey N
stock_rule.partner_address_id stock_rule_partner_address_id_fkey N
stock_scrap.owner_id stock_scrap_owner_id_fkey N
stock_warehouse.partner_id stock_warehouse_partner_id_fkey N
stock_warehouse_orderpoint.vendor_id stock_warehouse_orderpoint_vendor_id_fkey N
company_id int4 10 √ null
res_company.id res_partner_company_id_fkey N
create_date timestamp 29,6 √ null
name varchar 2147483647 √ null
title int4 10 √ null
res_partner_title.id res_partner_title_fkey N

Title
parent_id int4 10 √ null
res_partner.id res_partner_parent_id_fkey N

Related Company
user_id int4 10 √ null
res_users.id res_partner_user_id_fkey N

Salesperson
state_id int4 10 √ null
res_country_state.id res_partner_state_id_fkey R

State
country_id int4 10 √ null
res_country.id res_partner_country_id_fkey R

Country
industry_id int4 10 √ null
res_partner_industry.id res_partner_industry_id_fkey N

Industry
color int4 10 √ null

Color Index
commercial_partner_id int4 10 √ null
res_partner.id res_partner_commercial_partner_id_fkey N

Commercial Entity
create_uid int4 10 √ null
res_users.id res_partner_create_uid_fkey N

Created by
write_uid int4 10 √ null
res_users.id res_partner_write_uid_fkey N

Last Updated by
complete_name varchar 2147483647 √ null

Complete Name
ref varchar 2147483647 √ null

Reference
lang varchar 2147483647 √ null

Language
tz varchar 2147483647 √ null

Timezone
vat varchar 2147483647 √ null

Tax ID
company_registry varchar 2147483647 √ null

Company ID
website varchar 2147483647 √ null

Website Link
function varchar 2147483647 √ null

Job Position
type varchar 2147483647 √ null

Address Type
street varchar 2147483647 √ null

Street
street2 varchar 2147483647 √ null

Street2
zip varchar 2147483647 √ null

Zip
city varchar 2147483647 √ null

City
email varchar 2147483647 √ null

Email
phone varchar 2147483647 √ null

Phone
mobile varchar 2147483647 √ null

Mobile
commercial_company_name varchar 2147483647 √ null

Company Name Entity
company_name varchar 2147483647 √ null

Company Name
date date 13 √ null

Date
comment text 2147483647 √ null

Notes
partner_latitude numeric 0 √ null

Geo Latitude
partner_longitude numeric 0 √ null

Geo Longitude
active bool 1 √ null

Active
employee bool 1 √ null

Employee
is_company bool 1 √ null

Is a Company
partner_share bool 1 √ null

Share Partner
write_date timestamp 29,6 √ null

Last Updated on
message_bounce int4 10 √ null

Bounce
email_normalized varchar 2147483647 √ null

Normalized Email
signup_type varchar 2147483647 √ null

Signup Token Type
signup_expiration timestamp 29,6 √ null

Signup Expiration
signup_token varchar 2147483647 √ null
team_id int4 10 √ null
crm_team.id res_partner_team_id_fkey N

Sales Team
partner_gid int4 10 √ null

Company database ID
additional_info varchar 2147483647 √ null

Additional info
phone_sanitized varchar 2147483647 √ null

Sanitized Number
supplier_rank int4 10 √ null

Supplier Rank
customer_rank int4 10 √ null

Customer Rank
invoice_warn varchar 2147483647 √ null

Invoice
invoice_warn_msg text 2147483647 √ null

Message for Invoice
debit_limit numeric 0 √ null

Payable Limit
last_time_entries_checked timestamp 29,6 √ null

Latest Invoices & Payments Matching Date
picking_warn varchar 2147483647 √ null

Stock Picking
picking_warn_msg text 2147483647 √ null

Message for Stock Picking
ubl_cii_format varchar 2147483647 √ null

Format
peppol_endpoint varchar 2147483647 √ null

Peppol Endpoint
peppol_eas varchar 2147483647 √ null

Peppol e-address (EAS)
buyer_id int4 10 √ null
res_users.id res_partner_buyer_id_fkey N

Buyer
purchase_warn varchar 2147483647 √ null

Purchase Order
purchase_warn_msg text 2147483647 √ null

Message for Purchase Order
sale_warn varchar 2147483647 √ null

Sales Warnings
sale_warn_msg text 2147483647 √ null

Message for Sales Order

Indexes

Constraint Name Type Sort Column(s)
res_partner_pkey Primary key Asc id
res_partner__commercial_partner_id_index Performance Asc commercial_partner_id
res_partner__company_id_index Performance Asc company_id
res_partner__complete_name_index Performance Asc complete_name
res_partner__date_index Performance Asc date
res_partner__name_index Performance Asc name
res_partner__parent_id_index Performance Asc parent_id
res_partner__ref_index Performance Asc ref
res_partner__vat_index Performance Asc vat
res_partner_mobile_partial_tgm Performance
res_partner_phone_partial_tgm Performance

Check Constraints

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

Relationships

Close relationships within degrees of separation