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)