QRAFT
Tables (6)
DAY_ACTIVE_STOCK_INFO (Untitled5)
- STD_DATE — VARCHAR2(8) — Primary key — NOT NULL
- S_NAME — VARCHAR(30) — Primary key
- S_STATUS_YN — NUMBER(1)
- S_DATE — VARCHAR2(8)
- E_DATE — VARCHAR2(8)
- RP_E_MONTH — NUMBER(2)
- DAY1_PRCIE (DAY1_RPICE) — NUMBER(10,2)
- STD_DEV — NUMBER(10,2)
- DAY60_PRICE — NUMBER(10,2)
- PER — NUMBER(10,2)
- RG_CH_DTTI — TIMESTAMP
DAY_INFO
- F_DATE — VARCHAR2(8) — Primary key — NOT NULL
- TXT_DAY — VARCHAR2(9)
- NUM_DAY — NUMBER(1)
- BIZ_DAY_YN — NUMBER(1)
- RG_CH_DTTI — TIMESTAMP
DAY_STOCK_HIS_PER_INFO
- STD_DATE — VARCHAR2(8) — Primary key — NOT NULL
- S_NAME — VARCHAR2(30) — Primary key
- NOTI_DATE — VARCHAR2(8) — Primary key
- F_STD_DATE — VARCHAR2(8) — Primary key
- ACC_VALUE — NUMBER(10)
- HIS_PER — NUMBER(10,2)
- RG_CH_DTTI — TIMESTAMP
FUNDAMENTAL
- NO_FMT — NUMBER(10) — Primary key — NOT NULL
- NOTI_DATE — VARCHAR2(8) — Primary key — NOT NULL
- F_STD_DATE — VARCHAR2(8) — Primary key — NOT NULL
- S_NAME — VARCHAR2(30)
- ACC_NAME — VARCHAR2(30)
- ACC_VALUE — NUMBER(10)
- RG_CH_DTTI — TIMESTAMP
META (Untitled4)
- S_NAME — VARCHAR2(30) — Primary key — NOT NULL
- S_STATUS_YN — NUMBER(1) — Primary key — NOT NULL
- S_DATE — VARCHAR2(8) — Primary key
- E_DATE — VARCHAR2(8) — Primary key
- RP_E_MONTH — NUMBER(2)
- RG_CH_DTTI — TIMESTAMP
PRICE
- U_DATE — VARCHAR2(8) — Primary key — NOT NULL
- S_NAME — VARCHAR2(30) — Primary key — NOT NULL
- PRICE — NUMBER(30)
- RG_CH_DTTI — TIMSTAMP