Tables : res_bank


Columns

16

Keys

1

Triggers

0

Comment:

Description:

Indexes

1

Contraints

0


Columns :

Name Caption Primary Key type
id id true INTEGER
name name CHARACTER VARYING
street street CHARACTER VARYING
street2 street2 CHARACTER VARYING
zip zip CHARACTER VARYING
city city CHARACTER VARYING
state state INTEGER
country country INTEGER
email email CHARACTER VARYING
phone phone CHARACTER VARYING
active active BOOLEAN
bic bic CHARACTER VARYING
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_bank_pkey true

Indexes

Name UNIQUE Type Description
res_bank_bic_index Ascending

Columns Detail :

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

Name name
Table res_bank
Type CHARACTER VARYING
Domain
Not null true

Name street
Table res_bank
Type CHARACTER VARYING
Domain

Name street2
Table res_bank
Type CHARACTER VARYING
Domain

Name zip
Table res_bank
Type CHARACTER VARYING
Domain

Name city
Table res_bank
Type CHARACTER VARYING
Domain

Name state
Table res_bank
Type INTEGER
Domain
Foreign key true

Name country
Table res_bank
Type INTEGER
Domain
Foreign key true

Name email
Table res_bank
Type CHARACTER VARYING
Domain

Name phone
Table res_bank
Type CHARACTER VARYING
Domain

Name active
Table res_bank
Type BOOLEAN
Domain

Name bic
Table res_bank
Type CHARACTER VARYING
Domain

Name create_uid
Table res_bank
Type INTEGER
Domain
Foreign key true

Name create_date
Table res_bank
Type TIMESTAMP(6)
Domain

Name write_uid
Table res_bank
Type INTEGER
Domain
Foreign key true

Name write_date
Table res_bank
Type TIMESTAMP(6)
Domain

Project

Odoo Data Model

Company

Author

Version

Copyright

Comment

Description