BOND

ERD_BOND

Tables (10)

BOND_CASHFLOW_M (채권현금흐름)

  • ID (채권현금흐름ID) — LONG — Primary key — NOT NULL
  • ID (채권원장ID) — LONG — Foreign key → BOND_M.ID — NOT NULL
  • sequenceNo (회차번호) — int
  • paymentDate (결제일자) — Date
  • startDate (계산시작일자) — Date
  • endDate (계산종료일자) — Date
  • interestAmount (결제금액) — BigDecimal
  • interestDays (계산일수) — int
  • baseAmount (결제기준금액) — BigDecimal
  • interestRate (적용금리) — BigDecimal
  • isFinalPayment (마지막회차여부) — boolean
  • holidayAdjusted (휴일적용여부) — boolean
  • memo (기타) — String
  • sourceType (현금흐름기준) — ENUM
  • isDeleted (삭제여부) — boolean
  • createdDate (생성일자) — Datetime
  • updatedDate (수정일자) — Datetime

BOND_CASHFLOW_M (_채권현금흐름)

  • ID (채권현금흐름ID) — LONG — Primary key — NOT NULL
  • ID (채권원장ID) — LONG — Foreign key → BOND_M.ID — NOT NULL
  • sequenceNo (회차번호) — int
  • paymentDate (결제일자) — Date
  • startDate (계산시작일자) — Date
  • endDate (계산종료일자) — Date
  • interestAmount (결제금액) — BigDecimal
  • interestDays (계산일수) — int
  • baseAmount (결제기준금액) — BigDecimal
  • interestRate (적용금리) — BigDecimal
  • isFinalPayment (마지막회차여부) — boolean
  • holidayAdjusted (휴일적용여부) — boolean
  • memo (기타) — String
  • sourceType (현금흐름기준) — ENUM
  • isDeleted (삭제여부) — boolean
  • createdDate (생성일자) — Datetime
  • updatedDate (수정일자) — Datetime

BOND_H (채권종목원장이력)

  • ID (채권원장이력ID) — LONG — Primary key — NOT NULL
  • ID (채권원장ID) — LONG — Foreign key → BOND_M.ID — NOT NULL
  • bondCode (종목코드) — String
  • issueDate (발행일자) — Date
  • maturityDate (만기일자) — Date
  • interestRate (발행금리) — BigDecimal
  • interestType (이자지급구분) — ENUM
  • interestCycleMonth (이자지급주기) — int
  • isDeleted (삭제여부) — boolean
  • createdDate (생성일자) — Datetime
  • updatedDate (수정일자) — Datetime

BOND_M (채권종목원장)

  • ID (채권원장ID) — LONG — Primary key — NOT NULL
  • bondCode (종목코드) — String
  • issueDate (발행일자) — Date
  • maturityDate (만기일자) — Date
  • interestRate (발행금리) — BigDecimal
  • interestType (이자지급구분) — ENUM
  • interestCycleMonth (이자지급주기) — int
  • isDeleted (삭제여부) — boolean
  • createdDate (생성일자) — Datetime
  • updatedDate (수정일자) — Datetime

BOND_M (_채권종목원장)

  • ID (채권원장ID) — LONG — Primary key — NOT NULL
  • bondCode (종목코드) — String
  • issueDate (발행일자) — Date
  • maturityDate (만기일자) — Date
  • interestRate (발행금리) — BigDecimal
  • interestType (이자지급구분) — ENUM
  • interestCycleMonth (이자지급주기) — int
  • isDeleted (삭제여부) — boolean
  • createdDate (생성일자) — Datetime
  • updatedDate (수정일자) — Datetime

BOND_M (__채권종목원장)

  • ID (채권원장ID) — LONG — Primary key — NOT NULL
  • bondCode (종목코드) — String
  • issueDate (발행일자) — Date
  • maturityDate (만기일자) — Date
  • interestRate (발행금리) — BigDecimal
  • interestType (이자지급구분) — ENUM
  • interestCycleMonth (이자지급주기) — int
  • isDeleted (삭제여부) — boolean
  • createdDate (생성일자) — Datetime
  • updatedDate (수정일자) — Datetime

BOND_TRADE_H (채권거래원장이력)

  • ID (채권거래이력ID) — LONG — Primary key — NOT NULL
  • ID (채권거래원장ID) — LONG — Foreign key → BOND_TRADE_M.ID — NOT NULL
  • ID (채권원장ID) — LONG — Foreign key → BOND_TRADE_M.ID — NOT NULL
  • bondCode (종목코드) — String
  • transactionDate (거래일자) — Date
  • settlementDate (결제일자) — Date
  • tradeType (거래구분) — ENUM
  • parValue (액면금액) — BigDecimal
  • bookValue (장부금액) — BigDecimal
  • unitPrice (단가) — BigDecimal
  • balance (잔액) — BigDecimal
  • isCancelled (취소여부) — Boolean
  • createdDate (생성일자) — Datetime
  • updatedDate (수정일자) — Datetime

BOND_TRADE_H (_채권거래원장이력)

  • ID (채권거래이력ID) — LONG — Primary key — NOT NULL
  • ID (채권거래원장ID) — LONG — Foreign key → BOND_TRADE_M.ID — NOT NULL
  • ID (채권원장ID) — LONG — Foreign key → BOND_TRADE_M.ID — NOT NULL
  • bondCode (종목코드) — String
  • transactionDate (거래일자) — Date
  • settlementDate (결제일자) — Date
  • tradeType (거래구분) — ENUM
  • parValue (액면금액) — BigDecimal
  • bookValue (장부금액) — BigDecimal
  • unitPrice (단가) — BigDecimal
  • balance (잔액) — BigDecimal
  • isCancelled (취소여부) — Boolean
  • createdDate (생성일자) — Datetime
  • updatedDate (수정일자) — Datetime

BOND_TRADE_M (채권거래원장)

  • ID (채권거래원장ID) — LONG — Primary key — NOT NULL
  • ID (채권원장ID) — LONG — Foreign key → BOND_M.ID — NOT NULL
  • bondCode (종목코드) — String
  • transactionDate (거래일자) — Date
  • settlementDate (결제일자) — Date
  • tradeType (거래구분) — ENUM
  • parValue (액면금액) — BigDecimal
  • bookValue (장부금액) — BigDecimal
  • unitPrice (단가) — BigDecimal
  • balance (잔액) — BigDecimal
  • isCancelled (취소여부) — Boolean
  • createdDate (생성일자) — Datetime
  • updatedDate (수정일자) — Datetime

BOND_TRADE_M (_채권거래원장)

  • ID (채권거래원장ID) — LONG — Primary key — NOT NULL
  • ID (채권원장ID) — LONG — Foreign key → BOND_M.ID — NOT NULL
  • bondCode (종목코드) — String
  • transactionDate (거래일자) — Date
  • settlementDate (결제일자) — Date
  • tradeType (거래구분) — ENUM
  • parValue (액면금액) — BigDecimal
  • bookValue (장부금액) — BigDecimal
  • unitPrice (단가) — BigDecimal
  • balance (잔액) — BigDecimal
  • isCancelled (취소여부) — Boolean
  • createdDate (생성일자) — Datetime
  • updatedDate (수정일자) — Datetime