Table : geographicalAreas

Raw table description

Fields

id id

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

name M

{
  "name": "name",
  "type": "text",
  "maxLength": 100,
  "mandatory": "true"
}

parentId  → geographicalAreas

{
  "name": "parentId",
  "type": "foreignKey",
  "table": "geographicalAreas"
}

identifier M

{
  "name": "identifier",
  "type": "text",
  "maxLength": 20,
  "mandatory": "true"
}

updatedDate

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

Referenced by

dealGeographicalAreas as geographicalAreaId (connection table to deals via dealId)
estateGeographicalAreas as geographicalAreaId (connection table to estates via estateId)
geographicalAreas as parentId
housingAssociationGeographicalAreas as geographicalAreaId (connection table to housingAssociations via housingAssociationId)
matchingGeographicalAreas as geographicalAreaId (connection table to matchings via matchingId)