CMSRESERVEDITEMS
Primary Key
| Primary Key | Field Type |
|---|---|
| ID | uniqueidentifier |
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| SESSIONID | nvarchar(50) | BBSession ID to identify who the hold is for | ||
| ITEMQTY | int | Default = 0 | Quantity of the item to to hold, such as 3 event tickets | |
| ITEMID | int | Default = 0 | ID of the item on hold, such as EventItemPriceBackOfficeId | |
| EXPIRESAT | datetime | When the hold expires |
Indexes
| Index Name | Fields | Unique | Primary | Clustered |
|---|---|---|---|---|
| PK_CMSTIMEDRESERVATIONS | ID | yes | yes | yes |