java_service
Tables (3)
ACCOUNT (계좌)
- 계좌번호 (account_num) — Varchar2(20) — Primary key — NOT NULL
- 비밀번호 (account_password) — Varchar2(4) — NOT NULL
- 임시여부 (is_temporary) — CHAR(1) — NOT NULL
- 잔고 (balance) — Integer — NOT NULL
- 생성날짜 (create_date) — Date — NOT NULL
- 유저키 (user_key) — Integer — Foreign key → Bank_user.유저키 — NOT NULL
Bank_user (사용자)
- 유저키 (user_key) — Integer — Primary key — NOT NULL
- 아이디 (user_id) — Varchar2(20) — NOT NULL
- 비밀번호 (user_password) — Varchar2(20) — NOT NULL
- 타입 (type) — Varchar2(10) — NOT NULL
- 이름 (name) — Varchar2(20) — NOT NULL
- 생년월일 (birth_day) — Date — NOT NULL
TRANSACTION (거래)
- 거래키 (transaction_key) — Integer — Primary key — NOT NULL
- 거래타입 (transaction_type) — Short — NOT NULL
- 거래금액 (transaction_amount) — Integer — NOT NULL
- 거래후잔액 (transaction_balance) — Integer — NOT NULL
- 거래시간 (transaction_datetime) — Datetime — NOT NULL
- 계좌번호 (account_num) — Varchar2(20) — Foreign key → ACCOUNT.계좌번호 — NOT NULL
- 보낸사람 (transaction_send_name) — Varchar2(20)
- 받은사람 (transaction_take_name) — Varchar2(20)
- 거래대상계좌번호 (account_counterpart_num) — Varchar2(20) — Foreign key → ACCOUNT.계좌번호