ELS-ERD

Tables (19)

C_KAP_SOURCING_PRODUCT_MAPPING

  • KAPProductDefineID — varchar(12) — Foreign key → M_KAPPRODUCT_LIST.KAPProductDefineID — NOT NULL — KAP상품정의ID
  • SourcingCompanyID — varchar(6) — Foreign key → M_SOURCING_PRODUCT_LIST.SourcingCompanyID — NOT NULL — 조달사ID
  • SourcingProductDefineID — varchar(8) — Foreign key → M_SOURCING_PRODUCT_LIST.SourcingProductDefineID — NOT NULL — 조달상품정의ID
  • UsingTable_1 — varchar(256)
  • UsingTable_2 — varchar(256)
  • UsingTable_3 — varchar(256)
  • Memo — varchar(256) — 비고
  • InputUserID — varchar(24) — NOT NULL — 입력사용자ID
  • InputDateTime — varchar(16) — NOT NULL — 입력일시
  • InputIP — varchar(15) — 입력IP

M_BIDDING_COMPANY

  • IssuerCompanyID — varchar(6) — Primary key — NOT NULL — 발행사ID
  • SourcingProductID — varchar(15) — Foreign key → M_SOURCING_PRODUCT_TENDER_REG.SourcingProductID — NOT NULL — 조달상품ID
  • SourcingCompanyID (SourcingCompanyID2) — varchar(6) — Foreign key → M_SOURCING_PRODUCT_TENDER_REG.SourcingCompanyID — NOT NULL — 조달사ID
  • TenderPossibleYN — varchar(1) — 참여가능여부
  • InputUserID — varchar(24) — NOT NULL — 입력사용자ID
  • InputDateTime — varchar(16) — NOT NULL — 입력일시
  • InputIP — varchar(15) — 입력IP

M_BIDDING_INFO

  • IssuerCompanyID — varchar(6) — Foreign key → M_BIDDING_COMPANY.IssuerCompanyID — NOT NULL — 발행사ID
  • SourcingProductID — varchar(15) — Foreign key → M_BIDDING_COMPANY.SourcingProductID — NOT NULL — 조달상품ID
  • SourcingCompanyID — varchar(6) — Foreign key → M_BIDDING_COMPANY.SourcingCompanyID — NOT NULL — 조달사ID
  • ProposePrice — decimal(6, 3) — 제안가격
  • SetLimitAmout — decimal(18, 0) — NOT NULL — 설정한도금액
  • SubmitStdCode — varchar(256) — NOT NULL — 제출기준코드
  • SubmitStdOfferCondition — varchar(128) — NOT NULL — 제출기준제시조건
  • BiddingCancelYN — varchar(1) — 응찰취소여부
  • BiddingCancelDateTime — varchar(16) — 응찰취소일시
  • InputUserID — varchar(24) — NOT NULL — 입력사용자ID
  • InputDateTime — varchar(16) — NOT NULL — 입력일시
  • InputIP — varchar(15) — 입력IP

M_BIDDING_SUCCBID

  • IssuerCompanyID (IssuerCompanyID2) — varchar(6) — Foreign key → M_BIDDING_INFO.IssuerCompanyID — NOT NULL — 발행사ID
  • SourcingProductID (SourcingProductID2) — varchar(15) — Foreign key → M_BIDDING_INFO.SourcingProductID — NOT NULL — 조달상품ID
  • SourcingCompanyID (SourcingCompanyID2) — varchar(6) — Foreign key → M_BIDDING_INFO.SourcingCompanyID — NOT NULL — 조달사ID
  • SuccessDate — varchar(8) — NOT NULL — 낙찰일
  • SourcingPossibleAmout — decimal(18, 0) — NOT NULL — 조달확정금액
  • SuccessReason — varchar(512) — 낙찰사유
  • SuccessFixYN — varchar(1) — 낙찰확정
  • InputUserID — varchar(24) — NOT NULL — 입력사용자ID
  • InputDateTime — varchar(16) — NOT NULL — 입력일시
  • InputIP — varchar(15) — 입력IP
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

