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