통합계좌서비스

테이블 (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