hw
Tables (7)
ACCOUNT
- Acct_no — VARCHAR(20)
- Balance — DECIMAL(15, 2) — NOT NULL
- Type — VARCHAR(50)
- Branch_no — VARCHAR(20)
ACCOUNT_CUSTOMER
- Acct_no — VARCHAR(20)
- Ssn — VARCHAR(20)
BANK
- Code — VARCHAR(20)
- Name — VARCHAR(255) — NOT NULL
- Addr — VARCHAR(255)
BANK_BRANCH
- Branch_no — VARCHAR(20)
- Addr — VARCHAR(255)
- Bank_code — VARCHAR(20)
CUSTOMER
- Ssn — VARCHAR(20)
- Name — VARCHAR(255) — NOT NULL
- Phone — VARCHAR(50)
- Addr — VARCHAR(255)
LOAN
- Loan_no — VARCHAR(20)
- Amount — DECIMAL(15, 2) — NOT NULL
- Type — VARCHAR(50)
- Branch_no — VARCHAR(20)
LOAN_CUSTOMER
- Loan_no — VARCHAR(20)
- Ssn — VARCHAR(20)