res_bank

-1 rows


Description

Bank

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('res_bank_id_seq'::regclass)
res_partner_bank.bank_id res_partner_bank_bank_id_fkey N
state int4 10 √ null
res_country_state.id res_bank_state_fkey N

Fed. State
country int4 10 √ null
res_country.id res_bank_country_fkey N

Country
create_uid int4 10 √ null
res_users.id res_bank_create_uid_fkey N

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

Last Updated by
name varchar 2147483647 null

Name
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
bic varchar 2147483647 √ null

Bank Identifier Code
active bool 1 √ null

Active
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_bank_pkey Primary key Asc id
res_bank__bic_index Performance Asc bic

Relationships

Close relationships within degrees of separation