Table : estateTenantsSubObjectTypes

Raw table description

Fields

id id

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

name

{
  "name": "name",
  "type": "text",
  "maxLength": 80
}

estateTenantsObjectTypeId M  → estateTenantsObjectTypes

{
  "name": "estateTenantsObjectTypeId",
  "type": "foreignKey",
  "table": "estateTenantsObjectTypes",
  "mandatory": "true"
}

organizationUnitId  → organizationUnits

{
  "name": "organizationUnitId",
  "type": "foreignKey",
  "table": "organizationUnits"
}

isUserDefined bit

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

isInactive bit

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

generalizedCost $$  (cost/m2)

{
  "name": "generalizedCost",
  "type": "money",
  "note": "cost/m2"
}

updatedDate

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

Unique Fields

 The fields name and organizationUnitId together.

Referenced by

estateTenants as estateTenantsSubObjectTypeId
estateTenantsSubObjectTypeEstateCalculations as estateTenantsSubObjectTypeId