Tables : res_partner_bank


Columns

13

Keys

2

Triggers

0

Comment:

Description:

Indexes

1

Contraints

0


Columns :

Name Caption Primary Key type
id id true INTEGER
acc_number acc_number CHARACTER VARYING
sanitized_acc_number sanitized_acc_number CHARACTER VARYING
acc_holder_name acc_holder_name CHARACTER VARYING
partner_id partner_id INTEGER
bank_id bank_id INTEGER
sequence sequence INTEGER
currency_id currency_id INTEGER
company_id company_id INTEGER
create_uid create_uid INTEGER
create_date create_date TIMESTAMP(6)
write_uid write_uid INTEGER
write_date write_date TIMESTAMP(6)

Keys :

Name Primary Key Description
res_partner_bank_pkey true
res_partner_bank_unique_number

Indexes

Name UNIQUE Type Description
res_partner_bank_partner_id_index Ascending

Columns Detail :

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

Name acc_number
Table res_partner_bank
Type CHARACTER VARYING
Domain
Not null true

Name sanitized_acc_number
Table res_partner_bank
Type CHARACTER VARYING
Domain
Unique true

Name acc_holder_name
Table res_partner_bank
Type CHARACTER VARYING
Domain

Name partner_id
Table res_partner_bank
Type INTEGER
Domain
Not null true
Foreign key true

Name bank_id
Table res_partner_bank
Type INTEGER
Domain
Foreign key true

Name sequence
Table res_partner_bank
Type INTEGER
Domain

Name currency_id
Table res_partner_bank
Type INTEGER
Domain
Foreign key true

Name company_id
Table res_partner_bank
Type INTEGER
Domain
Foreign key true
Unique true

Name create_uid
Table res_partner_bank
Type INTEGER
Domain
Foreign key true

Name create_date
Table res_partner_bank
Type TIMESTAMP(6)
Domain

Name write_uid
Table res_partner_bank
Type INTEGER
Domain
Foreign key true

Name write_date
Table res_partner_bank
Type TIMESTAMP(6)
Domain

Project

Odoo Data Model

Company

Author

Version

Copyright

Comment

Description