sbank

Tables (3)

Account (account)

  • AccountId (accountId) — BIGINT — Primary key — NOT NULL
  • No (no) — BIGINT — Foreign key → Member.No — NOT NULL
  • BankName (bankName) — VARCHAR(255)
  • AccountNumber (accountNumber) — VARCHAR(255)
  • Balance (balance) — INT
  • CreationDate (creationDate) — DATETIME

History (history)

  • HistoryId (historyId) — BIGINT — Primary key — NOT NULL
  • AccountId (accountId) — BIGINT — Foreign key → Account.AccountId — NOT NULL
  • Statement (statement) — TINYINT
  • Money (money) — INT
  • TransactionDate (transactionDate) — DATETIME
  • Sender (sender) — VARCHAR(255)

Member (member)

  • No (no) — BIGINT — Primary key — NOT NULL
  • ID (id) — VARCHAR(255)
  • Password (password) — VARCHAR(255)
  • Name (name) — VARCHAR(255)
  • Email (email) — VARCHAR(255)
  • Phone (phone) — VARCHAR(255)
  • BirthDay (birthday) — VARCHAR(255)
  • Authority (authority) — VARCHAR(255)