카뱅 2차 try
테이블 (13)
고객 (Untitled12)
- 고객번호 (Customer Number) — number — 기본 키 — NOT NULL
- 고객성명 (Customer Name) — varchar2(100)
- 고객주소 (Customer Address) — varchar2(300)
- 이메일주소 (Email Address) — varchar2(100)
- 전화번호 (Cell Phone Number) — varchar2(50)
- 국적코드 (Nationality Code) — varchar2(3)
- 고객성별 (Customer Gender) — varchar2(1)
- 고객유형 (Customer Type) — varchar2(2)
기준금리 원장 (Untitled7)
- 이율종류코드 (Interest Rate Kind Code) — varchar2(3) — 기본 키 — NOT NULL
- 적용시작일자 (Apply Start Date) — varchar2(8) — 기본 키 — NOT NULL
- 금리기간코드 (Interest Term Code) — varchar2(5) — 기본 키 — NOT NULL
- 금리승인상태 (Interest Rate Approval Status) — varchar2(1)
- 적용종료일자 (Apply Close Date) — varchar2(8)
- 기준금리 (Standard Interest Rate) — number
상환스케줄 상세 (Untitled10)
- 상환예정일자 (Repayment Schedule Date) — varchar2(8) — 기본 키 — NOT NULL
- 상환계획번호 (Repayment Plan Number2) — varchar2(12) — 외래 키 → 상환스케쥴.상환계획번호 — NOT NULL
- 상환계획일련번호 (Repayment Plan Serial Number2) — number — 외래 키 → 상환스케쥴.상환계획일련번호 — NOT NULL
- 여신원장상태 (Loan Table Status) — varchar2(2)
- 상환예정영업일자 (Repayment Schedule Business Date) — varchar2(8)
- 상환예정원금금액 (Repayment Schedule Principal Amount) — number
- 상환예정이자금액 (Repayment Schedule Interest Amount) — number
- 상환원금금액 (Repayment Principal Amount) — number
- 상환이자금액 (Repayment Interest Amount) — number
- 상환후원금잔액 (After Repayment Principal Balance) — number
- 최종원금상환일자 (Last Principal Repayment Date) — varchar2(8)
- 최종이자상환일자 (Last Interest Repayment Date) — varchar2(8)
- 기일내원금잔액 (Within Term Principal Amount) — number
- 기일내이자잔액 (Within Term Interest Amount) — number
상환스케쥴 (Untitled9)
- 상환계획번호 (Repayment Plan Number) — varchar2(12) — 기본 키 — NOT NULL
- 상환계획일련번호 (Repayment Plan Serial Number) — number — 기본 키 — NOT NULL
- 여신실행번호 (Loan Execute Number) — number — 외래 키 → 여신실행.여신실행번호 — NOT NULL
- 여신계좌번호 (Loan Account Number2) — varchar2(12) — 외래 키 → 여신실행.여신계좌번호 — NOT NULL
- 여신스케줄유형 (Loan Schedule Type) — varchar2(2)
- 여신원장상태 (Loan Table Status) — varchar2(2)
- 고객번호 (Customer Number) — number
- 상환계획시작일자 (Repayment Plan Start Date) — varchar2(8)
- 상환계획종료일자 (Repayment Plan Close Date) — varchar2(8)
승인원장 (Untitled8)
- 승인번호 (Approval Number) — varchar2(12) — 기본 키 — NOT NULL
- 승인일련번호 (Approval Serial) — number
- 여신신청번호 (Loan Application Number) — varchar2(12) — 외래 키 → 여신신청.여신신청번호 — NOT NULL
- 승인진행상태코드 (Approval Progress Status Code) — varchar2(2)
- 여신상품코드 (Loan Product Code) — varchar2(10)
- 승인일자 (Approval Date) — varchar2(8)
- 승인금액 (Approval Amount) — number
- 이율종류코드 (Interest Rate Kind Code) — varchar2(3)
- 금리기간코드 (Interest Rate Term Code) — varchar2(5)
- 승인이율 (Approval Interest Rate) — number
- 여신실행여부 (Loan Execute YN) — number
- 여신실행일자 (Loan Execute Date) — varchar2(8)
- 여신한도번호 (Loan Limit Number) — varchar2(12)
- 여신한도유형 (Loan Limit Type) — varchar2(2)
- 여신만기일자 (Loan Due Date) — varchar2(8)
실행적용이율내역 (Untitled5)
- 이율변경일련번호 (Interest Rate Change Serial) — number — 기본 키 — NOT NULL
- 여신실행번호 (Loan Execute Number2) — number — 외래 키 → 여신실행.여신실행번호 — NOT NULL
- 여신계좌번호 (Loan Account Number2) — varchar2(12) — 외래 키 → 여신실행.여신계좌번호 — NOT NULL
- 실행이율변경일자 (Execute Interest Rate Change Date) — varchar2(8)
- 가산금리 (Additional Interest Rate) — number
- 적용금리 (Apply Interest Rate) — number
- 이율종류코드 (Interest Kind Code) — varchar2(3)
- 여신금리고정변동구분 (Loan Interest Fix Floating Division) — varchar2(2)
- 금리기간코드 (Interest Rate Term Code) — varchar2(5)
여신신청 (Untitled13)
- 여신신청번호 (Loan Application Number) — varchar2(12) — 기본 키 — NOT NULL
- 고객번호 (Customer Number2) — number — 외래 키 → 고객.고객번호 — NOT NULL
- 신청구분 (Application Division) — varchar2(2)
- 여신신청금액 (Loan Application Amount) — number
- 상품코드 (Product Code) — varchar2(10)
- 여신한도유형 (Loan Limit Type) — varchar2(2)
- 여신신청일자 (Loan Application Date) — varchar2(8)
여신실행 (Untitled3)
- 여신실행번호 (Loan Execute Number) — number — 기본 키 — NOT NULL
- 여신계좌번호 (Loan Account Number2) — varchar2(12) — 외래 키 → 여신약정.여신계좌번호 — NOT NULL
- 여신계좌상태 (Loan Account Status) — varchar2(2)
- 상품코드 (Product Code) — varchar2(10)
- 여신실행일자 (Loan Execute Date) — varchar2(8)
- 실행만기일자 (Execute Due Date) — varchar2(8)
- 여신실행금액 (Loan Execute Amount) — number
- 금리고정변동구분 (Interest Fix Floating Division) — varchar2(2)
- 이율종류코드 (Interest Rate Kind Code) — varchar2(3)
- 적용금리 (Apply Interest Rate) — number
- 가산금리 (Additional Interest Rate) — number
- 여신상환방법 (Loan Repayment Method) — varchar2(2)
- 여신상환주기 (Loan Repayment Period) — varchar2(3)
- 여신상환주기일 (Loan Repayment Period D-Day) — varchar2(2)
- 여신완제일자 (Loan Pay-Off Date) — varchar2(8)
- 여신연체상태 (Loan Overdue Status) — varchar2(2)
- 미수이자 (Unpaid Interest) — number
- 최종이자계산일자 (Last Interest Calculation Date) — varchar2(8)
- 다음이자상환일자 (Next Interest Repayment Date) — varchar2(8)
- 휴일이자지급유형 (Holiday Interest Payment Type) — varchar2(2)
여신실행거래내역 (Untitled6)
- 거래일련번호 (Transaction Serial) — number — 기본 키 — NOT NULL
- 여신실행번호 (Loan Execute Number2) — number — 외래 키 → 여신실행.여신실행번호 — NOT NULL
- 여신계좌번호 (Loan Account Number2) — varchar2(12) — 외래 키 → 여신실행.여신계좌번호 — NOT NULL
- 여신거래종류 (Loan Transaction Kind) — varchar2(3)
- 거래일자 (Transaction Date) — varchar2(8)
- 거래합계금액 (Transaction Sum Amount) — number
- 거래원금금액 (Transaction Principal Amount) — number
- 거래이자금액 (Transaction Interest Amount) — number
- 원금연체이자금액 (Principal Overdue Interest Amount) — number
- 이자연체이자금액 (Interest Overdue Interest Amount) — number
- 상환후여신잔액 (After Repayment Loan Balance) — number
- 변경전여신상태 (Before Changing Loan Account Status) — varchar2(2)
- 변경전여신잔액 (Before Changing Loan Balance) — number
- 변경전최종이자계산일자 (Before Changing Last Interest Rate Date) — varchar2(8)
- 변경전다음이자상환일자 (Before Changing Repayment Interest Repayment Date) — varchar2(8)
- 변경전미수이자 (Before Changing Unpaid Interest) — number
- 변경전연체상태 (Before Changing Overdue Status) — varchar2(2)
여신약정 (Untitled2)
- 여신계좌번호 (Loan Account Number) — varchar2(12) — 기본 키 — NOT NULL
- 여신한도번호 (Loan Limit Number2) — varchar2(12) — 외래 키 → 여신한도.여신한도번호 — NOT NULL
- 여신계좌상태 (Loan Account Status) — varchar2(2)
- 여신약정시작일자 (Loan Commitment Start Date) — varchar2(8)
- 여신약정만기일자 (Loan Commitment Due Date) — varchar2(8)
- 여신약정금액 (Loan Commitment Amount) — number
- 여신약정잔액 (Loan Commitment Balance) — number
여신한도 (Untitled)
- 여신한도번호 (Loan Limit Number) — varchar2(12) — 기본 키 — NOT NULL
- 승인번호 (Approval Number2) — varchar2(12) — 외래 키 → 승인원장.승인번호 — NOT NULL
- 여신한도상태 (Loan Limit Status) — varchar2(2)
- 고객번호 (Customer Number) — number
- 한도시작일자 (Limit Start Date) — varchar2(8)
- 한도만기일자 (Limit Due Date) — varchar2(8)
- 여신한도금액 (Loan Limit Amount) — number
- 여신한도잔액 (Loan Limit Balance) — number
- 여신한도유형 (Loan Limit Type) — varchar2(2)
여신한도거래내역 (Untitled4)
- 거래일련번호 (Transaction Serial) — number — 기본 키 — NOT NULL
- 여신한도번호 (Loan Limit Number) — varchar2(12) — 외래 키 → 여신한도.여신한도번호 — NOT NULL
- 여신거래종류 (Loan Transaction Kind) — varchar2(3)
- 거래일자 (Transaction Date) — varchar2(8)
- 기준통화거래금액 (Standard Currency Transaction Amount) — number
- 여신한도금액 (Loan Limit Amount) — number
- 여신한도잔액 (Loan Limit Balance) — number
- 변경전여신한도상태 (Before Changing Loan Limit Status) — varchar2(2)
- 변경전여신한도금액 (Before Changing Loan Limit Amount) — number
- 변경전여신신한도잔액 (Before Changing Loan Limit Balance) — number
연체내역 (Untitled11)
- 상환예정일자 (Repayment Schedule Date) — varchar2(8) — 기본 키 — NOT NULL
- 연체일련번호 (Overdue Serial) — number — 기본 키 — NOT NULL
- 상환계획번호 (Repayment Plan Number2) — varchar2(12) — 외래 키 → 상환스케쥴.상환계획번호 — NOT NULL
- 상환계획일련번호 (Repayment Plan Serial Number2) — number — 외래 키 → 상환스케쥴.상환계획일련번호 — NOT NULL
- 연체기준금액 (Overdue Standard Amount) — number
- 연체시작일자 (Overdue Start Date) — varchar2(8)
- 연체종료일자 (Overdue End Date) — varchar2(8)
- 여신연체상태 (Loan Overdue Status) — varchar2(2)
- 연체이자 (Overdue Interest) — number
- 상환연체이자 (Repayment Overdue Interest) — number