GoBank

Tables (6)

Account (accounts)

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

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
  • ZipCodez (zip_code) — int
  • Country (country) — string

Customer (customers)

  • Key (cid) — string — Primary key — NOT NULL
  • Password (pasword) — string
  • Status (status) — tinyint
  • FirstName (first_name) — string
  • MiddleName (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 (deletedAt) — bigint

Deposit (deposits)

  • Number (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
  • Number (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)

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