M_ISSUE_PRODUCT_INFO

  • IssueProductID — varchar(12) — Primary key — NOT NULL — 발행상품ID
  • IssuerCompanyID — varchar(6) — Foreign key → M_BIDDING_SUCCBID.IssuerCompanyID — NOT NULL — 발행사ID
  • SourcingProductID — varchar(15) — Foreign key → M_BIDDING_SUCCBID.SourcingProductID — NOT NULL — 조달상품ID
  • SourcingCompanyID — varchar(6) — Foreign key → M_BIDDING_SUCCBID.SourcingCompanyID — NOT NULL — 조달사ID
  • SourcingProductDefineID — varchar(8) — NOT NULL — 조달상품정의ID
  • IssueProductName — varchar(256) — 발행상품명
  • IssueXth — varchar(6) — 발행회차
  • SubscriptNoticeDate — varchar(8) — 청약공고일
  • SubscriptStartDate — varchar(8) — 청약시작일
  • SubscriptEndDate — varchar(8) — 청약종료일
  • SubscriptEndTime — varchar(4) — 청약종료시각
  • TradeDate — varchar(8) — 거래일
  • IssueDate — varchar(8) — 발행일
  • IssueCurrencyID — varchar(3)
  • DueDate — varchar(8) — 만기일
  • DueMonthCount — int — 만기개월수
  • DueStepmonth — varchar(2) — 상환주기
  • UnderlyingBasisDate — varchar(8) — 기초자산기준가결정일
  • UnderlyingID_1 — varchar(20) — 기초자산ID1
  • UnderlyingID_2 — varchar(20) — 기초자산ID2
  • UnderlyingID_3 — varchar(20) — 기초자산ID3
  • UnderlyingID_4 — varchar(20) — 기초자산ID4
  • UnderlyingID_5 — varchar(20) — 기초자산ID5
  • ExerciseStructure — varchar(80) — 행사구조
  • MonthCouponBarrier — decimal(4, 0) — 월쿠폰베리어
  • KnockType — varchar(2) — 낙유형
  • KnockBarrier — decimal(4, 0) — 낙베리어
  • CouponRate — decimal(7, 4) — 연지급금리
  • ShortCutProductId — varchar(15) — 쇼컷ProductID
  • ProposePrice — decimal(6, 3) — 제안가격
  • MaxIssueAmount — decimal(18, 0) — 최대발행금액
  • LastlIssueAmount — decimal(18, 0) — 최종발행금액
  • ParticipationRate — decimal(7, 4) — 참여율
  • AddRedemtionConditionNo — varchar(256) — 추가상환조건행사회차
  • AddRedemtionCondition — varchar(256) — 추가상환조건
  • AddANNPayInterest — decimal(7, 4) — 추가연지급금리
  • DummyCouponRate — decimal(7, 4) — 더미쿠폰
  • MoniteringMethodCode — varchar(1)
  • KRCODE — varchar(12) — 표준코드
  • DeleteYN — varchar(1) — 삭제여부
  • Memo — varchar(512) — 메모
  • InputUserID — varchar(24) — NOT NULL — 입력사용자ID
  • InputDateTime — varchar(16) — NOT NULL — 입력일시
  • InputIP — varchar(15) — 입력IP

M_ISSUE_PRODUCT_PAYMENT

  • ExerMonth — int — Primary key — NOT NULL — 행사월
  • IssueProductID — varchar(12) — Foreign key → M_ISSUE_PRODUCT_INFO.IssueProductID — NOT NULL — 발행상품ID
  • IssuerCompanyID — varchar(6) — NOT NULL — 발행사ID
  • ExerXth — int — 행사순서
  • ExerDate — varchar(8) — 관찰일
  • PayDate — varchar(8) — 지급일
  • TrustPayDate — varchar(8) — 신탁지급일
  • AddPayInterest — decimal(7, 4) — 지급금리
  • InputUserID — varchar(24) — NOT NULL — 입력사용자ID
  • InputDateTime — varchar(16) — NOT NULL — 입력일시
  • InputIP — varchar(15) — 입력IP

