Table : patios

Raw table description

Fields

id id

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

estateId M  → estates

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

patioType T

{
  "name": "patioType",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "ENUMS_PATIOTYPE_PATIO (Uteplats)",
    "ENUMS_PATIOTYPE_TERRACE (Terrass)",
    "ENUMS_PATIOTYPE_BALCONY (Balkong)",
    "ENUMS_PATIOTYPE_ALTAN (Altan)"
  ]
}

isGlasCovered bit

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

direction E

{
  "name": "direction",
  "type": "enum",
  "enums": [
    "ENUMS_DIRECTION_EAST (Öster)",
    "ENUMS_DIRECTION_WEST (Väster)",
    "ENUMS_DIRECTION_SOUTH (Söder)",
    "ENUMS_DIRECTION_SOUTHWEST (Sydväst)",
    "ENUMS_DIRECTION_SOUTHEAST (Sydost)",
    "ENUMS_DIRECTION_NORTH (Norr)",
    "ENUMS_DIRECTION_NORTHWEST (Nordväst)",
    "ENUMS_DIRECTION_NORTHEAST (Nordost)"
  ]
}

area 

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

comment 

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

displayOrder 

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

updatedDate 

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