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) — 수정일시