BankApp
Tables (3)
Account (계좌)
- 계좌번호 (account_no) — varchar2(50) — Primary key — NOT NULL
- 잔액 (balance) — number
- 계좌생성일 (create_at) — date
- 아이디 (user_id) — varchar2(50) — Foreign key → Users.아이디 — NOT NULL
Transactions (거래내역)
- 거래id (tx_id) — number — Primary key — NOT NULL
- 거래종류 (tx_type) — varchar2(20) — NOT NULL
- 거래금액 (amount) — number — NOT NULL
- 이체대상계좌 (target_account) — varchar2(50)
- 거래일시 (tx_date) — sysdate — NOT NULL
- 계좌번호 (account_no) — varchar2(50) — Foreign key → Account.계좌번호 — NOT NULL
Users (회원)
- 아이디 (user_id) — varchar2(50) — Primary key — NOT NULL
- 비밀번호 (password) — varchar2(100) — NOT NULL
- 회원이름 (user_name) — varchar2(50) — NOT NULL
- 권한 (role) — varchar2(10)
- 가입일자 (create_at) — sysdate