Bank

Tables (4)

Account (Untitled3)

  • 걔좌 식별아이디 (accountId) — INT — Primary key — NOT NULL
  • 고객식별아이디 (customerId) — INT — Foreign key → Customer.고객식별아이디 — NOT NULL
  • 은행식별아이디 (bankId) — INT — Foreign key → Bank.은행식별아이디 — NOT NULL
  • 계좌번호 (accountNumber) — NVARCHAR(15)
  • 남은돈 (remainMoney) — LONG

Bank (Untitled)

  • 은행식별아이디 (bankId) — INT — Primary key — NOT NULL
  • 은행이름 (bankName) — NVARCHAR(5)
  • 최대인원 (MaxPeople)

BankRole (Untitled4)

  • 고객식별아이디 (customerId) — INT — Foreign key → Customer.고객식별아이디 — NOT NULL
  • 은행식별아이디 (bankId) — INT — Foreign key → Bank.은행식별아이디 — NOT NULL

Customer (Untitled2)

  • 고객식별아이디 (customerId) — INT — Primary key — NOT NULL
  • 고객이름 (customerName) — NVARCHAR(5)
  • 고객아이디 (customerLoginId) — NVARCHAR(10)
  • 고객비밀번호 (customerLoginpassword) — NVARCHAR(10)