===================================== DATABASE TABLE 정의 ===================================== 1. **T\_PUSH\_APPLICATION** =========================== +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_APPLICATION** | +-------------------------+-----------------------------------+ | **COMMENT** | 　 | +-------------------------+-----------------------------------+ +-------------------------+----------------------------------+---------------------------+-----------------+----------------------------+----------------------+--------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | APPID | varchar(255) | PRI | Not Null | 　 | 앱아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | APPNAME | varchar(50) | 　 | 　 | 　 | 앱이름 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | ISDELETED | varchar(1) | 　 | 　 | 　 | 삭제여부(Y:삭제, N:사용) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | REGDATE | datetime | 　 | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | MODDATE | datetime | 　 | 　 | 　 | 수정일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | SVC\_ID | bigint(10) | 　 | 　 | 　 | 서비스아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | SVC\_DTL | varchar(255) | 　 | 　 | 　 | 다운로드경로 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 2. **T\_PUSH\_FAIL** ======================== +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_FAIL** | +-------------------------+-----------------------------------+ | **COMMENT** | 발송 실패메세지 히스토리 테이블 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | PSID | varchar(255) | MUL | 　 | 　 | 토큰키 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | SEQNO | bigint(20) | 　 | Not Null | 　 | 메세지원장번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | CUID | varchar(50) | 　 | 　 | 　 | 유저아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | APPID | varchar(50) | 　 | 　 | 　 | 앱아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | PNSID | varchar(10) | 　 | 　 | 　 | 보낸 푸쉬서버 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | RETRYCNT | int(11) | 　 | Not Null | 0 | 전송회수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | RESULTCODE | varchar(10) | 　 | 　 | 　 | 에러코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | RESULTMSG | varchar(4000) | 　 | 　 | 　 | 에러메세지 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | REGDATE | datetime | 　 | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 10 | MODEDATE | datetime | 　 | 　 | 　 | 수정 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 11 | CSV\_VARS | varchar(2000) | 　 | 　 | 　 | CSV 템플릿 파라미터 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 3. **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 | bigint(20) | PRI | Not Null | 　 | 고유번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | RESERVE\_SEQNO | bigint(20) | 　 | 　 | 0 | 예약발송번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | SOUNDFILE | varchar(20) | 　 | 　 | 　 | 사운드파일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | BADGENO | int(5) | 　 | 　 | 　 | 뱃지카운트 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | MESSAGE | varchar(4000) | 　 | 　 | 　 | 보낼메세지 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | EXT | varchar(4000) | 　 | 　 | 　 | 커스텀메세지 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | RESERVEDATE | datetime | 　 | 　 | 　 | 예약일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | PRIORITY | int(1) | 　 | 　 | 　 | 우선수위(3:일반, 5:긴급) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | SENDERID | varchar(50) | 　 | 　 | 　 | 메세지종류,또는 발송자 구분 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 10 | REGDATE | datetime | MUL | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 11 | APPID | varchar(255) | 　 | 　 | 　 | 앱아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 12 | SERVICECODE | varchar(20) | 　 | 　 | 　 | 발송정책서비스코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 13 | TYPE | char(1) | 　 | 　 | E | 메세지 타입(A:전체, G:그룹, E:개별, C:CSV발송, S:시스템 또는 비밀발송 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 14 | TOTAL\_SEND\_CNT | int(11) | 　 | 　 | 0 | 총발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 15 | SEND\_CNT | int(11) | 　 | 　 | 0 | 푸시서버에 발송요청 성공수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 16 | FAIL\_CNT | int(11) | 　 | 　 | 0 | 실패수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 17 | REV\_CNT | int(11) | 　 | 　 | 0 | 수신확인수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 18 | READ\_CNT | int(11) | 　 | 　 | 0 | 읽음확인수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 19 | UPNS\_CNT | int(10) | 　 | 　 | 0 | UPNS 발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 20 | APNS\_CNT | int(10) | 　 | 　 | 0 | APNS 발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 21 | GCM\_CNT | int(10) | 　 | 　 | 0 | GCM 발송 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 22 | DB\_IN | char(1) | 　 | 　 | N | 발송 성공 메시지 DB 저장여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 23 | ORIGINAL\_SEQNO | int(10) | 　 | 　 | 0 | 재 발송시 원본 메시지 SEQNO | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 4. **T\_PUSH\_PNS\_INFO** ========================== +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_PNS\_INFO** | +-------------------------+-----------------------------------+ | **COMMENT** | 푸시서버 인증 정보 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | PNSID | varchar(4) | PRI | Not Null | 　 | 푸시서버종류(UPNS, APNS, GCM..) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | APPID | varchar(255) | PRI | Not Null | 　 | 앱아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | KEYSTORE | varchar(4000) | 　 | 　 | 　 | 인증키 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | PASSWORD | varchar(255) | 　 | 　 | 　 | 인증키패스워드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | CERT | blob | 　 | 　 | 　 | 인증서 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 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 | bigint(20) | PRI | Not Null | 　 | 고유번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | APP\_ID | varchar(255) | 　 | 　 | 　 | 앱아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | MESSAGE | varchar(4000) | 　 | 　 | 　 | 메세지 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | SOUNDFILE | varchar(20) | 　 | 　 | 　 | 사운드파일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | BADGENO | int(5) | 　 | 　 | 　 | 뱃지카운트 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | PRIORITY | int(1) | 　 | 　 | 　 | 우선순위(3:일반, 5긴급) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | EXT | varchar(255) | 　 | 　 | 　 | 확장 커스텀 필드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | SENDERCODE | varchar(50) | 　 | 　 | 　 | 사용자정보, 메세지 종류 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | SERVICECODE | varchar(20) | 　 | 　 | 　 | 푸시발송정책 서비스코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 10 | RESERVEDATE | datetime | 　 | 　 | 　 | 예약일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 11 | TYPE | char(1) | 　 | 　 | E | E:개별발송, A:전체발송,G:그룹발송,C:CSV발송 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 12 | DB\_IN | char(1) | 　 | 　 | 　 | Y:성공메세지 저장, N:성공메세지 저장하지 않음 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 13 | ATTACHFILE | varchar(255) | 　 | 　 | 　 | 첨부파일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 14 | GROUPSEQ | varchar(50) | 　 | 　 | 　 | 발송그룹시퀀스번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 15 | CUID | text | 　 | 　 | 　 | 발송 대상자 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 16 | REGDATE | datetime | MUL | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 17 | PROCESS\_FLAG | char(1) | 　 | Not Null | N | N:예약, R:발송대기/쓰레드등록,패 Y:발송,F:실패 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 18 | RESERVETYPE | varchar(2) | 　 | 　 | 　 | 예약 타입(A: admin) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 19 | ISCONDITION | varchar(2) | 　 | 　 | 　 | 조건여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 6. **T\_PUSH\_SENDER\_INFO** ============================ +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_SENDER\_INFO** | +-------------------------+-----------------------------------+ | **COMMENT** | 푸시 발송자 정보 테이블 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | SENDERSEQ | int(8) | PRI | Not Null | 　 | 고유번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | SENDERNAME | varchar(50) | 　 | 　 | 　 | 발송자이름 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | SENDERCODE | varchar(50) | MUL | 　 | 　 | 발송자 코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | ISDELETED | varchar(1) | 　 | 　 | 　 | 사용여부(N:사용, Y:미사용) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | SENDERDESC | varchar(45) | 　 | 　 | 　 | 발송자 설명 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | REGID | varchar(20) | 　 | 　 | 　 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | REGDT | datetime | 　 | 　 | 　 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | MODID | varchar(20) | 　 | 　 | 　 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | MODDT | timestamp | 　 | Not Null | CURRENT\_TIMESTAMP | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 7. **T\_PUSH\_SERVER\_GROUP** ============================= +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_SERVER\_GROUP** | +-------------------------+-----------------------------------+ | **COMMENT** | 　 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | GROUPID | varchar(20) | PRI | Not Null | 　 | 서버그룹ID | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | GROUPNAME | varchar(50) | 　 | 　 | 　 | 서버그룹 명 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | SERVERTYPE | varchar(10) | 　 | 　 | 　 | 서버 타입 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | VIP | varchar(30) | 　 | 　 | 　 | IP | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | PORT | varchar(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 | varchar(20) | PRI | Not Null | 　 | 서버ID | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | GROUPID | varchar(20) | 　 | 　 | 　 | 서버 그룹 ID | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | IP | varchar(20) | 　 | 　 | 　 | 아이피 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | PORT | varchar(6) | 　 | 　 | 　 | 포트 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | SERVERTYPE | varchar(10) | 　 | 　 | 　 | 서버종류(UPMC,UPNS,PROVIDER) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | SERVERNAME | varchar(20) | 　 | 　 | 　 | 서버이름 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | URL | varchar(1024) | 　 | 　 | 　 | URL | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | 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 | varchar(1) | 　 | 　 | 　 | 상태정보 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | REGDATE | datetime | 　 | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | IPADDRESS | varchar(15) | PRI | Not Null | 　 | 아이피 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | PORT | varchar(6) | PRI | Not Null | 　 | 포트 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 10. **T\_PUSH\_SERVICE** ========================= +-------------------------+----------------------------------+ | **TABLE NAME** | **T\_PUSH\_SERVICE** | +-------------------------+----------------------------------+ | **COMMENT** | 　 | +-------------------------+----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | SERVICENAME | varchar(100) | 　 | 　 | 　 | 발송정책 서비스 이름 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | SERVICECODE | varchar(20) | MUL | Not Null | 　 | 발송정책 서비스 코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | MAXRETRYCNT | int(2) | 　 | 　 | 　 | 최대 발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | RETRYFLAG | varchar(1) | MUL | 　 | 　 | 리트라이 여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | RESENDFLAG | varchar(1) | 　 | 　 | 　 | 재발송여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | MAXRESENDCNT | int(2) | 　 | 　 | 　 | 최대 발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | PNSID | varchar(4) | MUL | 　 | 　 | 발송서버 종류(UPNS, UPNC, APNS, GCM) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | FAILSMSFLAG | varchar(1) | 　 | 　 | N | 실패시 SMS 발송여부(Y:발송, N:미발송) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 11. **T\_PUSH\_SMS** ============================ +-------------------------+----------------------------------+ | **TABLE NAME** | **T\_PUSH\_SMS** | +-------------------------+----------------------------------+ | **COMMENT** | 　 | +-------------------------+----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | PHONENO | varchar(20) | 　 | 　 | 　 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | TELCOMP | varchar(4) | 　 | 　 | 　 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | MESSAGE | varchar(4000) | 　 | 　 | 　 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | REGDATE | datetime | 　 | 　 | 　 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | PROCESSED | varchar(1) | 　 | 　 | 　 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 12. **T\_PUSH\_SUCCESS** ========================= +-------------------------+----------------------------------+ | **TABLE NAME** | **T\_PUSH\_SUCCESS** | +-------------------------+----------------------------------+ | **COMMENT** | 보낸메세지정보 | +-------------------------+----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | PSID | varchar(255) | MUL | 　 | 　 | 토큰키 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | SEQNO | bigint(20) | 　 | Not Null | 　 | 메세지원장번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | APPID | varchar(50) | 　 | 　 | 　 | 앱아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | PNSID | varchar(10) | 　 | 　 | 　 | 보낸 푸쉬서버 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | STATUS | int(11) | 　 | Not Null | 1 | 1:발송완료, 2:수신완료,3:읽음확인 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | CUID | varchar(50) | 　 | 　 | 　 | 유저아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | REGDATE | datetime | 　 | 　 | 　 | 푸시서버에 발송성공시간 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | REVDATE | datetime | 　 | 　 | 　 | 수신완료시간 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | REDDATE | datetime | 　 | 　 | 　 | 읽음확인기간 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 10 | CSV\_VARS | varchar(2000) | 　 | 　 | 　 | CSV 템플릿 파라미터 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 13. **T\_PUSH\_SUPERVISOR** =============================== +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_SUPERVISOR** | +-------------------------+-----------------------------------+ | **COMMENT** | 푸시관리자 정보 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | SUPERVISORSEQ | int(8) | PRI | Not Null | 　 | 고유번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | NAME | varchar(50) | 　 | 　 | 　 | 이름 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | PHONENO | varchar(20) | 　 | 　 | 　 | 전화번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | ISDELETED | varchar(1) | 　 | 　 | 　 | 사용여부 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | REGDATE | datetime | 　 | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | MODDATE | datetime | 　 | 　 | 　 | 수정일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | TELCOMP | varchar(4) | 　 | 　 | 　 | 회사전화번 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 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) | PRI | Not Null | 　 | 발송일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | SENDERCODE | varchar(50) | PRI | Not Null | 　 | 발송자/메세지종류 코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | SENT\_CNT | int(11) | 　 | 　 | 0 | 발송성공 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | FAIL\_CNT | int(11) | 　 | 　 | 0 | 발송실패 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | READ\_CNT | int(11) | 　 | 　 | 0 | 수신확인 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | UPNS\_SENT\_CNT | int(11) | 　 | 　 | 0 | UPNS 발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | UPNS\_FAIL\_CNT | int(11) | 　 | 　 | 0 | UPNS 실패수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | APNS\_SENT\_CNT | int(11) | 　 | 　 | 0 | APNS 발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | APNS\_FAIL\_CNT | int(11) | 　 | 　 | 0 | APNS 실패수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 10 | GCM\_SENT\_CNT | int(11) | 　 | 　 | 0 | GCM발송수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 11 | GCM\_FAIL\_CNT | int(11) | 　 | 　 | 0 | GCM 실패수 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 12 | TIME00 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 13 | TIME01 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 14 | TIME02 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 15 | TIME03 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 16 | TIME04 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 17 | TIME05 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 18 | TIME06 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 19 | TIME07 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 20 | TIME08 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 21 | TIME09 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 22 | TIME10 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 23 | TIME11 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 24 | TIME12 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 25 | TIME13 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 26 | TIME14 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 27 | TIME15 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 28 | TIME16 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 29 | TIME17 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 30 | TIME18 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 31 | TIME19 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 32 | TIME20 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 33 | TIME21 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 34 | TIME22 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 35 | TIME23 | int(11) | 　 | 　 | 0 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 15. **T\_PUSH\_TEMPLATE** ========================== +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_TEMPLATE** | +-------------------------+-----------------------------------+ | **COMMENT** | 템플릿 정보 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | TEMPLATECODE | varchar(20) | PRI | Not Null | 　 | 템플릿 코드 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | MESSAGE | varchar(4000) | 　 | 　 | 　 | 메세지 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | REGDATE | datetime | 　 | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | MODDATE | datetime | 　 | 　 | 　 | 수정 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | EXT | text | 　 | 　 | 　 | 내용 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | URL | text | 　 | 　 | 　 | 참조URL | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | TEMPLATE\_TYPE | varchar(50) | 　 | 　 | 　 | 템플릿유형 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | REGID | varchar(20) | 　 | 　 | 　 | 등록자ID | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 16. **T\_PUSH\_USER\_GROUP** ============================ +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_USER\_GROUP** | +-------------------------+-----------------------------------+ | **COMMENT** | 유저그룹 마스터 테이블 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | CUID | varchar(50) | PRI | Not Null | 　 | 사용자아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | GROUPSEQ | int(6) | PRI | 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 | int(6) | PRI | Not Null | 　 | 그룹고유번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | GROUPNAME | varchar(50) | 　 | 　 | 　 | 그룹명 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | ISDELETED | varchar(1) | 　 | 　 | 　 | 삭제여부(Y:삭제, N:사용) | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | REGDATE | datetime | 　 | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | MODDATE | datetime | 　 | 　 | 　 | 수정일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | PARENTGROUPSEQ | int(6) | 　 | 　 | 　 | 부모 그룹고유번 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | GROUPDESC | varchar(100) | 　 | 　 | 　 | 그룹설명 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | REGID | varchar(20) | 　 | 　 | 　 | 등록자ID | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | GROUPTYPE | varchar(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 | int(11) | PRI | Not Null | 　 | 시퀀스번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | PUSHKEY | varchar(40) | UNI | Not Null | 　 | 고유키(디바이스아이디+앱아이디+PNSID) sha256 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | PSID | varchar(255) | 　 | Not Null | 　 | 푸쉬발송토큰 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 4 | PNSID | varchar(4) | 　 | Not Null | 　 | 푸쉬서버종류 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 5 | DEVICEID | varchar(50) | 　 | Not Null | 　 | 디바이스고유번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 6 | CUID | varchar(50) | 　 | Not Null | 　 | 아이디 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 7 | CNAME | varchar(50) | 　 | 　 | 　 | 이름 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 8 | APPID | varchar(255) | 　 | Not Null | 　 | 팩키지명 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 9 | PHONENO | varchar(20) | 　 | 　 | 　 | 전화번호 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 10 | REGDATE | datetime | 　 | 　 | 　 | 등록일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 11 | MODDATE | datetime | MUL | 　 | 　 | 수정일 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 12 | OS\_VER | varchar(50) | 　 | 　 | 　 | OS버전 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 13 | DEVICE\_MD | varchar(50) | 　 | 　 | 　 | 디바이스종류 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 14 | APP\_VER | varchar(50) | 　 | 　 | 　 | 앱버전 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 15 | UPNSID | varchar(20) | 　 | 　 | 　 | UPNS 사용자 일 경우 UPNS ID | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 16 | APNS\_MODE | varchar(10) | 　 | 　 | 　 | 　 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ 20. **T\_PUSH\_VARIABLES** ============================= +-------------------------+-----------------------------------+ | **TABLE NAME** | **T\_PUSH\_VARIABLES** | +-------------------------+-----------------------------------+ | **COMMENT** | 푸시서비스 변수 정보 테이블 | +-------------------------+-----------------------------------+ +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | **Col #** | **Column Name** | **Data Type** | **Key** | **Not Null** | **Default** | **Comments** | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 1 | VGROUP | varchar(20) | PRI | Not Null | 　 | 변수 그룹 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 2 | VNAME | varchar(40) | PRI | Not Null | 　 | 변수 이름 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+ | 3 | VVALUE | varchar(255) | 　 | 　 | 　 | 변수 값 | +-------------------------+-----------------------------------+---------------------------+-----------------+----------------------------+----------------------+-------------------------------------------------------------------------+