M_ISSUE_PRODUCT_REDEMTION

  • ExerMonth — int — Primary key — NOT NULL — 행사월
  • IssueProductID — varchar(12) — Foreign key → M_ISSUE_PRODUCT_INFO.IssueProductID — NOT NULL — 발행상품ID
  • IssuerCompanyID — varchar(6) — NOT NULL — 발행사ID
  • ExerXth — int — NOT NULL — 행사회차
  • ExerciseBarrier — decimal(7, 4) — NOT NULL — 행사베리어
  • ExerDate — varchar(8) — 행사일
  • PayDate — varchar(8) — 지급일
  • TrustPayDate — varchar(8) — 신탁지급일
  • PayInterest — decimal(7, 4) — 지급금리
  • InputUserID — varchar(24) — NOT NULL — 입력사용자ID
  • InputDateTime — varchar(16) — NOT NULL — 입력일시
  • InputIP — varchar(15) — 입력IP

M_ISSUE_PRODUCT_REDEMTION_ADD

  • ExerMonth — int — Primary key — NOT NULL — 행사월
  • IssueProductID — varchar(12) — Foreign key → M_ISSUE_PRODUCT_INFO.IssueProductID — NOT NULL — 발행상품ID
  • IssuerCompanyID — varchar(6) — NOT NULL — 발행사ID
  • ExerDate — varchar(8) — 행사일
  • PayDate — varchar(8) — 지급일
  • TrustPayDate — varchar(8) — 신탁지급일
  • AddExerXth — int — 추가상환조건회차
  • MoniteringMethodCode — varchar(1) — 관찰방법코드
  • AddExecBarrier — decimal(7, 4) — 추가행사베리어
  • AddPayInterest — decimal(7, 4) — 추가지급금리
  • InputUserID — varchar(24) — NOT NULL — 입력사용자ID
  • InputDateTime — varchar(16) — NOT NULL — 입력일시
  • InputIP — varchar(15) — 입력IP

M_ISSUE_PRODUCT_UNDERLYING_PRICE

  • UnderlyingID — varchar(20) — Primary key — NOT NULL — 기초자산ID
  • IssueProductID — varchar(12) — Foreign key → M_ISSUE_PRODUCT_INFO.IssueProductID — NOT NULL — 발행상품ID
  • IssuerCompanyID — varchar(6) — NOT NULL — 발행사ID
  • UnderlyingBasisPrice — decimal(20, 8) — 기준가격
  • Seq — varchar(4) — Seq
  • InputUserID — varchar(24) — NOT NULL — 입력사용자ID
  • InputDateTime — varchar(16) — NOT NULL — 입력일시
  • InputIP — varchar(15) — 입력IP

M_KAPPRODUCT_LIST

  • KAPProductDefineID — varchar(12) — Primary key — NOT NULL — KAP상품정의ID
  • KAPProductName — varchar(40) — NOT NULL — KAP상품명
  • LargeCategoryCode — varchar(3) — NOT NULL — 대분류코드
  • MiddleCategoryCode — varchar(3) — NOT NULL — 중분류코드
  • SmallCategoryCode — varchar(4) — NOT NULL — 소분류코드
  • KnockType — varchar(2) — NOT NULL — 낙유형
  • UseYN — varchar(1) — 사용여부
  • Memo — varchar(256) — 비고
  • InputUserID — varchar(24) — 입력사용자ID
  • InputDateTime — varchar(16) — 입력일시
  • InputIP — varchar(15) — 입력IP
  • STATISTICS_NORECOMPUTE — =
  • IGNORE_DUP_KEY — =
  • ALLOW_ROW_LOCKS — =
  • ALLOW_PAGE_LOCKS — =

M_KAPPRODUCT_OPTIONS

  • Seq — int — Primary key — NOT NULL — 순번
  • KAPProductDefineID — varchar(12) — Foreign key → M_KAPPRODUCT_LIST.KAPProductDefineID — NOT NULL — KAP상품정의ID
  • KAPOptionID — varchar(12) — NOT NULL — KapOptionID
  • UseYN — varchar(1) — 사용여부
  • Memo — varchar(256) — 비고
  • InputUserID — varchar(24) — 입력사용자ID
  • InputDateTime — varchar(16) — 입력일시
  • InputIP — varchar(15) — 입력IP

