Item_price_history

Columns

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

Foreign keys in this table

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