Table : dealMarketingPlaces

Raw table description

Fields

id id

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

dealId M  → deals

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

providerServiceId  → providerServices

{
  "name": "providerServiceId",
  "type": "foreignKey",
  "table": "providerServices",
  "schema": "mspx_admin"
}

marketingPlace M E

{
  "name": "marketingPlace",
  "type": "enum",
  "enums": [
    "ENUM_MARKETING_PLACES_HEMNET (Hemnet)",
    "ENUM_MARKETING_PLACES_OBJEKT_VISION (Objektvision)",
    "ENUM_MARKETING_PLACES_BLOCKET (Blocket)",
    "ENUM_MARKETING_PLACES_WEBSITE (Hemsida)",
    "ENUM_MARKETING_PLACES_HITTA_HEM (Hittahem)",
    "ENUM_MARKETING_PLACES_BOVISION (Bovision)",
    "ENUM_MARKETING_PLACES_SWEDENESTATES",
    "ENUM_MARKETING_PLACES_BOOLI",
    "ENUM_MARKETING_PLACES_BONYTT",
    "ENUM_MARKETING_PLACES_BONEO",
    "ENUM_MARKETING_PLACES_PROVIDER_SERVICE"
  ],
  "mandatory": "true"
}

status E

{
  "name": "status",
  "type": "enum",
  "enums": [
    "ENUM_DEAL_MARKETING_PLACES_STATUS_NOT_PUBLISHED",
    "ENUM_DEAL_MARKETING_PLACES_STATUS_PUBLISHED",
    "ENUM_DEAL_MARKETING_PLACES_STATUS_UN_PUBLISHED",
    "ENUM_DEAL_MARKETING_PLACES_STATUS_PENDING",
    "ENUM_DEAL_MARKETING_PLACES_STATUS_SOLD"
  ]
}

createdDate   (Date first published)

{
  "name": "createdDate",
  "type": "timestamp",
  "note": "Date first published"
}

publishedDate

{
  "name": "publishedDate",
  "type": "datetime",
  "note": ""
}

unpublishedDate   (If null its still published, if set. Its the last time it was unpublished)

{
  "name": "unpublishedDate",
  "type": "datetime",
  "note": "If null its still published, if set. Its the last time it was unpublished"
}

updatedOnMarketingPlaceDate

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

isPreview bit

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

accessGrants

{
  "name": "accessGrants",
  "type": "jsonObject",
  "validationSchema": {
    "id": "DealMarketingPlaces/AccessGrants",
    "type": "object",
    "additionalProperties": false,
    "properties": {
      "READ_BUYER_BASIC": {
        "type": "boolean"
      },
      "READ_BUYER_IDENTIFIER": {
        "type": "boolean"
      },
      "READ_BUYER_ADDRESS": {
        "type": "boolean"
      },
      "READ_BUYER_PHONE": {
        "type": "boolean"
      },
      "READ_BUYER_EMAIL": {
        "type": "boolean"
      },
      "READ_SELLER_BASIC": {
        "type": "boolean"
      },
      "READ_SELLER_IDENTIFIER": {
        "type": "boolean"
      },
      "READ_SELLER_ADDRESS": {
        "type": "boolean"
      },
      "READ_SELLER_PHONE": {
        "type": "boolean"
      },
      "READ_SELLER_EMAIL": {
        "type": "boolean"
      }
    }
  }
}

updatedDate

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