트센

테이블 (16)

TB_CH01L

  • CHT_RM_ID — character — NOT NULL
  • CHT_RM_NM — character — NOT NULL
  • CHT_RM_TYPE — character — NOT NULL
  • MAX_USER_CNT — integer — NOT NULL
  • CHT_RM_PWD — character — NOT NULL
  • CHT_RM_TF — boolean — NOT NULL
  • DEL_TF — boolean — NOT NULL
  • FRST_DTTM — timestamp(6) — NOT NULL
  • LAST_DTTM — timestamp(6) — NOT NULL

TB_CH02D

  • USER_ID — character — NOT NULL
  • CHT_RM_RSTR_CD — character — NOT NULL
  • RSTR_CRTN_DTTM — timestamp(0) — NOT NULL
  • RSTR_TM — integer — NOT NULL
  • VLD_TF — boolean — NOT NULL
  • DEL_TF — boolean — NOT NULL
  • FRST_DTTM — timestamp(6) — NOT NULL
  • LAST_DTTM — timestamp(6) — NOT NULL
  • CHT_RM_ID — character — NOT NULL

TB_CH02L

  • CHT_RM_ID — character — NOT NULL
  • USER_ID — character — NOT NULL
  • CHT_RM_AUTH — character — NOT NULL
  • CHT_RM_JOIN_TF — boolean — NOT NULL
  • ENTRY_DTTM — timestamp(0) — NOT NULL
  • AUTH_CHG_DTTM — timestamp(0) — NOT NULL
  • DEL_FT — boolean — NOT NULL
  • FRST_DTTM — timestamp(6) — NOT NULL
  • LAST_DTTM — timestamp(6) — NOT NULL

TB_CH03L

  • CHT_RM_ID — character — NOT NULL
  • USER_ID — character — NOT NULL
  • MSG_SEQ — integer — NOT NULL
  • MSG — character — NOT NULL
  • DEL_TF — boolean — NOT NULL
  • FRST_DTTM — timestamp(6) — NOT NULL
  • LAST_DTTM — timestamp(6) — NOT NULL

TB_CH04L

  • USER_ID — character — NOT NULL
  • BLOCK_USER_ID — character — NOT NULL
  • ST_CD — character — NOT NULL
  • RSST_DTTM — timestamp(0) — NOT NULL
  • RELE_DTTM — timestamp(0) — NOT NULL
  • DEL_TF — boolean — NOT NULL
  • FRST_DTTM — timestamp(6) — NOT NULL
  • LAST_DTTM — timestamp(6) — NOT NULL

TB_CM01D

  • tmpId — integer — NOT NULL
  • CMMN_CD — character — NOT NULL
  • CMMN_DTL_CD — character — NOT NULL
  • CMMN_CD_NM — character — NOT NULL
  • CMMN_CD_DTL_NM — character — NOT NULL
  • DEL_TF — boolean — NOT NULL
  • FRST_DTTM — timestamp(6) — NOT NULL
  • LAST_DTTM — timestamp(6) — NOT NULL

TB_GM01D

  • GM_SRNO — character — NOT NULL
  • USER_ID — character — NOT NULL
  • GET_SCR — integer — NOT NULL
  • GM_RSLT_CD — character — NOT NULL
  • RSLT_LLVL — integer — NOT NULL
  • ENTRY_DTTM — timestamp(0) — NOT NULL
  • EXIT_DTTM — timestamp(0) — NOT NULL
  • DEL_TF — boolean — NOT NULL
  • FRST_DTTM — timestamp(6) — NOT NULL
  • LAST_DTTM — timestamp(6) — NOT NULL

TB_GM01L

  • GM_SRNO — character — NOT NULL
  • GM_STRT_DTTM — timestamp(0) — NOT NULL
  • GM_END_DTTM — timestamp(0) — NOT NULL
  • GM_TYPE — character — NOT NULL
  • END_TYPE — character — NOT NULL
  • TRGT_SCR — integer — NOT NULL
  • LV_DFCT — integer — NOT NULL
  • BGRD_IMG_PAT — character — NOT NULL
  • DEL_TF — boolean — NOT NULL
  • FRST_DTTM — timestamp(6) — NOT NULL
  • LAST_DTTM — timestamp(6) — NOT NULL

