This table contains all of the coupons issued to
individual customers.
Column Descriptions:
| Name | Type | Description |
| PX_COUPON_ID | BIGINT NOT NULL | The primary key of a coupon. This is the coupon
ID. |
| USERS_ID | BIGINT | Foreign key to the USERS table. The identified
customer is the owner of this coupon, if the coupon is issued to a
registered user. |
| STOREENT_ID | INTEGER NOT NULL | Foreign key to the STOREENT table. The store
entity ID, plus the name, plus the version uniquely identify the
promotion for which this coupon is issued. |
| VERSION | INTEGER NOT NULL | The version of the promotion for which this
coupon is issued. |
| EFFECTIVE | TIMESTAMP NOT NULL | The date on which this coupon first becomes
active. |
| EXPIRE | TIMESTAMP NOT NULL | The date when this coupon expires. |
| STATUS | INTEGER NOT NULL DEFAULT 0 | The current status of this coupon:
0: active
1: canceled
2: being used in an order but not finalized yet
3: expired
4: deleted
The default value is 0. |
| ORDERS_ID | BIGINT | Foreign key to the ORDERS table. If this coupon
is being used in an order, or applied to an order and canceled,
this identifies the order. |
| GUESTID | VARCHAR (64) | This is the token by which this guest user will
be recognized next time, if the coupon is issued to a guest
user. |
| NAME | VARCHAR (128) NOT NULL | The name of the promotion for which this coupon
is issued. |
| CODE | VARCHAR (128) | An optional code to identify this coupon. |
| 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> | PX_COUPON_ID | Primary Key |
| I0000389 | STOREENT_ID+NAME+VERSION | Non-Unique Index |
| I0000390 | ORDERS_ID+USERS_ID | Non-Unique Index |
| I0000391 | ORDERS_ID+GUESTID | Non-Unique Index |
| I0000404 | STOREENT_ID | Non-Unique Index |
| I0000405 | USERS_ID | Non-Unique Index |
| I0000406 | ORDERS_ID | Non-Unique Index |
Constrained By Parent Tables:
| Constraint | Columns | Parent Table | Parent Columns | Type |
| F_1052 | USERS_ID | USERS | USERS_ID | Cascade |
| F_1053 | STOREENT_ID | STOREENT | STOREENT_ID | Cascade |
| F_1054 | ORDERS_ID | ORDERS | ORDERS_ID | Cascade |