Each row of this table represents a price rule in a
store. Price rule is a business rule which defines how to get a
dynamic price under different business conditions.
Column Descriptions:
Name | Type | Description |
PRICERULE_ID | BIGINT NOT NULL | Generated Key |
STOREENT_ID | INTEGER NOT NULL | The unique identifier of the store in which the
price rule was created. |
IDENTIFIER | VARCHAR (64) NOT NULL | The identifier of the price rule. |
DESCRIPTION | VARCHAR (254) | A description of the price rule, suitable for
display to business users. |
VERSION | DOUBLE | Reserved for HCL internal use. |
STATE | SMALLINT NOT NULL DEFAULT 0 | Reserved for HCL internal use. |
CREATETIME | TIMESTAMP | Created time. |
LASTUPDATETIME | TIMESTAMP | Last updated time. |
DEPENDENT | SMALLINT NOT NULL DEFAULT 0 | Indicate if the price rule is independent or not.
Valid values include: 0 = Independent, 1 = Dependent. The default
value is 0. |
TYPE | SMALLINT NOT NULL DEFAULT 0 | The type of the price rule. Valid values include:
0 = internal, 1 = external. The default value is 0. |
STARTTIME | TIMESTAMP | The start time for the price rule. If the start
time is null, then the price rule will take effect immediately.
Currently Reserved for HCL internal use. |
ENDTIME | TIMESTAMP | The end time for the price rule. If the end time
is null, then the price rule will run indefinitely. Currently
Reserved for HCL internal use. |
FIELD1 | VARCHAR (254) | Customizable. |
FIELD2 | VARCHAR (254) | Customizable. |
FIELD3 | VARCHAR (254) | Customizable. |
MARKFORDELETE | INTEGER NOT NULL DEFAULT 0 | Indicates if this is marked for deletion: 0 = No.
1 = Yes. |
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> | PRICERULE_ID | Primary Key |
I0001340 | IDENTIFIER+STOREENT_ID | Unique Index |
I0001341 | STOREENT_ID | Non-Unique Index |
I0001342 | TYPE | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_3630 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
Referenced By Child Tables:
Constraint | Columns | Child Table | Child Columns | Type |
F_3633 | PRICERULE_ID | PRELEMENT | PRICERULE_ID | Cascade |