PUSH
Tables (14)
NP_CODE
- CODE — VARCHAR(50) — Primary key — NOT NULL
- GRP_CD — VARCHAR(20) — Primary key — NOT NULL
- CODE_VAL — VARCHAR(200)
- CODE_NM — VARCHAR(200)
- CODE_DESC — VARCHAR(300)
- USE_YN — VARCHAR(1)
- REG_ID — VARCHAR(20)
- REG_DT — DATE
- UPD_DT — DATE
- UPD_ID — VARCHAR(20)
- CODE_VAL1 — VARCHAR(200)
- CODE_VAL2 — VARCHAR(200)
- CODE_VAL3 — VARCHAR(300)
- SORT_ORDER — INT
NP_CODE_GROUP
- GRP_CD — VARCHAR(20) — Primary key — NOT NULL
- GRP_NM — VARCHAR(150)
- GRP_DESC — VARCHAR(300)
- REG_ID — VARCHAR(20)
- REG_DT — DATE
- UPD_DT — DATE
- UPD_ID — VARCHAR(20)
NP_PUSH_BATCH
- BATCH_ID — BIGINT — Primary key — NOT NULL
- BATCH_TP_CD — VARCHAR(1)
- BATCH_NAME — VARCHAR(200)
- STAT_TP_CD — VARCHAR(1)
- BATCH_CNT — INT
- REG_DTM — VARCHAR(14)
- SEND_DTM — VARCHAR(14)
- RESV_YN — CHAR(1)
- RESV_SEND_DTM — VARCHAR(14)
- SENDER_ID — VARCHAR(20)
- GUBUN_CD — VARCHAR(4)
- APPROVE_ID — VARCHAR(20)
- SCHD_DELAY — INT
- SCHD_CNT — INT
- DIV_YN — CHAR(1)
- DIV_CNT — NUMBER(10)
- DIV_INTERVAL — NUMBER(10)
- DIV_SEND_DTM — VARCHAR(14)
- DIV_PROC_NUM — INT
- AD_TIME_BLOCK_YN — CHAR(1)
- AD_BLOCK_SEND_YN — CHAR(1)
- REQ_CNT — INT
- REQ_FAIL_DESC — VARCHAR(500)
- BATCH_FILE_NAME — VARCHAR(500)
NP_PUSH_CUST_BYPASS_SEND
- BYPASS_REQ_ID — BIGINT — Primary key — NOT NULL
- BYPASS_REQ_TYPE — VARCHAR(1) — NOT NULL
- PUSH_ID — VARCHAR(24) — NOT NULL
- REQ_DTM — VARCHAR(14)
- BATCH_ID — BIGINT
- SEND_REQ_ID — BIGINT
- SENDER_MSG_ID — VARCHAR(256)
- REQ_STAT_CD — VARCHAR(1)
NP_PUSH_DEVICE_HIS
- SEQ_ID — BIGINT(20) — Primary key — NOT NULL
- CUST_ID_NO — VARCHAR(128) — Primary key — NOT NULL
- APP_ID — VARCHAR(4) — NOT NULL
- DVC_UUID — VARCHAR(256)
- OS_TP — VARCHAR(1) — NOT NULL
- DVC_ID — VARCHAR(256) — NOT NULL
- PUBLIC_TOKEN — VARCHAR(256)
- OS_VER — VARCHAR(20)
- APP_VER — VARCHAR(10)
- MODEL_NO — VARCHAR(20)
- SERIAL_NO — VARCHAR(256)
- USIM_TP — VARCHAR(10)
- RCV_YN1 — VARCHAR(1)
- OPT_VAL — VARCHAR(1)
- CHANGE_DTM — VARCHAR(14)
- STAT_TP_CD — VARCHAR(1)
- RCV_YN2 — VARCHAR(1)
- RCV_YN3 — VARCHAR(2)
- RCV_YN4 — VARCHAR(1)
- RCV_YN5 — VARCHAR(1)
- LINKER_NUMBER — VARCHAR(1)
- APP_PKG — VARCHAR(256)
- CUST_SVC_ID — VARCHAR(128)
- CSUT_SVC_TP — VARCHAR(1)
NP_PUSH_DEVICE_INFO
- APP_ID — VARCHAR(4) — Primary key — NOT NULL
- CUST_ID_NO — VARCHAR(128) — Primary key — NOT NULL
- DVC_UUID — VARCHAR(256)
- OS_TP — VARCHAR(1) — NOT NULL
- DVC_ID — VARCHAR(256) — NOT NULL
- PUBLIC_TOKEN — VARCHAR(256)
- OS_VER — VARCHAR(20)
- APP_VER — VARCHAR(10)
- MODEL_NO — VARCHAR(20)
- SERIAL_NO — VARCHAR(256)
- USIM_TP — VARCHAR(10)
- RCV_YN1 — VARCHAR(1)
- OPT_VAL — VARCHAR(1)
- UPDATE_DTM — VARCHAR(14)
- REGI_DTM — VARCHAR(14)
- STAT_TP_CD — VARCHAR(1)
- RCV_YN2 — VARCHAR(1)
- RCV_YN3 — VARCHAR(1)
- RCV_YN4 — VARCHAR(1)
- RCV_YN5 — VARCHAR(1)
- LINKER_NUMBER — VARCHAR(1)
- APP_PKG — VARCHAR(256)
- CUST_SVC_ID — VARCHAR(128)
- CSUT_SVC_TP — VARCHAR(1)
- RCV_Y_UPDATE_DTM — VARCHAR(14)
- RCV_N_UPDATE_DTM — VARCHAR(14)
NP_PUSH_DEVICE_STAT
- SEQ_ID — BIGINT(20) — Primary key — NOT NULL — 시퀀스
- STAT_DATE — VARCHAR(12) — NOT NULL — yyyymmddhhmi
- APP_ID — VARCHAR(4) — NOT NULL — 앱구분
- OS_TP — VARCHAR(1) — NOT NULL — 1: Android, 2 : iOS
- LINKER_NUMBER — VARCHAR(1) — NOT NULL — 링커넘버
- USIM_TP — VARCHAR(10) — K : KT L : LGU+ S : SKT
- REG_CNT — BIGINT — 등록건수
- USE_CNT — BIGINT — 사용가능건수
- NOTUSE_CNT — BIGINT — 장기미사용건수
- DEL_CNT — BIGINT — 앱삭제건수
- RECV_Y_CNT — BIGINT — 수신동의건수
- RECV_N_CNT — BIGINT — 수신거부건수
NP_PUSH_RESOURCE
- STAT_DATE — VARCHAR(14) — Primary key — NOT NULL — yyyymmddhhmiss
- HOST_NM — VARCHAR(50) — Primary key — NOT NULL — 모니터링 장비 Host명
- CPU_USAGE — INT(3) — CPU 사용율
- MEM_USAGE — INT(3) — MEM 사용율
- SESS_CNT — INT(20) — 세션수
- UPD_DATE — VARCHAR(14) — yyyymmddhhmiss
NP_PUSH_SEND
- REQ_ID — BIGINT — Primary key — NOT NULL
- REQ_DTM — VARCHAR(14) — NOT NULL
- BATCH_ID — BIGINT
- APP_ID — VARCHAR(4) — NOT NULL
- SND_TP_CD — VARCHAR(2) — NOT NULL
- RCV_DVC_ID — VARCHAR(256) — NOT NULL
- RCV_PUBLIC_TOKEN — VARCHAR(256)
- RCV_OS_CD — VARCHAR(1) — NOT NULL
- APP_PKG — VARCHAR(256)
- OS_VER — VARCHAR(10)
- APP_VER — VARCHAR(10)
- NOTI_MSG — VARCHAR(1000) — NOT NULL
- NOTI_MSG_TITLE — VARCHAR(90)
- NOTI_IMG_URL — VARCHAR(256)
- NOTI_LNK_URL — VARCHAR(256)
- NOTI_OPT_VAL — VARCHAR(1000)
- DATA_CONTENT — VARCHAR(3000)
- RESV_YN — CHAR(1)
- RESV_SEND_DTM — VARCHAR(14)
- SENDER_ID — VARCHAR(20)
- MSG_EXPIRE_SEC — INT
- MSG_TYPE — CHAR(1)
- REQ_STAT_CD — VARCHAR(1)
- RETRY_CNT — INT
- LINKER_NUMBER — VARCHAR(1)
- SMS_SEND_YN — CHAR(1)
- CUST_ID_NO — VARCHAR(128)
- GUBUN_CD — VARCHAR(4)
- SENDER_MSG_ID — VARCHAR(256)
- CUST_SVC_ID — VARCHAR(128)
- CUST_ADDITIONAL — VARCHAR(3000)
NP_PUSH_SEND_CODE_STAT
- SEQ_ID — BIGINT(20) — Primary key — NOT NULL
- STAT_DATE — VARCHAR(12) — NOT NULL — yyyymmddhhmi
- RSLT_CD — VARCHAR(5) — NOT NULL — 결과코드값
- APP_ID — VARCHAR(4) — NOT NULL — 앱구분
- SND_TP_CD — VARCHAR(2) — NOT NULL — 메시지 발송 구분 00:API, 01:DB적재(단건), 02:배치 발송, 03:Device 발송
- BATCH_ID — BIGINT(20) — NOT NULL — 배치 발송인 경우에만 관리, 비배치 시 0
- LINKER_NUMBER — VARCHAR(1) — NOT NULL — 링커넘버
- GUBUN_CD — VARCHAR(4) — 업무유형 구분 컬럼 - 고객사에 따라 정의/통계 추출 용도
- TOT_CNT — BIGINT(20) — 전체건수
NP_PUSH_SEND_LOG
- INPUT_DATE — VARCHAR2(8) — Primary key — NOT NULL
- PUSH_ID — VARCHAR2(40) — Primary key — NOT NULL
- REQ_ID — VARCHAR2(64)
- REQ_DTM — VARCHAR2(14)
- RESV_SEND_DTM — VARCHAR2(14)
- SEND_DTM — VARCHAR2(14)
- RECV_DTM — VARCHAR2(14)
- RECV_CONF_DTM — VARCHAR2(14)
- APP_ID — VARCHAR2(64)
- APP_PKG — VARCHAR2(256)
- APP_VER — VARCHAR2(32)
- OS_VER — VARCHAR2(32)
- RCV_OS_CD — VARCHAR2(2)
- RCV_DVC_ID — VARCHAR2(256)
- CUST_ID_NO — VARCHAR2(40)
- CUST_SVC_ID — VARCHAR2(40)
- GUBUN_CD — VARCHAR2(2)
- SENDER_ID — VARCHAR2(40)
- SENDER_MSG_ID — VARCHAR2(256)
- NOTI_MSG_TITLE — VARCHAR2(2000)
- NOTI_MSG — VARCHAR2(4000)
- NOTI_IMG_URL — VARCHAR2(1024)
- NOTI_LNK_URL — VARCHAR2(1024)
- MSG_TYPE — VARCHAR2(1)
- MSG_STAT_TP_CD — VARCHAR2(2)
- RSLT_CD — VARCHAR2(8)
- RECV_SVR_PFX — VARCHAR2(4)
- RECV_SVR_IP — VARCHAR2(64)
- DATA_CONTENT — VARCHAR2(4000)
- SEND_DATA — VARCHAR2(4000)
- MSG_EXPIRE_SEC — NUMBER(6)
- LINKER_NUMBER — VARCHAR2(64)
- CUST_ADDITIONAL — VARCHAR2(4000)
- RESV_YN — VARCHAR2(1)
- RETRY_CNT — NUMBER(2)
- SMS_SEND_YN — VARCHAR2(1)
- DIV_NUM — NUMBER(2)
- DB_REG_DTM — VARCHAR2(14)
- BYPASS_REQ_DTM — VARCHAR2(14)
- BYPASS_RSLT_CD — VARCHAR2(8)
- BATCH_ID — VARCHAR2(64)
NP_PUSH_SEND_STAT
- SEQ_ID — BIGINT(20) — Primary key — NOT NULL
- STAT_DATE — VARCHAR(12) — NOT NULL — yyyymmddhhmi
- APP_ID — VARCHAR(4) — NOT NULL — 앱구분
- SND_TP_CD — VARCHAR(2) — NOT NULL — 메시지 발송 구분 00:API, 01:DB적재(단건), 02:배치 발송, 03:Device 발송
- BATCH_ID — BIGINT(20) — NOT NULL — 배치 발송인 경우에만 관리, 비배치 시 0
- GUBUN_CD — VARCHAR(4) — 업무유형 구분 컬럼 - 고객사에 따라 정의/통계 추출 용도
- LINKER_NUMBER — VARCHAR(1) — NOT NULL — 링커넘버
- TOT_CNT — BIGINT(20) — 전체건수
- RECV_CNT — BIGINT(20) — 수신건수
- CONF_CNT — BIGINT(20) — 확인건수
- ERR_CNT — BIGINT(20) — 에러건수
- SEND_CNT — BIGINT(20) — 전송건수
- BYPASS_CNT — BIGINT(20) — 우회건수
NP_PUSH_SEND_STAT_MIN
- SEQ_ID — BIGINT — Primary key — NOT NULL
- STAT_DATE — VARCHAR(12) — NOT NULL — yyyymmddhhmi
- APP_ID — VARCHAR(4) — NOT NULL — 앱구분
- SND_TP_CD — VARCHAR(2) — NOT NULL — 메시지 발송 구분 00:API, 01:DB적재, 02:배치, 03:Device
- BATCH_ID — BIGINT(20) — NOT NULL — 배치 발송인 경우에만 관리. 비배치 시 0
- GUBUN_CD — VARCHAR(4) — 업무유형 구분 컬럼 - 고객사에 따라 정의
- LINKER_NUMBER — VARCHAR(1) — NOT NULL
- TOT_CNT — BIGINT(20) — 전체건수
- RECV_CNT — BIGINT(20) — 수신건수
- CONF_CNT — BIGINT(20) — 확인건수
- ERR_CNT — BIGINT(20) — 에러건수
- SEND_CNT — BIGINT(20) — 전송건수
- BYPASS_CNT — BIGINT(20) — 우회건수
NP_PUSH_SERVER
- HOST_NM — VARCHAR(50) — Primary key — NOT NULL — 모니터링 장비 Host
- HOST_TP_CD — VARCHAR(1) — Primary key — NOT NULL — 1:Sender, 2:Linker
- MON_URL — VARCHAR(128) — 모니터링 URL
- USE_FLAG — VARCHAR(1) — Y:사용, N:미사용
- UPD_DATE — VARCHAR(14) — yyyymmddhhmiss
- LINKER_NUM — INT(1) — 링커넘버