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