db 쉅
테이블 (6)
account (계좌)
- account_number (Key) — 기본 키 — NOT NULL
- branch_name (Key2) — 외래 키 → branch.branch_name — NOT NULL
- balance (Field)
borrower (대출자)
- loan_number (Key1) — 외래 키 → loan.loan_number — NOT NULL
- ID (Key2) — 외래 키 → customer.ID — NOT NULL
branch (지점)
- branch_name (Key) — 기본 키 — NOT NULL
- branch_city (Field)
- assets (Field2)
customer (고객)
- ID (Key) — 기본 키 — NOT NULL
- customer_name (Field)
- customer_street (Field2)
- customer_city (Field3)
depositor (예금자)
- account_number (Key) — 외래 키 → account.account_number — NOT NULL
- ID (Key3) — 외래 키 → customer.ID — NOT NULL
loan (대출)
- loan_number (Key) — 기본 키 — NOT NULL
- branch_name (Key2) — 외래 키 → branch.branch_name — NOT NULL
- amount (Field)