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"
}{
"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"
}