Table : formInvitations

Raw table description

Fields

id id

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

createdByUserId M  → userAccounts

{
  "name": "createdByUserId",
  "type": "foreignKey",
  "table": "userAccounts",
  "schema": "mspx_admin",
  "mandatory": "true"
}

dealId M  → deals

{
  "name": "dealId",
  "type": "foreignKey",
  "table": "deals",
  "mandatory": "true"
}

formId M  → forms

{
  "name": "formId",
  "type": "foreignKey",
  "table": "forms",
  "schema": "mspx_admin",
  "mandatory": "true"
}

message

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

formStatus E

{
  "name": "formStatus",
  "type": "enum",
  "enums": [
    "ENUM_FORM_INVITATIONS_FORM_STATUS_OPEN (Öppen)",
    "ENUM_FORM_INVITATIONS_FORM_STATUS_SUBMITTED (Inskickad)",
    "ENUM_FORM_INVITATIONS_FORM_STATUS_LOCKED",
    "ENUM_FORM_INVITATIONS_FORM_STATUS_CLOSED"
  ]
}

reply

{
  "name": "reply",
  "type": "jsonObject"
}

isHidden bit

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

updatedDate

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

Referenced by

formInvitationContacts as formInvitation