Table : viewings

Raw table description

Fields

id id

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

dealId M  → deals

{
  "name": "dealId",
  "type": "foreignKey",
  "table": "deals",
  "mandatory": "true"
}

startDate

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

endDate

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

hostContactId  → contacts

{
  "name": "hostContactId",
  "type": "foreignKey",
  "table": "contacts"
}

viaInternet bit

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

viaSms bit

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

viaMarketingDocuments bit

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

description   (Public text)

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

comment   (Private text)

{
  "name": "comment",
  "type": "text",
  "note": "Private text"
}

isInactive bit

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

allowExternalBooking bit  (If this viewing is bookable from other sources, like broker webpage)

{
  "name": "allowExternalBooking",
  "type": "bit",
  "note": "If this viewing is bookable from other sources, like broker webpage"
}

externalBookingTriggerAction E

{
  "name": "externalBookingTriggerAction",
  "type": "enum",
  "enums": [
    "ENUM_VIEWING_EXTERNAL_BOOKING_TRIGGER_ACTION_SEND_SMS",
    "ENUM_VIEWING_EXTERNAL_BOOKING_TRIGGER_ACTION_SEND_EMAIL"
  ]
}

externalBookingTriggerRecipientContactId  → contacts

{
  "name": "externalBookingTriggerRecipientContactId",
  "type": "foreignKey",
  "table": "contacts"
}

viewingType E

{
  "name": "viewingType",
  "type": "enum",
  "enums": [
    "ENUMS_VIEWINGS_TYPE_COMMENT_ONLY (Visa enbart kommentar)",
    "ENUMS_VIEWINGS_TYPE_CONTACT_BROKER (Visa \"Kontakta mäklaren för visning\")",
    "ENUMS_VIEWINGS_TYPE_DATE_AND_TIME (Visa datum och tid)",
    "ENUMS_VIEWINGS_TYPE_DATE_ONLY (Visa endast datum)",
    "ENUMS_VIEWINGS_TYPE_TIME_SLOTS (Tidsseparerade visningar)"
  ]
}

numberOfSlots

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

slotLength   (length of slot in mins)

{
  "name": "slotLength",
  "type": "int",
  "note": "length of slot in mins"
}

slotCapacity   (number of participants allowed in slot)

{
  "name": "slotCapacity",
  "type": "int",
  "note": "number of participants allowed in slot"
}

slotLimitReminder

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

hideWebsiteViewingStartDate bit  (used to hide time for slot viewings)

{
  "name": "hideWebsiteViewingStartDate",
  "type": "bit",
  "note": "used to hide time for slot viewings"
}

contactBrokerForViewing bit  (Use viewingType instead)

{
  "name": "contactBrokerForViewing",
  "type": "bit",
  "isDeprecated": "true",
  "note": "Use viewingType instead"
}

isNoSpecifiedTime bit  (Use viewingType instead)

{
  "name": "isNoSpecifiedTime",
  "type": "bit",
  "isDeprecated": "true",
  "note": "Use viewingType instead"
}

displayOnlyViewingDescription bit  (Use viewingType instead)

{
  "name": "displayOnlyViewingDescription",
  "type": "bit",
  "isDeprecated": "true",
  "note": "Use viewingType instead"
}

updatedDate

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

Collections

[
  "viewingBuyers",
  "viewingEvents",
  "viewingSlots"
]

Referenced by

viewingBuyers as viewingId
viewingEvents as viewingId (connection table to events via eventId)
viewingSlots as viewingId