Table : newDevelopmentProperties

Raw table description

Fields

id id

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

dealId M  → deals

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

objectTypeId M  → objectTypes

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

amount M

{
  "name": "amount",
  "type": "smallint",
  "mandatory": "true"
}

updatedDate

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