Table : areas

Raw table description

Fields

id id

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

parentId  → areas  (Is only used in commercial, to connect valuation units to an area)

{
  "name": "parentId",
  "type": "foreignKey",
  "table": "areas",
  "note": "Is only used in commercial, to connect valuation units to an area"
}

estateId  → estates

{
  "name": "estateId",
  "type": "foreignKey",
  "table": "estates"
}

estateEconomicTypeCodeId  → estateEconomicTypeCodes

{
  "name": "estateEconomicTypeCodeId",
  "type": "foreignKey",
  "table": "estateEconomicTypeCodes",
  "schema": "mspx_admin"
}

externalId

{
  "name": "externalId",
  "type": "text",
  "maxLength": 40
}

value $$

{
  "name": "value",
  "type": "money"
}

name

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

area

{
  "name": "area",
  "type": "decimal",
  "digits": 15,
  "decimals": 1
}

type E

{
  "name": "type",
  "type": "enum",
  "enums": [
    "ENUM_AREA_TYPE_FIELD (Åkermark)",
    "ENUM_AREA_TYPE_OTHER (Övrigmark)",
    "ENUM_AREA_TYPE_CROPS (Betesmark)",
    "ENUM_AREA_TYPE_FISHING (Fiskemark)",
    "ENUM_AREA_TYPE_RENTAL_HOUSING (Hyresbostad)",
    "ENUM_AREA_TYPE_RENTAL_PREMISES (Hyreshusmark lokaler)",
    "ENUM_AREA_TYPE_IMPEDIMENT (Impediment)",
    "ENUM_AREA_TYPE_INDUSTRIAL (Industrimark)",
    "ENUM_AREA_TYPE_INFIELDS (Inägomark)",
    "ENUM_AREA_TYPE_HUNTING_GROUND (Jaktmark)",
    "ENUM_AREA_TYPE_POWERPLANT (Kraftverksmark)",
    "ENUM_AREA_TYPE_WATERPOWER (Vattenfallsenhet)",
    "ENUM_AREA_TYPE_FOREST (Skogsmark)",
    "ENUM_AREA_TYPE_FOREST_WITH_RESTRICTIONS (Skog med restriktion)",
    "ENUM_AREA_TYPE_IMPEDIMENT_FORREST (Skogsimpediment)",
    "ENUM_AREA_TYPE_HOUSING (Småhusmark)",
    "ENUM_AREA_TYPE_FARMING_HOUSE (Småhusmark lantbruk)",
    "ENUM_AREA_TYPE_EXTRACTION (Täktmark)",
    "ENUM_AREA_TYPE_WATER (Vatten)",
    "ENUM_AREA_TYPE_PLOT (Mark)",
    "ENUM_AREA_TYPE_MIRE_MARCH_BOG (Myr/kärr/mosse)",
    "ENUM_AREA_TYPE_MOUNTAIN_ROCKY_GROUND (Berg/hällmark)",
    "ENUM_AREA_TYPE_ROAD_AND_POWER_LINE (Väg och kraftledning)"
  ]
}

overallType T

{
  "name": "overallType",
  "type": "text",
  "enums": [
    "ENUM_AREA_OVERALL_TYPE_AREA_UNDER_LAND_REGISTER (Areal pågående registrering)",
    "ENUM_AREA_OVERALL_TYPE_AREA_FORESTRY_PLAN (Skogsbruksplan)",
    "ENUM_AREA_OVERALL_TYPE_AREA_PLAN_ON_PROPERTY_MAP (Områdesplan)",
    "ENUM_AREA_OVERALL_TYPE_AREA_SAM_APPLICATION (SAM-ansökan)",
    "ENUM_AREA_OVERALL_TYPE_AREA_TAXABLE_AREA (Taxerad areal)",
    "ENUM_AREA_OVERALL_TYPE_AREA_SELLERS_DATA (Säljarens uppgifter)"
  ],
  "maxLength": 200
}

comment

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

isImported bit

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

isPublished bit

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

isMarketing bit  (Used in commercial. If area should be in object description and so forth)

{
  "name": "isMarketing",
  "type": "bit",
  "note": "Used in commercial. If area should be in object description and so forth"
}

displayOrder

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

buildingRightArea   (How many kvm that are allowed above ground)

{
  "name": "buildingRightArea",
  "type": "decimal",
  "digits": 15,
  "decimals": 1,
  "note": "How many kvm that are allowed above ground"
}

isCommercialArea bit  (Only used in commercial. To differ an area from a valuation unit)

{
  "name": "isCommercialArea",
  "type": "bit",
  "note": "Only used in commercial. To differ an area from a valuation unit"
}

tax $$

{
  "name": "tax",
  "type": "money"
}

isTaxable bit  (Not in use yet)

{
  "name": "isTaxable",
  "type": "bit",
  "note": "Not in use yet"
}

valueYear   (Not in use yet)

{
  "name": "valueYear",
  "type": "year",
  "note": "Not in use yet"
}

updatedDate

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

Referenced by

areas as parentId
buildings as areaId