Database Table: POLICY

Each row in this table represents a business policy.

Column Name Column Type Column Description
ENDTIME TIMESTAMP
NULL
End date of the policy. If null, no end time.
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 CHARACTER (64)
NOT NULL
The policy type ID. Foreign key to the POLICYTYPE table.
POLICY_ID BIGINT
NOT NULL
The policy ID.
PROPERTIES VARCHAR (254)
NULL
Default name value pairs that can be set to the business policy command. For example: n1=v1&n2=v2.
STARTTIME TIMESTAMP
NULL
Start date of the policy. If null, the policy starts immediately.
STOREENT_ID INTEGER
NOT NULL
The Store or StoreGroup ID.
Indexes:
Index Name Indexed Column Names Index Type
I0000189 POLICYNAME, POLICYTYPE_ID, STOREENT_ID Unique Index
I0000337 POLICYTYPE_ID, STOREENT_ID Non-Unique Index
SQL030416035036540 POLICY_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_608 STOREENT_ID STOREENT STOREENT_ID Cascade
F_609 POLICYTYPE_ID POLICYTYPE POLICYTYPE_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
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