POLICY

Each row of this table indicates that the TradingPositions in a TradingPositionContainer are available to customers of Stores. There the Contract is deployed, subject to any terms and conditions associated with the Contract.

Column Descriptions:

Name	Type	Description
POLICY_ID	BIGINT NOT NULL	The policy ID.
POLICYNAME	VARCHAR (128) NOT NULL	The unique policy name. It is expected that a store contains the following bootstrap policies: MasterCatalog (one per StoreEntity) CreditLine (one per StoreEntity)
POLICYTYPE_ID	CHAR (64) NOT NULL	The policy type ID. Foreign key to the POLICYTYPE table.
STOREENT_ID	INTEGER NOT NULL	The Store or StoreGroup ID.
PROPERTIES	VARCHAR (254)	Default name value pairs that can be set to the business policy command. For example: n1=v1&n2=v2.
STARTTIME	TIMESTAMP	Start date of the policy. If null, the policy starts immediately.
ENDTIME	TIMESTAMP	End date of the policy. If null, no end time.
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>	POLICY_ID	Primary Key
I0000189	POLICYNAME+POLICYTYPE_ID+STOREENT_ID	Unique Index
I0000337	POLICYTYPE_ID+STOREENT_ID	Non-Unique Index
I0000697	STOREENT_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_608	STOREENT_ID	STOREENT	STOREENT_ID	Cascade
F_609	POLICYTYPE_ID	POLICYTYPE	POLICYTYPE_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_1147	POLICY_ID	SHIPINFO	POLICY_ID	Cascade
F_536	POLICY_ID	ORDPAYMTHD	POLICY_ID	Cascade
F_584	POLICY_ID	PAYSUMMARY	POLICY_ID	Cascade
F_610	POLICY_ID	POLICYCMD	POLICY_ID	Cascade
F_612	POLICY_ID	POLICYDESC	POLICY_ID	Cascade
F_613	POLICY_ID	POLICYTC	POLICY_ID	Cascade
F_669	POLICY_ID	REFUNDMTHD	POLICY_ID	Cascade
F_695	POLICY_ID	RMA	POLICY_ID	Cascade