트센
테이블 (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