트러스톤
테이블 (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)