M_KAP_PRODUCT_DEFAULTVALUE

  • TargetColumnName — varchar(256) — Primary key — NOT NULL — 대상컬럼명
  • KAPProductDefineID — varchar(12) — Foreign key → M_KAPPRODUCT_LIST.KAPProductDefineID — NOT NULL — KAP상품정의ID
  • Seq — varchar(4) — 순번
  • ColumnDisplayName — varchar(256) — 컬럼표시명
  • PreProcessEquation — varchar(512) — 사전처리수식
  • DefaultSetValue — varchar(256) — 기본설정값
  • AfterProcessEquation — varchar(512) — 사후처리수식
  • UseYN — varchar(1) — 사용여부
  • Memo — varchar(256) — 비고
  • InputUserID — varchar(24) — NOT NULL — 입력사용자ID
  • InputDateTime — varchar(16) — NOT NULL — 입력일시
  • InputIP — varchar(15) — 입력IP

M_PROPOSE_PRODUCT_INFO

  • ProposeProductID — varchar(15) — Primary key — NOT NULL — 제안상품ID
  • SourcingCompanyID — varchar(6) — Foreign key → M_SOURCING_PRODUCT_LIST.SourcingCompanyID — NOT NULL — 조달사ID
  • SourcingProductDefineID — varchar(8) — Foreign key → M_SOURCING_PRODUCT_LIST.SourcingProductDefineID — NOT NULL — 조달상품정의ID
  • IssuerCompanyID — varchar(6) — NOT NULL — 제안발행사ID
  • ProposeProductName — varchar(256) — 제안상품명
  • IssueCurrencyID — varchar(3) — 발행통화
  • DueMonthCount — int — 만기개월수
  • DueStepmonth — varchar(2) — 상환주기
  • UnderlyingID_1 — varchar(20) — 기초자산ID1
  • UnderlyingID_2 — varchar(20) — 기초자산ID2
  • UnderlyingID_3 — varchar(20) — 기초자산ID3
  • UnderlyingID_4 — varchar(20) — 기초자산ID4
  • UnderlyingID_5 — varchar(20) — 기초자산ID5
  • ExerciseStructure — varchar(80) — 행사구조
  • MonthCouponBarrier — decimal(4, 0) — 월쿠폰베리어
  • KnockType — varchar(2) — 낙유형
  • KnockBarrier — decimal(4, 0) — 낙베리어
  • CouponRate — decimal(7, 4) — 연지급금리
  • OfferPrice — decimal(6, 3) — 제안가격
  • MaxIssueAmount — decimal(18, 0) — 최대발행금액
  • ParticipationRate — decimal(7, 4) — 참여율
  • AddRedemtionConditionNo — varchar(256) — 추가상환조건행사회차
  • AddRedemtionCondition — varchar(256) — 추가상환조건
  • AddANNPayInterest — decimal(7, 4) — 추가연지급금리
  • DummyCouponRate — decimal(7, 4) — 더미쿠폰
  • MoniteringMethodCode — varchar(1)
  • OfferRegDate — varchar(8) — 제안등록일
  • OfferEndDate — varchar(8) — 제안마감일
  • Memo — varchar(512) — 제안요청사항
  • DeleteYN — varchar(1)
  • ProposeNo — varchar(40) — 제안상품No
  • InputUserID — varchar(24) — NOT NULL — 입력사용자ID
  • InputDateTime — varchar(16) — NOT NULL — 입력일시
  • InputIP — varchar(15) — 입력IP

M_SOURCING_PRODUCT_DEFAULTVALUE

  • TargetColumnName — varchar(256) — Primary key — NOT NULL — 대상컬럼명
  • Key — Primary key — NOT NULL — 순번
  • SourcingCompanyID — varchar(6) — Foreign key → M_SOURCING_PRODUCT_LIST.SourcingCompanyID — NOT NULL — 조달사ID
  • SourcingProductDefineID — varchar(8) — Foreign key → M_SOURCING_PRODUCT_LIST.SourcingProductDefineID — NOT NULL — 조달상품정의ID
  • ColumnDisplayName — varchar(256) — 컬럼표시명
  • PreProcessEquation — varchar(512)
  • DefaultSetValue — varchar(256) — 기본설정값
  • AfterProcessEquation — varchar(512)
  • UseYN — varchar(1)
  • Memo — varchar(256) — 비고
  • InputUserID — varchar(24) — NOT NULL — 입력사용자ID
  • InputDateTime — varchar(16) — NOT NULL — 입력일시
  • InputIP — varchar(15) — 입력IP

