# | 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 |
---|