bank

Tables (3)

Account

  • 계좌id (Account_id) — INT — Primary key — NOT NULL
  • 고객번호 (Client_id) — INT — Foreign key → Client.고객번호 — NOT NULL
  • 계좌번호 (Account_num) — VARCHAR(20)
  • 잔고 (Balance) — INT

Client

  • 고객번호 (Client_id) — INT — Primary key — NOT NULL
  • 이름 (name) — VARCHAR(50)
  • 연락처 (tel) — INT

Transaction

  • 거래번호 (Transaction_id) — INT — Primary key — NOT NULL
  • 계좌id (Account_id) — INT — Foreign key → Account.계좌id — NOT NULL
  • 거래유형 (transtype) — ENUM
  • 거래금액 (amount) — INT
  • 거래일시 (trans_date) — DATETIME