Messaging
Tables (20)
push_fail
- seqno (seq_no) — NUMBER — Primary key — NOT NULL
- psid (ps_id) — VARCHAR2(255) — Primary key — NOT NULL
- cuid (user_id) — VARCHAR2(50)
- appid (app_id) — VARCHAR2(50)
- pnsid (pns_id) — VARCHAR2(10)
- retry_cnt (retry_count) — NUMBER
- result_code — VARCHAR2(10)
- result_msg — VARCHAR2(4000)
- reg_date — DATE
- mode_date (mod_date) — DATE
- is_sms_sent — CHAR(1)
- csv_vars — VARCHAR2(2000)
push_msg_recv_master
- seqno (seq_no) — NUMBER — Primary key — NOT NULL
- reserve_seqno (reserve_seq_no) — NUMBER
- sound_file — VARCHAR2(20)
- badge_no — NUMBER
- message — VARCHAR2(4000)
- sub_title — VARCHAR2(4000)
- ext — VARCHAR2(4000)
- reserve_date — DATE
- priority — NUMBER
- sender_id — VARCHAR2(50)
- reg_date — DATE
- appid (app_id) — VARCHAR2(255)
- service_code — VARCHAR2(20)
- type — CHAR(1)
- total_send_cnt — NUMBER
- send_cnt — NUMBER
- fail_cnt — NUMBER
- rev_cnt — NUMBER
- read_cnt — NUMBER
- upns_cnt — NUMBER
- apns_cnt — NUMBER
- aom_cnt — NUMBER
- gcm_cnt — NUMBER
- db_in — CHAR(1)
- original_seqno (original_seq_no) — NUMBER
- group_seq — VARCHAR2(50)
- start_timestamp — NUMBER
- end_timestamp — NUMBER
push_pause_upns_history
- seqno (seq_no) — NUMBER — Primary key — NOT NULL
- source_upnsid (source_upns_id) — VARCHAR2(50)
- target_upnsids (target_upns_id) — VARCHAR2(255)
- move_allocate_cnts (move_allocate_count) — VARCHAR2(255)
- moved_count — VARCHAR2(10)
- moved_allocate_info — VARCHAR2(255)
- start_user_seqno (start_user_seq_no) — VARCHAR2(30)
- end_user_seqno (end_user_seq_no) — VARCHAR2(30)
- reg_date — DATE
push_pitcher_completed_msg
- pitcher_seqno (pitcher_seq_no) — NUMBER — Primary key — NOT NULL
- app_id — VARCHAR2(255)
- message — VARCHAR2(4000)
- sound_file — VARCHAR2(20)
- badge_no — NUMBER
- priority — NUMBER
- ext — VARCHAR2(255)
- sender_code — VARCHAR2(50)
- service_code — VARCHAR2(20)
- reserve_date — DATE
- type — CHAR(1)
- db_in — CHAR(1)
- attach_file — VARCHAR2(255)
- group_seq — VARCHAR2(50)
- cuid (user_id) — LONG
- reg_date — DATE
- process_flag — CHAR(1)
- split_msg_cnt (split_message_count) — NUMBER
- delay_second — NUMBER
- reserve_type — VARCHAR2(2)
- sub_title — VARCHAR2(4000)
- push_fail_sms_send — CHAR(1)
- sms_read_wait_minute — VARCHAR2(5)
- doz_gcm_send — CHAR(1)
- send_time_limit — VARCHAR2(20)
- result_code — VARCHAR2(20)
- result_msg — VARCHAR2(4000)
push_pitcher_msg
- pitcher_seqno (pitcher_seq_no) — NUMBER — Primary key — NOT NULL
- app_id — VARCHAR2(255)
- message — VARCHAR2(4000)
- sound_file — VARCHAR2(20)
- badge_no — NUMBER
- priority — NUMBER
- ext — VARCHAR2(255)
- sender_code — VARCHAR2(50)
- service_code — VARCHAR2(20)
- reserve_date — DATE
- type — CHAR(1)
- db_in — CHAR(1)
- attach_file — VARCHAR2(255)
- group_seq — VARCHAR2(50)
- cuid (user_id) — LONG
- reg_date — DATE
- process_flag — CHAR(1)
- split_msg_cnt (split_message_count) — NUMBER
- delay_second — NUMBER
- reserve_type — VARCHAR2(2)
- sub_title — VARCHAR2(4000)
- push_fail_sms_send — CHAR(1)
- sms_read_wait_minute — VARCHAR2(5)
- doz_gcm_send — CHAR(1)
- send_time_limit — VARCHAR2(20)
push_reserve_msg
- reserve_seqno (reserve_seq_no) — NUMBER — Primary key — NOT NULL
- app_id — VARCHAR2(255)
- message — VARCHAR2(4000)
- sound_file — VARCHAR2(20)
- badge_no — NUMBER
- priority — NUMBER
- ext — VARCHAR2(255)
- sender_code — VARCHAR2(50)
- service_code — VARCHAR2(20)
- reserve_date — DATE
- type — CHAR(1)
- db_in — CHAR(1)
- attach_file — VARCHAR2(255)
- group_seq — VARCHAR2(50)
- cuid (user_id) — LONG
- reg_date — DATE
- process_flag — CHAR(1)
- split_msg_cnt (split_message_count) — NUMBER
- delay_second — NUMBER
- reserve_type — VARCHAR2(2)
- is_condition — VARCHAR2(2)
- sub_title — VARCHAR2(4000)
- push_fail_sms_send — CHAR(1)
- sms_read_wait_minute — VARCHAR2(5)
- doz_gcm_send — CHAR(1)
- send_time_limit — VARCHAR2(20)
push_sender_info
- sender_seq — NUMBER(8) — Primary key — NOT NULL — 발신자
- sender_name — VARCHAR2(50) — 발신자
- sender_code — VARCHAR2(50) — 발신자
- is_deleted — VARCHAR2(1) — 삭제
- sender_desc — VARCHAR2(45)
- reg_id — VARCHAR2(20)
- reg_dt (reg_date) — DATE
- mod_id — VARCHAR2(20)
- mod_dt (mod_date) — DATE
push_server_group
- group_id (server_group_id) — VARCHAR2(20) — Primary key — NOT NULL — 서버
- group_name (server_group_name) — VARCHAR2(50) — 서버그룹이름
- server_type — VARCHAR2(10) — 서버타입:
- vip (ip) — VARCHAR2(30) — 클라이언트에게
- port — VARCHAR2(6) — VIP
push_server_info
- server_id — VARCHAR2(50) — Primary key — NOT NULL — 서버아이디
- group_id (server_group_id) — VARCHAR2(20) — Foreign key → push_server_group.group_id — NOT NULL — 서버
- ip — VARCHAR2(20) — 아이피
- port — VARCHAR2(6) — 포트
- internal_ip — VARCHAR2(20)
- server_type — VARCHAR2(10) — 서버타입:
- server_name — VARCHAR2(50) — 서버
- url — VARCHAR2(1024) — 웹서버일
- is_active — CHAR(1) — 사용여부
push_server_status
- ip_address — VARCHAR2(15) — Primary key — NOT NULL
- port — VARCHAR2(6) — Primary key — NOT NULL
- status — VARCHAR2(1)
- reg_date — DATE
push_service
- service_name — VARCHAR2(100)
- service_code — VARCHAR2(20) — NOT NULL
- max_retry_cnt (max_retry_count) — NUMBER(2)
- retry_flag — VARCHAR2(1)
- resend_flag — VARCHAR2(1)
- max_resend_cnt (max_resend_count) — NUMBER(2)
- pnsid (pns_id) — VARCHAR2(4)
- fail_sms_flag — VARCHAR2(1)
push_sms
- appid (app_id) — VARCHAR2(255) — Primary key — NOT NULL
- cuid (user_id) — VARCHAR2(50) — Primary key — NOT NULL
- seqno (seq_no) — VARCHAR2(50) — Primary key — NOT NULL
- title — VARCHAR2(4000)
- sub_title — VARCHAR2(4000)
- pnsid — VARCHAR2(10)
- psid — VARCHAR2(255)
- sms_read_wait_minute — VARCHAR2(5)
- push_status — CHAR(1)
- err_code — VARCHAR2(10)
- reg_date — DATE
- expire_date — DATE
push_success
- seqno (seq_no) — NUMBER(20) — Primary key — NOT NULL
- psid (ps_id) — VARCHAR2(255) — Primary key — NOT NULL
- appid (app_id) — VARCHAR2(50)
- pnsid (pns_id) — VARCHAR2(10)
- status — NUMBER
- cuid (user_id) — VARCHAR2(50)
- reg_date — DATE
- rev_date — DATE
- read_date — DATE
- is_sms_sent — CHAR(1)
- csv_vars — VARCHAR2(2000)
push_supervisor
- supervisor_seq — NUMBER(8) — Primary key — NOT NULL
- name — VARCHAR2(50)
- phone_no — VARCHAR2(20)
- is_deleted — VARCHAR2(1)
- reg_date — DATE
- mod_date — DATE
- tel_comp — VARCHAR2(4)
push_sysmsg_sentinfo
- send_date — CHAR(8) — Primary key — NOT NULL
- sender_code — VARCHAR2(50) — Primary key — NOT NULL
- sent_cnt (sent_count) — NUMBER
- fail_cnt (fail_count) — NUMBER
- read_cnt (read_count) — NUMBER
- upns_sent_cnt (upns_sent_count) — NUMBER
- upns_fail_cnt (upns_fail_count) — NUMBER
- apns_sent_cnt (apns_sent_count) — NUMBER
- apns_fail_cnt (apns_fail_count) — NUMBER
- gcm_sent_cnt (gcm_sent_count) — NUMBER
- gcm_fail_cnt (gcm_fail_count) — NUMBER
- aom_sent_cnt (aom_sent_count) — NUMBER
- aom_fail_cnt (aom_fail_count) — NUMBER
- time00 — NUMBER
- time01 — NUMBER
- time02 — NUMBER
- time03 — NUMBER
- time04 — NUMBER
- time05 — NUMBER
- time06 — NUMBER
- time07 — NUMBER
- time08 — NUMBER
- time09 — NUMBER
- time10 — NUMBER
- time11 — NUMBER
- time12 — NUMBER
- time13 — NUMBER
- time14 — NUMBER
- time15 — NUMBER
- time16 — NUMBER
- time17 — NUMBER
- time18 — NUMBER
- time19 — NUMBER
- time20 — NUMBER
- time21 — NUMBER
- time22 — NUMBER
- time23 — NUMBER
push_user
- cuid (user_id) — VARCHAR2(50) — Primary key — NOT NULL
- cname — VARCHAR2(50)
- val1 — VARCHAR2(50) — 타게팅
- val2 — VARCHAR2(50) — 타게팅
- val3 — VARCHAR2(50) — 타게팅
- val4 — VARCHAR2(50) — 타게팅
- val5 — VARCHAR2(50) — 타게팅
- val6 — VARCHAR2(50) — 타게팅
- val7 — VARCHAR2(50) — 타게팅
- val8 — VARCHAR2(50) — 타게팅
- val9 — VARCHAR2(50) — 타게팅
- reg_dt (reg_date) — DATE
- mod_dt (mod_date) — DATE
push_user_group
- group_seq — NUMBER(6) — Primary key — NOT NULL
- cuid (user_id) — VARCHAR2(50) — Foreign key → push_user.cuid — NOT NULL
push_user_group_info
- group_seq — NUMBER(6) — NOT NULL
- group_name — VARCHAR2(50)
- is_deleted — VARCHAR2(1)
- reg_date — DATE
- mod_date — DATE
- parent_group_seq — NUMBER(6)
- group_desc — VARCHAR2(100) — 그룹설명
- reg_id — VARCHAR2(20) — 등록자ID
- group_type — VARCHAR2(1) — (N:normal
push_user_info
- push_key — VARCHAR2(40) — Primary key — NOT NULL — 고유키(디바이스아이디+앱아이디+PNSID)
- user_seqno (user_seq_no) — NUMBER
- psid — VARCHAR2(255) — 푸쉬발송토큰
- pnsid — VARCHAR2(4) — 푸쉬서버종류
- device_id — VARCHAR2(50) — 디바이스고유번호
- cuid — VARCHAR2(50) — 아이디
- cname — VARCHAR2(50) — 이름
- appid (app_id) — VARCHAR2(255) — 팩키지명
- phone_no — VARCHAR2(20) — 전화번호
- os_ver — VARCHAR2(50) — OS
- device_md — VARCHAR2(100) — 디바이스
- app_ver — VARCHAR2(50) — 앱버전
- apns_mode — VARCHAR2(10) — APNS
- upnsid (upns_id) — VARCHAR2(20) — 할당된
- org_upnsid (org_upns_id) — VARCHAR2(20)
- reg_date — DATE — 등록일
- mod_date — DATE — 수정일
push_variables
- v_group — VARCHAR2(20) — Primary key — NOT NULL
- v_name — VARCHAR2(40) — Primary key — NOT NULL
- v_value — VARCHAR2(256)