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