Table : premises

Raw table description

Fields

id id

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

name M

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

estateId M  → estates

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

floor T

{
  "name": "floor",
  "type": "text",
  "maxLength": 50,
  "enums": [
    "ENUMS_FLOORS_1 (Våningsplan 1)",
    "ENUMS_FLOORS_2 (Våningsplan 2)",
    "ENUMS_FLOORS_3 (Våningsplan 3)",
    "ENUMS_FLOORS_4 (Våningsplan 4)",
    "ENUMS_FLOORS_5 (Våningsplan 5)",
    "ENUMS_FLOORS_BASEMENT (Källare)",
    "ENUMS_FLOORS_GROUND (Bottenvåning)",
    "ENUMS_FLOORS_UPSTAIRS (Ovanvåning)",
    "ENUMS_FLOORS_MAIN_FLOOR (Entréplan)",
    "ENUMS_FLOORS_INCLINE_PLANE (Souterrängplan)"
  ]
}

area

{
  "name": "area",
  "type": "area"
}

description

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

displayOrder

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

updatedDate

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