Table : buyers

Raw table description

Fields

id id

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

contactId M  → contacts

{
  "name": "contactId",
  "type": "foreignKey",
  "table": "contacts",
  "mandatory": "true"
}

buyerGroupId M  → buyerGroups

{
  "name": "buyerGroupId",
  "type": "foreignKey",
  "table": "buyerGroups",
  "mandatory": "true"
}

share

{
  "name": "share",
  "type": "text",
  "maxLength": 20
}

hasMortgageCommitment bit

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

mortgageCommitmentComment

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

displayOrder

{
  "name": "displayOrder",
  "type": "int"
}

buyerInterestInformationId  → buyerInterestInformation

{
  "name": "buyerInterestInformationId",
  "type": "foreignKey",
  "table": "buyerInterestInformation"
}

description

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

interestedStatus E

{
  "name": "interestedStatus",
  "type": "enum",
  "enums": [
    "ENUM_BUYER_INTERESTED_STATUS_INTERESTED (Intresserad)",
    "ENUM_BUYER_INTERESTED_STATUS_NOT_INTERESTED (Inte intresserad)",
    "ENUM_BUYER_INTERESTED_STATUS_CONTACTED_UNDECIDED (Kontaktad-funderar)",
    "ENUM_BUYER_INTERESTED_STATUS_CONTACTED_NO_ANSWER (Kontaktad-ej svar)"
  ]
}

ownsProperty E

{
  "name": "ownsProperty",
  "type": "enum",
  "enums": [
    "ENUM_BUYER_OWNS_PROPERTY_YES (Ja)",
    "ENUM_BUYER_OWNS_PROPERTY_NO (Nej)"
  ]
}

updatedDate

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

Collections

[
  "signees"
]

Referenced by

bidders as buyerId
buyerBankIdVerifications as buyerId
buyerContactSignees as buyerId (connection table to contactSignees via contactSigneeId)
buyerDealSignatures as buyerId (connection table to dealSignatures via dealSignatureId)
buyerGroups as mainBuyerId
viewingBuyers as buyerId
viewingSlotBuyers as buyerId