Table : userAccounts

Raw table description

Fields

id id

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

contactId M  → contacts

{
  "name": "contactId",
  "type": "keyField",
  "table": "contacts",
  "mandatory": "true"
}

username M

{
  "name": "username",
  "type": "text",
  "maxLength": 80,
  "mandatory": "true",
  "unique": true
}

password

{
  "name": "password",
  "type": "password",
  "notInDB": true
}

organizationId M  → organizations

{
  "name": "organizationId",
  "type": "foreignKey",
  "table": "organizations",
  "mandatory": "true"
}

validUntil

{
  "name": "validUntil",
  "type": "date"
}

languageId D  → languages

{
  "name": "languageId",
  "type": "foreignKey",
  "table": "languages",
  "mandatory": "true",
  "default": "MDAtMXwwMDAwMDAwMDAwMXwxMg.."
}

lastLogin

{
  "name": "lastLogin",
  "type": "datetime"
}

timezone D T

{
  "name": "timezone",
  "type": "text",
  "maxLength": 100,
  "enums": [
    "Europe/Stockholm",
    "Europe/Oslo",
    "Europe/Helsinki",
    "Europe/Copenhagen"
  ],
  "mandatory": "true",
  "default": "Europe/Stockholm"
}

createdDate

{
  "name": "createdDate",
  "type": "timestamp"
}

dealId  → deals  (This deal is used for personal service orders and deliveries)

{
  "name": "dealId",
  "type": "keyField",
  "table": "deals",
  "note": "This deal is used for personal service orders and deliveries"
}

claimedIdentifier

{
  "name": "claimedIdentifier",
  "type": "text",
  "maxLength": 200
}

emailSignature

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

letterSignature

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

passwordSetDate

{
  "name": "passwordSetDate",
  "type": "date",
  "readOnly": true
}

allowPasswordLogin bit  (Only used if organization is onlySSO org. Can only be edited by admin.)

{
  "name": "allowPasswordLogin",
  "type": "bit",
  "note": "Only used if organization is onlySSO org. Can only be edited by admin."
}

updatedDate

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

Collections

[
  "accessRights"
]

Unique Fields

 The fields contactId and organizationId together.

Referenced by

associationDocuments as createdByUserId
associationFiles as createdByUserId
bankIdVerifications as createdByUserId
bidderStatusLog as createdByUserId
bidders as createdByUserId
bids as createdByUserId
brokerJournalEntries as userAccountId
comments as createdByUserId
communicateSessions as userAccountId
communications as createdByUserId
contactLogs as userAccountId
contacts as createdByUserId, userAccountId
dealProviderServices as createdByUserId, updatedByUserId
digitalSignatures as initiatedByUserAccountId
documents as createdByUserId
emailOutboxes as senderUserAccountId
emails as createdByUserId
events as ownerUserAccountId
files as createdByUserId
formInvitationContacts as createdByUserId
formInvitations as createdByUserId
forms as createdByUserId
futureChanges as createdByUserId
gridFilters as userAccountId
invoices as createdByUserId
invoicingInformation as createdByUserId
memoPad as userAccountId
providerServiceSubscribers as createdByUserId
pushSubscriptions as eventUserAccountId
queryFilters as userAccountId
searchFilters as userAccountId
smsOutboxes as senderUserAccountId
staff as userAccountId
userAccountsAccessRights as userAccountId (connection table to accessRights via accessRightId)