Tables : res_currency


Columns

13

Keys

2

Triggers

0

Comment:

Description:

Indexes

0

Contraints

1


Columns :

Name Caption Primary Key type
id id true INTEGER
name name CHARACTER VARYING
symbol symbol CHARACTER VARYING
rounding rounding NUMERIC
decimal_places decimal_places INTEGER
active active BOOLEAN
position position CHARACTER VARYING
currency_unit_label currency_unit_label CHARACTER VARYING
currency_subunit_label currency_subunit_label 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_currency_pkey true
res_currency_unique_name

Constraints

Name Expression Description
res_currency_rounding_gt_zero

((rounding > (0)::numeric))

Columns Detail :

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

Name name
Table res_currency
Type CHARACTER VARYING
Domain
Not null true
Unique true

Name symbol
Table res_currency
Type CHARACTER VARYING
Domain
Not null true

Name rounding
Table res_currency
Type NUMERIC
Domain

Name decimal_places
Table res_currency
Type INTEGER
Domain

Name active
Table res_currency
Type BOOLEAN
Domain

Name position
Table res_currency
Type CHARACTER VARYING
Domain

Name currency_unit_label
Table res_currency
Type CHARACTER VARYING
Domain

Name currency_subunit_label
Table res_currency
Type CHARACTER VARYING
Domain

Name create_uid
Table res_currency
Type INTEGER
Domain
Foreign key true

Name create_date
Table res_currency
Type TIMESTAMP(6)
Domain

Name write_uid
Table res_currency
Type INTEGER
Domain
Foreign key true

Name write_date
Table res_currency
Type TIMESTAMP(6)
Domain

Project

Odoo Data Model

Company

Author

Version

Copyright

Comment

Description