Table : bankAccounts

Raw table description

Fields

id id

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

title 

{
  "name": "title",
  "type": "text",
  "maxLength": 60
}

owner 

{
  "name": "owner",
  "type": "text",
  "maxLength": 60
}

bank 

{
  "name": "bank",
  "type": "text",
  "maxLength": 60
}

clearingNumber 

{
  "name": "clearingNumber",
  "type": "text",
  "maxLength": 8
}

accountNumber 

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

updatedDate 

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

Collections

[
  "bankAccountRoles"
]

Referenced by

bankAccountRoles as bankAccountId
commissionCuts as bankAccountId
contactBankAccounts as bankAccountId (connection table to contacts via contactId)
deals as downPaymentAccountId, sellerDownPaymentAccountId, outgoingPaymentBankAccountId
transactions as bankAccountId