M_SOURCING_PRODUCT_DEFINE_SUBMIT_STD

  • SourcingCompanyID — varchar(6) — Foreign key → M_SOURCING_PRODUCT_LIST.SourcingCompanyID — NOT NULL — 조달사ID
  • SourcingProductDefineID — varchar(8) — Foreign key → M_SOURCING_PRODUCT_LIST.SourcingProductDefineID — NOT NULL — 조달상품정의ID
  • SubmitStdCode — varchar(2) — NOT NULL — 제출기준코드
  • UseYN — varchar(1) — 사용여부
  • Memo — varchar(256) — 비고
  • InputUserID — varchar(24) — NOT NULL — 입력사용자ID
  • InputDateTime — varchar(16) — NOT NULL — 입력일시
  • InputIP — varchar(15) — 입력IP

M_SOURCING_PRODUCT_INFO

  • SourcingProductID — varchar(15) — Primary key — NOT NULL — 조달상품ID
  • ProposeProductID — varchar(15) — Foreign key → M_PROPOSE_PRODUCT_INFO.ProposeProductID — NOT NULL — 제안상품ID
  • SourcingCompanyID — varchar(6) — Foreign key → M_PROPOSE_PRODUCT_INFO.SourcingCompanyID — NOT NULL — 조달사ID
  • SourcingProductDefineID — varchar(8) — NOT NULL — 조달상품정의ID
  • SourcingProductName — varchar(256) — 조달상품명
  • IssueCurrencyID — varchar(3) — 발행통화
  • DueMonthCount — int — 만기개월수
  • DueStepmonth — varchar(2) — 상환주기
  • UnderlyingID_1 — varchar(20) — 기초자산ID1
  • UnderlyingID_2 — varchar(20) — 기초자산ID2
  • UnderlyingID_3 — varchar(20) — 기초자산ID3
  • UnderlyingID_4 — varchar(20) — 기초자산ID4
  • UnderlyingID_5 — varchar(20) — 기초자산ID5
  • ExerciseStructure — varchar(80) — 행사구조
  • MonthCouponBarrier — decimal(4, 0) — 월쿠폰베리어
  • KnockType — varchar(2) — 낙유형
  • KnockBarrier — decimal(4, 0) — 낙베리어
  • CouponRate — decimal(7, 4) — 연지급금리
  • ProposePrice — decimal(6, 3) — 제안가격
  • MaxIssueAmount — decimal(18, 0) — 최대발행금액
  • ParticipationRate — decimal(7, 4) — 참여율
  • AddRedemtionConditionNo — varchar(256) — 추가상환조건행사회차
  • AddRedemtionCondition — varchar(256) — 추가상환조건
  • AddANNPayInterest — decimal(7, 4) — 추가연지급금리
  • DummyCouponRate — decimal(8, 4)
  • MoniteringMethodCode — varchar(1)
  • SourcingRegDate — varchar(8) — 조달등록일
  • ProposeCompanyID — varchar(6) — NOT NULL — 제안발행사ID
  • ProposeUserID — varchar(24) — NOT NULL — 제안사용자ID
  • DeleteYN — varchar(1) — 삭제여부
  • Memo — varchar(256)
  • InputUserID — varchar(24) — NOT NULL — 입력사용자ID
  • InputDateTime — varchar(16) — NOT NULL — 입력일시
  • InputIP — varchar(15) — 입력IP

M_SOURCING_PRODUCT_LIST

  • SourcingCompanyID — varchar(6) — Primary key — NOT NULL — 조달사ID
  • SourcingProductDefineID — varchar(8) — Primary key — NOT NULL — 조달상품정의ID
  • Seq — varchar(4) — 순번
  • SourcingProductName — varchar(256) — NOT NULL — 조달사상품명
  • UseYN — varchar(1) — 사용여부
  • Memo — varchar(256) — 비고
  • InputUserID — varchar(24) — NOT NULL — 입력사용자ID
  • InputDateTime — varchar(16) — NOT NULL — 입력일시
  • InputIP — varchar(15) — 입력IP

