rudolph

Tables (12)

BANNER (Untitled5)

  • BANNER_ID (Key) — Primary key — NOT NULL
  • ADMIN_ID (Key2) — Foreign key → admin_user.ADMIN_ID — NOT NULL
  • TYPE (Field)
  • LINK (Field2)
  • NEW_WINDOW (Field3)
  • FILE_ID (Field4)
  • IS_VIEW (Field5)
  • ORDER_NO (Field6)
  • ADMIN_ID (Field7)

CONCENSUS_HIT (Untitled10)

  • TRD_DD (Key) — Primary key — NOT NULL
  • CP_ID (Field)
  • ISU_SRT_CD (Field2)
  • HIT_D1 (Field3)
  • HIT_D3 (Field4)
  • HIT_D5 (Field5)
  • HIT_D10 (Field6)
  • HIT_SUM (Field7)
  • HIT_20 (Field8)
  • HIT_COUNT (Field9)
  • MIS_COUNT (Field10)

COUPON (Untitled7)

  • COUPON_ID (Key) — Primary key — NOT NULL
  • ADMIN_ID (Key2) — Foreign key → admin_user.ADMIN_ID — NOT NULL
  • COUPON_GB (Field)
  • COUPON_TYPE (Field2)
  • COUPON_NAME (Field3)
  • USER_ID (Field4)
  • CP_ID (Field5)
  • START_DT (Field6)
  • END_DT (Field7)
  • IS_USE (Field8)
  • DAYS (Field9)
  • ORDER_ID (Field10)

MASTER_TMP (Untitled9)

  • ISU_SRT_CD (Key) — Primary key — NOT NULL
  • MKT_CD (Field)
  • TRD_DD (Field2)
  • ISU_KOR_ABBRV (Field3)
  • LIST_SHRS (Field4)
  • BAS_PRC (Field5)
  • PREVDD_CLSPRC (Field6)
  • MKTCAP_SCALE_CD (Field7)
  • ADJ_STKPRC_CALC_YN (Field8)
  • HALT_YN (Field9)
  • ARRANTRD_YN (Field10)

MK_CATEGORY (Untitled11)

  • CATEGORY_ID (Key) — Primary key — NOT NULL
  • TITLE (Field)
  • DP_TYPE (Field2)
  • ADMIN_ID (Field3)
  • PROC_TYPE (Field4)
  • IS_DELETE (Field5)
  • ORDER_NO (Field6)
  • T_TITLE (Field7)
  • B_TITLE (Field8)

ORDER_ERROR (Untitled12)

  • OE_ID (Key) — Primary key — NOT NULL
  • USER_ID (Field)
  • PAYMENT_CODE (Field2)
  • PURCHASE_ID (Field3)
  • PURCHASE_TOKEN (Field4)
  • ORDER_TYPE (Field5)
  • METHOD (Field6)
  • Field7

PORTFOLIO_STOCK (Untitled6)

  • PS_ID (Key) — Primary key — NOT NULL
  • CP_ID (Field)
  • PF_ID (Field2)
  • BUY_PRICE (Field3)
  • SELL_PRICE (Field4)
  • BUT_DT (Field5)
  • SELL_DT (Field6)
  • RATE (Field7)
  • STATUS (Field8)
  • WEIGHT (Field9)

PURCHASE_LOG (Untitled3)

  • NOTIFICATION_UUID (Field1) — Primary key — NOT NULL
  • ADMIN_ID (Key) — Foreign key → admin_user.ADMIN_ID — NOT NULL
  • NOTIFICATION_TYPE (Field)
  • SUBTYPE (Field2)
  • STATUS (Field3)
  • BUNDLE_ID (Field4)
  • ENVIRONMENT (Field5)
  • Field6
  • Field7

QnA (Untitled8)

  • QNA_ID (Key) — Primary key — NOT NULL
  • USER_ID (Field)
  • TITLE (Field2)
  • QUESTION (Field3)
  • ANSWER_YN (Field4)
  • ANSWER (Field5)
  • PHONE (Field6)
  • ADMIN_ID (Field7)
  • IS_DELETE (Field8)

RESUBSCRIBE_PURCHASE (Untitled2)

  • RP_ID (Key) — Primary key — NOT NULL
  • USER_ID (Field)
  • CP_ID (Field2)
  • PR_ID (Field3)
  • ORDER_ID (Field4)
  • SUB_ID (Field5)
  • PURCHASE_TOKEN (Field6)
  • BILLKEY (Field7)
  • PRICE (Field8)
  • IS_COMPLETE (Field9)
  • TRY_COUNT (Field10)

SUBSCRIBE (Untitled4)

  • SUB_ID (Key) — Primary key — NOT NULL
  • ORDER_ID (Field)
  • START_DT (Field2)
  • END_DT (Field3)
  • PRICE (Field4)
  • PURCHASE_ID (Field5)
  • STATUS (Field6)
  • REFUND_DT (Field7)
  • SUB_CNT (Field8)
  • KG_TRADE_ID (Field9)
  • IS_SMS (Field10)

admin_user (Untitled)

  • ADMIN_ID (Key) — Primary key — NOT NULL
  • ADMIN_PASSWORD (Field)
  • ADMIN_NAME (Field2)
  • REFRESH_TOKEN (Field3)
  • ACCESS_TOKEN (Field4)
  • AUTHORITY (Field5)
  • CP_ID (Field6)
  • IS_USE (Field7)