통합계좌서비스
테이블 (7)
ACCOUNT_SYSTEM (하나은행 통합계좌시스템)
- PK (ACCOUNT_NO) — VARCHAR2(20) — 기본 키 — NOT NULL
- (BANK) — VARCHAR2(20)
- (ACCOUNT_HOLDER) — VARCHAR2(10)
- (BALANCE) — NUMBER
- (NICKNAME) — VARCHAR2(15)
- (CREATE_DATE) — DATE
- FK (USER_ID) — VARCHAR2(20) — 외래 키 → USER_TABLE.PK — NOT NULL
ACCOUNT_국민 (국민은행)
- PK (ACCOUNT_NO) — VARCHAR2(20) — 기본 키 — NOT NULL
- (BANK) — VARCHAR2(20)
- (ACCOUNT_HOLDER) — VARCHAR2(10)
- (BALANCE) — NUMBER
- (NICKNAME) — VARCHAR2(15)
- (CREATE_DATE) — DATE
- FK (USER_ID) — VARCHAR2(20) — 외래 키 → USER_TABLE.PK — NOT NULL
ACCOUNT_기업 (기업은행)
- PK (ACCOUNT_NO) — VARCHAR2(20) — 기본 키 — NOT NULL
- (BANK) — VARCHAR2(20)
- (ACCOUNT_HOLDER) — VARCHAR2(10)
- (BALANCE) — NUMBER
- (NICKNAME) — VARCHAR2(15)
- (CREATE_DATE) — DATE
- FK (USER_ID) — VARCHAR2(20) — 외래 키 → USER_TABLE.PK — NOT NULL
ACCOUNT_신한 (신한은행)
- PK (ACCOUNT_NO) — VARCHAR2(20) — 기본 키 — NOT NULL
- (BANK) — VARCHAR2(20)
- (ACCOUNT_HOLDER) — VARCHAR2(10)
- (BALANCE) — NUMBER
- (NICKNAME) — VARCHAR2(15)
- (CREATE_DATE) — DATE
- FK (USER_ID) — VARCHAR2(20) — 외래 키 → USER_TABLE.PK — NOT NULL
ACCOUNT_우리 (우리은행)
- PK (ACCOUNT_NO) — VARCHAR2(20) — 기본 키 — NOT NULL
- (BANK) — VARCHAR2(20)
- (ACCOUNT_HOLDER) — VARCHAR2(10)
- (BALANCE) — NUMBER
- (NICKNAME) — VARCHAR2(15)
- (CREATE_DATE) — DATE
- FK (USER_ID) — VARCHAR2(20) — 외래 키 → USER_TABLE.PK — NOT NULL
ADMIN_TABLE (관리자)
- PK (ID) — VARCHAR2(20) — 기본 키 — NOT NULL
- (PW) — VARCHAR2(20)
- (NAME) — VARCHAR2(20)
- (JOIN_DATE) — DATE
USER_TABLE (유저)
- PK (ID) — VARCHAR2(20) — 기본 키 — NOT NULL
- (PW) — VARCHAR2(20)
- (NAME) — VARCHAR2(20)
- (JOIN_DATE) — DATE