TB_GM02S

  • USER_ID — character — NOT NULL
  • TOT_RCD — integer — NOT NULL
  • TOT_VCT — integer — NOT NULL
  • TOT_DFT — integer — NOT NULL
  • LLVL — integer — NOT NULL
  • LDDR_PCENT — integer — NOT NULL
  • DEL_TF — boolean — NOT NULL
  • FRST_DTTM — timestamp(6) — NOT NULL
  • LAST_DTTM — timestamp(6) — NOT NULL

TB_GM03D

  • OPT_CD — character — NOT NULL
  • OPT_DTL_CD — character — NOT NULL
  • OPT_NM — character — NOT NULL
  • OPT_VAL — character — NOT NULL
  • DEL_TF — boolean — NOT NULL
  • FRST_DTTM — timestamp(6) — NOT NULL
  • LAST_DTTM — timestamp(6) — NOT NULL

TB_GM04L

  • USER_ID — character — NOT NULL
  • LDDR_RDY_SRNO — character — NOT NULL
  • MTCH_APLY_DTTM — timestamp(0) — NOT NULL
  • MTCH_TF — boolean — NOT NULL
  • RDDR_RDY_TF — boolean — NOT NULL
  • DEL_TF — boolean — NOT NULL
  • FRST_DTTM — timestamp(6) — NOT NULL
  • LAST_DTTM — timestamp(6) — NOT NULL
  • MTCH_USER_ID — character — NOT NULL
  • GM_SRNO — character

TB_UA01L

  • USER_ID — character — NOT NULL
  • LOGIN_SEQ — integer — NOT NULL
  • LOGIN_DTTM — timestamp(0) — NOT NULL
  • LOGOUT_DTTM — timestamp(0) — NOT NULL
  • CHT_TF — boolean — NOT NULL
  • GM_TF — boolean — NOT NULL
  • SESSION_ID — character — NOT NULL
  • LOGIN_TF — boolean — NOT NULL
  • DEL_TF — boolean — NOT NULL
  • FRST_DTTM — timestamp(6) — NOT NULL
  • LAST_DTTM — timestamp(6) — NOT NULL

TB_UA01M

  • USER_ID — character — NOT NULL
  • NICKNAME — character — NOT NULL
  • TWOFACTOR — boolean — NOT NULL
  • TWOFACTOR_DATA — character — NOT NULL
  • IMG_PATH — character — NOT NULL
  • DEL_TF — boolean — NOT NULL
  • FRST_DTTM — timestamp(6) — NOT NULL
  • LAST_DTTM — timestamp(6) — NOT NULL

TB_UA02L

  • USER_ID — character — NOT NULL
  • FR_USER_ID — character — NOT NULL
  • ST_CD — character — NOT NULL
  • RSST_DTTM — timestamp(0) — NOT NULL
  • RELE_DTTM — timestamp(0) — NOT NULL
  • DEL_TF — boolean — NOT NULL
  • FRST_DTTM — timestamp(6) — NOT NULL
  • LAST_DTTM — timestamp(6) — NOT NULL

TB_UA03D

  • USER_ID — character — NOT NULL
  • ACHV_CD — character — NOT NULL
  • ACHV_DTTM — timestamp(0) — NOT NULL
  • DEL_TF — boolean — NOT NULL
  • FRST_DTTM — timestamp(6) — NOT NULL
  • LAST_DTTM — timestamp(6) — NOT NULL

TB_UA03M

  • ACHV_CD — character — NOT NULL
  • ACHV_NM — character — NOT NULL
  • ACHV_CMT — character — NOT NULL
  • ACHV_IMG_PATH — character — NOT NULL
  • DEL_TF — boolean — NOT NULL
  • FRST_DTTM — timestamp(6) — NOT NULL
  • LAST_DTTM — timestamp(6) — NOT NULL