카뱅 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