| # | Column Name | Nullable | Data Type | Max Length | Description |
|---|---|---|---|---|---|
| 1 | exchange_rate_detail_id | bigint | 0 | The primary key of this table, which is also a bigserial field. | |
| 2 | exchange_rate_id | bigint | 0 | Foreign key to the table core.exchange_rates. | |
| 3 | local_currency_code | character varying | 12 | Foreign key to the table core.currencies | |
| 4 | foreign_currency_code | character varying | 12 | Foreign key to the table core.currencies | |
| 5 | unit | integer_strict | 0 | ||
| 6 | exchange_rate | decimal_strict | 0 |
| # | Column Name | Key Name | References |
|---|---|---|---|
| 2 | exchange_rate_id | exchange_rate_details_exchange_rate_id_fkey | core.exchange_rates.exchange_rate_id |
| 3 | local_currency_code | exchange_rate_details_local_currency_code_fkey | core.currencies.currency_code |
| 4 | foreign_currency_code | exchange_rate_details_foreign_currency_code_fkey | core.currencies.currency_code |
| Index Name | Owner | Access Method | Definition | Description |
|---|---|---|---|---|
| exchange_rate_details_pkey | postgres | btree | exchange_rate_detail_id |
| Constraint Name | Description |
|---|
| # | Column Name | Default |
|---|---|---|
| 1 | exchange_rate_detail_id | nextval('core.exchange_rate_details_exchange_rate_detail_id_seq'::regclass) |
| Trigger Name | Targets | On Event | Timing | Condition | Order | Orientation | Description |
|---|