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)