Tables : res_currency_rate
Columns9 |
Keys2 |
Triggers0 |
Comment:Description: |
|
Indexes1 |
Contraints1 |
|||
Columns :
| Name | Caption | Primary Key | type |
|---|---|---|---|
| id | id | true | INTEGER |
| name | name | DATE | |
| rate | rate | NUMERIC | |
| 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_currency_rate_pkey | true | |
| res_currency_rate_unique_name_per_day |
Indexes
| Name | UNIQUE | Type | Description |
|---|---|---|---|
| res_currency_rate_name_index | Ascending |
Constraints
| Name | Expression | Description |
|---|---|---|
| res_currency_rate_currency_rate_check |
((rate > (0)::numeric)) |
Columns Detail :
| Name | id |
| Table | res_currency_rate |
| Type | INTEGER |
| Domain | |
| Primary Key | true |
| Not null | true |
| Default Value | nextval('res_currency_rate_id_seq'::regclass) |
| Name | name |
| Table | res_currency_rate |
| Type | DATE |
| Domain | |
| Not null | true |
| Unique | true |
| Name | rate |
| Table | res_currency_rate |
| Type | NUMERIC |
| Domain |
| Name | currency_id |
| Table | res_currency_rate |
| Type | INTEGER |
| Domain | |
| Foreign key | true |
| Unique | true |
| Name | company_id |
| Table | res_currency_rate |
| Type | INTEGER |
| Domain | |
| Foreign key | true |
| Unique | true |
| Name | create_uid |
| Table | res_currency_rate |
| Type | INTEGER |
| Domain | |
| Foreign key | true |
| Name | create_date |
| Table | res_currency_rate |
| Type | TIMESTAMP(6) |
| Domain |
| Name | write_uid |
| Table | res_currency_rate |
| Type | INTEGER |
| Domain | |
| Foreign key | true |
| Name | write_date |
| Table | res_currency_rate |
| Type | TIMESTAMP(6) |
| Domain |
Project
Odoo Data Model