res_country_state

1748 rows


Description

Country state

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('res_country_state_id_seq'::regclass)
account_fiscal_position_res_country_state_rel.res_country_state_id account_fiscal_position_res_country_s_res_country_state_id_fkey C
payment_transaction.partner_state_id payment_transaction_partner_state_id_fkey N
res_bank.state res_bank_state_fkey N
res_partner.state_id res_partner_state_id_fkey R
snailmail_letter.state_id snailmail_letter_state_id_fkey N
snailmail_letter_missing_required_fields.state_id snailmail_letter_missing_required_fields_state_id_fkey N
country_id int4 10 null
res_country.id res_country_state_country_id_fkey R

Country
create_uid int4 10 √ null
res_users.id res_country_state_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

State Name
code varchar 2147483647 null

State Code
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_state_pkey Primary key Asc id
res_country_state_name_code_uniq Must be unique Asc/Asc country_id + code

Relationships

Close relationships within degrees of separation