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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I_STDPRICE | PRICE, CATENTRY_ID, CURRENCY | Non-Unique Index |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|