M_SOURCING_PRODUCT_TENDER_REG

  • SourcingProductID — varchar(15) — Foreign key → M_TENDER_PRODUCT_INFO.SourcingProductID — NOT NULL — 조달상품ID
  • SourcingCompanyID — varchar(6) — Foreign key → M_TENDER_PRODUCT_INFO.SourcingCompanyID — NOT NULL — 조달사ID
  • TenderStartDate — varchar(8) — 입찰시작일시
  • TenderEndDate — varchar(16) — 입찰마감일시
  • TenderType — varchar(1) — 입찰방식
  • TenderTarget — varchar(1) — 입찰대상
  • CollectMaxLimitAmount — decimal(18, 0) — 모집한도금액
  • TenderCancelYN — varchar(1) — 입찰취소여부
  • TenderCancelDateTime — varchar(16) — 입찰취소일시
  • TenderStatus — varchar(1) — 입찰상태
  • TenderConfirmDateTime — varchar(16) — 낙찰확정일시
  • SuccableReason — varchar(512) — 낙찰될만한조건
  • SubscriptStartDate — varchar(8) — 청약시작일
  • SubscriptEndDate — varchar(8) — 청약종료일
  • TenderCouponRate — decimal(7, 4) — 입찰쿠폰금리
  • TenderProposePrice — decimal(6, 3) — 입찰제안가
  • InputUserID — varchar(24) — NOT NULL — 입력사용자ID
  • InputDateTime — varchar(16) — NOT NULL — 입력일시
  • InputIP — varchar(15) — 입력IP

M_TENDER_PRODUCT_INFO

  • SourcingProductID — varchar(15) — Foreign key → M_SOURCING_PRODUCT_INFO.SourcingProductID — NOT NULL — 조달상품ID
  • SourcingCompanyID — varchar(6) — Foreign key → M_SOURCING_PRODUCT_INFO.SourcingCompanyID — NOT NULL — 조달사ID
  • SourcingProductDefineID — varchar(8) — NOT NULL — 조달상품정의ID
  • TenderProductName — varchar(256) — 입찰상품명
  • IssueCurrencyID — varchar(3)
  • DueMonthCount — int — 만기개월수
  • DueStepmonth — varchar(2) — 상환주기
  • UnderlyingID_1 — varchar(20) — 기초자산ID1
  • UnderlyingID_2 — varchar(20) — 기초자산ID2
  • UnderlyingID_3 — varchar(20) — 기초자산ID3
  • UnderlyingID_4 — varchar(20) — 기초자산ID4
  • UnderlyingID_5 — varchar(20) — 기초자산ID5
  • ExerciseStructure — varchar(80) — 행사구조
  • MonthCouponBarrier — decimal(4, 0) — 월쿠폰베리어
  • KnockType — varchar(2) — 낙유형
  • KnockBarrier — decimal(4, 0) — 낙베리어
  • CouponRate — decimal(7, 4) — 연지급금리
  • ProposePrice — decimal(6, 3) — 제안가격
  • MaxIssueAmount — decimal(18, 0) — 최대발행금액
  • ParticipationRate — decimal(7, 4) — 참여율
  • AddRedemtionConditionNo — varchar(256) — 추가상환조건행사회차
  • AddRedemtionCondition — varchar(256) — 추가상환조건
  • AddANNPayInterest — decimal(7, 4) — 추가연지급금리
  • DummyCouponRate — decimal(7, 4) — 더미쿠폰
  • SourcingRegDate — varchar(8) — 조달등록일
  • ProposeCompanyID — varchar(6) — NOT NULL — 제안발행사ID
  • ProposeUserID — varchar(24) — NOT NULL — 제안사용자ID
  • ProposeProductID — varchar(15) — NOT NULL — 제안상품ID
  • DeleteYN — varchar(1) — 삭제여부
  • Memo — varchar(256) — 메모
  • InputUserID — varchar(24) — NOT NULL — 입력사용자ID
  • InputDateTime — varchar(16) — NOT NULL — 입력일시
  • InputIP — varchar(15) — 입력IP