AuctionSession
The AuctionSession table is used to define and set up the parameters for the Sessions for an Auction. An AuctionSession corresponds to two SessionTime records, one for the entry to the AuctionSession and for the exit from the AuctionSession.
- Section: CartaX
Metadata
- Base Table Class: Static
- Default Size: Auction * 10 = 1000
Fields
| Name | Type | Size (bytes) | Description |
|---|---|---|---|
| Id | Integer (signed) | 8 | The unique identifier of this AuctionSession. |
| Status | Set of Status | 4 | |
| Auction | Foreign key to Auction | 8 | A foreign key to the Auction table for the Auction to which the Session applies. |
| Phase | One of CcmxAuctionPhase | 1 | The phase number (0 to N) of the Auction that this AuctionSession triggers. |
| ShortName | String | 24 | This will be constructed from the Auction ShortName and Phase. |
| Manual | Integer (unsigned) | 1 | If this AuctionSession fires manually (no SessionTime records), set to true. |
| EntrySession | Foreign key to Session | 8 | A foreign key to the Session table. |
| ExitSession | Foreign key to Session | 8 | A foreign key to the Session table. |
| EntrySessionTime | Foreign key to SessionTime | 8 | A foreign key to the SessionTime table. |
| ExitSessionTime | Foreign key to SessionTime | 8 | A foreign key to the SessionTime table. |
| ExtEntrySessionTime | Foreign key to SessionTime | 8 | A foreign key to the SessionTime table. |
| ExtExitSessionTime | Foreign key to SessionTime | 8 | A foreign key to the SessionTime table. |
| SessionStartTime | Integer (unsigned) | 8 | The start date and time for the Session in TIMESTAMP format. |
| SessionEndTime | Integer (unsigned) | 8 | The end date and time for the Session in TIMESTAMP format. |
| PriceDecimals | Integer (unsigned) | 1 | The PriceDecimals for the Auction, this value will be populated automatically from the Auction. |
| QuantityDecimals | Integer (unsigned) | 1 | The QuantityDecimals for the Auction, this value will be populated automatically from the Auction. |
| ThresholdAbsolute | Integer (signed) | 8 | The Threshold amount from the Provisional Price for the Auction as an absolute value (uses PriceDecimals). |
| ThresholdPercent | Integer (unsigned) | 1 | The Threshold amount from the Provisional Price for the Auction as a percentage value (no decimals). |
| ProvisionalPrice | Integer (signed) | 8 | The Provisional Price of the Auction at the start of the Session. |
| ThresholdPrice | Integer (signed) | 8 | The Threshold Price for the Session. |
| AuctionPrice | Integer (signed) | 8 | The provisional (or final) price of the Auction at the end of the Session (corresponds to field in Auction table). |
| AuctionQuantity | Integer (signed) | 8 | The provisional (or final) quantity of the Auction at the end of the Session (corresponds to field in Auction table). |
| Extension | Integer (unsigned) | 2 | Count for extensions for this record |
| UpdateNumber | Integer (unsigned) | 8 | A number that records every change that happens to a record. It is primarily used to avoid write after read problems when an intermediate write has changed the originally read record. |
| OwnerUser | Foreign key to User | 8 | The Id of the User that owns this AuctionSession. |
| OwnerGroup | Foreign key to Group | 8 | The Id of the Group that owns this AuctionSession. |
| OwnerFirm | Foreign key to Firm | 8 | The Id of the Firm that owns this AuctionSession. |
| CreateUser | Foreign key to User | 8 | The Id of the User that created this AuctionSession. |
| CreateTimestamp | Integer (unsigned) | 8 | The time at which this AuctionSession was created. |
| UpdateUser | Foreign key to User | 8 | The Id of the User that last updated this AuctionSession. |
| UpdateTimestamp | Integer (unsigned) | 8 | The time at which this AuctionSession was last updated. |
Foreign Keys
The following diagram shows the tables that have a foreign key link to the AuctionSession table. All Table nodes can be clicked to take you to that table's definition page.
graph LR; Auction-->|AuctionSession|AuctionSession click Auction "/marketgrid/developer/model/tables/Auction" SessionTime-->|AuctionSession|AuctionSession click SessionTime "/marketgrid/developer/model/tables/SessionTime"