res_currency_rate

163 rows


Description

Currency Rate

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('res_currency_rate_id_seq'::regclass)
currency_id int4 10 null
res_currency.id res_currency_rate_currency_id_fkey C

Currency
company_id int4 10 √ null
res_company.id res_currency_rate_company_id_fkey N

Company
create_uid int4 10 √ null
res_users.id res_currency_rate_create_uid_fkey N

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

Last Updated by
name date 13 null

Date
rate numeric 0 √ null

Technical Rate
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_currency_rate_pkey Primary key Asc id
res_currency_rate__name_index Performance Asc name
res_currency_rate_unique_name_per_day Must be unique Asc/Asc/Asc name + currency_id + company_id

Check Constraints

Constraint Name Constraint
res_currency_rate_currency_rate_check ((rate > (0)::numeric))

Relationships

Close relationships within degrees of separation