Table : biddings

Raw table description

Fields

id id

{
  "name": "id",
  "type": "primaryKey"
}

communicationTokenId M  → communicationTokens

{
  "name": "communicationTokenId",
  "type": "foreignKey",
  "table": "communicationTokens",
  "mandatory": "true",
  "schema": "mspx_admin"
}

contactSmsNumberId  → contactSmsNumbers

{
  "name": "contactSmsNumberId",
  "type": "foreignKey",
  "table": "contactSmsNumbers"
}

smsSender

{
  "name": "smsSender",
  "type": "text",
  "maxLength": 10
}

endDate

{
  "name": "endDate",
  "type": "datetime"
}

currentBid  → bids  (The bid that is set as the leading bid, it's not always the highest bid!)

{
  "name": "currentBid",
  "type": "foreignKey",
  "table": "bids",
  "note": "The bid that is set as the leading bid, it's not always the highest bid!"
}

dealId  → deals  (Back reference to the deal that the bidding belongs to.)

{
  "name": "dealId",
  "type": "foreignKey",
  "table": "deals",
  "note": "Back reference to the deal that the bidding belongs to."
}

allowWebsiteBids bit  (It's possible to place bid from mspecs bidding website)

{
  "name": "allowWebsiteBids",
  "type": "bit",
  "note": "It's possible to place bid from mspecs bidding website"
}

allowSMSBids bit  (It's possible to send SMS bids to the system)

{
  "name": "allowSMSBids",
  "type": "bit",
  "note": "It's possible to send SMS bids to the system"
}

displayBiddingOnMarketingPlaces bit  (If deal is published marketingPlaces will be updated and bidding is active will be set)

{
  "name": "displayBiddingOnMarketingPlaces",
  "type": "bit",
  "note": "If deal is published marketingPlaces will be updated and bidding is active will be set"
}

displayBiddingOnWebsite bit  (Website will display that bidding is active)

{
  "name": "displayBiddingOnWebsite",
  "type": "bit",
  "note": "Website will display that bidding is active"
}

displayBidderStatusOnWebsite bit  (Website will display each bidders status)

{
  "name": "displayBidderStatusOnWebsite",
  "type": "bit",
  "note": "Website will display each bidders status"
}

websiteBidSettings E  (If not set, display all bids)

{
  "name": "websiteBidSettings",
  "type": "enum",
  "enums": [
    "ENUMS_BIDDINGS_WEBSITE_BID_SETTINGS_HIDE_BIDS (Göm buden)",
    "ENUMS_BIDDINGS_WEBSITE_BID_SETTINGS_SHOW_ONLY_CURRENT_BID (Visa endast aktuellt bud)"
  ],
  "note": "If not set, display all bids"
}

hideBidsOnWebsite bit  (Use websiteBidSettings instead)

{
  "name": "hideBidsOnWebsite",
  "type": "bit",
  "note": "Use websiteBidSettings instead",
  "isDeprecated": "true"
}

updatedDate

{
  "name": "updatedDate",
  "type": "updated"
}

Referenced by

bidders as biddingId
bids as biddingId
deals as biddingId