국채관리시스템_draft

테이블 (9)

Bond Code (채권 코드)

  • Sequence (ID) — integer — 기본 키 — NOT NULL
  • UUID (유일ID) — uuid — 기본 키 — NOT NULL
  • Code (코드) — varchar(n) — 기본 키 — NOT NULL
  • Bond title (채권명) — varchar(n) — 기본 키 — NOT NULL
  • CreateDate (생성날짜) — timestamp
  • UpdateDate (수정날짜) — timestamp
  • isOn (지표) — boolean
  • isOff (비지표) — boolean

Daily Bond Statistics (일별채권통계)

  • Sequence (ID) — integer — 기본 키 — NOT NULL
  • UUID (유일ID) — uuid — 기본 키 — NOT NULL
  • Code (코드) — varchar(n)
  • CreateDate (생성날짜) — timestamp
  • UpdateDate (수정날짜) — timestamp
  • Volume (거래량) — money
  • Ratio (비중) — numeric

Foreign Exchange Equilibrium Fund Bonds (외국환평형기금채권)

  • Sequence (자동증가) — integer — 기본 키 — NOT NULL
  • UUID (유일ID) — uuid — 기본 키 — NOT NULL
  • CreateDate (생성날짜) — timestamp
  • UpdateDate (수정날짜) — timestamp
  • krwAmount (원화금액) — money
  • usdAmount (외화금액) — money
  • isIssued (상환) — boolean
  • isRepayment (발행) — boolean
  • krwBalance (원화잔액) — money
  • usdBalance (외화잔액) — money

Korea Treasury Bond (국고채권)

  • Sequence (ID) — integer — 기본 키 — NOT NULL
  • UUID (유일ID) — uuid — 기본 키 — NOT NULL
  • CreateDate (생성날짜) — timestamp
  • UpdateDate (수정날짜) — timestamp
  • Amount (금액) — money
  • isIssued (상환) — boolean
  • isRepayment (발행) — boolean
  • Balance (잔액) — money

Monthly Bond Statistics (월별채권통계)

  • Sequence (ID) — integer — 기본 키 — NOT NULL
  • UUID (유일ID) — uuid — 기본 키 — NOT NULL
  • Code (코드) — varchar(n)
  • CreateDate (생성날짜) — timestamp
  • UpdateDate (수정날짜) — timestamp
  • Volume (거래량) — money
  • PublicBalance (상장잔액) — money
  • Turnover (회전율) — numeric
  • isOTC (장외) — boolean
  • isEX (장내) — boolean
  • Ratio (비중) — numeric

Performance of Issuing Bonds (국채발행실적)

  • Sequence (ID) — integer — 기본 키 — NOT NULL
  • UUID (유일ID) — uuid — 기본 키 — NOT NULL
  • CreateDate (생성날짜) — timestamp
  • UpdateDate (수정날짜) — timestamp
  • Amount (금액) — money
  • isIssued (상환) — boolean
  • isRepayment (발행) — boolean
  • Balance (잔액) — money

Swap / Early (교환/조기상환)

  • Sequence (ID) — integer — 기본 키 — NOT NULL
  • UUID (유일ID) — uuid — 기본 키 — NOT NULL
  • CreateDate (생성날짜) — timestamp
  • UpdateDate (수정날짜) — timestamp
  • Amount (금액) — money
  • isIssued (상환) — boolean
  • isRepayment (발행) — boolean
  • isTreasury (국고채) — boolean
  • isRepo (환매조건부) — boolean
  • Remark (비고) — text

Treasury Bills (재정증권)

  • Sequence (ID) — integer — 기본 키 — NOT NULL
  • UUID (유일ID) — uuid — 기본 키 — NOT NULL
  • CreateDate (생성날짜) — timestamp
  • UpdateDate (수정날짜) — timestamp
  • Amount (금액) — money
  • isIssued (상환) — boolean
  • isRepayment (발행) — boolean
  • Balance (잔액) — money

Yearly Bond Statistics (연간채권통계)

  • Sequence (ID) — integer — 기본 키 — NOT NULL
  • UUID (유일ID) — uuid — 기본 키 — NOT NULL
  • Code (코드) — varchar(n)
  • CreateDate (생성날짜) — timestamp
  • UpdateDate (수정날짜) — timestamp
  • VolumeTrend (거래량추이) — money
  • RatioTrend (비중추이) — numeric
  • Balance (잔액) — money
  • BalanceRadio (잔액비중) — numeric