Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
currency_id | NUMBER | 39 | 0 |
currency_id |
Currencies |
||
item_id | NUMBER | 39 | 0 |
item_id |
Items |
||
item_quantity_id | NUMBER | 39 | 0 | ||||
min_count | NUMBER | 15 | 5 | ||||
price_type_id | NUMBER | 39 | 0 |
price_type_id |
Price_types |
||
unit_price | NUMBER | 30 | 15 | ||||
version_0 | NUMBER | 39 | 0 |
FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
---|---|---|---|---|
item_price_history_currencies_fk | currency_id | Currencies | currency_id | 1 |
item_price_history_items_fk | item_id | Items | item_id | 1 |
item_price_history_price_types_fk | price_type_id | Price_types | price_type_id | 1 |