Wells Far-Go

Tables (10)

Account (accounts)

  • Number (account_number) — string — Primary key — NOT NULL
  • CustomerID (cid) — string — Foreign key → Customer.ID — NOT NULL
  • Type (type) — tinyint
  • Status (acccount_status) — tinyint
  • Name (name) — string
  • Balance (balance) — float
  • Status (status) — tinyint
  • OpenedAt (opened_at) — bigint
  • DeletedAt (deleted_at) — bigint

AccountHolder (Untitled)

  • AccountNumber (Field)
  • BankNumber (Field2)

Address (addresses)

  • ID (aid) — int — Primary key — NOT NULL
  • Number (account_number) — string — Foreign key → Account.Number — NOT NULL
  • CustomerID (cid) — string — Foreign key → Account.CustomerID — NOT NULL
  • Type (type) — tinyint
  • State (state) — string
  • City (city) — string
  • Street (street) — string
  • ZipCode (zip_code) — int
  • Country (country) — string

Admin (admins)

    Bank (banks)

    • BankCode (bank_code) — string — Primary key — NOT NULL
    • Name (bank_name) — string
    • Address (bank_address) — string

    Branch (branches)

    • ID (bid) — int — Primary key — NOT NULL
    • BankCode (bank_code) — string — Foreign key → Bank.BankCode — NOT NULL
    • Name (name) — string
    • Location (location) — string

    Customer (customers)

    • ID (cid) — string — Primary key — NOT NULL
    • Password (password) — string
    • Status (status) — tinyint
    • FirstName (first_name) — string
    • MiddleNanme (middle_name) — string
    • LastName (last_name) — string
    • Gender (gender) — tinyint
    • Salary (salary) — float
    • CountryCode (country_code) — int
    • Phone (phone) — string
    • Email (email) — string
    • DOB (date_of_birth) — string
    • RegisteredDate (registered_date) — bigint
    • UpdatedAt (updated_at) — bigint
    • DeletedAt (deleted_at) — bigint

    Deposit (deposits)

    • AccountNumber (account_number) — string — Foreign key → Account.Number — NOT NULL
    • CustomerID (cid) — string — Foreign key → Account.CustomerID — NOT NULL
    • Date (date) — bigint
    • Amount (amount) — float

    Transaction (transactions)

    • ID (tid) — uuid — Primary key — NOT NULL
    • AccountNumber (account_number) — string — Foreign key → Account.Number — NOT NULL
    • CustomerID (cid) — string — Foreign key → Account.CustomerID — NOT NULL
    • Type (type) — string
    • Status (status) — string
    • Amount (transfer_amount) — float
    • TransferDate (transfer_date) — bigint
    • From (from) — string
    • To (to) — string
    • Description (description) — string

    Withdraw (withdraws)

    • AccountNumber (account_number) — string — Foreign key → Account.Number — NOT NULL
    • CustomerID (cid) — string — Foreign key → Account.CustomerID — NOT NULL
    • Date (date) — bigint
    • Amount (amount) — float