| name | value |
|---|---|
| name | currency |
| inheritance hierarchy depth | 0 |
| derived from | |
| is local data by default | False |
| persistence | True |
| is system table | False |
| owner | SYSTEM |
| column | datatype | length | default | nulls | PK | FK | UQ | inherited | hidden | external | persistence | is array | is local | comment |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| code | varchar | no | yes | False | False | True | True | False | False | |||||
| country | varchar | yes | False | False | True | True | False | False | ||||||
| name | varchar | yes | False | False | True | True | False | False | ||||||
| usdollar | float | yes | False | False | False | True | False | False |
| name | description | column | comment |
|---|---|---|---|
| PK-currency | primary key index on currency | code |
| code | country | name | usdollar |
|---|---|---|---|
| GBP | UK | Pound | 0.67 |
| FRF | France | Franc | 7.07 |
| CHF | Switzerland | Franc | 1.67 |
| CAD | Canada | Dollar | 1.49 |
| AUD | Australia | Dollar | 1.72 |
| JPY | Japan | Yen | 109.5 |