===================================== DATABASE TABLE 정의 ===================================== :download:`download [PUSH DB 테이블 명세서] ` 1. **T\_PUSH\_FAIL** ======================== +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_FAIL** | +-------------------------+-----------------------------------+ | **COMMENT** | 발송 실패메세지 히스토리 테이블 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | SEQNO | NUMBER | PK | NOT NULL | 　 | 고유번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | PSID | VARCHAR2(255) | PK | NOT NULL | 　 | 토큰 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | CUID | VARCHAR2(50) | 　 | 　 | 　 | 유저아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | APPID | VARCHAR2(50) | 　 | 　 | 　 | 앱아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | PNSID | VARCHAR2(10) | 　 | 　 | 　 | 발송푸시서버 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | RETRYCNT | NUMBER | 　 | | 0 | 재발송횟수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | RESULTCODE | VARCHAR2(10) | 　 | 　 | 　 | 결과코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | RESULTMSG | VARCHAR2(4000) | 　 | 　 | 　 | 결과메세지 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | REGDATE | DATE | 　 | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 10 | MODEDATE | DATE | 　 | 　 | | 수정일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 11 | ISSMSSENT | VARCHAR2(2000) | 　 | 　 | N | SMS발송처리 여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 12 | CSV\_VARS | VARCHAR2(2000) | 　 | 　 | 　 | CSV파일 발송시 개별화정보 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 2. **T\_PUSH\_MSG\_RECV\_MASTER** ================================= +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_MSG\_RECV\_MASTER** | +-------------------------+-----------------------------------+ | **COMMENT** | 메세지원장테이블 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | SEQNO | NUMBER | PK | NOT NULL | 　 | 고유번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | RESERVE\_SEQNO | NUMBER | 　 | 　 | 0 | 예약발송번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | SOUNDFILE | VARCHAR2(20) | 　 | 　 | 　 | 사운드파일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | BADGENO | NUMBER | 　 | 　 | 　 | 뱃지사용여부 1:사용, 0 :미사용 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | MESSAGE | VARCHAR2(4000) | 　 | 　 | 　 | 보낼메세지 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | SUB_TITLE | VARCHAR2(4000) | 　 | 　 | 　 | 선택사항. 해당 값을 보낼시 APNS발송은 HTTP2로 발송됨 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | EXT | VARCHAR2(4000) | 　 | 　 | 　 | 사용자 추가 메세지 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | RESERVEDATE | DATE | 　 | 　 | 　 | 예약일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | PRIORITY | NUMBER | 　 | 　 | 　 | 우선수위(3:일반, 5:긴급) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 10 | SENDERID | VARCHAR2(50) | 　 | 　 | 　 | 메세지종류,또는 발송자 구분 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 11 | REGDATE | DATE | | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 12 | APPID | VARCHAR2(255) | 　 | 　 | 　 | 앱아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 13 | SERVICECODE | VARCHAR2(20) | 　 | 　 | 　 | 발송정책서비스코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 14 | TYPE | CHAR(1) | 　 | 　 | E | 메세지 타입(A:전체, G:그룹, E:개별, C:CSV발송, S:시스템 또는 비밀발송 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 15 | TOTAL\_SEND\_CNT | NUMBER | 　 | 　 | 0 | 총발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 16 | SEND\_CNT | NUMBER | 　 | 　 | 0 | 푸시서버에 발송요청 성공수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 17 | FAIL\_CNT | NUMBER | 　 | 　 | 0 | 실패수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 18 | REV\_CNT | NUMBER | 　 | 　 | 0 | 수신확인수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 19 | READ\_CNT | NUMBER | 　 | 　 | 0 | 읽음확인수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 20 | UPNS\_CNT | NUMBER | 　 | 　 | 0 | UPNS 발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 21 | APNS\_CNT | NUMBER | 　 | 　 | 0 | APNS 발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 22 | AOM\_CNT | NUMBER | 　 | 　 | 0 | AOM 발송 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 23 | GCM\_CNT | NUMBER | 　 | 　 | 0 | GCM 발송 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 24 | DB\_IN | CHAR(1) | 　 | 　 | N | 발송 성공 메시지 DB 저장여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 25 | ORIGINAL\_SEQNO | NUMBER | 　 | 　 | 0 | 재 발송시 원본 메시지 SEQNO | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 26 | GROUPSEQ | VARCHAR2(50) | 　 | 　 | | 그룹 발송시 그룹 SEQNO | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 27 | START\_TIMESTAMP | NUMBER | 　 | 　 | 0 | 발송시작시간 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 28 | END\_TIMESTAMP | NUMBER | 　 | 　 | 0 | 발송완료시간 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 3. **T\_PUSH\_PITCHER\_COMPLETED\_MSG** ==================================================== +-------------------------+-------------------------------------------------+ | **TABLE NAME** | **T\_PUSH\_PITCHER\_COMPLETED\_MSG** | +-------------------------+-------------------------------------------------+ | **COMMENT** | DB이용 발송 정보 이력 | +-------------------------+-------------------------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 1 | PITCHER_SEQNO | NUMBER | PK | NOT NULL | 　 | 고유번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 2 | APP\_ID | VARCHAR2(255) | | | 　 | 앱아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 3 | MESSAGE | VARCHAR2(4000) | 　 | 　 | 　 | 발송메세지 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 4 | SOUNDFILE | VARCHAR2(20) | 　 | 　 | 　 | 사운드파일이름 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 5 | BADGENO | NUMBER | 　 | 　 | 　 | 뱃지사용여부 1:사용, 0:미사용 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 6 | PRIORITY | NUMBER | 　 | 　 | 　 | 3:보통발송, 5:긴급발송 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 7 | EXT | VARCHAR2(255) | 　 | 　 | 　 | 사용자 추가 메세지 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 8 | SENDERCODE | VARCHAR2(50) | 　 | 　 | 　 | 메세지 구분코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 9 | SERVICECODE | VARCHAR2(20) | 　 | 　 | 　 | 푸시서버 발송정책코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 10 | RESERVEDATE | DATE | 　 | 　 | 　 | 예약발송날자 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 11 | TYPE | CHAR(1) | 　 | 　 | E | 메세지 발송타입. E:개별발송, S:시스템발송, A:전체발송, M: 회원발송, C: csv발송, N:비회원발송 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 12 | DB\_IN | CHAR(1) | 　 | 　 | 　 | 성공메시지 DB 테이블 저장 여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 13 | ATTACHFILE | VARCHAR2(255) | 　 | 　 | 　 | 첨부파일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 14 | GROUPSEQ | VARCHAR2(50) | 　 | 　 | 　 | 발송그룹시퀀스번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 15 | CUID | VARCHAR(100) | 　 | 　 | 　 | 발송대상자아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 16 | REGDATE | DATE | 　 | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 17 | PROCESS\_FLAG | CHAR(1) | 　 | 　 | N　 | N:예약, R:발송대기/쓰레드등록, Y:발송, F:실패 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 18 | SPLIT\_MSG\_CNT | NUMBER | 　 | 　 | 0 | 분할발송 메시지 건수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 19 | DELAY\_SECOND | NUMBER | 　 | 　 | 0 | 분할발송 후 SLEEP 초시간 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 20 | RESERVETYPE | VARCHAR2(2) | 　 | 　 | 　 | 예약 타입 (A: admin) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 21 | SUB\_TITLE | VARCHAR2(4000) | 　 | 　 | 　 | 선택사항. 해당 값을 보낼시 APNS발송은 HTTP2로 발송됨 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 22 | PUSH\_FAIL\_SMS\_SEND | CHAR(1) | 　 | 　 | N | SMS발송처리 여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 23 | SMS\_READ\_WAIT\_MINUTE | VARCHAR2(5) | 　 | 　 | 0 | 0 : 사용 하지 않음. 기타 정수값. (대기 분) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 24 | DOZ\_GCM\_SEND | CHAR(1) | 　 | 　 | N | DOZ모드 깨움을 위한 GCM 발송 여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 25 | SEND\_TIME\_LIMIT | VARCHAR2(20) | 　 | 　 | 　 | 발송제한 시간 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 26 | RESULT\_CODE | VARCHAR2(20) | 　 | 　 | 　 | 결과코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 27 | RESULT\_MSG | VARCHAR2(4000) | 　 | 　 | 　 | 결과메시지 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ 4. **T\_PUSH\_PITCHER\_MSG** ==================================================== +-------------------------+--------------------------------------+ | **TABLE NAME** | **T\_PUSH\_PITCHER\_MSG** | +-------------------------+--------------------------------------+ | **COMMENT** | DB이용 발송 정보 | +-------------------------+--------------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 1 | PITCHER_SEQNO | NUMBER | PK | NOT NULL | 　 | 고유번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 2 | APP\_ID | VARCHAR2(255) | | | 　 | 앱아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 3 | MESSAGE | VARCHAR2(4000) | 　 | 　 | 　 | 발송메세지 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 4 | SOUNDFILE | VARCHAR2(20) | 　 | 　 | 　 | 사운드파일이름 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 5 | BADGENO | NUMBER | 　 | 　 | 　 | 뱃지사용여부 1:사용, 0:미사용 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 6 | PRIORITY | NUMBER | 　 | 　 | 　 | 3:보통발송, 5:긴급발송 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 7 | EXT | VARCHAR2(255) | 　 | 　 | 　 | 사용자 추가 메세지 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 8 | SENDERCODE | VARCHAR2(50) | 　 | 　 | 　 | 메세지 구분코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 9 | SERVICECODE | VARCHAR2(20) | 　 | 　 | 　 | 푸시서버 발송정책코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 10 | RESERVEDATE | DATE | 　 | 　 | 　 | 예약발송날자 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 11 | TYPE | CHAR(1) | 　 | 　 | E | 메세지 발송타입. E:개별발송, S:시스템발송, A:전체발송, M: 회원발송, C: csv발송, N:비회원발송 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 12 | DB\_IN | CHAR(1) | 　 | 　 | 　 | 성공메시지 DB 테이블 저장 여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 13 | ATTACHFILE | VARCHAR2(255) | 　 | 　 | 　 | 첨부파일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 14 | GROUPSEQ | VARCHAR2(50) | 　 | 　 | 　 | 발송그룹시퀀스번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 15 | CUID | VARCHAR(100) | 　 | 　 | 　 | 발송대상자아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 16 | REGDATE | DATE | 　 | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 17 | PROCESS\_FLAG | CHAR(1) | 　 | 　 | N　 | N:예약, R:발송대기/쓰레드등록, Y:발송, F:실패 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 18 | SPLIT\_MSG\_CNT | NUMBER | 　 | 　 | 0 | 분할발송 메시지 건수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 19 | DELAY\_SECOND | NUMBER | 　 | 　 | 0 | 분할발송 후 SLEEP 초시간 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 20 | RESERVETYPE | VARCHAR2(2) | 　 | 　 | 　 | 예약 타입 (A: admin) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 21 | SUB\_TITLE | VARCHAR2(4000) | 　 | 　 | 　 | 선택사항. 해당 값을 보낼시 APNS발송은 HTTP2로 발송됨 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 22 | PUSH_FAIL\_SMS\_SEND | CHAR(1) | 　 | 　 | N | SMS발송처리 여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 23 | SMS_READ\_WAIT\_MINUTE | VARCHAR2(5) | 　 | 　 | 0 | 0 : 사용 하지 않음. 기타 정수값. (대기 분) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 24 | DOZ\_GCM\_SEND | CHAR(1) | 　 | 　 | N | DOZ모드 깨움을 위한 GCM 발송 여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ | 25 | SEND\_TIME\_LIMIT | VARCHAR2(20) | 　 | 　 | 　 | 발송제한 시간 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-----------------------------------------------------------------------------------------------+ 5. **T\_PUSH\_RESERVE\_MSG** ============================ +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_RESERVE\_MSG** | +-------------------------+-----------------------------------+ | **COMMENT** | 예약발송 테이블 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | RESERVE\_SEQNO | NUMBER | PK | NOT NULL | 　 | 고유번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | APP\_ID | VARCHAR2(255) | 　 | 　 | 　 | 앱아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | MESSAGE | VARCHAR2(4000) | 　 | 　 | 　 | 메세지 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | SOUNDFILE | VARCHAR2(20) | 　 | 　 | 　 | 사운드파일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | BADGENO | NUMBER | 　 | 　 | 　 | 뱃지카운트 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | PRIORITY | NUMBER | 　 | 　 | 　 | 우선순위(3:일반, 5긴급) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | EXT | VARCHAR2(255) | 　 | 　 | 　 | 확장 커스텀 필드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | SENDERCODE | VARCHAR2(50) | 　 | 　 | 　 | 사용자정보, 메세지 종류 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | SERVICECODE | VARCHAR2(20) | 　 | 　 | 　 | 푸시발송정책 서비스코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 10 | RESERVEDATE | DATE | 　 | 　 | 　 | 예약일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 11 | TYPE | CHAR(1) | 　 | 　 | E | E:개별발송, A:전체발송,G:그룹발송,C:CSV발송 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 12 | DB\_IN | CHAR(1) | 　 | 　 | 　 | Y:성공메세지 저장, N:성공메세지 저장하지 않음 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 13 | ATTACHFILE | VARCHAR2(255) | 　 | 　 | 　 | 첨부파일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 14 | GROUPSEQ | VARCHAR2(50) | 　 | 　 | 　 | 발송그룹시퀀스번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 15 | CUID | LONG | 　 | 　 | 　 | 발송 대상자 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 16 | REGDATE | DATE | | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 17 | PROCESS\_FLAG | CHAR(1) | 　 | | N | N:예약, R:발송대기/쓰레드등록,패 Y:발송,F:실패 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 18 | SPLIT\_MSG_CNT | NUMBER | 　 | 　 | 0　 | 분할발송 메시지 수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 19 | DELAY\_SECOND | NUMBER | 　 | 　 | 0 | 분할 발송 지연 시간 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 20 | RESERVETYPE | VARCHAR2(2) | 　 | 　 | 　 | 예약 타입(A: admin) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 21 | ISCONDITION | VARCHAR2(2) | 　 | 　 | 　 | 조건여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 22 | SUB\_TITLE | VARCHAR2(4000) | 　 | 　 | 　 | 선택사항. 해당 값을 보낼시 APNS발송은 HTTP/2로 발송됨 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 23 | PUSH\_FAIL\_SMS\_SEND | CHAR(1) | 　 | 　 | N | SMS발송처리 여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 24 | SMS\_READ\_WAIT\_MINUTE | VARCHAR2(5) | 　 | 　 | 0 | 0 : 사용 하지 않음. 기타 정수값. (대기 분) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 25 | DOZ\_GCM\_SEND | CHAR(1) | 　 | 　 | N　 | DOZ모드 깨움을 위한 GCM 발송 여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 26 | SEND\_TIME\_LIMIT | VARCHAR2(20) | 　 | 　 | 　 | 발송제한 시간 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 6. **T\_PUSH\_SENDER\_INFO** ============================ +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_SENDER\_INFO** | +-------------------------+-----------------------------------+ | **COMMENT** | 푸시 발송자 정보 테이블 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | SENDERSEQ | NUMBER(8) | PK | NOT NULL | 　 | 고유번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | SENDERNAME | VARCHAR2(50) | 　 | 　 | 　 | 발송자이름 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | SENDERCODE | VARCHAR2(50) | | 　 | 　 | 발송자 코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | ISDELETED | VARCHAR2(1) | 　 | 　 | 　 | 사용여부(N:사용, Y:미사용) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | SENDERDESC | VARCHAR2(45) | 　 | 　 | 　 | 발송자 설명 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | REGID | VARCHAR2(20) | 　 | 　 | 　 | 등록자 아이디　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | REGDT | DATE | 　 | 　 | 　 | 등록일　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | MODID | VARCHAR2(20) | 　 | 　 | 　 | 수정자 아이디　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | MODDT | DATE | 　 | | | 수정일　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 7. **T\_PUSH\_SERVER\_GROUP** ============================= +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_SERVER\_GROUP** | +-------------------------+-----------------------------------+ | **COMMENT** | 서버 그룹 정보 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | GROUPID | VARCHAR2(20) | PK | NOT NULL | 　 | 서버그룹ID | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | GROUPNAME | VARCHAR2(50) | 　 | 　 | 　 | 서버그룹 명 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | SERVERTYPE | VARCHAR2(10) | 　 | 　 | 　 | 서버타입: UPNS, UPMC, PROVIDER | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | VIP | VARCHAR2(30) | 　 | 　 | 　 | IP | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | PORT | VARCHAR2(6) | 　 | 　 | 　 | PORT | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 8. **T\_PUSH\_SERVER\_INFO** ============================ +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_SERVER\_INFO** | +-------------------------+-----------------------------------+ | **COMMENT** | 서버 정보 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | SERVERID | VARCHAR2(20) | PK | NOT NULL | 　 | 서버ID | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | GROUPID | VARCHAR2(20) | 　 | 　 | 　 | 서버 그룹 ID | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | IP | VARCHAR2(20) | 　 | 　 | 　 | 아이피 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | PORT | VARCHAR2(6) | 　 | 　 | 　 | 포트 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | INTERNEL\_IP | VARCHAR2(20) | 　 | 　 | 　 | 서버 내부 IP (예: 127.0.0.1) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | SERVERTYPE | VARCHAR2(10) | 　 | 　 | 　 | 서버종류(UPMC,UPNS,PROVIDER) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | SERVERNAME | VARCHAR2(50) | 　 | 　 | 　 | 서버이름 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | URL | VARCHAR2(1024) | 　 | 　 | 　 | URL | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | ISACTIVE | CHAR(1) | 　 | 　 | N | 사용 여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 9. **T\_PUSH\_SERVER\_STATUS** ============================== +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_SERVER\_STATUS** | +-------------------------+-----------------------------------+ | **COMMENT** | 푸시서버 상태 테이블 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | STATUS | VARCHAR2(1) | 　 | 　 | 　 | 상태정보 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | REGDATE | DATE | 　 | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | IPADDRESS | VARCHAR2(15) | PK | NOT NULL | 　 | 아이피 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | PORT | VARCHAR2(6) | PK | NOT NULL | 　 | 포트 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 10. **T\_PUSH\_SERVICE** ========================= +-------------------------+----------------------------------+ | **TABLE NAME** | **T\_PUSH\_SERVICE** | +-------------------------+----------------------------------+ | **COMMENT** | PUSH 발송 정책 | +-------------------------+----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | SERVICENAME | VARCHAR2(100) | 　 | 　 | 　 | 발송정책 서비스 이름 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | SERVICECODE | VARCHAR2(20) | | NOT NULL | 　 | 발송정책 서비스 코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | MAXRETRYCNT | NUMBER2) | 　 | 　 | 　 | 최대 재발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | RETRYFLAG | VARCHAR2(1) | | 　 | 　 | 재발송 사용 유무 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | RESENDFLAG | VARCHAR2(1) | 　 | 　 | 　 | 재발송여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | MAXRESENDCNT | NUMBER2) | 　 | 　 | 　 | 최대 재발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | PNSID | VARCHAR2(4) | | 　 | 　 | 발송서버 종류(UPNS, UPNC, APNS, GCM) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | FAILSMSFLAG | VARCHAR2(1) | 　 | 　 | N | 실패시 SMS 발송여부(Y:발송, N:미발송) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 11. **T\_PUSH\_SMS** ============================ +-------------------------+----------------------------------+ | **TABLE NAME** | **T\_PUSH\_SMS** | +-------------------------+----------------------------------+ | **COMMENT** | SMS 대상 정보 | +-------------------------+----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | APPID | VARCHAR2(255) | PK | NOT NULL | 　 | 앱아이디 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | CUID | VARCHAR2(50) | PK | NOT NULL　 | 　 | 사용자아이디　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | SEQNO | VARCHAR2(50) | PK | NOT NULL　 | 　 | 고유번호　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | TITLE | VARCHAR2(4000) | 　 | 　 | 　 | 메시지　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | SUB\_TITLE | VARCHAR2(4000) | 　 | 　 | 　 | 선택사항　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | PNSID | VARCHAR2(10) | 　 | 　 | 　 | 푸시서버종류 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | PSID | VARCHAR2(255) | 　 | 　 | 　 | 푸시토큰 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | SMS\_READ\_WAIT\_MINUTE | VARCHAR2(5) | 　 | 　 | 　 | 0 : 사용 하지 않음. 기타 정수값. (대기 분) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | PUSH\_STATUS | CHAR(1) | 　 | 　 | F | PUSH 발송 상태　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 10 | ERRCODE | VARCHAR2(10) | 　 | 　 | 0000 | 에러코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 11 | REGDATE | DATE | 　 | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 12 | EXPIREDATE | DATE | 　 | 　 | 　 | 만기일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 12. **T\_PUSH\_SUCCESS** ========================= +-------------------------+----------------------------------+ | **TABLE NAME** | **T\_PUSH\_SUCCESS** | +-------------------------+----------------------------------+ | **COMMENT** | 보낸메세지정보 | +-------------------------+----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | SEQNO | NUMBER(20) | PK | NOT NULL | 　 | 메세지원장번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | PSID | VARCHAR2(255) | PK | NOT NULL | 　 | 토큰키 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | APPID | VARCHAR2(50) | 　 | 　 | 　 | 앱아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | PNSID | VARCHAR2(10) | 　 | 　 | 　 | 보낸 푸쉬서버 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | STATUS | NUMBER | 　 | 　 | 1 | 1:발송완료, 2:수신완료,3:읽음확인 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | CUID | VARCHAR2(50) | 　 | 　 | 　 | 유저아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | REGDATE | DATE | 　 | 　 | 　 | 푸시서버에 발송성공시간 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | REVDATE | DATE | 　 | 　 | 　 | 수신완료시간 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | READDATE | DATE | 　 | 　 | 　 | 읽음확인시간 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 10 | ISSMSSENT | CHAR(1) | 　 | 　 | N　 | SMS발송처리 여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 11 | CSV\_VARS | VARCHAR2(2000) | 　 | 　 | 　 | CSV 템플릿 파라미터 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 13. **T\_PUSH\_SUPERVISOR** =============================== +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_SUPERVISOR** | +-------------------------+-----------------------------------+ | **COMMENT** | 푸시관리자 정보 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | SUPERVISORSEQ | NUMBER(8) | PK | NOT NULL | 　 | 고유번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | NAME | VARCHAR2(50) | 　 | 　 | 　 | 이름 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | PHONENO | VARCHAR2(20) | 　 | 　 | 　 | 전화번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | ISDELETED | VARCHAR2(1) | 　 | 　 | 　 | 사용여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | REGDATE | DATE | 　 | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | MODDATE | DATE | 　 | 　 | 　 | 수정일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | TELCOMP | VARCHAR2(4) | 　 | 　 | 　 | 통신사정보 (예:SKT) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 14. **T\_PUSH\_SYSMSG\_SENTINFO** ================================= +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_SYSMSG\_SENTINFO** | +-------------------------+-----------------------------------+ | **COMMENT** | 일별/발송자(메세지종류)별 통계 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | SENDDATE | CHAR(8) | PK | NOT NULL | 　 | 발송일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | SENDERCODE | VARCHAR2(50) | PK | NOT NULL | 　 | 발송자/메세지종류 코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | SENT\_CNT | NUMBER | 　 | 　 | 0 | 발송성공 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | FAIL\_CNT | NUMBER | 　 | 　 | 0 | 발송실패 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | READ\_CNT | NUMBER | 　 | 　 | 0 | 수신확인 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | UPNS\_SENT\_CNT | NUMBER | 　 | 　 | 0 | UPNS 발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | UPNS\_FAIL\_CNT | NUMBER | 　 | 　 | 0 | UPNS 실패수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | APNS\_SENT\_CNT | NUMBER | 　 | 　 | 0 | APNS 발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | APNS\_FAIL\_CNT | NUMBER | 　 | 　 | 0 | APNS 실패수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 10 | GCM\_SENT\_CNT | NUMBER | 　 | 　 | 0 | GCM발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 11 | GCM\_FAIL\_CNT | NUMBER | 　 | 　 | 0 | GCM 실패수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 12 | AOM\_SENT\_CNT | NUMBER | 　 | 　 | 0 | GCM발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 13 | AOM\_FAIL\_CNT | NUMBER | 　 | 　 | 0 | GCM 실패수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 14 | TIME00 | NUMBER | 　 | 　 | 0 | 0시발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 15 | TIME01 | NUMBER | 　 | 　 | 0 | 1시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 16 | TIME02 | NUMBER | 　 | 　 | 0 | 2시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 17 | TIME03 | NUMBER | 　 | 　 | 0 | 3시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 18 | TIME04 | NUMBER | 　 | 　 | 0 | 4시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 19 | TIME05 | NUMBER | 　 | 　 | 0 | 5시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 20 | TIME06 | NUMBER | 　 | 　 | 0 | 6시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 21 | TIME07 | NUMBER | 　 | 　 | 0 | 7시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 22 | TIME08 | NUMBER | 　 | 　 | 0 | 8시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 23 | TIME09 | NUMBER | 　 | 　 | 0 | 9시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 24 | TIME10 | NUMBER | 　 | 　 | 0 | 10시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 25 | TIME11 | NUMBER | 　 | 　 | 0 | 11시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 26 | TIME12 | NUMBER | 　 | 　 | 0 | 12시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 27 | TIME13 | NUMBER | 　 | 　 | 0 | 13시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 28 | TIME14 | NUMBER | 　 | 　 | 0 | 14시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 29 | TIME15 | NUMBER | 　 | 　 | 0 | 15시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 30 | TIME16 | NUMBER | 　 | 　 | 0 | 16시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 31 | TIME17 | NUMBER | 　 | 　 | 0 | 17시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 32 | TIME18 | NUMBER | 　 | 　 | 0 | 18시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 33 | TIME19 | NUMBER | 　 | 　 | 0 | 19시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 34 | TIME20 | NUMBER | 　 | 　 | 0 | 20시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 35 | TIME21 | NUMBER | 　 | 　 | 0 | 21시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 36 | TIME22 | NUMBER | 　 | 　 | 0 | 22시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 37 | TIME23 | NUMBER | 　 | 　 | 0 | 23시발송수　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 15. **T\_PUSH\_TEMPLATE** ========================== +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_TEMPLATE** | +-------------------------+-----------------------------------+ | **COMMENT** | 템플릿 정보 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | TEMPLATECODE | VARCHAR2(20) | PK | NOT NULL | 　 | 템플릿 코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | MESSAGE | VARCHAR2(4000) | 　 | 　 | 　 | 메세지 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | REGDATE | DATE | 　 | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | MODDATE | DATE | 　 | 　 | 　 | 수정 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | TEMPLATE\_TYPE | VARCHAR2(50) | 　 | 　 | 　 | 템플릿유형 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | REGID | VARCHAR2(20) | 　 | 　 | 　 | 등록자ID | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | EXT | CLOB | 　 | 　 | 　 | 내용 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | URL | CLOB | 　 | 　 | 　 | 참조URL | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 16. **T\_PUSH\_USER** ============================ +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_USER** | +-------------------------+-----------------------------------+ | **COMMENT** | 마케팅 대상 유저 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | CUID | VARCHAR2(50) | PK | NOT NULL | 　 | 아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | CNAME | VARCHAR2(50) | | | 　 | 이름 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | VAL1 | VARCHAR2(50) | | | 　 | 타게팅 조건1 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | VAL2 | VARCHAR2(50) | | | 　 | 타게팅 조건2 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | VAL3 | VARCHAR2(50) | | | 　 | 타게팅 조건3 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | VAL4 | VARCHAR2(50) | | | 　 | 타게팅 조건4 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | VAL5 | VARCHAR2(50) | | | 　 | 타게팅 조건5 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | VAL6 | VARCHAR2(50) | | | 　 | 타게팅 조건6 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | VAL7 | VARCHAR2(50) | | | 　 | 타게팅 조건7 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 10 | VAL8 | VARCHAR2(50) | | | 　 | 타게팅 조건8 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 11 | VAL9 | VARCHAR2(50) | | | 　 | 타게팅 조건9 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 12 | REGDT | VARCHAR2(50) | | | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 13 | MODDT | VARCHAR2(50) | | | 　 | 수정일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 17. **T\_PUSH\_USER\_GROUP** ============================ +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_USER\_GROUP** | +-------------------------+-----------------------------------+ | **COMMENT** | 유저그룹 마스터 테이블 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | CUID | VARCHAR2(50) | PK | NOT NULL | 　 | 사용자아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | GROUPSEQ | NUMBER(6) | PK | NOT NULL | 　 | 그룹 고유번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 18. **T\_PUSH\_USER\_GROUP\_INFO** ================================== +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_USER\_GROUP\_INFO** | +-------------------------+-----------------------------------+ | **COMMENT** | 푸시 발송대상 그룹 정보 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | GROUPSEQ | NUMBER(6) | PK | NOT NULL | 　 | 그룹고유번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | GROUPNAME | VARCHAR2(50) | 　 | 　 | 　 | 그룹명 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | ISDELETED | VARCHAR2(1) | 　 | 　 | 　 | 삭제여부(Y:삭제, N:사용) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | REGDATE | DATE | 　 | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | MODDATE | DATE | 　 | 　 | 　 | 수정일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | PARENTGROUPSEQ | NUMBER(6) | 　 | 　 | 　 | 부모 그룹고유번 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | GROUPDESC | VARCHAR2(100) | 　 | 　 | 　 | 그룹설명 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | REGID | VARCHAR2(20) | 　 | 　 | 　 | 등록자ID | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | GROUPTYPE | VARCHAR2(1) | 　 | 　 | N | 그룹종류 구분(N:normal, T:test) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 19. **T\_PUSH\_USER\_INFO** =========================== +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_USER\_INFO** | +-------------------------+-----------------------------------+ | **COMMENT** | 푸시서비스 가입자 정보 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | USERSEQNO | NUMBER | UNIQUE | | 　 | 시퀀스번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | PUSHKEY | VARCHAR2(40) | PK | NOT NULL | 　 | 고유키(디바이스아이디+앱아이디+PNSID) sha256 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | PSID | VARCHAR2(255) | 　 | | 　 | 푸쉬발송토큰 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | PNSID | VARCHAR2(4) | 　 | | 　 | 푸쉬서버종류 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | DEVICEID | VARCHAR2(50) | 　 | | 　 | 디바이스고유번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | CUID | VARCHAR2(50) | 　 | | 　 | 아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | CNAME | VARCHAR2(50) | 　 | 　 | 　 | 이름 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | APPID | VARCHAR2(255) | 　 | | 　 | 팩키지명 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | PHONENO | VARCHAR2(20) | 　 | 　 | 　 | 전화번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 10 | OS\_VER | VARCHAR2(50) | 　 | 　 | 　 | OS버전 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 11 | DEVICE\_MD | VARCHAR2(100) | 　 | 　 | 　 | 디바이스종류 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 12 | APP\_VER | VARCHAR2(50) | 　 | 　 | 　 | 앱버전 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 13 | APNS\_MODE | VARCHAR2(10) | 　 | 　 | 　 | APNS 모드 : REAL, DEV　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 14 | UPNSID | VARCHAR2(20) | 　 | 　 | 　 | UPNS 사용자 일 경우 UPNS 그룹 ID | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 15 | ORGUPNSID | VARCHAR2(20) | 　 | 　 | 　 | UPNS 사용자 일 경우 UPNS 서버 ID | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 16 | REGDATE | DATE | 　 | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 17 | MODDATE | DATE | | 　 | 　 | 수정일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 20. **T\_PUSH\_VARIABLES** ============================= +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_VARIABLES** | +-------------------------+-----------------------------------+ | **COMMENT** | 푸시서비스 변수 정보 테이블 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | VGROUP | VARCHAR2(20) | PK | NOT NULL | 　 | 변수 그룹 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | VNAME | VARCHAR2(40) | PK | NOT NULL | 　 | 변수 이름 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | VVALUE | VARCHAR2(256) | 　 | 　 | 　 | 변수 값 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+