트러스톤

테이블 (12)

ETF_INFO (Untitled3)

  • TICKER (Key) — varchar(50) — 기본 키 — NOT NULL
  • SHORT_NM (Field) — varchar(30) — NOT NULL
  • LONG_NM (Field2) — varchar(100) — NOT NULL
  • KR_NM (Field3) — varchar(100)

INDEX_DATA_BB (Untitled)

  • BASEDATE (Key) — date — 기본 키 — NOT NULL
  • VALUE_NM (Key2) — varchar(50) — 기본 키 — NOT NULL
  • TICKER (Key3) — varchar(50) — 외래 키 → INDEX_INFO.TICKER — NOT NULL
  • RELEASE_DT (Field4) — date
  • ECO_FUTURE_RELEASE_DATE (Field) — date
  • VALUE (Field2) — float

INDEX_INFO (Untitled2)

  • TICKER (Key) — varchar(50) — 기본 키 — NOT NULL
  • SHORT_NAME (Field) — varchar(50)
  • NAME (Field2) — varchar(50) — NOT NULL
  • NAME_KOREAN (Field3) — varchar(100)
  • NAME_DISPLAY (Field4) — varchar(50)

dbo (DATA_UETF_BB)

  • ID (Key) — varchar(50) — 기본 키 — NOT NULL
  • TICKER (Field1) — varchar(20) — NOT NULL
  • BASEDATE (Field2) — date
  • PX_LAST (Field3) — float
  • FUND_NET_ASSET_VAL (Field4) — float
  • FUND_FLOW (Field5) — float

dbo (DATA_INDEX_BB)

  • ID (Key) — varchar(50) — 기본 키 — NOT NULL
  • TICKER (Field) — varchar(50)
  • BASEDATE (Field2) — date
  • PX_LAST (Field3) — float
  • PR893 (Field4) — float

dbo (DATA_MACRO_BB)

  • ID (Field) — varchar(50) — NOT NULL
  • TICKER (Field2) — varchar(max)
  • BASEDATE (Field3) — date
  • PX_LAST (Field4) — float

dbo (DATA_UETF_FS)

  • ID (Key) — varchar(50) — 기본 키 — NOT NULL
  • TICKER (Field) — varchar(max)
  • BASEDATE (Field2) — date
  • PX_LAST (Field3) — float
  • Closing (Field4) — float
  • Dividend (Field5) — float

dbo (DATA_KETF_FS)

  • ID (Key) — varchar(50) — 기본 키 — NOT NULL
  • TICKER (Field) — varchar(max)
  • BASEDATE (Field2) — date
  • PX_LAST (Field3) — foat
  • Closing (Field4) — float
  • Dividend (Field5) — foat

dbo (UNIV_MASTER)

  • AA_JM_ID (Key) — varchar(60) — 기본 키 — NOT NULL
  • UPDT_DT (Key2) — date — 기본 키 — NOT NULL
  • AA_ASSET_ID (Field) — varchar(MAX)
  • AC_CTGR_LV1_CD (Field2) — varchar(MAX)
  • AC_CTGR_LV2_CD (Field3) — varchar(MAX)
  • AC_CTGR_LV3_CD (Field4) — varchar(MAX)
  • AC_CTGR_LV4_CD (Field5) — varchar(MAX)
  • AC_CTGR_LV5_CD (Field6) — varchar(MAX)
  • AC_CTGR_LV6_CD (Field7) — varchar(MAX)
  • AC_CTGR_LV7_CD (Field8) — varchar(MAX)
  • AC_CTGR_LV8_CD (Field9) — varchar(MAX)
  • AC_CTGR_LV9_CD (Field10) — varchar(MAX)
  • AC_CTGR_LV10_CD (Field11) — varchar(MAX)
  • AC_CTGR_LV11_CD (Field12) — varchar(MAX)
  • AC_CTGR_LV12_CD (Field13) — varchar(MAX)
  • AC_CTGR_LV13_CD (Field14) — varchar(MAX)
  • AC_CTGR_LV14_CD (Field15) — varchar(MAX)
  • AC_CTGR_LV15_CD (Field16) — varchar(MAX)

dbo (STRG_HRP_MODEL_BT)

  • ID (Key) — varchar(50 — 기본 키 — NOT NULL
  • BaseDate (Field) — date
  • TICKER (Field2) — varchar(max)
  • HRP_WT (Field3) — float
  • DIC_WT (Field4) — float

dbo (Z_HRP_MODEL_WT)

  • ID (Key) — varchar(50) — 기본 키 — NOT NULL
  • TICKER (Field4) — varchar(max)
  • BaseDate (Field) — date
  • WEIGHT (Field2) — float
  • CD (Field3) — varchar(max)

dbo (UNIV_FILTER2)

  • TICKER (Key) — varchar(50) — 기본 키 — NOT NULL
  • LV_0 (Field) — varchar(max)
  • LV_1 (Field2) — varchar(max)
  • LV_2 (Field3) — varchar(max)
  • LV_3 (Field4) — varchar(max)
  • LV_4 (Field5) — varchar(max)
  • LV_5 (Field6) — varchar(max)
  • LV_6 (Field7) — varchar(max)
  • LV_7 (Field8) — varchar(max)
  • LV_8 (Field9) — varchar(max)
  • LV_9 (Field10) — varchar(max)
  • LV_10 (Field11) — varchar(max)
  • LV_11 (Field12) — varchar(max)
  • LV_12 (Field13) — varchar(max)