Table : matchings

Raw table description

Fields

id id

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

maxRooms

{
  "name": "maxRooms",
  "type": "smallint"
}

minRooms

{
  "name": "minRooms",
  "type": "smallint"
}

maxPrice

{
  "name": "maxPrice",
  "type": "float"
}

minPrice

{
  "name": "minPrice",
  "type": "float"
}

maxLivingArea

{
  "name": "maxLivingArea",
  "type": "smallint"
}

minLivingArea

{
  "name": "minLivingArea",
  "type": "smallint"
}

maxHectare

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

minHectare

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

objectTypeId  → objectTypes

{
  "name": "objectTypeId",
  "type": "foreignKey",
  "table": "objectTypes",
  "schema": "mspx_admin"
}

isActive M bit

{
  "name": "isActive",
  "type": "bit",
  "mandatory": "true"
}

residentialArea

{
  "name": "residentialArea",
  "type": "text",
  "maxLength": 150
}

countryId  → countries

{
  "name": "countryId",
  "type": "foreignKey",
  "table": "countries",
  "schema": "mspx_admin"
}

inactivatedDate

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

matchingChangedDate

{
  "name": "matchingChangedDate",
  "type": "date"
}

createdDate

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

polygonListJSON   (Expected structure: [ [{x:19.232323, y:56.3434343}, {x:15.33434, y:70.444}...], [{x:15.232323, y:50.3434343}, {x:16.33434, y:45.444}...]...]. A list that contains polygons which is a list with coordinates)

{
  "name": "polygonListJSON",
  "type": "jsonObject",
  "note": "Expected structure: [ [{x:19.232323, y:56.3434343}, {x:15.33434, y:70.444}...], [{x:15.232323, y:50.3434343}, {x:16.33434, y:45.444}...]...]. A list that contains polygons which is a list with coordinates"
}

comment

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

isInternational bit

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

updatedDate

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

Collections

[
  "matchingAttributes",
  "matchingGeographicalAreas"
]

Referenced by

contactMatchings as matchingId (connection table to contacts via contactId)
matchingAttributesMatching as matchingId (connection table to matchingAttributes via matchingAttributeId)
matchingGeographicalAreas as matchingId (connection table to geographicalAreas via geographicalAreaId)
matchingHistory as matchingId
matchingObjectSubTypes as matchingId