STORETPC

The relationship between store entity and trading position container.

Column Descriptions:

Name	Type	Description
STOREENT_ID	INTEGER NOT NULL	Store entity id.
TRADEPOSCN_ID	BIGINT NOT NULL	Trading position container id.
STTPCUSG_ID	INTEGER NOT NULL	Store TPC usage id.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	STOREENT_ID+TRADEPOSCN_ID+STTPCUSG_ID	Primary Key
I0001357	TRADEPOSCN_ID	Non-Unique Index
I0001388	STTPCUSG_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3642	STOREENT_ID	STOREENT	STOREENT_ID	Cascade
F_3643	TRADEPOSCN_ID	TRADEPOSCN	TRADEPOSCN_ID	Cascade
F_3675	STTPCUSG_ID	STTPCUSG	STTPCUSG_ID	Cascade