res_country

250 rows


Description

Country

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('res_country_id_seq'::regclass)
account_account_tag.country_id account_account_tag_country_id_fkey N
account_fiscal_position.country_id account_fiscal_position_country_id_fkey N
account_report.country_id account_report_country_id_fkey N
account_tax.country_id account_tax_country_id_fkey R
account_tax_group.country_id account_tax_group_country_id_fkey N
mail_guest.country_id mail_guest_country_id_fkey N
payment_country_rel.country_id payment_country_rel_country_id_fkey C
payment_method_res_country_rel.res_country_id payment_method_res_country_rel_res_country_id_fkey C
payment_transaction.partner_country_id payment_transaction_partner_country_id_fkey N
res_bank.country res_bank_country_fkey N
res_company.account_fiscal_country_id res_company_account_fiscal_country_id_fkey N
res_country_res_country_group_rel.res_country_id res_country_res_country_group_rel_res_country_id_fkey C
res_country_state.country_id res_country_state_country_id_fkey R
res_partner.country_id res_partner_country_id_fkey R
snailmail_letter.country_id snailmail_letter_country_id_fkey N
snailmail_letter_missing_required_fields.country_id snailmail_letter_missing_required_fields_country_id_fkey N
address_view_id int4 10 √ null
ir_ui_view.id res_country_address_view_id_fkey N

Input View
currency_id int4 10 √ null
res_currency.id res_country_currency_id_fkey N

Currency
phone_code int4 10 √ null

Country Calling Code
create_uid int4 10 √ null
res_users.id res_country_create_uid_fkey N

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

Last Updated by
code varchar 2 null

Country Code
name_position varchar 2147483647 √ null

Customer Name Position
name jsonb 2147483647 null

Country Name
vat_label jsonb 2147483647 √ null

Vat Label
address_format text 2147483647 √ null

Layout in Reports
state_required bool 1 √ null

State Required
zip_required bool 1 √ null

Zip Required
create_date timestamp 29,6 √ null

Created on
write_date timestamp 29,6 √ null

Last Updated on

Indexes

Constraint Name Type Sort Column(s)
res_country_pkey Primary key Asc id
res_country_code_uniq Must be unique Asc code
res_country_name_uniq Must be unique Asc name

Relationships

Close relationships within degrees of separation