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. |
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 |
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 |
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 |