Table : bids

Raw table description

Fields

id id

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

biddingId M  → biddings

{
  "name": "biddingId",
  "type": "foreignKey",
  "table": "biddings",
  "mandatory": "true"
}

bidderId M  → bidders

{
  "name": "bidderId",
  "type": "foreignKey",
  "table": "bidders",
  "mandatory": "true"
}

incomingSmsId  → incomingSms

{
  "name": "incomingSmsId",
  "type": "foreignKey",
  "table": "incomingSms"
}

bidAmount $$

{
  "name": "bidAmount",
  "type": "money"
}

bidDate D

{
  "name": "bidDate",
  "type": "datetime",
  "mandatory": "true",
  "default": "CURRENT_TIMESTAMP"
}

createdDate

{
  "name": "createdDate",
  "type": "timestamp"
}

createdByUserId  → userAccounts

{
  "name": "createdByUserId",
  "type": "foreignKey",
  "table": "userAccounts",
  "schema": "mspx_admin"
}

isAutomaticBid bit

{
  "name": "isAutomaticBid",
  "type": "bit"
}

isPrivate bit

{
  "name": "isPrivate",
  "type": "bit"
}

description

{
  "name": "description",
  "type": "text"
}

status M E

{
  "name": "status",
  "type": "enum",
  "enums": [
    "ENUMS_BID_STATUS_ACTIVE (Aktiv)",
    "ENUMS_BID_STATUS_QUARANTINE (Karantän)",
    "ENUMS_BID_STATUS_REVOKED (Ã…terkallat)",
    "ENUMS_BID_STATUS_NOT_VALID (Inte giltigt)"
  ],
  "mandatory": "true"
}

updatedDate

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

Referenced by

biddings as currentBid
buyerGroups as highestBidId