h-apps3
Tables (9)
PUSH_IMDT_SEND
- SEQ — NUMBER — Primary key — NOT NULL
- PUSH_MESSAGE_SEQ — NUMBER — Foreign key → PUSH_MSG_MASTER.SEQ — NOT NULL — 푸쉬메세지마스터순번
- TARGET_EMPID — VARCHAR(50) — Foreign key → USER_DEVICE_INFO.EMP_ID — NOT NULL — 발송
- PRC_FLAG — CHAR — NOT NULL — 처리
- REG_DTM — VARCHAR2(14) — 등록일시
- RGST_ID — VARCHAR(50) — 등록자
PUSH_FAIL_RESULT
- SEQ — NUMBER — Primary key — NOT NULL
- PUSH_SEND_STBY_SEQ — NUMBER — Foreign key → PUSH_SEND_STBY.SEQ — NOT NULL — 푸쉬발송대기순번
- PUSH_MSG_SEQ — NUMBER — Foreign key → PUSH_MSG_MASTER.SEQ — NOT NULL — 푸쉬메세지마스터순번
- DEVICE_TOKEN — VARCHAR(1000) — NOT NULL — 디바이스
- EMP_ID — VARCHAR(50) — NOT NULL — 사용자
- APP_ID — VARCHAR(100) — NOT NULL — 앱
- PUSH_SVR_TYPE — VARCHAR(20) — NOT NULL — 푸시서버
- PUSH_SVR_RST_CODE — VARCHAR(50) — 푸시
- PUSH_SVR_RST_MSG — VARCHAR2(200) — 푸시
- REG_DTM — VARCHAR2(14) — 등록일
- RGST_ID — VARCHAR(50) — 등록자
PUSH_MSG_MASTER
- SEQ — NUMBER — Primary key — NOT NULL
- SYS_TYPE_CODE — VARCHAR(50) — Foreign key → PUSH_TRGT_SYS_INFO.SYS_TYPE_CODE — NOT NULL — 시스템유형코드
- APP_ID — VARCHAR(100) — NOT NULL — 앱
- TITLE — VARCHAR(200) — NOT NULL — 타이틀
- SUBTITLE — VARCHAR(200) — 서브타이틀
- MSG_BODY — VARCHAR2(4000) — NOT NULL — 발송메세지
- RSV_YN — BOOLEAN — 예약발송여부
- RSV_DTM — VARCHAR2(14) — 예약발송날짜
- PRTY — NUMBER — 우선순위
- REG_DTM — VARCHAR2(14) — 등록일시
- RGST_ID — VARCHAR(50) — 등록자
PUSH_RSV_SEND
- SEQ — NUMBER — Primary key — NOT NULL
- PUSH_MSG_SEQ — NUMBER — Foreign key → PUSH_MSG_MASTER.SEQ — NOT NULL — 푸쉬메세지마스터순번
- TARGET_EMPID — VARCHAR(50) — Foreign key → USER_DEVICE_INFO.EMP_ID — NOT NULL — 발송
- RSV_DTM — VARCHAR2(14) — 예약발송일시
- REG_DTM — VARCHAR2(14) — 등록일시
- RGST_ID — VARCHAR2(100) — 등록자
PUSH_SEND_STBY
- SEQ — NUMBER — Primary key — NOT NULL
- PUSH_MSG_SEQ — NUMBER — Foreign key → PUSH_MSG_MASTER.SEQ — NOT NULL — 푸쉬메세지마스터순번
- TARGET_EMPID — VARCHAR(50) — 발송
- PUSH_SVR_TYPE — VARCHAR2(20) — 푸시서버
- PRC_FLAG — CHAR — 처리
- REG_DTM — VARCHAR2(14) — 등록일시
- RGST_ID — VARCHAR(50) — 등록자
PUSH_SEND_TARGET_INFO
- SEQ — NUMBER — Primary key — NOT NULL
- PUSH_MSG_SEQ — NUMBER — Foreign key → PUSH_MSG_MASTER.SEQ — NOT NULL — 푸쉬메세지마스터순번
- TARGET_EMPID — VARCHAR(50) — NOT NULL — 발송
- REG_DTM — TIMESTAMP — 등록일
- RGST_ID — VARCHAR(50) — 등록자
PUSH_SUCCESS_RESULT
- SEQ — NUMBER — Primary key — NOT NULL
- PUSH_SEND_STBY_SEQ — NUMBER — Foreign key → PUSH_SEND_STBY.SEQ — NOT NULL — 푸쉬발송대기순번
- PUSH_MSG_SEQ — NUMBER — Foreign key → PUSH_MSG_MASTER.SEQ — NOT NULL — 푸쉬메세지마스터순번
- DEVICE_TOKEN — VARCHAR(1000) — NOT NULL — 디바이스
- EMP_ID — VARCHAR(50) — NOT NULL — 사용자
- APP_ID — VARCHAR(100) — NOT NULL — 앱
- PUSH_SVR_TYPE — VARCHAR(20) — NOT NULL — 푸시서버
- SEND_STATUS_CODE — CHAR(1) — NOT NULL — 발송
- SENT_DTM — VARCHAR2(14) — 발송일시
- RCV_DTM — VARCHAR2(14) — 수신일시
- READ_DTM — VARCHAR2(14) — 읽음일시
- REG_DTM — VARCHAR2(14) — 등록일
- RGST_ID — VARCHAR(50) — 등록자
PUSH_TRGT_SYS_INFO
- SYS_TYPE_CODE — VARCHAR(50) — Primary key — NOT NULL
- SYS_NAME — VARCHAR(100) — NOT NULL — 시스템명
- USE_YN — BOOLEAN — 사용여부
- REG_DTM — TIMESTAMP — 등록일시
- RGST_ID — VARCHAR(50) — 등록자
- CHG_DTM — TIMESTAMP — 수정일시
- CHG_ID — VARCHAR(50) — 수정자
USER_DEVICE_INFO
- SEQ — NUMBER — Primary key — NOT NULL
- EMP_ID — VARCHAR(50) — Primary key — NOT NULL — 사용자
- TE_OPSY_GBCD — VARCHAR2(1) — NOT NULL — 단말기
- DEVICE_TOKEN — VARCHAR(500) — NOT NULL — 디바이스
- DEVICE_MODEL — VARCHAR(100) — 디바이스
- NAME — VARCHAR(100) — NOT NULL — 이름
- PUSH_SVR_TYPE — VARCHAR(20) — NOT NULL — 푸시서버
- PUSH_OS_AUTH_STATUS — VARCHAR(20) — NOT NULL — 푸쉬OS권한상태(01:
- APP_VER — VARCHAR(20) — 앱
- SVR_ENV — VARCHAR(10) — NOT NULL — 서버환경
- REG_DTM — VARCHAR2(14) — 등록일시
- RGST_ID — VARCHAR(50) — 등록자
- CHG_DTM — VARCHAR2(14) — 수정일시