Database View: STDPRICE

This summary table defines standard (offer) price for each CatalogEntry. It contains pre-computed results based on the data existing in the underlying OFFER, OFFERPRICE and TRADEPOSCN tables

Column Name Column Type Column Description
C5 INTEGER
NOT NULL
Count of the number of rows. Required by definition of summary tables.
CATENTRY_ID BIGINT
NOT NULL
This CatalogEntry that this standard price describes. It is CATENTRY_ID found in the OFFER table.
CURRENCY CHARACTER (3)
NOT NULL
The currency of Price. It is CURRENCY found in the OFFERPRICE table.
PRICE DECIMAL (20,5)
NOT NULL
The Price that this standard price describes. It is Price found in the OFFERPRICE table.
Indexes:
Index Name Indexed Column Names Index Type
I_STDPRICE PRICE, CATENTRY_ID, CURRENCY Non-Unique Index
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable