Table : contactInformation

Raw table description

Fields

id id

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

contactType E

{
  "name": "contactType",
  "type": "enum",
  "enums": [
    "ENUMS_CONTACTTYPE_TELEPHONE (Telefon)",
    "ENUMS_CONTACTTYPE_HOMEPAGE (Hemsida)",
    "ENUMS_CONTACTTYPE_EMAIL (E-post)",
    "ENUMS_CONTACTTYPE_ADDRESS (Adress)",
    "ENUMS_CONTACTTYPE_FAX (Fax)"
  ]
}

contactSubType

{
  "name": "contactSubType",
  "type": "text",
  "maxLength": 100
}

streetAddress

{
  "name": "streetAddress",
  "type": "text",
  "maxLength": 100
}

postalCode

{
  "name": "postalCode",
  "type": "text",
  "maxLength": 20
}

city

{
  "name": "city",
  "type": "text",
  "maxLength": 100
}

email

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

phoneNumber

{
  "name": "phoneNumber",
  "type": "text",
  "maxLength": 25
}

isSmsNumber bit

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

websiteUrl

{
  "name": "websiteUrl",
  "type": "text",
  "maxLength": 150
}

faxNumber

{
  "name": "faxNumber",
  "type": "text",
  "maxLength": 25
}

updatedDate

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

Referenced by

contactContactInformation as contactInformationId (connection table to contacts via contactId)
housingAssociations as contactInformationId