| # | Column Name | Nullable | Data Type | Max Length | Description |
|---|---|---|---|---|---|
| 1 | exchange_rate_id | bigint | 0 | The primary key of this table, which is also a serial field. | |
| 2 | updated_on | timestamp with time zone | 0 | Date & time of the last update of exchange rate. | |
| 3 | office_id | integer | 0 | Foreign key to the table office.offices. | |
| 4 | status | boolean | 0 |
| # | Column Name | Key Name | References |
|---|---|---|---|
| 3 | office_id | exchange_rates_office_id_fkey | office.offices.office_id |
| Index Name | Owner | Access Method | Definition | Description |
|---|---|---|---|---|
| exchange_rates_pkey | postgres | btree | exchange_rate_id |
| Constraint Name | Description |
|---|
| # | Column Name | Default |
|---|---|---|
| 1 | exchange_rate_id | nextval('core.exchange_rates_exchange_rate_id_seq'::regclass) |
| 2 | updated_on | now() |
| 4 | status | true |
| Trigger Name | Targets | On Event | Timing | Condition | Order | Orientation | Description |
|---|