bankProject

Tables (7)

ai_account_info_hana (하나은행)

  • 인덱스 (account_index) — varchar2(30) — Primary key — NOT NULL
  • 멤버index (member_index2) — varchar2(30) — Foreign key → ai_member.멤버index — NOT NULL
  • 멤버_index (member_index) — varchar2(30)
  • 계좌번호 (account_number) — varchar2(30)
  • 잔액 (balance) — number(10)
  • 계좌비밀번호 (account_passwd) — varchar2(20)
  • 별칭 (nickname) — varchar2(100)
  • 생성/등록 (account_type) — number(5)
  • 등록날짜 (registration_date) — date

ai_account_info_ibk (기업은행)

  • 인덱스 (account_index) — varchar2(30) — Primary key — NOT NULL
  • 멤버index (member_index2) — varchar2(30) — Foreign key → ai_member.멤버index — NOT NULL
  • 멤버_index (member_index) — varchar2(30)
  • 계좌번호 (account_number) — varchar2(30)
  • 잔액 (balance) — number(10)
  • 계좌비밀번호 (account_passwd) — varchar2(20)
  • 별칭 (nickname) — varchar2(100)
  • 등록날짜 (registration_date) — date

ai_account_info_kb (국민은행)

  • 인덱스 (account_index) — varchar2(30) — Primary key — NOT NULL
  • 멤버index (member_index2) — varchar2(30) — Foreign key → ai_member.멤버index — NOT NULL
  • 멤버_index (member_index) — varchar2(30)
  • 계좌번호 (account_number) — varchar2(30)
  • 잔액 (balance) — number(10)
  • 계좌비밀번호 (account_passwd) — varchar2(20)
  • 별칭 (nickname) — varchar2(100)
  • 등록날짜 (registration_date) — date

ai_account_info_kdb (산업은행)

  • 인덱스 (account_index) — varchar2(30) — Primary key — NOT NULL
  • 멤버index (member_index2) — varchar2(30) — Foreign key → ai_member.멤버index — NOT NULL
  • 멤버_index (member_index) — varchar2(30)
  • 계좌번호 (account_number) — varchar2(30)
  • 잔액 (balance) — number(10)
  • 계좌비밀번호 (account_passwd) — varchar2(20)
  • 별칭 (nickname) — varchar2(100)
  • 등록날짜 (registration_date) — date

ai_account_info_nh (농협은행)

  • 인덱스 (account_index) — varchar2(30) — Primary key — NOT NULL
  • 멤버index (member_index2) — varchar2(30) — Foreign key → ai_member.멤버index — NOT NULL
  • 멤버_index (member_index) — varchar2(30)
  • 계좌번호 (account_number) — varchar2(30)
  • 잔액 (balance) — number(10)
  • 계좌비밀번호 (account_passwd) — varchar2(20)
  • 별칭 (nickname) — varchar2(100)
  • 등록날짜 (registration_date) — date

ai_member (Untitled)

  • 멤버index (member_index) — varchar2(30) — Primary key — NOT NULL
  • 아이디 (id) — varchar2(30)
  • 비밀번호 (passwd) — varchar2(50)
  • 이름 (name) — varchar2(30)
  • 핸드폰번호 (phone) — varchar2(100)
  • 주소 (addr) — varchar2(100)
  • 성별 (gender) — number(2)
  • 회원가입날짜 (join_date) — date

manager (관리자)

  • 매니저index (manager_index) — varchar2(30) — Primary key — NOT NULL
  • 아이디 (manager_id) — varchar2(30)
  • 비밀번호 (manager_passwd) — varchar2(50)
  • 등록날짜 (join_date) — date