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)